AnsweredAssumed Answered

MySQL database other than 'alfresco'

Question asked by cflong on Sep 10, 2007
Latest reply on Sep 26, 2007 by sergio
While installing Alfresco Community 2.1 from the community-tomcat package, I have been unable to successfully connect to a mysql db named anything other than "alfresco".

I have attempted to set this with the db.url variable in custom-repository.properties as such:
db.username=testuser
db.password=password
db.pool.initial=10
db.pool.max=20

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco_test
where  the database was created as such:
create database alfresco_test;
grant all on alfresco.* to 'testuser'@'localhost' identified by 'password' with grant option;
grant all on alfresco.* to 'testuser'@'localhost.localdomain' identified by 'password' with grant option;

I have no trouble when using the same config/username/password with a database named "alfresco".  Is this a limitation of alfresco or are there additional configuration steps needed to actually use a different database name?

Outcomes