topic Unable to deploy alfresco.war (4.2.c) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-deploy-alfresco-war-4-2-c/m-p/309407#M262537 <HTML><HEAD></HEAD><BODY><SPAN>Hi guys,</SPAN><BR /><SPAN>I am using Alfresco 4.2.c SDK with MySQL. By using this I can run FirstFoundationClient through eclipse. Then I tried to deploy alfresco.war (4.2.c) into tomcat to check created document details but it throws so many errors (please find attached deploy_error.txt for details),&nbsp; </SPAN><BR /><BR /><BR /><SPAN>2013-11-28 13:28:50,734&nbsp; WARN&nbsp; [hibernate.cfg.SettingsFactory] [localhost-startStop-1] Could not obtain connection metadata</SPAN><BR /><SPAN> org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that</SPAN><BR /><SPAN>the postmaster is accepting TCP/IP connections.)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.</SPAN><BR /><SPAN>Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP conne</SPAN><BR /><SPAN>ctions.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 106 more</SPAN><BR /><SPAN>Caused by: java.net.ConnectException: Connection refused: connect</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.DualStackPlainSocketImpl.connect0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:69)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:208)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.PGStream.&lt;init&gt;(PGStream.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 118 more</SPAN><BR /><BR /><BR /><SPAN>My global property file given below,</SPAN><BR /><BR /><SPAN>###############################</SPAN><BR /><SPAN>## Common Alfresco Properties #</SPAN><BR /><SPAN>###############################</SPAN><BR /><BR /><SPAN>dir.root=D:\\alfresco\\alf_data</SPAN><BR /><BR /><BR /><SPAN>alfresco.context=alfresco</SPAN><BR /><SPAN>alfresco.host=127.0.0.1</SPAN><BR /><SPAN>alfresco.port=8080</SPAN><BR /><SPAN>alfresco.protocol=http</SPAN><BR /><BR /><SPAN>share.context=share</SPAN><BR /><SPAN>share.host=127.0.0.1</SPAN><BR /><SPAN>share.port=8080</SPAN><BR /><SPAN>share.protocol=http</SPAN><BR /><BR /><SPAN>### database connection properties - MySQL ###</SPAN><BR /><SPAN>db.script.dialect=org.hibernate.dialect.MySQLInnoDBDialect</SPAN><BR /><SPAN>db.driver=com.mysql.jdbc.Driver</SPAN><BR /><SPAN>db.name=alfresco</SPAN><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><SPAN>db.host=localhost</SPAN><BR /><SPAN>db.port=3306</SPAN><BR /><SPAN>db.pool.max=40</SPAN><BR /><SPAN>db.url=jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8</SPAN><BR /><BR /><SPAN>#hibernate.default_schema = alfresco</SPAN><BR /><BR /><SPAN>### FTP Server Configuration ###</SPAN><BR /><SPAN>ftp.enabled=true</SPAN><BR /><SPAN>ftp.port=21</SPAN><BR /><BR /><SPAN>### RMI service ports ###</SPAN><BR /><SPAN>alfresco.rmi.services.port=50500</SPAN><BR /><SPAN>avm.rmi.service.port=0</SPAN><BR /><SPAN>avmsync.rmi.service.port=0</SPAN><BR /><SPAN>attribute.rmi.service.port=0</SPAN><BR /><SPAN>authentication.rmi.service.port=0</SPAN><BR /><SPAN>repo.rmi.service.port=0</SPAN><BR /><SPAN>action.rmi.service.port=0</SPAN><BR /><SPAN>deployment.rmi.service.port=0</SPAN><BR /><BR /><SPAN>### Initial admin password ###</SPAN><BR /><SPAN>alfresco_user_store.adminpassword=209c6174da490caeb422f3fa5a7ae634</SPAN><BR /><BR /><SPAN>### E-mail site invitation setting ###</SPAN><BR /><SPAN>notification.email.siteinvite=false</SPAN><BR /><BR /><SPAN>### License location ###</SPAN><BR /><SPAN>dir.license.external=D:/alfresco</SPAN><BR /><BR /><SPAN>### Solr indexing ###</SPAN><BR /><SPAN>index.subsystem.name=solr</SPAN><BR /><SPAN>dir.keystore=${dir.root}/keystore</SPAN><BR /><SPAN>solr.port.ssl=8443</SPAN><BR /><BR /><SPAN>### BPM Engine ###</SPAN><BR /><SPAN>system.workflow.engine.jbpm.enabled=false</SPAN><BR /><BR /><BR /><SPAN>Kindly suggest me to resolve this.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Thu, 28 Nov 2013 08:54:11 GMT prabakaran 2013-11-28T08:54:11Z Unable to deploy alfresco.war (4.2.c) https://connect.hyland.com/t5/alfresco-archive/unable-to-deploy-alfresco-war-4-2-c/m-p/309407#M262537 Hi guys,I am using Alfresco 4.2.c SDK with MySQL. By using this I can run FirstFoundationClient through eclipse. Then I tried to deploy alfresco.war (4.2.c) into tomcat to check created document details but it throws so many errors (please find attached deploy_error.txt for details),&nbsp; 2013-11-28 13: Thu, 28 Nov 2013 08:54:11 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-deploy-alfresco-war-4-2-c/m-p/309407#M262537 prabakaran 2013-11-28T08:54:11Z Re: Unable to deploy alfresco.war (4.2.c) https://connect.hyland.com/t5/alfresco-archive/unable-to-deploy-alfresco-war-4-2-c/m-p/309408#M262538 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>but is your alfresco-global.properties under tomcat/shared/classes?</SPAN><BR /><SPAN>Because it seems to try to connect to the PostGresql embedded instance even you configured Alfresco to go with MySQL.</SPAN><BR /><SPAN>Check configuration files and then that MySQL is up and running.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Andrea</SPAN></BODY></HTML> Thu, 28 Nov 2013 09:23:10 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-deploy-alfresco-war-4-2-c/m-p/309408#M262538 abarisone 2013-11-28T09:23:10Z