Mysql connection error during install

Openfire Openfire Support
1

Hi,

I’‘m having a problem gettig Jive to connect to Mysql during install. I’‘ve created the db, ran the table sql file. I’‘ve checked all the permissions. I can connect to the db using the comand line client. I’‘ve read all the posts I could find in regards to this problem and have tried everything suggested. What can I try next? Here is my error log. I’'m using Mandriva 2005LE

Thanks

2005.08.26 16:50:18 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:108)] Failed to create new connections on startup. Attempt 0 of 3

java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

  • BEGIN NESTED EXCEPTION **

java.net.ConnectException

MESSAGE: Connection refused

STACKTRACE:

java.net.ConnectException: Connection refused

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at java.net.Socket.(ConnectionPool.java:85)

at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProv ider.java:83)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:330)

at org.jivesoftware.messenger.admin.setup_002ddatasource_002dstandard_jsp._jspServ ice(setup_002ddatasource_002dstandard_jsp.java:269)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

  • END NESTED EXCEPTION **

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1851)

at com.mysql.jdbc.Connection.(ConnectionPool.java:108)] Failed to create new connections on startup. Attempt 1 of 3

java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

2

Well lets start with the basics…

You’'ve made a database called “jivemessenger”

You’'ve run the table script to make all the tables etc.

Have you granted permission on that database to the user you are specifing in Messenger?

Have you tried logging into the DB console as that user?

Verify your DNS and Hosts for proper pointers - There is an issue with some distros not resolving “localhost” and 127.0.0.1 to each other.

Run netstat -an and look for open SQL socket, Mandriva was concidering closing this on default installs

Search the forums for MYSQL - there are a nuber of posts of people “strugling” with getting MySQL working http://www.jivesoftware.org/forums/thread.jspa?messageID=101186

Hope this helps

Peter

3

Hey man,

I had the same problem, now I attribute mine to my limited knowledge of MySQL connection strings…

My one and only suggestion is to check your My SQL string, I had this http://[127.0.0.1]:3306/[messenger]

Now any one who has been programming with MySQL very long can tell my problem lol I left the “[]” symbols in there, make sure their removed from your string and then try again…

I feel dumb just mentioning I did that haha

4

Mandriva was concidering closing this on default installs.

To enable, edit /etc/sysconfig/mysqld .