80,351
社区成员
发帖
与我相关
我的任务
分享
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.<init>(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.<init>(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.<init>(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)
mysql> show databases; <-- 看到没有?我有test数据库
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test | ----------------------------------------这里
+--------------------+
3 rows in set (0.03 sec)
mysql> use test;
Database changed
mysql> show tables; <---------------- 在我没有设置openfire那个的时候,是没有任何表的
Empty set (0.01 sec)
mysql> show tables; <---------------- 在我配置好openfire所有东西之后出现这些表
+----------------------+
| Tables_in_test |
+----------------------+
| ofextcomponentconf |
| ofgroup |
| ofgroupprop |
| ofgroupuser |
| ofid |
| ofmucaffiliation |
| ofmucconversationlog |
| ofmucmember |
| ofmucroom |
| ofmucroomprop |
| ofmucservice |
| ofmucserviceprop |
| ofoffline |
| ofpresence |
| ofprivacylist |
| ofprivate |
| ofproperty |
| ofpubsubaffiliation |
| ofpubsubdefaultconf |
| ofpubsubitem |
| ofpubsubnode |
| ofpubsubnodegroups |
| ofpubsubnodejids |
| ofpubsubsubscription |
| ofremoteserverconf |
| ofroster |
| ofrostergroups |
| ofsaslauthorized |
| ofsecurityauditlog |
| ofuser | <----------------------------这个就是用户表
| ofuserflag |
| ofuserprop |
| ofvcard |
| ofversion |
+----------------------+
34 rows in set (0.00 sec)
mysql> select * from ofuser;
+----------+---------------+-------------------+---------------+----------------
---+--------------+------------------+
| username | plainPassword | encryptedPassword | name | email
| creationDate | modificationDate |
+----------+---------------+-------------------+---------------+----------------
---+--------------+------------------+
| admin | admin | NULL | Administrator | admin@example.c
om | 0 | 0 |
+----------+---------------+-------------------+---------------+----------------
---+--------------+------------------+
1 row in set (0.00 sec)