Hi Jeffrey, Are you able to connect to mysql using the mysql client like this?
$ mysql -h your_host_or_ip -P 3306 -u your_username -pyour_password Cheers, Chris On Wed, Apr 16, 2014 at 6:42 PM, Jeffrey Nguyen (jeffrngu) <[email protected]> wrote: > Hi Nirmal, > > I'm getting the exception below. I 've verified mysql is running on port > 3306, which I configured in setup.conf. Mysql's credential is also correct. > > > TID: [0] [STRATOS] [2014-04-16 13:31:03,331] ERROR > {org.wso2.carbon.user.core.util.DatabaseUtil} - Database Error - Could not > create connection to database server. Attempted reconnect 3 times. Giving > up. {org.wso2.carbon.user.core.util.DatabaseUtil} > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could > not create connection to database server. Attempted reconnect 3 times. > Giving up. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.Util.getInstance(Util.java:384) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) > at > com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2405) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2326) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278) > at > org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188) > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount(ClaimDAO.java:158) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:411) > at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: > Communications link failure > > The last packet sent successfully to the server was 0 milliseconds ago. The > driver has not received any packets from the server. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356) > at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502) > at > com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2344) > ... 39 more > Caused by: java.net.ConnectException: Connection refused > at java.net.PlainSocketImpl.socketConnect(Native Method) > at > java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) > at > java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391) > at java.net.Socket.connect(Socket.java:579) > at java.net.Socket.connect(Socket.java:528) > at java.net.Socket.<init>(Socket.java:425) > at java.net.Socket.<init>(Socket.java:241) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306) > ... 41 more > > > From: Nirmal Fernando <[email protected]> > Reply-To: "[email protected]" > <[email protected]> > Date: Wednesday, April 16, 2014 9:19 AM > To: "[email protected]" <[email protected]> > Subject: Re: Problem setting up multi-profile single JVM > > Can you please send the > /opt/stratos/apache-stratos-default/repository/logs/wso2carbon.log file ? > > > On Wed, Apr 16, 2014 at 10:40 PM, Jeffrey Nguyen (jeffrngu) > <[email protected]> wrote: >> >> Hi, >> >> I followed the instructions on >> https://cwiki.apache.org/confluence/display/STRATOS/4.0.0+Single+JVM+Product+Configuration >> and went through the setup process. After the setup.sh script ran >> successfully (I used default profile), I was not able to load the link to >> Stratos console. The Stratos install log looks clean (see below). Did >> "netstat" and found nothing running on port 9443 and 61616 (activemq). >> There's no info on the wiki for troubleshooting of installation issues. >> There aren't information on what sort of things to verify to make sure >> installation was successful. Any ideas on how to debug this? >> >> Thanks, >> -Jeffrey >> >> >> >> Setup CC >> Setup AS >> Setup SM >> Create and configure MySql Databases >> Setup CEP >> Starting the servers >> 'default' profile selected. >> INFO: Loading '/etc/default/activemq' >> INFO: Using java '/opt/java/jdk1.7.0_07/bin/java' >> INFO: Starting - inspect logfiles specified in logging.properties and >> log4j.properties to get details >> INFO: pidfile created : >> '/opt/stratos/apache-activemq-5.8.0/data/activemq-coi-h1-stack.pid' (pid >> '38648') >> /opt/stratos/apache-stratos-default/bin/stratos.sh -Dprofile=default start > > > > > -- > Best Regards, > Nirmal > > Nirmal Fernando. > PPMC Member & Committer of Apache Stratos, > Senior Software Engineer, WSO2 Inc. > > Blog: http://nirmalfdo.blogspot.com/ -- Check out my professional profile and connect with me on LinkedIn. http://lnkd.in/cw5k69
