[Openfire-br] Openfire-br Digest, Vol 15, Issue 6
Rui Ornellas Junior
ruiornellas at gmail.com
Wed Sep 11 10:59:59 BRT 2013
Rogério eu tentei fazer uma vez esse procedimento
http://mastigado.wordpress.com/2013/01/25/aumentando-a-memoria-do-java-do-openfire/
Porem quando eu executei o serviço do OpenFire parou.
2013/9/11 <openfire-br-request em listas.softwarelivre.org>
> Send Openfire-br mailing list submissions to
> openfire-br em 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 em listas.softwarelivre.org
>
> You can reach the person managing the list at
> openfire-br-owner em 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. RES: Help Urgente
> (Rog?rio Gonzaga Mendes - Gerente de TI - LagoSan)
> 2. Re: Openfire-br Digest, Vol 15, Issue 4 (Rui Ornellas Junior)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 11 Sep 2013 10:53:08 -0300
> From: Rog?rio Gonzaga Mendes - Gerente de TI - LagoSan
> <informatica em lagosan.com.br>
> To: "'Openfire-BR list'" <openfire-br em listas.softwarelivre.org>
> Subject: [Openfire-br] RES: Help Urgente
> Message-ID:
>
> <!&!AAAAAAAAAAAYAAAAAAAAANuH267OD5FEpddD2R2xL8rCgAAAEAAAAPpyxiIIY3lCt66WivAxOggBAAAAAA==@
> lagosan.com.br>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Bom dia Rui.
>
> Esse problema parece ser nas configura??es do Java.
>
> Procure no Google aumentar mem?ria Java no Openfire, existem v?rios artigos
> que explicam passo-a-passo como fazer o procedimento.
>
> ? bem simples, porem voc? ter? que parar o servi?o do Openfire para
> realizar
> a altera??o.
>
> O ideal tamb?m ? voc? utilizar o MySQL.
>
> Atualmente eu tenho 250 usu?rio ativos no Openfire com banco MySQL e
> funciona 100%.
>
>
>
> Rog?rio Gonzaga O. M. Mendes
>
> Gerente de TI - Lagosan
>
> rogerio em lagosan.com.br
>
> www.lagosan.com.br <http://www.lagosan.com.br/>
>
> (16)3456-8282
>
>
>
> De: openfire-br-bounces em listas.softwarelivre.org
> [mailto:openfire-br-bounces em listas.softwarelivre.org] Em nome de Rui
> Ornellas Junior
> Enviada em: quarta-feira, 11 de setembro de 2013 10:34
> Para: openfire-br em listas.softwarelivre.org
> Assunto: [Openfire-br] Help Urgente
>
>
>
> Pessoal bom dia,
>
>
>
> Ja um tempo estou procurando uma solu??o para o meu problema no meu
> servidor
> de OpenFire, eu estou com o seguinte problema.... eu possuo meu OpenFire
> integrado ao meu Active Directory, e chega uma hora do dia e quem esta
> conectado ao servi?o do openfire permanece e quem n?o esta n?o consegue
> conex?o e depois de uns 10 min todos param de enviar mensagens. Eu estou
> descabelando aqui e revirei os logs do OpenFire e encontrei essas mensagens
> no log do OpenFire ....
>
> Banco de dados do openfire ? interno mesmo, n?o criei instancia em mysql.
>
>
>
> Dados coletados do info.log
>
>
>
> 2013.09.10 11:07:28 org.jivesoftware.database.DbConnectionManager - Unable
> to get a connection from the database pool (attempt 0 out of 10).
>
> java.sql.SQLException: Couldn't get connection because we are at maximum
> connection count (25/25) and there are none available
>
> at
> org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
>
> at
>
> org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:
> 152)
>
> at
> org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
>
> at java.sql.DriverManager.getConnection(Unknown Source)
>
> at java.sql.DriverManager.getConnection(Unknown Source)
>
> at
>
> org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedC
> onnectionProvider.java:61)
>
> at
>
> org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionMana
> ger.java:124)
>
> at
>
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackend.<init>(RrdSqlBackend
> .java:110)
>
> at
>
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackendFactory.open(RrdSqlBa
> ckendFactory.java:36)
>
> at org.jrobin.core.RrdDb.<init>(Unknown Source)
>
> at org.jrobin.core.RrdDb.<init>(Unknown Source)
>
> at
>
> org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEn
> gine.java:361)
>
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> Source)
>
> at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
>
> at java.util.concurrent.FutureTask.run(Unknown Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>
> at java.lang.Thread.run(Unknown Source)
>
>
>
>
>
> Dados coletados do error.log
>
>
>
> 2013.09.11 09:54:31 org.jivesoftware.openfire.handler.IQHandler - Erro
> interno do servidor
>
> java.lang.NullPointerException
>
> at java.util.regex.Matcher.quoteReplacement(Unknown Source)
>
> at
>
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardPro
> vider.java:540)
>
> at
>
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardPro
> vider.java:544)
>
> at
>
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.getVCard(LdapVCardPro
> vider.java:521)
>
> at
>
> org.jivesoftware.openfire.ldap.LdapVCardProvider.loadVCard(LdapVCardProvider
> .java:234)
>
> at
>
> org.jivesoftware.openfire.vcard.VCardManager.getOrLoadVCard(VCardManager.jav
> a:239)
>
> at
>
> org.jivesoftware.openfire.vcard.VCardManager.getVCard(VCardManager.java:232)
>
> at
>
> org.jivesoftware.openfire.handler.IQvCardHandler.handleIQ(IQvCardHandler.jav
> a:120)
>
> at
> org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
>
> at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372)
>
> at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:121)
>
> at
>
> org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:7
> 6)
>
> at
>
> org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:337
> )
>
> at
>
> org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHand
> ler.java:93)
>
> at
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:302)
>
> at
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:194)
>
> at
>
> org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHa
> ndler.java:169)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageRecei
> ved(AbstractIoFilterChain.java:570)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
> (AbstractIoFilterChain.java:299)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoF
> ilterChain.java:53)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageRece
> ived(AbstractIoFilterChain.java:648)
>
> at
>
> org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:
> 80)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
> (AbstractIoFilterChain.java:299)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoF
> ilterChain.java:53)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageRece
> ived(AbstractIoFilterChain.java:648)
>
> at
>
> org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(Simpl
> eProtocolDecoderOutput.java:58)
>
> at
>
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCod
> ecFilter.java:185)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived
> (AbstractIoFilterChain.java:299)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoF
> ilterChain.java:53)
>
> at
>
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageRece
> ived(AbstractIoFilterChain.java:648)
>
> at
>
> org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.j
> ava:239)
>
> at
>
> org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(Exe
> cutorFilter.java:283)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>
> at
>
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:
> 51)
>
> at java.lang.Thread.run(Unknown Source)
>
>
>
> Tipo de implementa??o do OPENFIRE
>
>
>
>
> http://andreysmith.wordpress.com/2010/04/05/openfire-integrando-com-o-active
> -directory/
>
>
>
>
>
> Ambiente
>
>
>
>
> Vers?o e Fabricante da JVM:
>
> 1.6.0_24 Sun Microsystems Inc. -- Java HotSpot(TM) Server VM
>
>
> Servidor de Aplica??o:
>
> jetty/7.0.2-SNAPSHOT
>
>
> Host Name:
>
> servidor
>
>
> SO / Hardware:
>
> Linux / i386
>
>
> Idioma / Fuso Hor?rio:
>
> pt_BR / Fuso hor?rio de Bras?lia (-3 GMT)
>
>
> Mem?ria do Java
>
>
>
> <http://jupter.cruzazul.com.br:9090/images/blank.gif>
>
> <http://jupter.cruzazul.com.br:9090/images/blank.gif>
>
> 791.59 MB of 910.25 MB (87.0%) used
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130911/41014262/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Wed, 11 Sep 2013 10:54:53 -0300
> From: Rui Ornellas Junior <ruiornellas em gmail.com>
> To: openfire-br em listas.softwarelivre.org
> Subject: Re: [Openfire-br] Openfire-br Digest, Vol 15, Issue 4
> Message-ID:
> <CAKJbLe7n9Arn-DV0kNEg72V7UCi4au2CnvY=
> N6-ewJ5Z2EY8GA em mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Marcelo obrigado pelo help, segue abaixo os dados da consulta do SQL, onde
> que fica para alterar o parametro que voc? informou ??
>
> Estat?stica de Consulta do Banco de Dados
>
> Ativa estat?sticas de consulta do banco de dados para rastrear todas as
> consultas feitas no banco. Este recurso pode ser ?til para monitorar a
> performance do banco ou por quest?es de debug. Todavia, n?o ? recomendado
> que voc? deixe as estat?sticas de consulta rodando permanentemente, pois
> elas causar?o degrada??o da performance.
> Status das Estat?sticas de Consulta *Ativado* Desativado
> Configura??es das Estat?sticas de ConsultaAtualizar:
> nenhum
> 10 segundos
> 30 segundos 60 segundos
> 90 segundos
> ||
> *Estat?stica de Consulta SELECT*
>
> N?mero Total de opera??es3.388Tempo total para todas as opera??es (ms)
> 4.516.101Tempo m?dio para cada opera??o (ms)1,332.97Opera??es por
> segundo
> 0.00Consultas SQL mais comuns
> *Consulta**Contar**Tempo Total**Tempo M?dio*SELECT name, list FROM
> ofPrivacyList WHERE username=? AND isDefault=?8391.030.1121.227SELECT
> jid, rosterID, sub, ask, recv, nick FROM ofRoster WHERE username=?479
> 584.1031.219SELECT DISTINCT serviceID FROM ofPubsubNode WHERE
> serviceID=?
> 397455.1541.146SELECT offlinePresence, offlineDate FROM ofPresence WHERE
> username=?395526.5751.333SELECT bytes from ofRRDs where id = ?296205.173
> 693SELECT id FROM ofID WHERE idType=?167282.4161.691SELECT name,
> startTime, endTime FROM ofUserFlag WHERE username=? AND name=?118218.890
> 1.855SELECT isExternal FROM ofConversation WHERE
> conversationID=?9617.846
> 185SELECT SUM(messageSize) FROM ofOffline WHERE
> username=?3170.7502.282SELECT
> name, isDefault FROM ofPrivacyList WHERE username=?2734.4441.275SELECT
> stanza, creationDate FROM ofOffline WHERE username=?2649.4981.903SELECT
> rosterID, groupName FROM ofRosterGroups WHERE rosterID IN (3253, 3257,
> 3259, 3263, 3265, 3267, 3269, 3271, 3275, 3277, 3279, 3281, 3283, 3300,
> 4265, 10430, 12704, 12706, 12708, 13962, 15758, 17227, 17975, 18491,
> 20106)
> ORDER BY rosterID, rank635.1485.858SELECT rosterID, groupName FROM
> ofRosterGroups WHERE rosterID IN (3708, 4381, 7177, 7481, 7483, 7485,
> 7659,
> 7665, 8305, 8695, 10702, 10731, 12250, 12393, 12478, 12682, 12942,
> 13422,
> 14914, 16930, 17053, 17821, 20194) ORDER BY rosterID, rank6233SELECT
> rosterID, groupName FROM ofRosterGroups WHERE rosterID IN (5282, 14103,
> 14105, 14109, 14195, 14202, 14463, 14824, 15613, 15671, 16643, 18004,
> 19188) ORDER BY rosterID, rank547.0319.406SELECT rosterID, groupName
> FROM ofRosterGroups WHERE rosterID IN (7690, 7732, 8413, 8831, 9187,
> 9189,
> 9191, 9193, 9195, 9200, 9203, 9206, 9208, 9212, 9214, 10202, 10204,
> 12010,
> 13023, 16039, 19273) ORDER BY rosterID, rank512.0642.412SELECT rosterID,
> groupName FROM ofRosterGroups WHERE rosterID IN (1203, 3021, 5603, 5881,
> 7323, 7433, 8316, 20138) ORDER BY rosterID, rank52.857571SELECT
> rosterID, groupName FROM ofRosterGroups WHERE rosterID IN (6146, 6148,
> 6672, 6689, 6691, 6693, 7070, 11145, 14694, 14696, 15659, 15860, 17083,
> 17352, 18646, 19884) ORDER BY rosterID, rank512.3052.461SELECT rosterID,
> groupName FROM ofRosterGroups WHERE rosterID IN (7733, 8419, 8833, 8935,
> 8937, 8939, 8941, 8943, 8945, 8947, 8949, 9458, 9806, 9857, 10407,
> 11090)
> ORDER BY rosterID, rank5183SELECT rosterID, groupName FROM
> ofRosterGroups WHERE rosterID IN (3169, 3172, 3174, 3176, 3178, 3190,
> 4976,
> 5584, 8874, 9173, 9729, 10376, 12899, 13206, 14477, 15813, 18199) ORDER
> BY
> rosterID, rank414.1133.528SELECT rosterID, groupName FROM ofRosterGroups
> WHERE rosterID IN (14396, 14398, 14401, 14402, 14408, 14419, 14438,
> 14442,
> 14480, 14482, 14484, 14486, 14495, 14501, 14503, 14631, 14643, 14645,
> 14647, 14803, 14909, 14950, 15032, 15036, 15056, 15092, 15114, 15665,
> 15797, 16401, 17941, 18119, 19201, 19652) ORDER BY rosterID, rank424.804
> 6.201
>
> *Estat?stica de Consulta INSERT*
>
> N?mero Total de opera??es377Tempo total para todas as opera??es (ms)
> 428.555Tempo m?dio para cada opera??o (ms)1,136.75Opera??es por segundo
> 0.00Consultas SQL mais comuns
> *Consulta**Contar**Tempo Total**Tempo M?dio*INSERT INTO
> ofConParticipant(conversationID, joinedDate, bareJID, jidResource,
> nickname) VALUES (?, ?, ?, ?, ?)114153.4741.346INSERT INTO ofOffline
> (username, messageID, creationDate, messageSize, stanza) VALUES (?, ?,
> ?,
> ?, ?)10969.961641INSERT INTO ofMessageArchive(conversationID, fromJID,
> toJID, sentDate, body) VALUES (?, ?, ?, ?, ?)6269.7201.124INSERT INTO
> ofConversation(conversationID, room, isExternal, startDate,
> lastActivity,
> messageCount) VALUES (?, ?, ?, ?, ?, 0)5738.948683INSERT INTO
> ofPresence(username, offlinePresence, offlineDate) VALUES(?, ?, ?)23
> 46.8602.037INSERT INTO ofRosterGroups (rosterID, rank, groupName) VALUES
> (?, ?, ?)825.8303.228INSERT INTO ofRoster (username, rosterID, jid, sub,
> ask, recv, nick) VALUES (?, ?, ?, ?, ?, ?, ?)423.7625.940
>
> *Estat?stica de Consulta UPDATE*
>
> N?mero Total de opera??es429Tempo total para todas as opera??es (ms)
> 463.673Tempo m?dio para cada opera??o (ms)1,080.82Opera??es por segundo
> 0.00Consultas SQL mais comuns
> *Consulta**Contar**Tempo Total**Tempo M?dio*UPDATE ofID SET id=? WHERE
> idType=? AND id=?167162.255971UPDATE ofRRDs SET bytes = ?, updatedDate=?
> WHERE id = ?148164.2211.109UPDATE ofConversation SET lastActivity=?,
> messageCount=? WHERE conversationID=?6236.253584UPDATE ofConParticipant
> SET leftDate=? WHERE conversationID=? AND bareJID=? AND jidResource=?
> AND
> joinedDate=?3946.4001.189UPDATE ofRoster SET sub=?, ask=?, recv=?,
> nick=? WHERE rosterID=?1354.5444.195
>
> *Estat?stica de Consulta DELETE*
>
> N?mero Total de opera??es561Tempo total para todas as opera??es (ms)
> 514.743Tempo m?dio para cada opera??o (ms)917.55Opera??es por
> segundo0.00Consultas
> SQL mais comuns
> *Consulta**Contar**Tempo Total**Tempo M?dio*DELETE FROM ofPresence WHERE
> username=?540514.738953DELETE FROM ofRosterGroups WHERE
> rosterID=?1340DELETE
> FROM ofOffline WHERE username=?810
>
>
>
> 2013/9/11 <openfire-br-request em listas.softwarelivre.org>
>
> > Send Openfire-br mailing list submissions to
> > openfire-br em 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 em listas.softwarelivre.org
> >
> > You can reach the person managing the list at
> > openfire-br-owner em 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. Help Urgente (Rui Ornellas Junior)
> > 2. Re: Help Urgente (Marcelo Terres)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Wed, 11 Sep 2013 10:33:54 -0300
> > From: Rui Ornellas Junior <ruiornellas em gmail.com>
> > To: openfire-br em listas.softwarelivre.org
> > Subject: [Openfire-br] Help Urgente
> > Message-ID:
> > <CAKJbLe7xfhwHdE7jh1gs=T3Ae92HVOOYZBh1N1tmEQ=
> > Vtv-eTg em mail.gmail.com>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Pessoal bom dia,
> >
> > Ja um tempo estou procurando uma solu??o para o meu problema no meu
> > servidor de OpenFire, eu estou com o seguinte problema.... eu possuo meu
> > OpenFire integrado ao meu Active Directory, e chega uma hora do dia e
> quem
> > esta conectado ao servi?o do openfire permanece e quem n?o esta n?o
> > consegue conex?o e depois de uns 10 min todos param de enviar mensagens.
> Eu
> > estou descabelando aqui e revirei os logs do OpenFire e encontrei essas
> > mensagens no log do OpenFire ....
> > Banco de dados do openfire ? interno mesmo, n?o criei instancia em mysql.
> >
> > Dados coletados do info.log
> >
> > 2013.09.10 11:07:28 org.jivesoftware.database.DbConnectionManager -
> Unable
> > to get a connection from the database pool (attempt 0 out of 10).
> > java.sql.SQLException: Couldn't get connection because we are at maximum
> > connection count (25/25) and there are none available
> > at
> > org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
> > at
> >
> >
> org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152)
> > at
> > org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at java.sql.DriverManager.getConnection(Unknown Source)
> > at
> >
> >
> org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:61)
> > at
> >
> >
> org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:124)
> > at
> >
> >
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackend.<init>(RrdSqlBackend.java:110)
> > at
> >
> >
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackendFactory.open(RrdSqlBackendFactory.java:36)
> > at org.jrobin.core.RrdDb.<init>(Unknown Source)
> > at org.jrobin.core.RrdDb.<init>(Unknown Source)
> > at
> >
> >
> org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:361)
> > at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> > Source)
> > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
> > at java.util.concurrent.FutureTask.run(Unknown Source)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> > Source)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> > Source)
> > at java.lang.Thread.run(Unknown Source)
> >
> >
> > Dados coletados do error.log
> >
> > 2013.09.11 09:54:31 org.jivesoftware.openfire.handler.IQHandler - Erro
> > interno do servidor
> > java.lang.NullPointerException
> > at java.util.regex.Matcher.quoteReplacement(Unknown Source)
> > at
> >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:540)
> > at
> >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:544)
> > at
> >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.getVCard(LdapVCardProvider.java:521)
> > at
> >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider.loadVCard(LdapVCardProvider.java:234)
> > at
> >
> >
> org.jivesoftware.openfire.vcard.VCardManager.getOrLoadVCard(VCardManager.java:239)
> > at
> >
> >
> org.jivesoftware.openfire.vcard.VCardManager.getVCard(VCardManager.java:232)
> > at
> >
> >
> org.jivesoftware.openfire.handler.IQvCardHandler.handleIQ(IQvCardHandler.java:120)
> > at
> > org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
> > at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372)
> > at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:121)
> > at
> >
> >
> org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
> > at
> >
> >
> org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:337)
> > at
> >
> >
> org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHandler.java:93)
> > at
> >
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:302)
> > at
> >
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:194)
> > at
> >
> >
> org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandler.java:169)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > at
> >
> >
> org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > at
> >
> >
> org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimpleProtocolDecoderOutput.java:58)
> > at
> >
> >
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:185)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > at
> >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > at
> >
> >
> org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java:239)
> > at
> >
> >
> org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(ExecutorFilter.java:283)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> > Source)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> > Source)
> > at
> >
> >
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
> > at java.lang.Thread.run(Unknown Source)
> >
> > Tipo de implementa??o do OPENFIRE
> >
> >
> >
> http://andreysmith.wordpress.com/2010/04/05/openfire-integrando-com-o-active-directory/
> >
> >
> > Ambiente
> >
> > Vers?o e Fabricante da JVM:1.6.0_24 Sun Microsystems Inc. -- Java
> > HotSpot(TM) Server VMServidor de Aplica??o:jetty/7.0.2-SNAPSHOTHost Name:
> > servidorSO / Hardware:Linux / i386Idioma / Fuso Hor?rio:pt_BR / Fuso
> > hor?rio de Bras?lia (-3 GMT)Mem?ria do Java
> > 791.59 MB of 910.25 MB (87.0%) used
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> >
> http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130911/2ea03552/attachment-0001.html
> > >
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Wed, 11 Sep 2013 10:43:54 -0300
> > From: Marcelo Terres <mhterres em gmail.com>
> > To: Openfire-BR list <openfire-br em listas.softwarelivre.org>
> > Subject: Re: [Openfire-br] Help Urgente
> > Message-ID:
> > <
> > CAGzWidgVwSQYmFohsK4Sw0CaLZ818HHzpFFNtHBiZwAsZq-Zmw em mail.gmail.com>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Pela info:
> >
> > java.sql.SQLException: Couldn't get connection because we are at maximum
> > connection count (25/25) and there are none available
> >
> >
> > Voc? esgotou a quantidade de conex?es simult?neas ao DB. Nunca vi isso
> > acontecer. :-/
> >
> > Voc? pode editar o arquivo openfire.xml e alterar o par?metro na tag:
> >
> > <maxConnections>25</maxConnections>
> >
> >
> > Tente colocar 50 e veja como fica.
> >
> > No console admin do Openfire, na op??o Banco de dados tu pode ativar as
> > estat?sticas de uso do banco e ver informa??es sobre o mesmo.
> >
> > []s
> >
> >
> > Marcelo H. Terres
> > mhterres em gmail.com
> > http://mundoopensource.blogspot.com
> > http://biertasters.blogspot.com
> > http://twitter.com/mhterres
> >
> >
> > On Wed, Sep 11, 2013 at 10:33 AM, Rui Ornellas Junior <
> > ruiornellas em gmail.com
> > > wrote:
> >
> > > Pessoal bom dia,
> > >
> > > Ja um tempo estou procurando uma solu??o para o meu problema no meu
> > > servidor de OpenFire, eu estou com o seguinte problema.... eu possuo
> meu
> > > OpenFire integrado ao meu Active Directory, e chega uma hora do dia e
> > quem
> > > esta conectado ao servi?o do openfire permanece e quem n?o esta n?o
> > > consegue conex?o e depois de uns 10 min todos param de enviar
> mensagens.
> > Eu
> > > estou descabelando aqui e revirei os logs do OpenFire e encontrei essas
> > > mensagens no log do OpenFire ....
> > > Banco de dados do openfire ? interno mesmo, n?o criei instancia em
> mysql.
> > >
> > > Dados coletados do info.log
> > >
> > > 2013.09.10 11:07:28 org.jivesoftware.database.DbConnectionManager -
> > > Unable to get a connection from the database pool (attempt 0 out of
> 10).
> > > java.sql.SQLException: Couldn't get connection because we are at
> maximum
> > > connection count (25/25) and there are none available
> > > at
> > > org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
> > > at
> > >
> >
> org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152)
> > > at
> > > org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
> > > at java.sql.DriverManager.getConnection(Unknown Source)
> > > at java.sql.DriverManager.getConnection(Unknown Source)
> > > at
> > >
> >
> org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:61)
> > > at
> > >
> >
> org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:124)
> > > at
> > >
> >
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackend.<init>(RrdSqlBackend.java:110)
> > > at
> > >
> >
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackendFactory.open(RrdSqlBackendFactory.java:36)
> > > at org.jrobin.core.RrdDb.<init>(Unknown Source)
> > > at org.jrobin.core.RrdDb.<init>(Unknown Source)
> > > at
> > >
> >
> org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:361)
> > > at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
> > > Source)
> > > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown
> Source)
> > > at java.util.concurrent.FutureTask.run(Unknown Source)
> > > at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> > > Source)
> > > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> > > Source)
> > > at java.lang.Thread.run(Unknown Source)
> > >
> > >
> > > Dados coletados do error.log
> > >
> > > 2013.09.11 09:54:31 org.jivesoftware.openfire.handler.IQHandler - Erro
> > > interno do servidor
> > > java.lang.NullPointerException
> > > at java.util.regex.Matcher.quoteReplacement(Unknown Source)
> > > at
> > >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:540)
> > > at
> > >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:544)
> > > at
> > >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.getVCard(LdapVCardProvider.java:521)
> > > at
> > >
> >
> org.jivesoftware.openfire.ldap.LdapVCardProvider.loadVCard(LdapVCardProvider.java:234)
> > > at
> > >
> >
> org.jivesoftware.openfire.vcard.VCardManager.getOrLoadVCard(VCardManager.java:239)
> > > at
> > >
> >
> org.jivesoftware.openfire.vcard.VCardManager.getVCard(VCardManager.java:232)
> > > at
> > >
> >
> org.jivesoftware.openfire.handler.IQvCardHandler.handleIQ(IQvCardHandler.java:120)
> > > at
> > > org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
> > > at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372)
> > > at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:121)
> > > at
> > >
> >
> org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
> > > at
> > >
> >
> org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:337)
> > > at
> > >
> >
> org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHandler.java:93)
> > > at
> > >
> >
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:302)
> > > at
> > >
> >
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:194)
> > > at
> > >
> >
> org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandler.java:169)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > > at
> > >
> >
> org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > > at
> > >
> >
> org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimpleProtocolDecoderOutput.java:58)
> > > at
> > >
> >
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:185)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
> > > at
> > >
> >
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
> > > at
> > >
> >
> org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java:239)
> > > at
> > >
> >
> org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(ExecutorFilter.java:283)
> > > at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> > > Source)
> > > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> > > Source)
> > > at
> > >
> >
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
> > > at java.lang.Thread.run(Unknown Source)
> > >
> > > Tipo de implementa??o do OPENFIRE
> > >
> > >
> > >
> >
> http://andreysmith.wordpress.com/2010/04/05/openfire-integrando-com-o-active-directory/
> > >
> > >
> > > Ambiente
> > >
> > > Vers?o e Fabricante da JVM: 1.6.0_24 Sun Microsystems Inc. -- Java
> > > HotSpot(TM) Server VM Servidor de Aplica??o:jetty/7.0.2-SNAPSHOT Host
> > > Name:servidor SO / Hardware:Linux / i386 Idioma / Fuso Hor?rio:pt_BR /
> > > Fuso hor?rio de Bras?lia (-3 GMT) Mem?ria do Java
> > > 791.59 MB of 910.25 MB (87.0%) used
> > >
> > >
> > > _______________________________________________
> > > Openfire-br mailing list
> > > Openfire-br em 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/20130911/4975b2e2/attachment.html
> > >
> >
> > ------------------------------
> >
> > _______________________________________________
> > Openfire-br mailing list
> > Openfire-br em listas.softwarelivre.org
> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
> >
> >
> > End of Openfire-br Digest, Vol 15, Issue 4
> > ******************************************
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130911/6dabd355/attachment.html
> >
>
> ------------------------------
>
> _______________________________________________
> Openfire-br mailing list
> Openfire-br em listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>
>
> End of Openfire-br Digest, Vol 15, Issue 6
> ******************************************
>
-------------- Pr?xima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130911/f9ce8d65/attachment-0001.html>
More information about the Openfire-br
mailing list