topic Re: Where is mysql/scripts/ctl.sh in Alfresco Archive

Where is mysql/scripts/ctl.sh

deliciouspickle — Tue, 13 Aug 2013 00:58:24 GMT

I can't seem to get Alfresco to work with MySQL. I've installed MySQL, created the database, etc. all according to the help file. However whenever I start Alfresco, it still wants to run PostgreSQL.I noticed in the alfresco.sh file that it looks for a file called $INSTALLDIR/mysql/scripts/ctl.sh.

Re: Where is mysql/scripts/ctl.sh

kaynezhang — Tue, 13 Aug 2013 02:10:27 GMT

First you should install mysql.
then create a database called alfresco (or other name),and create username and password for it

Then set these properties in alfresco-global.properties
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8
db.username=username
db.password=password
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
manu
and restart your alfresco server,it'll create tables automatically,you don't need to execute mysql scripts manually.

Re: Where is mysql/scripts/ctl.sh

kaynezhang — Tue, 13 Aug 2013 02:13:59 GMT

Re: Where is mysql/scripts/ctl.sh

deliciouspickle — Tue, 13 Aug 2013 13:35:51 GMT

Did all that. Didn't work. After restarting Alfresco server, it always runs postgresql/scripts/ctl.sh. Terminal looks like this:

/Applications/alfresco-4.1.5/postgresql/scripts/ctl.sh : postgresql (pid 67538) already running

How do I get it to use MySQL instead of PostgreSQL?

Re: Where is mysql/scripts/ctl.sh

kaynezhang — Thu, 15 Aug 2013 08:37:21 GMT

you can use Alfresco WAR files for manual install into existing application servers and using existing mysql .

Re: Where is mysql/scripts/ctl.sh

msauer75 — Thu, 15 Aug 2013 15:51:10 GMT

Hi I have a similarly problem. After first run tomcat / alfresco created all mysql tables but I don't know how I log in. All tables are empty.

best regards

martim