Wednesday, April 9, 2014

Openfire configuration always wrong


posts by mimixi666 on 2013-09-26 12:00:37 Edit

Always appear error :



A connection to the database could not be made. View the error message by opening the "\ logs \ error.log" log file, then go back to fix the problem.



I went to see the error.log :

 2013.09.26 11:40:03 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype 
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.UnknownHostException
MESSAGE: [host-name]

STACKTRACE:

java.net.UnknownHostException: [host-name]
at java.net.InetAddress.getAllByName (Unknown Source)
at java.net.InetAddress.getAllByName (Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect (StandardSocketFactory.java: 246)
at com.mysql.jdbc.MysqlIO (MysqlIO.java: 271).
at com.mysql.jdbc.Connection.createNewIO (Connection.java: 2771)
at com.mysql.jdbc.Connection (Connection.java: 1555).
at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java: 285)
at java.sql.DriverManager.getConnection (Unknown Source)
at java.sql.DriverManager.getConnection (Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection (DefaultConnectionBuilder.java: 39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection (Prototyper.java: 159)
at org.logicalcobwebs.proxool.Prototyper.sweep (Prototyper.java: 102)
at org.logicalcobwebs.proxool.PrototyperThread.run (PrototyperThread.java: 44)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO (Connection.java: 2847)
at com.mysql.jdbc.Connection (Connection.java: 1555).
at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java: 285)
at java.sql.DriverManager.getConnection (Unknown Source)
at java.sql.DriverManager.getConnection (Unknown Source)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection (DefaultConnectionBuilder.java: 39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection (Prototyper.java: 159)
at org.logicalcobwebs.proxool.Prototyper.sweep (Prototyper.java: 102)
at org.logicalcobwebs.proxool.PrototyperThread.run (PrototyperThread.java: 44)


I do not know where wrong. . .
I have to completely uninstall mysql database, delete all the registry was erased, and restart the computer, and re-installed mysql or not. . .

Who-configured Openfire then guide us, where the configuration of a problem? ? ! ? ! ? ! ?
<-! Main posts under Banner (D4) -><-! Posts under the main text (D5) ->
Reply:
host-name you specified yet
database-name you specified yet
Reply:
cited a floor guoyoulei520 reply:
host-name you specified yet
database-name you specified yet

Finally someone replied, leaving heroes step. . .
host-name
database-name
Where specified?
You said that you specify here?

Or where in the system environment variables set?
Seeking reply! !
This is according to my online tutorial to configure, wood has to be configured to see these two:
host-name
database-name
I do not know if it is accidentally skipped,
Heroes specify what? ? Where is the configuration?

Reply:
reference to the second floor mimixi666 reply:
Quote: references to a floor guoyoulei520 reply:

host-name you specified yet
database-name you specified yet

Finally someone replied, leaving heroes step. . .
host-name
database-name
Where specified?
You said that you specify here?

Or where in the system environment variables set?
Seeking reply! !
This is according to my online tutorial to configure, wood has to be configured to see these two:
host-name
database-name
I do not know if it is accidentally skipped,
Heroes specify what? ? Where is the configuration?


After a long time did not get a lot of ah ..... this online tutorial
Reply:
reference to the third floor guoyoulei520 reply:
Quote: references to the second floor mimixi666 reply:

Quote: references to a floor guoyoulei520 reply:

host-name you specified yet
database-name you specified yet

Finally someone replied, leaving heroes step. . .
host-name
database-name
Where specified?
You said that you specify here?

Or where in the system environment variables set?
Seeking reply! !
This is according to my online tutorial to configure, wood has to be configured to see these two:
host-name
database-name
I do not know if it is accidentally skipped,
Heroes specify what? ? Where is the configuration?


After a long time did not get a lot of ah ..... this online tutorial

Success, a success! ! ! ! !
Thank you, thank you! !
Read a lot of online tutorials do not say you want to configure host-name and database-name is. . .
May be too simple, so do not say, or Zayang. . .
Either way, or fixed up, thank you for your guidance, but for it, is really the first big change ah. . .
Reply:
I have encountered this problem, ah, how I solve it? Seek Reply
Reply:
How somehow you?
Reply:
Database url to change.
Brackets "[]" parameter is the inside of your own to fill, including the "[]" should be deleted weight change, hostname is the database where you want to connect a host name, local or general fill localhost 127.0.0.1; database- name is the library name of the database, such as the landlord is MySQL, then go after MySQL, database-name is in the database that you want to use xxxx xxxx, if there is such a coding requirements can also add some "? useUniCode = true & characterEncoding = xxxx (code set to be used), "Good luck.

No comments:

Post a Comment