5 Replies Latest reply on Jan 23, 2006 6:45 AM by pedrosacosta

mysql in a remote db

pedrosacosta Jan 5, 2006 11:00 AM

I want to access a remote database, by i get an exception:

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server")
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:164)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:519)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:208)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:410)
 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:342)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:73)
 at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:250)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
 at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
 at org.jboss.portal.core.security.store.HibernateCacheLoader.startService(HibernateCacheLoader.java:72)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
 at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
 at org.jboss.cache.TreeCache.createCacheLoader(TreeCache.java:1320)
 at org.jboss.cache.TreeCache.startService(TreeCache.java:1088)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
 at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:428)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
 at $Proxy81.start(Unknown Source)
 at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:185)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
 at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy6.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:428)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy5.deploy(Unknown Source)
 at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
 at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
 at org.jboss.Main.boot(Main.java:187)
 at org.jboss.Main$1.run(Main.java:438)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server"
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
 at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:154)
 ... 130 more
15:52:58,073 WARN [ServiceController] Problem starting service portal:service=TreeCache,type=persistent
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server"))
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:79)
 at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:250)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
 at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
 at org.jboss.portal.core.security.store.HibernateCacheLoader.startService(HibernateCacheLoader.java:72)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
 at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
 at org.jboss.cache.TreeCache.createCacheLoader(TreeCache.java:1320)
 at org.jboss.cache.TreeCache.startService(TreeCache.java:1088)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
 at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:428)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at org.jboss.system.ServiceController.start(ServiceController.java:446)
 at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
 at $Proxy81.start(Unknown Source)
 at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:185)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
 at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy6.deploy(Unknown Source)
 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
 at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
 at $Proxy0.start(Unknown Source)
 at org.jboss.system.ServiceController.start(ServiceController.java:428)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy4.start(Unknown Source)
 at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
 at $Proxy5.deploy(Unknown Source)
 at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
 at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
 at org.jboss.Main.boot(Main.java:187)
 at org.jboss.Main$1.run(Main.java:438)
 at java.lang.Thread.run(Thread.java:595)
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server")
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:164)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:519)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:208)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:410)
 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:342)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:462)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)
 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:73)
 ... 122 more
Caused by: java.sql.SQLException: null, message from server: "#HY000Host 'VS_EMPTY_W2003' is not allowed to connect to this MySQL server"
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
 at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:154)
 ... 130 more

I'm running mysql in the ip: 192.168.25.49, and i'm running the jboss AS in 192.168.24.205.

My portal-mysql-ds.xml is:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>PortalDS</jndi-name>
 <connection-url>jdbc:mysql://192.168.25.49:3306/jbossportal</connection-url>
 <driver-class>org.gjt.mm.mysql.Driver</driver-class>
 <user-name>root</user-name>
 <password>admin</password>
 </local-tx-datasource>
 <no-tx-datasource>
 <jndi-name>NoTxPortalDS</jndi-name>
 <connection-url>jdbc:mysql://192.168.25.49:3306/jbossportal?useServerPrepStmts=false</connection-url>
 <driver-class>org.gjt.mm.mysql.Driver</driver-class>
 <user-name>root</user-name>
 <password>admin</password>
 </no-tx-datasource>
</datasources>

I've mysql connector installed in the right directory.

What's wrong?

Thanks,
Pedro

1. Re: mysql in a remote db

bsmithjj Jan 5, 2006 11:02 AM (in response to pedrosacosta)

You need to go into your MySQL Admin Console and allow remote connections to your DB - that's documented inthe MySQL reference manual. It has nothing to do with JBoss Portal.

Good Luck.
Actions

2. Re: mysql in a remote db

pedrosacosta Jan 5, 2006 2:37 PM (in response to pedrosacosta)

Now, i configure mysql database to access remote connections, and it works fine.

But when a start the portal, i get the following error:

org.jboss.portal.server.invocation.InvocationException: javax.servlet.ServletException: No null layout allowed here
 at org.jboss.portal.core.command.RenderPageCommand.execute(RenderPageCommand.java:155)
 at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:65)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
 at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:72)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:156)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:48)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.NavigationInterceptor.invoke(NavigationInterceptor.java:45)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.invocation.Invocation.invoke(Invocation.java:162)
 at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:94)
 at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:80)
 at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:64)
 at org.jboss.portal.core.CoreController.handle(CoreController.java:177)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
 at $Proxy124.handle(Unknown Source)
 at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:63)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
 at org.jboss.portal.core.aspects.server.SubjectAssociationInterceptor.invoke(SubjectAssociationInterceptor.java:35)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.PolicyAssociationInterceptor.invoke(PolicyAssociationInterceptor.java:40)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:55)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:56)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:171)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:74)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.invocation.Invocation.invoke(Invocation.java:162)
 at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:208)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
Caused by: javax.servlet.ServletException: No null layout allowed here
 at org.jboss.portal.core.command.RenderPageCommand.renderMarkup(RenderPageCommand.java:169)
 at org.jboss.portal.core.command.RenderPageCommand.renderPortlets(RenderPageCommand.java:335)
 at org.jboss.portal.core.command.RenderPageCommand.execute(RenderPageCommand.java:151)
 ... 80 more
19:34:56,910 ERROR [[PortalServletWithPathMapping]] Servlet.service() for servlet PortalServletWithPathMapping threw exception
java.lang.IllegalArgumentException: No null layout allowed here
 at org.jboss.portal.theme.LayoutDispatcher.<init>(LayoutDispatcher.java:64)
 at org.jboss.portal.core.command.RenderPageCommand.renderMarkup(RenderPageCommand.java:164)
 at org.jboss.portal.core.command.RenderPageCommand.renderPortlets(RenderPageCommand.java:335)
 at org.jboss.portal.core.command.RenderPageCommand.execute(RenderPageCommand.java:151)
 at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:65)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
 at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:72)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:156)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:48)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.controller.NavigationInterceptor.invoke(NavigationInterceptor.java:45)
 at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.invocation.Invocation.invoke(Invocation.java:162)
 at org.jboss.portal.core.command.CommandContext.execute(CommandContext.java:94)
 at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:80)
 at org.jboss.portal.core.command.ExecutionContext.execute(ExecutionContext.java:64)
 at org.jboss.portal.core.CoreController.handle(CoreController.java:177)
 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:585)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
 at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
 at $Proxy124.handle(Unknown Source)
 at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:63)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
 at org.jboss.portal.core.aspects.server.SubjectAssociationInterceptor.invoke(SubjectAssociationInterceptor.java:35)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.PolicyAssociationInterceptor.invoke(PolicyAssociationInterceptor.java:40)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:55)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:56)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:171)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:74)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:25)
 at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
 at org.jboss.portal.server.invocation.Invocation.invoke(Invocation.java:162)
 at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:208)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)

3. Re: mysql in a remote db

pedrosacosta Jan 5, 2006 2:38 PM (in response to pedrosacosta)

I don't understand what's going on. Any suggestion?
Actions
4. Re: mysql in a remote db

carpediem Jan 21, 2006 2:33 PM (in response to pedrosacosta)

If it makes you feel any better (and I doubt it does), I landed here after searching, because I am having the same error. And I'm using a localhost install of MySQL, so it isn't due to a remote connection.

We must be doing something wrong, but I think I've followed all the instructions in the install guides. I'll let you know if I figure it out.
Actions
5. Re: mysql in a remote db

pedrosacosta Jan 23, 2006 6:45 AM (in response to pedrosacosta)

For the problem of the exception of "No null layout allowed here", i suggest to take a look at http://www.jboss.org/wiki/Wiki.jsp?page=JBossFaces.

My suggestion is to delete jsf libs in the jboss portal libs directory, and let the jsf libs in the server/deploy/lib do they work.
Actions

Go to original post