topic Install database to separate server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250342#M203472 <HTML><HEAD></HEAD><BODY><SPAN>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:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>jdbc:postgresql://10.0.0.10:5432/alfresco<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>The installation will complete but nothing is ever added to the database. I tried this with MySQL as well:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>jdbc:mysql://10.0.0.10/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>and</SPAN><BR /><PRE class="language-none line-numbers"><CODE>jdbc:mysql://10.0.0.10:3306/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>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.</SPAN><BR /><BR /><SPAN>Has anyone had any success with this during installation? If so, could you please share your methods of getting it done?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Fri, 01 Jun 2012 16:07:45 GMT jasonsfa98 2012-06-01T16:07:45Z Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250342#M203472 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<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://10.0.0.1 Fri, 01 Jun 2012 16:07:45 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250342#M203472 jasonsfa98 2012-06-01T16:07:45Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250343#M203473 <HTML><HEAD></HEAD><BODY><SPAN>You need to post errors from your alfresco log files.&nbsp;&nbsp;&nbsp; But I'm guessing that you will simply have a connection failure.</SPAN><BR /><BR /><SPAN>But it should be straightforward.</SPAN><BR /><BR /><SPAN>Set up your database in the remote Db.&nbsp;&nbsp; Create your empty alfresco schema and accounts.&nbsp;&nbsp; Set the database url in alfresco-global.properties.&nbsp;&nbsp;&nbsp; Start alfresco. That should be it.</SPAN></BODY></HTML> Fri, 01 Jun 2012 16:23:25 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250343#M203473 mrogers 2012-06-01T16:23:25Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250344#M203474 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Chicken? Egg?</SPAN></BODY></HTML> Fri, 01 Jun 2012 16:27:28 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250344#M203474 jasonsfa98 2012-06-01T16:27:28Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250345#M203475 <HTML><HEAD></HEAD><BODY><SPAN>If you want to use the installer then install locally and then cut it over to your other database.&nbsp;&nbsp;&nbsp;&nbsp; Or don't use the installer at all.</SPAN></BODY></HTML> Fri, 01 Jun 2012 16:51:49 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250345#M203475 mrogers 2012-06-01T16:51:49Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250346#M203476 <HTML><HEAD></HEAD><BODY><SPAN>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"?</SPAN></BODY></HTML> Fri, 01 Jun 2012 18:33:00 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250346#M203476 jasonsfa98 2012-06-01T18:33:00Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250347#M203477 <HTML><HEAD></HEAD><BODY><SPAN>yes.</SPAN></BODY></HTML> Sat, 02 Jun 2012 07:55:24 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250347#M203477 mrogers 2012-06-02T07:55:24Z Re: Install database to separate server https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250348#M203478 <HTML><HEAD></HEAD><BODY><SPAN>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</SPAN></BODY></HTML> Tue, 12 Mar 2013 09:24:11 GMT https://connect.hyland.com/t5/alfresco-archive/install-database-to-separate-server/m-p/250348#M203478 faithzondo 2013-03-12T09:24:11Z