Problem with integrating Aware IM with MySQL database

Mohammad

In Aware IM system setting when I choose MySQL as database engine :

I will receive the following message when restart Aware IM:

Unable to create or locate the databses required.
Error message databse BASDB Communications link failure due to underlying exeption:

BEGINE NESTED EXCEPTION

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at com.bas.basserver.persistence.dbplugins.MySQLInterface.createDatabase(Unknown Source)
at com.bas.basserver.persistence.DatabaseEnvironment.createDatabase(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager$A.A(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.initialise(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.P.B(Unknown Source)
at com.bas.basserver.bsmanager.K$C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)

** END NESTED EXCEPTION **

intra

Have you setup the required user credentials for MySQL ?

Can you connect to port 3306?

What operating system are you using?

aware_support

This error message indicates that Aware IM cannot connect to MySQL through the TCP/IP port. Either MySQL is running on a different port or the port is blocked.