[Openfire-br] Apagar conversar do Server

Fri Nov 23 09:51:31 BRST 2012

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 

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>

Send Openfire-br mailing list submissions to
        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

You can reach the person managing the list at
        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>
To: 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>
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
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/20121123/3f1bab2a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2894 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/3f1bab2a/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 4436 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/3f1bab2a/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 893 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/3f1bab2a/attachment-0005.png>