[Openfire-br] Monitoring Service

Fri Jul 26 14:31:36 BRT 2013

Daniel,

Já olhei em tudo que imaginei: logs do openfire (postei no início desta
thread), logs do Postgresql (há erros quando a coluna "bytes" da tabela
ofRRDs atinge um tamanho considerável e fica tão lento o acesso que trava o
openfire) e até o código-fonte, mas não sei quase nada de Java, então fica
difícil.
Estou, agora, testando todas as formas possíveis (com outros bancos e
usando o tar.gz do openfire) e só consegui com o hsqldb, mas pra mim não é
interessante, porque o número de usuários do meu trabalho é mais de 6000
usuários.

Boa sorte pra mim...

--
Renato Carneiro Pacheco
Certificado Linux LPIC-1
Pós-Graduado em Segurança em Redes de Computadores
Graduado em Redes de Comunicação

http://br.linkedin.com/in/renatocarneirop
http://www.facebook.com/renatocarneirop

*"Não acredite no que eu digo, pois é a minha experiência e não a sua.
Experimente, indague e busque." - *Osho Rajneesh

2013/7/26 Daniel Gaspary <dgaspary at gmail.com>

> Quando tenta com outro banco e não funciona, olhou os logs ?
>
>
> 2013/7/26 Alex Douglas <adsjcsp at gmail.com>
>
>> desculpa tentei copiar e colar a figura...
>>
>>
>> Em 26 de julho de 2013 10:56, Alex Douglas <adsjcsp at gmail.com> escreveu:
>>
>>>
>>> Bem, eu não entendo. São deste gráficos que está falando? por que se
>>> for, eu estou usando o mysql e está funcionando perfeitamente....
>>>
>>>
>>> Em 26 de julho de 2013 10:29, Renato C. Pacheco <
>>> renato.camarao at gmail.com> escreveu:
>>>
>>> Não tem lógica! Já testei com tudo quanto é tipo de versão, bancos como
>>>> MySQL e PostgreSQL e não gera o gráfico, somente com o hSQLdb! Vou
>>>> quebrando a cabeça aqui e qualquer coisa eu retorno...
>>>>
>>>> --
>>>> Renato Carneiro Pacheco
>>>> Certificado Linux LPIC-1
>>>> Pós-Graduado em Segurança em Redes de Computadores
>>>> Graduado em Redes de Comunicação
>>>>
>>>> http://br.linkedin.com/in/renatocarneirop
>>>> http://www.facebook.com/renatocarneirop
>>>>
>>>> *"Não acredite no que eu digo, pois é a minha experiência e não a sua.
>>>> Experimente, indague e busque." - *Osho Rajneesh
>>>>
>>>>
>>>> 2013/7/25 Marcelo Terres <mhterres at gmail.com>
>>>>
>>>>> Estou usando a última.
>>>>> []s
>>>>> Marcelo H. Terres
>>>>> mhterres at gmail.com
>>>>> http://mundoopensource.blogspot.com
>>>>> http://biertasters.blogspot.com
>>>>> http://twitter.com/mhterres
>>>>>
>>>>>
>>>>> 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>:
>>>>> > Última pergunta: qual é a versão do seu plugin?
>>>>> >
>>>>> > --
>>>>> > Renato Carneiro Pacheco
>>>>> > Certificado Linux LPIC-1
>>>>> > Pós-Graduado em Segurança em Redes de Computadores
>>>>> > Graduado em Redes de Comunicação
>>>>> >
>>>>> > http://br.linkedin.com/in/renatocarneirop
>>>>> > http://www.facebook.com/renatocarneirop
>>>>> >
>>>>> > "Não acredite no que eu digo, pois é a minha experiência e não a sua.
>>>>> > Experimente, indague e busque." - Osho Rajneesh
>>>>> >
>>>>> >
>>>>> > 2013/7/25 Marcelo Terres <mhterres at gmail.com>
>>>>> >>
>>>>> >> Não, só a instalação padrão do Openfire.
>>>>> >>
>>>>> >> Os plugins sempre criam suas tabelas no DB em uso.
>>>>> >>
>>>>> >> []s
>>>>> >> Marcelo H. Terres
>>>>> >> mhterres at gmail.com
>>>>> >> http://mundoopensource.blogspot.com
>>>>> >> http://biertasters.blogspot.com
>>>>> >> http://twitter.com/mhterres
>>>>> >>
>>>>> >>
>>>>> >> 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>:
>>>>> >> > Marcelo,
>>>>> >> >
>>>>> >> > Eu fiz o teste também com o openfire dos pacotes e obtive o mesmo
>>>>> >> > resultado.
>>>>> >> > Você alterou algum parâmetro no momento da configuração?
>>>>> >> >
>>>>> >> > --
>>>>> >> > Renato Carneiro Pacheco
>>>>> >> > Certificado Linux LPIC-1
>>>>> >> > Pós-Graduado em Segurança em Redes de Computadores
>>>>> >> > Graduado em Redes de Comunicação
>>>>> >> >
>>>>> >> > http://br.linkedin.com/in/renatocarneirop
>>>>> >> > http://www.facebook.com/renatocarneirop
>>>>> >> >
>>>>> >> > "Não acredite no que eu digo, pois é a minha experiência e não a
>>>>> sua.
>>>>> >> > Experimente, indague e busque." - Osho Rajneesh
>>>>> >> >
>>>>> >> >
>>>>> >> > 2013/7/25 Marcelo Terres <mhterres at gmail.com>
>>>>> >> >>
>>>>> >> >> Uso Ubuntu e Debian.
>>>>> >> >>
>>>>> >> >> Não instalo o openfire dos pacotes. Sempre usei o .tar.gz.
>>>>> >> >>
>>>>> >> >> []s
>>>>> >> >> Marcelo H. Terres
>>>>> >> >> mhterres at gmail.com
>>>>> >> >> http://mundoopensource.blogspot.com
>>>>> >> >> http://biertasters.blogspot.com
>>>>> >> >> http://twitter.com/mhterres
>>>>> >> >>
>>>>> >> >>
>>>>> >> >> 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>:
>>>>> >> >> > Marcelo,
>>>>> >> >> >
>>>>> >> >> > Qual distro você utiliza? Utilizamos Debian 6 e 7, com os
>>>>> mesmos
>>>>> >> >> > erros.
>>>>> >> >> >
>>>>> >> >> > --
>>>>> >> >> > Renato Carneiro Pacheco
>>>>> >> >> > Certificado Linux LPIC-1
>>>>> >> >> > Pós-Graduado em Segurança em Redes de Computadores
>>>>> >> >> > Graduado em Redes de Comunicação
>>>>> >> >> >
>>>>> >> >> > http://br.linkedin.com/in/renatocarneirop
>>>>> >> >> > http://www.facebook.com/renatocarneirop
>>>>> >> >> >
>>>>> >> >> > "Não acredite no que eu digo, pois é a minha experiência e não
>>>>> a sua.
>>>>> >> >> > Experimente, indague e busque." - Osho Rajneesh
>>>>> >> >> >
>>>>> >> >> >
>>>>> >> >> > 2013/7/25 Marcelo Terres <mhterres at gmail.com>
>>>>> >> >> >>
>>>>> >> >> >> Sempre usei Linux e nunca utilizei o banco interno, desde os
>>>>> tempos
>>>>> >> >> >> do
>>>>> >> >> >> Wildfire.
>>>>> >> >> >>
>>>>> >> >> >> Todas as várias instalações que fiz foram com MySQL ou
>>>>> Postgres.
>>>>> >> >> >>
>>>>> >> >> >> []s
>>>>> >> >> >> Marcelo H. Terres
>>>>> >> >> >> mhterres at gmail.com
>>>>> >> >> >> http://mundoopensource.blogspot.com
>>>>> >> >> >> http://biertasters.blogspot.com
>>>>> >> >> >> http://twitter.com/mhterres
>>>>> >> >> >>
>>>>> >> >> >>
>>>>> >> >> >> 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>:
>>>>> >> >> >> > Marcelo,
>>>>> >> >> >> >
>>>>> >> >> >> > Por algum motivo não funciona. Você usa o Openfire versão
>>>>> Windows
>>>>> >> >> >> > ou
>>>>> >> >> >> > Linux?
>>>>> >> >> >> > Eu utilizo a versão Linux.
>>>>> >> >> >> >
>>>>> >> >> >> > --
>>>>> >> >> >> > Renato Carneiro Pacheco
>>>>> >> >> >> > Certificado Linux LPIC-1
>>>>> >> >> >> > Pós-Graduado em Segurança em Redes de Computadores
>>>>> >> >> >> > Graduado em Redes de Comunicação
>>>>> >> >> >> >
>>>>> >> >> >> > http://br.linkedin.com/in/renatocarneirop
>>>>> >> >> >> > http://www.facebook.com/renatocarneirop
>>>>> >> >> >> >
>>>>> >> >> >> > "Não acredite no que eu digo, pois é a minha experiência e
>>>>> não a
>>>>> >> >> >> > sua.
>>>>> >> >> >> > Experimente, indague e busque." - Osho Rajneesh
>>>>> >> >> >> >
>>>>> >> >> >> >
>>>>> >> >> >> > 2013/7/25 Marcelo Terres <mhterres at gmail.com>
>>>>> >> >> >> >>
>>>>> >> >> >> >> Funciona com todos. Eu já usei com MySQL e agora uso com
>>>>> >> >> >> >> Postgres.
>>>>> >> >> >> >>
>>>>> >> >> >> >> []s
>>>>> >> >> >> >> Marcelo H. Terres
>>>>> >> >> >> >> mhterres at gmail.com
>>>>> >> >> >> >> http://mundoopensource.blogspot.com
>>>>> >> >> >> >> http://biertasters.blogspot.com
>>>>> >> >> >> >> http://twitter.com/mhterres
>>>>> >> >> >> >>
>>>>> >> >> >> >>
>>>>> >> >> >> >> 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>:
>>>>> >> >> >> >> > Pessoal,
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > Realizando algumas pesquisas e testes, progredi, mas não
>>>>> foi o
>>>>> >> >> >> >> > suficiente.
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > - Sobre a mensagem do erro Rrdb, era a tabela que estava
>>>>> >> >> >> >> > corrompida,
>>>>> >> >> >> >> > era
>>>>> >> >> >> >> > só
>>>>> >> >> >> >> > limpá-la para voltar a registrar as conversas.
>>>>> >> >> >> >> > - O gráfico ainda não é mostrado, então eu resolvi
>>>>> instalar em
>>>>> >> >> >> >> > outro
>>>>> >> >> >> >> > banco
>>>>> >> >> >> >> > de dados (HSQLDB) para ver se funcionava e, para a minha
>>>>> >> >> >> >> > surpresa,
>>>>> >> >> >> >> > funcionou
>>>>> >> >> >> >> > direitinho! Então eu tentei trocar o sql dessa base para
>>>>> o
>>>>> >> >> >> >> > PostgreSQL,
>>>>> >> >> >> >> > mas
>>>>> >> >> >> >> > não é compatível (tentei ainda fazer alguns ajustes, mas
>>>>> sem
>>>>> >> >> >> >> > sucesso).
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > A pergunta que não quer calar: por que raios o plugin
>>>>> >> >> >> >> > Monitoring
>>>>> >> >> >> >> > Service
>>>>> >> >> >> >> > funciona no banco HSQLDB, mas não funciona no
>>>>> PostgreSQL? (não
>>>>> >> >> >> >> > funciona
>>>>> >> >> >> >> > também no MySQL).
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > --
>>>>> >> >> >> >> > Renato Carneiro Pacheco
>>>>> >> >> >> >> > Certificado Linux LPIC-1
>>>>> >> >> >> >> > Pós-Graduado em Segurança em Redes de Computadores
>>>>> >> >> >> >> > Graduado em Redes de Comunicação
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > http://br.linkedin.com/in/renatocarneirop
>>>>> >> >> >> >> > http://www.facebook.com/renatocarneirop
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > "Não acredite no que eu digo, pois é a minha experiência
>>>>> e não
>>>>> >> >> >> >> > a
>>>>> >> >> >> >> > sua.
>>>>> >> >> >> >> > Experimente, indague e busque." - Osho Rajneesh
>>>>> >> >> >> >> >
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > 2013/7/25 Renato C. Pacheco <renato.camarao at gmail.com>
>>>>> >> >> >> >> >
>>>>> >> >> >> >> >> Bom dia a todos!
>>>>> >> >> >> >> >>
>>>>> >> >> >> >> >> Estou com dois problemas no plugin Monitoring Service
>>>>> (versão
>>>>> >> >> >> >> >> 1.3.2beta1),
>>>>> >> >> >> >> >> no Openfire 3.8.2. O primeiro problema é que os
>>>>> gráficos não
>>>>> >> >> >> >> >> aparecem
>>>>> >> >> >> >> >> de
>>>>> >> >> >> >> >> jeito nenhum e o segundo problema é que todas as vezes
>>>>> que
>>>>> >> >> >> >> >> acesso
>>>>> >> >> >> >> >> a
>>>>> >> >> >> >> >> aba
>>>>> >> >> >> >> >> "Estatística", demora bastante para carregar. Olhando
>>>>> nos
>>>>> >> >> >> >> >> logs, a
>>>>> >> >> >> >> >> seguinte
>>>>> >> >> >> >> >> mensagem aparece:
>>>>> >> >> >> >> >>
>>>>> >> >> >> >> >> org.jivesoftware.openfire.reporting.stats.StatsEngine -
>>>>> Error
>>>>> >> >> >> >> >> initializing
>>>>> >> >> >> >> >> Rrdb
>>>>> >> >> >> >> >> java.io.IOException: The underlying backend has no
>>>>> canonical
>>>>> >> >> >> >> >> path
>>>>> >> >> >> >> >>
>>>>> >> >> >> >> >> Alguém já passou por isso?
>>>>> >> >> >> >> >> --
>>>>> >> >> >> >> >> Renato Carneiro Pacheco
>>>>> >> >> >> >> >> Certificado Linux LPIC-1
>>>>> >> >> >> >> >> Pós-Graduado em Segurança em Redes de Computadores
>>>>> >> >> >> >> >> Graduado em Redes de Comunicação
>>>>> >> >> >> >> >>
>>>>> >> >> >> >> >> http://br.linkedin.com/in/renatocarneirop
>>>>> >> >> >> >> >> http://www.facebook.com/renatocarneirop
>>>>> >> >> >> >> >>
>>>>> >> >> >> >> >> "Não acredite no que eu digo, pois é a minha
>>>>> experiência e não
>>>>> >> >> >> >> >> a
>>>>> >> >> >> >> >> sua.
>>>>> >> >> >> >> >> Experimente, indague e busque." - Osho Rajneesh
>>>>> >> >> >> >> >
>>>>> >> >> >> >> >
>>>>> >> >> >> >> >
>>>>> >> >> >> >> > _______________________________________________
>>>>> >> >> >> >> > 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
>>>>> >> >> >> >
>>>>> >> >> >> >
>>>>> >> >> >> >
>>>>> >> >> >> > _______________________________________________
>>>>> >> >> >> > 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
>>>>> >> >> >
>>>>> >> >> >
>>>>> >> >> >
>>>>> >> >> > _______________________________________________
>>>>> >> >> > 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
>>>>> >> >
>>>>> >> >
>>>>> >> >
>>>>> >> > _______________________________________________
>>>>> >> > 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
>>>>> >
>>>>> >
>>>>> >
>>>>> > _______________________________________________
>>>>> > 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
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Openfire-br mailing list
>>>> Openfire-br at listas.softwarelivre.org
>>>> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Grato.*
>>>
>>> *
>>> *Imprima este e-mail somente se houver necessidade... Cuide da
>>> Natureza! *
>>> *Alex Douglas *(TIM) (11)8570-4410
>>> adsjcsp at gmail.com - www.facebook.com/adsjcsp - www.twitter.com/adsjcsp<http://www.twitter.com/adsjcsp>
>>>
>>
>>
>>
>> --
>>
>>
>>
>> Grato.*
>>
>> *
>> *Imprima este e-mail somente se houver necessidade... Cuide da Natureza!
>> *
>> *Alex Douglas *(TIM) (11)8570-4410
>> adsjcsp at gmail.com - www.facebook.com/adsjcsp - www.twitter.com/adsjcsp<http://www.twitter.com/adsjcsp>
>>
>> _______________________________________________
>> 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/20130726/300069d1/attachment-0001.html>