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

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.