Install database to separate server

[jasonsfa98]

I am trying to install Alfresco Enterprise on 2 separate servers. One server will run Apache and Tomcat while the other will run the database (MySQL or Postgresql). It seems pretty simple that during the installation process I should simply supply the following information:

jdbc:postgresql://10.0.0.10:5432/alfresco‍

The installation will complete but nothing is ever added to the database. I tried this with MySQL as well:

jdbc:mysql://10.0.0.10/alfresco?useUnicode=yes&characterEncoding=UTF-8‍

and

jdbc:mysql://10.0.0.10:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8‍

With the same results. The documentation on getting this done seems to be scattered about and I have yet to put it all together. Our goal is to use Share on a pair of dedicated Amazon EC2 instances with EBS volumes for the OS, database and content stores. I suppose we could put it all on one machine but we'd prefer to split the load so that we could handle high usage and be more flexible should the usage grow.

Has anyone had any success with this during installation? If so, could you please share your methods of getting it done?

Thanks.

[mrogers]

You need to post errors from your alfresco log files.    But I'm guessing that you will simply have a connection failure.

But it should be straightforward.

Set up your database in the remote Db.   Create your empty alfresco schema and accounts.   Set the database url in alfresco-global.properties.    Start alfresco. That should be it.

[jasonsfa98]

I agree, it should be straightforward. However, I cannot make the modifications to that file until it's installed. In order to install it I have to tell it where the database lives.

Chicken? Egg?

[mrogers]

If you want to use the installer then install locally and then cut it over to your other database.     Or don't use the installer at all.

[jasonsfa98]

Where can I download something other than the installer? I am looking at the "Enterprise Trial Download" page and don't see anything that's clearly Alfresco Enterprise in a non-installer package. Perhaps the ZIP file under "other"?

[mrogers]

yes.

[faithzondo]

I`m having problems connection to the SQL Database which on a separate server to Alfreso,I trying this installation for the first time,I have edited the Global properties file but I still cannot loggin