Thanks Chris,
I fixed the connection issue with mysql below. It was because my default
installation of mysql binds to external IP, while Stratos is trying to
connect to it using the 172.0.0.1. I fixed by changing the binding port
for mysql.
Now I'm hitting another connection issue my message broker. After running
setup.sh, I noticed nothing is running on port 61616. I'm using activeMQ.
From the Stratos install log, it says "/etc/default/activemq". I looked
at that script, it looks like the home directory for active mq doesn't
match with where we install active MQ (/opt/stratos/apache-activemq-5.8.0).
TID: [0] [STRATOS] [2014-04-16 13:52:12,884] ERROR
{org.apache.stratos.messaging.broker.subscribe.TopicSubscriber} - Error
while subscribing to the topic: instance-status
{org.apache.stratos.messaging.broker.subscribe.TopicSubscriber}
javax.jms.JMSException: Could not connect to broker URL:
tcp://127.0.0.1:61616. Reason: java.net.ConnectException: Connection
refused
at
org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.jav
a:35)
at
org.apache.activemq.ActiveMQConnectionFactory.createActiveMQConnection(Acti
veMQConnectionFactory.java:293)
at
org.apache.activemq.ActiveMQConnectionFactory.createActiveMQConnection(Acti
veMQConnectionFactory.java:238)
at
org.apache.activemq.ActiveMQConnectionFactory.createTopicConnection(ActiveM
QConnectionFactory.java:214)
at
org.apache.stratos.messaging.broker.connect.TopicConnector.init(TopicConnec
tor.java:68)
at
org.apache.stratos.messaging.broker.subscribe.TopicSubscriber.doSubscribe(T
opicSubscriber.java:65)
at
org.apache.stratos.messaging.broker.subscribe.TopicSubscriber.run(TopicSubs
criber.java:101)
at java.lang.Thread.run(Thread.java:722)
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.j
ava: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
org.apache.activemq.transport.tcp.TcpTransport.connect(TcpTransport.java:49
6)
at
org.apache.activemq.transport.tcp.TcpTransport.doStart(TcpTransport.java:45
9)
at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:55)
at
org.apache.activemq.transport.AbstractInactivityMonitor.start(AbstractInact
ivityMonitor.java:140)
at
org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:58
)
at
org.apache.activemq.transport.WireFormatNegotiator.start(WireFormatNegotiat
or.java:72)
at
org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:58
)
at
org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:58
)
at
org.apache.activemq.ActiveMQConnectionFactory.createActiveMQConnection(Acti
veMQConnectionFactory.java:273)
... 6 more
On 4/16/14 10:48 AM, "chris snow" <[email protected]> wrote:
>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(NativeConstructorAc
>>cessorImpl.java:57)
>> at
>>
>>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConst
>>ructorAccessorImpl.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(NativeConstructorAc
>>cessorImpl.java:57)
>> at
>>
>>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConst
>>ructorAccessorImpl.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(PooledCon
>>nection.java:278)
>> at
>>
>>org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.jav
>>a:182)
>> at
>>
>>org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPoo
>>l.java:701)
>> at
>>
>>org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPoo
>>l.java:635)
>> at
>>
>>org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.j
>>ava:188)
>> at
>>
>>org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy
>>.java:127)
>> at
>>
>>org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount(ClaimDAO.jav
>>a: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(Defa
>>ultRealmService.java:223)
>> at
>>
>>org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmS
>>ervice.java:101)
>> at
>>
>>org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmS
>>ervice.java:114)
>> at
>>
>>org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:6
>>9)
>> at
>>
>>org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheck
>>Activator.java:61)
>> at
>>
>>org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleCo
>>ntextImpl.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(BundleCo
>>ntextImpl.java:683)
>> at
>>
>>org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHos
>>t.java:381)
>> at
>>
>>org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBu
>>ndle.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(StartL
>>evelManager.java:457)
>> at
>>
>>org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLeve
>>l(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(EventManag
>>er.java:230)
>> at
>>
>>org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventMan
>>ager.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(NativeConstructorAc
>>cessorImpl.java:57)
>> at
>>
>>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConst
>>ructorAccessorImpl.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:3
>>39)
>> 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:2
>>58)
>> 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+Pro
>>>duct+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
