[RESOLVED]V. 3.0 remote mysql server db.host doesn't work

[ta_ba_so_usr]

Hello !

With V. 3.0 what is the correct way to indicate the remote mysql server please ?
db.host in alfresco.global.properties is ignore and custom-repository.properties doesn't exist.
Error is still the same :

Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'X.X.X.X' to database 'alfresco')

X.X.X.X is the localhost IP server.
Notice : connection from shell works perfectly.

Apache Tomcat/6.0.39
Alfresco V. 3.0

Thank you.

[romschn]

alfresco-global.properties file should be at location - tomcat\shared\classes

Could you please try creating a new database and point to it. Please follow below steps and check if it is working or not.
1.
create database yourdbname default character set utf8;
grant all on yourdbname.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on yourdbname.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

2. Modify following entries in alfresco-global.properties file.
db.username=
db.password=
db.driver=
db.url=

3. Make sure the mysql connector jar is added in tomcat/lib and mysql is running.

[ta_ba_so_usr]

1.
Create database, not on localhost but on remote server.
Create user and privileges with grant (remote connection works with success)
2.
alfresco-global.properties changed
3.
mysql connector is well added (when it's not, an error is raised).

The error is still the same.
When I make a volontary error, I've got the "Communication failure" error and when I write the good parameters, the IP of the localhost server is taken instead of the the remote server. It seems that db.url reads db.host but it replaces it with the IP of the localhost server.

[romschn]

Can you first try creating a db on local and check if it is working for you or not.

[ta_ba_so_usr]

Thank you for reply. It's resolved. Password was just wrong.