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

[fasold]

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.

[jamo88]

Hello,

Thank you for providing this information. But could you please also provide your changes to alfresco-global.properties? I'd like to try a formally installed mysql via apt-get, instead of the bundled one. What other changes did you have to make to use a non-bundled mysql?

Also it'd be a lot of help if you could post your /etc/hosts. 

mine is just:

10.0.2.5  debian

And with that I at least get to the login box in share, but cannot log in, nor I can access alfresco (I get a 404 error)

The thing is I too get the same mysql connection report you posted. I did try your solution,  and netstat indicates the port 3306 is opened, and I checked that the alfresco database was reallly created. I'm also able to log in to mysql with the alfresco user and all grants are there.


Thanks,

J.M.