Where is mysql/scripts/ctl.sh

[deliciouspickle]

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.  In my installation folder, there is a postgresql folder containing scripts/ctl.sh, but no equivalent mysql folder!  I suspect the reason it keeps trying to do PostgreSQL is because that's the only folder that's there.

So where do I get the mysql folder and its contents for Alfresco???

Or am I on the wrong track here, and there is another way?

Thanks for any help.

[kaynezhang]

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.

[kaynezhang]

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.

[deliciouspickle]

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?

[msauer75]

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

[kaynezhang]

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