[Openfire-br] Openfire-br Digest, Vol 5, Issue 19

Openfire-BR list openfire-br at listas.softwarelivre.org
Fri Nov 9 14:18:32 BRST 2012


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

	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
> 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/20121109/30c8469d/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/20121109/30c8469d/attachment-0002.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/20121109/30c8469d/attachment-0003.png>


More information about the Openfire-br mailing list