MySQL Connection problem

[Migrated From Jforum.net]

Hi,


i which to install jforum with a mysql 4.0.21 DB, but during installation i ever get a connection error. I have tested other users and users without password but allways the same error.
something that doesn't shows correct is that in the error allways user root with password = yes but i don,t use the user root (i Have tested with them too).

when trying hsqldb everything works.

have anyone any idea whats the problem?

Thanks

mfg Gideon

Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: 
Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"'.

** BEGIN NESTED EXCEPTION ** 

java.sql.SQLException
MESSAGE: Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"

STACKTRACE:

java.sql.SQLException: Invalid authorization specification message from server: 
"Access denied for user: 'root@localhost' (Using password: YES)"
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1898)
	at com.mysql.jdbc.Connection.<init>(Connection.java:450)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at net.jforum.SimpleConnection.getConnection(SimpleConnection.java:91)
	at net.jforum.SimpleConnection.init(SimpleConnection.java:73)
	at net.jforum.view.install.InstallAction.configureDatabase(InstallAction.java:425)
	at net.jforum.view.install.InstallAction.doInstall(InstallAction.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at net.jforum.Command.process(Command.java:88)
	at net.jforum.view.install.InstallAction.process(InstallAction.java:588)
	at net.jforum.InstallServlet.service(InstallServlet.java:120)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.

[originally posted on jforum.net by Gideon]

[Migrated From Jforum.net]

Hhmmm.. Which JForum version? 2.0 or 2.0.1?

As I check this issue, you can try configuring JForum manually.. Is not complex. Just follow the steps as described at http://www.jforum.net/install_no_wizard.htm

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Hi,

Rafael Steil wrote:Hhmmm.. Which JForum version? 2.0 or 2.0.1?

I use the 2.0.1 Version.

Thanks.

mfg Gideon.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I had the same problem. In fact, it's depend on how you are supposed to access the database.

My internet host provider gave me 2 URLs:

mysql:jdbc://servername:port/account

and

mysql:jdbc://servernameDNS/account

I had the problem with the second, and not with the first one.

I think it's because my web site already used the first URL and JForum provide a connection pool.

So, check if you don't have concurrent access to database. Check also if you are using the last driver for both (web site and jforum).
[originally posted on jforum.net by Blackwings]

[Migrated From Jforum.net]

Well, I released a new version of JForum, which fixes some issues with the installer. Please download at http://www.jforum.net/download.htm.

Thanks.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Hi,

I think the problem is that the properties file is not update when a user set values for the username and the password.
Hence, database.connection.string is not updated to and then jforum use always root as username and password.
To fixe the bug, these lines has to be add in:

**********************************************************

p.load(new FileInputStream(SystemGlobals.getValue(ConfigKeys.CONFIG_DIR) + "/database/" + type + "/" + type + ".properties"));

//update the file proprieties
p.put(ConfigKeys.DATABASE_CONNECTION_HOST, host);
p.put(ConfigKeys.DATABASE_CONNECTION_USERNAME, username);
p.put(ConfigKeys.DATABASE_CONNECTION_PASSWORD, password);
p.put(ConfigKeys.DATABASE_CONNECTION_DBNAME, dbName);
p.put(ConfigKeys.DATABASE_CONNECTION_ENCODING, encoding);
p.store(new java.io.FileOutputStream(SystemGlobals.getValue(ConfigKeys.CONFIG_DIR) + "/database/" + type + "/" + type + ".properties"), "MySql settings");
p.load(new FileInputStream(SystemGlobals.getValue(ConfigKeys.CONFIG_DIR) + "/database/" + type + "/" + type + ".properties"));


**********************************************************

class: InstallationAction.java
method: configureDatabase()
location: before the loop for() and after p.load(...)
(In the source code I have, it's the line 549 but I made some modifications...)

Normally, it's working
Best greats
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Problem is that installation (mysql) writes to wrong config-file. Fix file and problem is away.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Gideon wrote:Hi,


i which to install jforum with a mysql 4.0.21 DB, but during installation i ever get a connection error. I have tested other users and users without password but allways the same error.
something that doesn't shows correct is that in the error allways user root with password = yes but i don,t use the user root (i Have tested with them too).

when trying hsqldb everything works.

have anyone any idea whats the problem?

Thanks

mfg Gideon

Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: 
Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"'.

** BEGIN NESTED EXCEPTION ** 

java.sql.SQLException
MESSAGE: Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"

STACKTRACE:

java.sql.SQLException: Invalid authorization specification message from server: 
"Access denied for user: 'root@localhost' (Using password: YES)"
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1898)
	at com.mysql.jdbc.Connection.<init>(Connection.java:450)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at net.jforum.SimpleConnection.getConnection(SimpleConnection.java:91)
	at net.jforum.SimpleConnection.init(SimpleConnection.java:73)
	at net.jforum.view.install.InstallAction.configureDatabase(InstallAction.java:425)
	at net.jforum.view.install.InstallAction.doInstall(InstallAction.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at net.jforum.Command.process(Command.java:88)
	at net.jforum.view.install.InstallAction.process(InstallAction.java:588)
	at net.jforum.InstallServlet.service(InstallServlet.java:120)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Gideon wrote:Hi,


i which to install jforum with a mysql 4.0.21 DB, but during installation i ever get a connection error. I have tested other users and users without password but allways the same error.
something that doesn't shows correct is that in the error allways user root with password = yes but i don,t use the user root (i Have tested with them too).

when trying hsqldb everything works.

have anyone any idea whats the problem?

Thanks

mfg Gideon

Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: 
Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"'.

** BEGIN NESTED EXCEPTION ** 

java.sql.SQLException
MESSAGE: Invalid authorization specification message from server: "Access denied for user: 'root@localhost' (Using password: YES)"

STACKTRACE:

java.sql.SQLException: Invalid authorization specification message from server: 
"Access denied for user: 'root@localhost' (Using password: YES)"
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:954)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1898)
	at com.mysql.jdbc.Connection.<init>(Connection.java:450)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at net.jforum.SimpleConnection.getConnection(SimpleConnection.java:91)
	at net.jforum.SimpleConnection.init(SimpleConnection.java:73)
	at net.jforum.view.install.InstallAction.configureDatabase(InstallAction.java:425)
	at net.jforum.view.install.InstallAction.doInstall(InstallAction.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at net.jforum.Command.process(Command.java:88)
	at net.jforum.view.install.InstallAction.process(InstallAction.java:588)
	at net.jforum.InstallServlet.service(InstallServlet.java:120)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

When add user add acces by it's host
See mysql manual about users management.
(grant ... no ... to 'username'@'hostname')
or just change mysql.users table so as you need and make flush privileges.
[originally posted on jforum.net by Ilya1st]