Creating new context fails (MySQLNonTransientConnectionException)

[floeschie]

Hey there,

I'd like to write an installation howto for installing open-xchange community edition on an ubuntu 8.04 LTS server using the open-xchange repository.

Right now I'm on step "Creating your first context and users" of the Quick Install Guide for the Hosting Edition. Unfortunately, when running the createcontext script, I get a Java exception error and I don't know what's wrong:

$ sudo /opt/open-xchange/sbin/createcontext -A oxadminmaster -P mysecret -c 1 -N mycontext -u administrator -d "System Administrator" -g System -s Administrator -p myothersecret -e administrator@mydomain.tld -q 1024 -L defaultcontext --access-combination-name=all

Error message:

context 1 could not be created:
Server response:
 com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

[Edit]
When using a wrong password I get this error message, so connection seems to be possible somehow...

context 1 could not be created:
Server response: Authentication failed

[/Edit]


I can access the database using user "root" (no password) or user "openexchange" via the mysql client console without problems...

mysql> SELECT User, Host from mysql.user;
+------------------+---------------------+
| User             | Host                |
+------------------+---------------------+
| openexchange     | %                   |
| root             | %                   |
| root             | 127.0.0.1           |
| openexchange     | 192.168.178.10      |
| openexchange     | eriador             |
| root             | eriador             |
| debian-sys-maint | localhost           |
| openexchange     | localhost           |
| root             | localhost           |
| openexchange     | host.mydomain.tld |
+------------------+---------------------+
10 rows in set (0.00 sec)

Any hints?

[raistlin]

I have the same problem when i try to configure the context. Does anybody know a solution?

[Carsten Hoeger]

Please do not forget to post logs!

/var/log/open-xchange/open-xchange-admin.log.0

[raistlin]

Sorry, my fault, attache you'll find the logfile

[Carsten Hoeger]

Caused by: java.sql.SQLException: Access denied for user 'openexchange'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
        ... 23 more

Please check configured database username and password.
You can check with:

mysql -h localhost -u openexchange -p configdb

[raistlin]

tested, i can login without any problems.

But the createcontext-command exits still with the failure. If i change the password, then the failure message "Authentication failed" appears.

It seems the connect to the database is made but then there is a failure in processing some command.

[Carsten Hoeger]

tested, i can login without any problems.

But the createcontext-command exits still with the failure. If i change the password, then the failure message "Authentication failed" appears.

It seems the connect to the database is made but then there is a failure in processing some command.

check whether the output of

/opt/open-xchange/sbin/listdatabase -A oxadminmaster -P YOURSECRET --csv

contains the correct username/password to authenticate to your database.

The username/password combination to access the database must be configured in two places:

1.

/opt/open-xchange/etc/admindaemon/configdb.properties

2. with the

registerdatabase

command.

[raistlin]

Now it works, thanks for your help. It seems like i had a little password shaking. I#va made a new installation on a clean server and now it's running