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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-18-2014 06:37 AM
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.
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.
Labels:
- Labels:
-
Archive
13 REPLIES 13
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2014 05:15 AM
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.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2014 10:44 AM
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2014 12:23 PM
Can you first try creating a db on local and check if it is working for you or not.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2014 09:24 AM
Thank you for reply. It's resolved. Password was just wrong.
