topic Re: Cannot connect to MySQL at install time linux in Alfresco Archive

Cannot connect to MySQL at install time linux

mrsharkbait — Mon, 10 Apr 2006 17:58:50 GMT

Hi,I am trying to install Alfresco 1.2 on a hosted linux VPS environment. I am installing it via console.MySQL 4.1 is set up and running fine, and I entered the password for the root user in MySQL. When I entered the port information, I getlease enter the port for your MySQL database.MySQL datab

Re: Cannot connect to MySQL at install time linux

gavinc — Mon, 10 Apr 2006 21:01:06 GMT

It probably means you already have a MySQL server running on your machine and using the default port of 3306.

You can either try a different port number during the Alfresco install to see if that works. If you do though, you will have to change the database URL to incude the port number. Have a look at the following wiki page for info on changing the database properties: http://wiki.alfresco.com/wiki/Repository_Configuration

Alternatively, if you don't need the other MySQL server running on your machine stop that instance and try the installer again.

Re: Cannot connect to MySQL at install time linux

mrsharkbait — Wed, 12 Apr 2006 04:09:22 GMT

Ah, so the installer has an embedded MySQL! I wish there was some doc telling me that. Of course since I can't run the installer, I can't get to the docs :?

Is there a way I can install Alfresco into an existing MySQL installation, without having to create yet another instance? My web hosting company will certainly appreciate that. Perhaps I can specify a different port number, then let it install everything, and migrate the tables to the existing installation, then get rid of the new one? If so, what things do I need to look out for?

e

Re: Cannot connect to MySQL at install time linux

gavinc — Wed, 19 Apr 2006 19:34:49 GMT

Yes, you can use an existing database.

Once installed you can configure a custom repository.properties file (see http://wiki.alfresco.com/wiki/Repository_Configuration) to point to your existing MySQL database.

All you'll need to do is create the database and the user you want to use for the alfresco tables and start the server. The server will create the tables for you when it starts.

Alternatively, it may be easier to take one of the zip/tar bundles rather than using the installer as those presume you already have a MySQL install.