[Openfire-br] ERRO NO BANCO DE DADOS!!! POR FAVOR ME AJUDEM!!! URGENTE!!!

Openfire-BR list openfire-br at listas.softwarelivre.org
Mon Oct 29 15:44:52 BRST 2012


Prezados Colegas,

Alguém pode me ajudar por favor?

Tenho um servidor openfire no windows 7 que roda a quase 2 anos sem
problemas.
O Backup de toda a pasta Openfire é feito diariamente as 20:00
(sobrescrevendo o backup anterior).

Houve queda de energia neste domingo e o servidor não carrega mais
(mensagem em anexo). Nem consigo acessar o console.
O Backup também está com problemas pois copiou a pasta com problemas...

Por favor vejam as mensagens em anexo.

Alguém conhece uma maneira de recuperar o BD?
Algum comando de restauração?

Se por acaso não tiver jeito mais, alguém sabe quais arquivos eu devo
copiar para migrar todos os usuários e grupos já criados para uma nova
instalação?

Conto com vocês. Obrigado.

-- 
*-----------------------------------------------------------
Kleber Pedro Pires
kleberpedro at gmail.com*
62-8408-5995
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121029/e68a047e/attachment-0001.html>
-------------- next part --------------
Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: error in script file line: 230293 java.io.IOException: java.io.IOException: Unexpected end of command
	at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:764)
	at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:480)
	at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:212)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at java.lang.Class.newInstance0(Unknown Source)
	at java.lang.Class.newInstance(Unknown Source)
	at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:113)
	at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:58)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
	at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: error in script file line: 230293 java.io.IOException: java.io.IOException: Unexpected end of command
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:151)
	at org.jivesoftware.openfire.XMPPSErro iniciando o servidor. Por favor verifique os arquivos de log para mais informações.
erver.verifyDataSource(XMPPServer.java:754)
	... 16 more
Server halted
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Telas de erro openfire.png
Type: image/png
Size: 170825 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121029/e68a047e/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: error.log
Type: application/octet-stream
Size: 565331 bytes
Desc: not available
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20121029/e68a047e/attachment-0001.obj>


More information about the Openfire-br mailing list