[Openfire-br] Apagar conversar do Server
Openfire-BR list
openfire-br at listas.softwarelivre.org
Fri Nov 23 10:15:10 BRST 2012
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121123/965cf72c/attachment-0001.html>
-------------- 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/965cf72c/attachment-0003.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/965cf72c/attachment-0004.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/965cf72c/attachment-0005.png>
More information about the Openfire-br
mailing list