topic Fresh community 3.4 WAR install fails to start in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/fresh-community-3-4-war-install-fails-to-start/m-p/258873#M212003 <HTML><HEAD></HEAD><BODY><SPAN>I've looked through these forums and haven't found a topic that exactly describes the problem I'm running into.</SPAN><BR /><BR /><SPAN>I have installed alfresco-community-3.4.d.zip on Red Hat Enterprise Linux Server release 5.5, with Sun JDK 6, Tomcat 6 and mysql-connector-java-5.1.15-bin.jar.&nbsp; Alfresco fails to start.&nbsp; It looks as if the error is because Alfresco can't communicate with the database server.&nbsp; The server is running MySQL 5.0.77 (stock RHEL RPM install) on a different RHEL server.&nbsp; I'm able to connect to the remote MySQL server as the Alfresco user via a MySQL command-line client.</SPAN><BR /><BR /><SPAN>Here is the Alfresco config file snippet (from $TOMCAT_HOME/classes/alfresco-global.properties):</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>db.username=alfresco<BR />db.password=_my_alfresco_user_pwd<BR />db.pool.initial=10<BR />db.pool.max=100<BR />db.driver=org.gjt.mm.mysql.Driver<BR />db.url=jdbc:mysql://192.168.0.42/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>The alfresco log file is 2127 lines long–here is a part showing the db connection failing:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp; .<BR />&nbsp;&nbsp; .<BR />&nbsp;&nbsp; .<BR />&nbsp;&nbsp; .<BR />Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy5.setAutoCommit(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.hibernate.DialectFactoryBean.getObject(DialectFactoryBean.java:71)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:143)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 158 more<BR />Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure<BR /><BR />The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 163 more<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure<BR /><BR /><BR />The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:532)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:343)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:774)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:49)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:532)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 166 more<BR />Caused by: java.net.ConnectException: Connection refused<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.socketConnect(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:310)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:176)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:163)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:546)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:495)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:392)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:235)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:292)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 181 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I've verified the datbase name and password, and have logged in to the MySQL server from the Alfresco server as the Alfresco user.&nbsp; The Alfresco database exists, and the Alfresco user's password gives access to the database.</SPAN><BR /><BR /><SPAN>How do I debug the connection problem?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Carl</SPAN></BODY></HTML> Fri, 29 Apr 2011 05:00:48 GMT cgr 2011-04-29T05:00:48Z Fresh community 3.4 WAR install fails to start https://connect.hyland.com/t5/alfresco-archive/fresh-community-3-4-war-install-fails-to-start/m-p/258873#M212003 I've looked through these forums and haven't found a topic that exactly describes the problem I'm running into.I have installed alfresco-community-3.4.d.zip on Red Hat Enterprise Linux Server release 5.5, with Sun JDK 6, Tomcat 6 and mysql-connector-java-5.1.15-bin.jar.&nbsp; Alfresco fails to start.&nbsp; It Fri, 29 Apr 2011 05:00:48 GMT https://connect.hyland.com/t5/alfresco-archive/fresh-community-3-4-war-install-fails-to-start/m-p/258873#M212003 cgr 2011-04-29T05:00:48Z Re: Fresh community 3.4 WAR install fails to start https://connect.hyland.com/t5/alfresco-archive/fresh-community-3-4-war-install-fails-to-start/m-p/258874#M212004 <HTML><HEAD></HEAD><BODY><SPAN>This is fixed.&nbsp; I had a typo in the MySQL server IP address–cut and paste error.&nbsp; Once that was fixed I could connect to the Alfresco server on localhost:8080/alfresco.</SPAN><BR /><BR /><SPAN>I then had to modify this file:</SPAN><BR /><SPAN>&nbsp; /etc/httpd/conf/httpd.conf</SPAN><BR /><SPAN>to allow connections from anywhere else.&nbsp; Here are the diffs for that change:</SPAN><BR /><SPAN>===================================================================</SPAN><BR /><SPAN>RCS file: RCS/httpd.conf,v</SPAN><BR /><SPAN>retrieving revision 1.4</SPAN><BR /><SPAN>diff -r1.4 httpd.conf</SPAN><BR /><SPAN>966a967,978</SPAN><BR /><SPAN>&gt; # set up this proxy configuration for Alfresco</SPAN><BR /><SPAN>&gt; # cgr</SPAN><BR /><SPAN>&gt; # 29 Apr 2011</SPAN><BR /><SPAN>&gt; ProxyRequests Off</SPAN><BR /><SPAN>&gt; ProxyPass /alfresco </SPAN><A href="http://localhost:8080/alfresco" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco</A><BR /><SPAN>&gt; ProxyPassReverse /alfresco </SPAN><A href="http://localhost:8080/alfresco" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco</A><BR /><SPAN>&gt; ProxyPreserveHost On</SPAN><BR /><SPAN>&gt; ProxyRequests Off</SPAN><BR /><SPAN>&gt; ProxyPass /share </SPAN><A href="http://localhost:8080/share" rel="nofollow noopener noreferrer">http://localhost:8080/share</A><BR /><SPAN>&gt; ProxyPassReverse /share </SPAN><A href="http://localhost:8080/share" rel="nofollow noopener noreferrer">http://localhost:8080/share</A><BR /><SPAN>&gt; ProxyPreserveHost On</SPAN><BR /><SPAN>&gt;</SPAN><BR /><BR /><SPAN>Onward and upward…..</SPAN><BR /><BR /><SPAN>Carl</SPAN></BODY></HTML> Fri, 29 Apr 2011 23:19:12 GMT https://connect.hyland.com/t5/alfresco-archive/fresh-community-3-4-war-install-fails-to-start/m-p/258874#M212004 cgr 2011-04-29T23:19:12Z