AnsweredAssumed Answered

alfresco-community-3.4.b-installer-linux-x32.bin ; use MySQL

Question asked by fasold on Dec 12, 2010
Latest reply on Dec 19, 2010 by jamo88
For others to save time…

What I have done: downloaded alfresco-community-3.4.b-installer-linux-x32.bin and installed it on my Ubuntu 9.10; it should be mentioned that you need to execute the installer with 'root'; I wanted to use the already installed MySQL instance and gave the MySQL-root user to connect to the db in the install wizard.

What happened (Symptom): after the installation finished, I started with ./alfresco.sh but received error messages in the alfresco.log:
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory

Solution: this error, nor "alfresco database missing" or "alfresco database not created" or a hint when or from which script it will be created cannot be found in the forum/wiki/web. Former distributions had apparently a script db_setup.sql which created the database. Therefore I did the following:

mysql -uroot -p
mysql> create database alfresco;
mysql> create user 'alfresco'@'localhost' IDENTIFIED BY 'alfresco';
mysql> grant all privileges on alfresco.* to 'alfresco'@'localhost' ;
Insert the user and its password into tomcat/shared/classes/alfresco-global.properties. With the next start of alfresco the missing tables were created in the DB and I could make use of it.

Porposal: update this installation scenario in the documentation with the hint to create the db and provide a script to create the database and user.

Outcomes