cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco with existing MySql in Ubuntu - JDBC settings

mcollins323
Champ in-the-making
Champ in-the-making
I have a standard install of MySql and I simply want to use that vs another install of MySql on ubuntu.

I created a database via the MySql Admin called alfresco.

The 2 questions it aske you during the install are:
jdbc:url and jdbc:driver

I have MySql installed on port 3306 (default) but it is not installing the tables.

This is what my alfresco-global.properties file looks like with jdbc settings.

I am assuming that driver is inside Tomcat ?

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=xx
db.password=xxxxxxxxx
db.name=alfresco
db.url=jdbc:mysql://127.0.0.1:3306/alfresco
3 REPLIES 3

mcollins323
Champ in-the-making
Champ in-the-making
So I'd appreciate any pointers to what I might be doing wrong.  Thanks.

At what point does Alfresco create the tables? 

It would be nice to have the install test the connection before just continuing with install too.

Thanks.

mcollins323
Champ in-the-making
Champ in-the-making
Figured it out.

Needed to use actual ip and not 127.0.0.1

All set.

fluca1978
Champ in-the-making
Champ in-the-making
At what point does Alfresco create the tables?

Tables are created as soon as you connect to the service.