One more thing observed is: on the command prompt following works fine:
mysql -u root -h localhost -p mysql -u root -h ip_of_my_m/c -p However, following doesn't work. mysql -u root -h 127.0.0.1 -p ends in following exception: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Can anybody please help to resolve this issue asap? It will be a GREAT help to us. THanks. laxmiraghu wrote: > > HI, > > I developed an application using jetspeed as the portal server and mysql > as backend DB. > > Everything was just fine. Recently i modified my /etc/my.cnf file to > provide remote access to my DB from a remote machine. After that, my > portal server is unable to connect to mysql db lying in the same machine. > > If i undo changes to /etc/my.cnf file, i can't provide remote access to my > db. > > Here is the stack trace: > > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'PlatformConfigurator' defined in ServletContext resource > [/WEB-INF/assembly/boot/datasource.xml]: Invocation of init method failed; > nested exception is org.apache.ojb.broker.metadata.MetadataException: > Could not get the metadata from the given datasource > Caused by: org.apache.ojb.broker.metadata.MetadataException: Could not get > the metadata from the given datasource > at > org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(JdbcMetadataUtils.java:277) > at > org.apache.jetspeed.components.rdbms.ojb.DatabasePlatformConfigurator.init(DatabasePlatformConfigurator.java:70) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1241) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1206) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:428) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352) > at > org.apache.jetspeed.components.SpringComponentManager.start(SpringComponentManager.java:237) > at > org.apache.jetspeed.engine.JetspeedEngine.start(JetspeedEngine.java:122) > at > org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:159) > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966) > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4230) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) > at > org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) > at > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) > at > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:736) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) > at > org.apache.catalina.core.StandardService.start(StandardService.java:448) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:700) > at org.apache.catalina.startup.Catalina.start(Catalina.java:552) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Communications link failure > > "catalina.out" 384L, 30952C > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (Communications link failure > > Last packet sent to the server was 0 ms ago.) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > at > org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(JdbcMetadataUtils.java:261) > ... 44 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: > Communications link failure > > Last packet sent to the server was 0 ms ago. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) > ... 46 more > Caused by: java.net.ConnectException: Connection refused > at java.net.PlainSocketImpl.socketConnect(Native Method) > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) > at > java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) > at java.net.Socket.connect(Socket.java:519) > at java.net.Socket.connect(Socket.java:469) > at java.net.Socket.<init>(Socket.java:366) > at java.net.Socket.<init>(Socket.java:209) > at > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026) > ... 59 more > FATAL: Jetspeed: init() failed: > org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization > exception! > at > org.apache.jetspeed.engine.JetspeedEngine.start(JetspeedEngine.java:144) > at > org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:159) > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966) > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956) > > > Please help to resolve this problem. IT's very urgent. > > THank you. > > -- View this message in context: http://www.nabble.com/Unable-to-connect-to-mysql-tp23592587p23593189.html Sent from the Jetspeed - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
