[Openfire-br] Apagar conversar do Server

Openfire-BR list openfire-br at listas.softwarelivre.org
Fri Nov 23 10:40:53 BRST 2012


Cara o procedimento tá abaixo citado. Eu mesmo havia lhe passado isso.

*Michel Luis Grassi*
Departamento de Implantação e Suporte Administração de Redes
Tel.: +55 (54) 3314.6997 / 2104.7600
www.alfasig.com.br

	Descrição: http://images.alfasig.com.br/logo_alfasig.png

	
	

Descrição: http://images.alfasig.com.br/tarja_alfasig.png
Especializada em Soluções para SPED

Em 23/11/2012 10:15, Openfire-BR list escreveu:
> Bom dia.. tem que acessar o banco de dados e apagar por ele..
>
>
> Em 23/11/2012 08:51, Openfire-BR list escreveu:
>>
>> Bom dia,
>>
>> Alguém sabe informar seu eu consigo apagar o histórico do bate papo 
>> por usuário ... por exemplo, quero apagar toda a conversa do usuário X .
>>
>> Obrigado.
>>
>> **
>>
>> */Atenciosamente,/*
>>
>> *//*
>>
>> */Diego Silva/**//*
>>
>> /Tecnologia da Informação/
>>
>> //
>>
>> */TCM.png-- Logística, Transportes & Armazéns Gerais Ltda./**//*
>>
>> /DDR: (11) 2425 7047 / (11) 2422 7272 / ID: 55*67*101026/
>>
>> **
>>
>> **
>>
>> **
>>
>> *De:*openfire-br-bounces at listas.softwarelivre.org 
>> [mailto:openfire-br-bounces at listas.softwarelivre.org] *Em nome de 
>> *Openfire-BR list
>> *Enviada em:* sexta-feira, 9 de novembro de 2012 14:19
>> *Para:* openfire-br at listas.softwarelivre.org
>> *Assunto:* Re: [Openfire-br] Openfire-br Digest, Vol 5, Issue 19
>>
>> Olha que eu saiba somente por sql.
>>
>> Acessa o mysql via terminal no linux conectando ao banco do openfire.
>>
>> E roda algo assim:
>>
>> delete from ofMessageArchive where fromJID like 'usuarioX%'
>> delete from ofMessageArchive where toJID like 'usuarioX%'
>>
>> Onde estou usando o like para apagar todas as mensagens que são 
>> provenientes do usuarioX e com destino a ele respectivamente.
>>
>> Espero ter ajudado.
>>
>> *Michel Luis Grassi*
>> Departamento de Implantação e Suporte Administração de Redes
>> Tel.: +55 (54) 3314.6997 / 2104.7600
>> www.alfasig.com.br <http://www.alfasig.com.br>
>>
>> 	
>>
>> Descrição: http://images.alfasig.com.br/logo_alfasig.png
>>
>> 	
>>
>>
>> 	
>> 	
>>
>> Descrição: http://images.alfasig.com.br/tarja_alfasig.png
>>
>> Especializada em Soluções para SPED
>>
>> Em 9/11/2012 13:49, Openfire-BR list escreveu:
>>
>>     Boa tarde Pessoal,
>>     Preciso saber se existe como excluir uma conversa do openfire. Um
>>     diretor da empresa, exigiu que fosse exclusa uma conversa e nao
>>     sei como fazer no openfire.
>>     Uso o Openfire, integrado com AD, com banco de dados nativo do
>>     openfire.
>>     Obrigado
>>
>>     2012/11/8 <openfire-br-request at listas.softwarelivre.org
>>     <mailto:openfire-br-request at listas.softwarelivre.org>>
>>
>>     Send Openfire-br mailing list submissions to
>>     openfire-br at listas.softwarelivre.org
>>     <mailto:openfire-br at listas.softwarelivre.org>
>>
>>     To subscribe or unsubscribe via the World Wide Web, visit
>>     http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>     or, via email, send a message with subject or body 'help' to
>>     openfire-br-request at listas.softwarelivre.org
>>     <mailto:openfire-br-request at listas.softwarelivre.org>
>>
>>     You can reach the person managing the list at
>>     openfire-br-owner at listas.softwarelivre.org
>>     <mailto:openfire-br-owner at listas.softwarelivre.org>
>>
>>     When replying, please edit your Subject line so it is more specific
>>     than "Re: Contents of Openfire-br digest..."
>>
>>
>>     Today's Topics:
>>
>>        1. Re: E o fim do msn? (Openfire-BR list)
>>
>>
>>     ----------------------------------------------------------------------
>>
>>     Message: 1
>>     Date: Thu, 08 Nov 2012 17:12:35 -0200
>>     From: Openfire-BR list <openfire-br at listas.softwarelivre.org
>>     <mailto:openfire-br at listas.softwarelivre.org>>
>>     To: openfire-br at listas.softwarelivre.org
>>     <mailto:openfire-br at listas.softwarelivre.org>
>>     Subject: Re: [Openfire-br] E o fim do msn?
>>     Message-ID:
>>            
>>     <mailman.1397.1352402151.1763.openfire-br at listas.softwarelivre.org <mailto:mailman.1397.1352402151.1763.openfire-br at listas.softwarelivre.org>>
>>     Content-Type: text/plain; charset="us-ascii"
>>
>>     An HTML attachment was scrubbed...
>>     URL:
>>     <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121108/b76f3655/attachment.html>
>>     -------------- next part --------------
>>     A non-text attachment was scrubbed...
>>     Name: logo_neo.jpg
>>     Type: image/jpeg
>>     Size: 7670 bytes
>>     Desc: not available
>>     URL:
>>     <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121108/b76f3655/attachment.jpg>
>>     -------------- next part --------------
>>     A non-text attachment was scrubbed...
>>     Name: not available
>>     Type: image/jpeg
>>     Size: 75511 bytes
>>     Desc: not available
>>     URL:
>>     <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121108/b76f3655/attachment.jpe>
>>     -------------- next part --------------
>>     A non-text attachment was scrubbed...
>>     Name: not available
>>     Type: image/jpeg
>>     Size: 7670 bytes
>>     Desc: not available
>>     URL:
>>     <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121108/b76f3655/attachment-0001.jpe>
>>     -------------- next part --------------
>>     A non-text attachment was scrubbed...
>>     Name: not available
>>     Type: image/jpeg
>>     Size: 7670 bytes
>>     Desc: not available
>>     URL:
>>     <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121108/b76f3655/attachment-0002.jpe>
>>
>>     ------------------------------
>>
>>     _______________________________________________
>>     Openfire-br mailing list
>>     Openfire-br at listas.softwarelivre.org
>>     <mailto:Openfire-br at listas.softwarelivre.org>
>>     http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>
>>
>>     End of Openfire-br Digest, Vol 5, Issue 19
>>     ******************************************
>>
>>
>>
>>
>>
>>     _______________________________________________
>>
>>     Openfire-br mailing list
>>
>>     Openfire-br at listas.softwarelivre.org  <mailto:Openfire-br at listas.softwarelivre.org>
>>
>>     http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>
>>
>>
>> _______________________________________________
>> Openfire-br mailing list
>> Openfire-br at listas.softwarelivre.org
>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>
>
>
> _______________________________________________
> Openfire-br mailing list
> Openfire-br at listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_alfasig.png
Type: image/png
Size: 4436 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tarja_alfasig.png
Type: image/png
Size: 1401 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 2894 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4436 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 893 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/7e4d6f1b/attachment-0009.png>


More information about the Openfire-br mailing list