[Installation, Configuration & Deployment] - Re: Starting failed java.sql.SQLException: User not found: S
2:16 a.m.
Iam getting an error on ubuntu while starting Jboss server
My system details
hostname:SERVER
hostname --fqd : localhost
Iam using the following command to start jboss server on ubuntu
sudo ./run.sh on directory root@SERVER:/usr/local/jboss-4.0.5.GA/bin#
When iam typing http://localhost:8080/, iam able to view jboss page.
The error list is as below.Is my jboss server started successfully?If yes then why iam
getting "FAILED" for few in the list below??
root@SERVER:/usr/local/jboss-4.0.5.GA/bin# sudo ./run.jar
./run.jar: 2: Syntax error: word unexpected (expecting ")")
root@SERVER:/usr/local/jboss-4.0.5.GA/bin# sudo ./run.sh
run.sh: Missing file: /lib/tools.jar
run.sh: Unexpected results may occur. Make sure JAVA_HOME points to a JDK and not a JRE.
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /usr/local/jboss-4.0.5.GA
JAVA: java
JAVA_OPTS: -Dprogram.name=run.sh -server -Xms128m -Xmx512m
-Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
CLASSPATH: /usr/local/jboss-4.0.5.GA/bin/run.jar:/lib/tools.jar
=========================================================================
12:07:29,171 INFO [Server] Starting JBoss (MX MicroKernel)...
12:07:29,185 INFO [Server] Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0
date=200610162339)
12:07:29,187 INFO [Server] Home Dir: /usr/local/jboss-4.0.5.GA
12:07:29,187 INFO [Server] Home URL: file:/usr/local/jboss-4.0.5.GA/
12:07:29,189 INFO [Server] Patch URL: null
12:07:29,189 INFO [Server] Server Name: default
12:07:29,189 INFO [Server] Server Home Dir: /usr/local/jboss-4.0.5.GA/server/default
12:07:29,189 INFO [Server] Server Home URL:
file:/usr/local/jboss-4.0.5.GA/server/default/
12:07:29,190 INFO [Server] Server Log Dir: /usr/local/jboss-4.0.5.GA/server/default/log
12:07:29,190 INFO [Server] Server Temp Dir: /usr/local/jboss-4.0.5.GA/server/default/tmp
12:07:29,191 INFO [Server] Root Deployment Filename: jboss-service.xml
12:07:29,864 INFO [ServerInfo] Java version: 1.4.2-02,Blackdown Java-Linux Team
12:07:29,864 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM
Blackdown-1.4.2-02,Blackdown Java-Linux Team
12:07:29,865 INFO [ServerInfo] OS-System: Linux 2.6.17-11-server,i386
12:07:30,514 INFO [Server] Core system initialized
12:07:34,493 INFO [WebService] Using RMI server codebase: http://SERVER:8083/
12:07:34,511 INFO [Log4jService$URLWatchTimerTask] Configuring from URL:
resource:log4j.xml
12:07:39,351 INFO [ServiceEndpointManager] WebServices: jbossws-1.0.3.SP1
(date=200609291417)
12:07:40,303 INFO [SnmpAgentService] SNMP agent going active
12:07:40,888 INFO [InterceptorChainFactory] interceptor chain is:
class org.jboss.cache.interceptors.CallInterceptor
class org.jboss.cache.interceptors.PessimisticLockInterceptor
class org.jboss.cache.interceptors.UnlockInterceptor
class org.jboss.cache.interceptors.ReplicationInterceptor
class org.jboss.cache.interceptors.TxInterceptor
class org.jboss.cache.interceptors.CacheMgmtInterceptor
12:07:41,242 INFO [STDOUT]
-------------------------------------------------------
GMS: address is localhost:32786
-------------------------------------------------------
12:07:43,285 INFO [TreeCache] viewAccepted(): [localhost:32786|0] [localhost:32786]
12:07:43,306 INFO [TreeCache] TreeCache local address is localhost:32786
12:07:43,308 INFO [TreeCache] State could not be retrieved (we are the first member in
group)
12:07:43,308 INFO [TreeCache] parseConfig(): PojoCacheConfig is empty
12:07:43,829 INFO [DefaultPartition] Initializing
12:07:43,895 INFO [STDOUT]
-------------------------------------------------------
GMS: address is localhost:32788 (additional data: 14 bytes)
-------------------------------------------------------
12:07:45,910 INFO [DefaultPartition] Number of cluster members: 1
12:07:45,910 INFO [DefaultPartition] Other members: 0
12:07:45,910 INFO [DefaultPartition] Fetching state (will wait for 30000 milliseconds):
12:07:45,910 INFO [DefaultPartition] New cluster view for partition DefaultPartition (id:
0, delta: 0) : [127.0.0.1:1099]
12:07:45,910 INFO [DefaultPartition] State could not be retrieved (we are the first
member in group)
12:07:45,930 INFO [DefaultPartition] I am (127.0.0.1:1099) received membershipChanged
event:
12:07:45,930 INFO [DefaultPartition] Dead members: 0 ([])
12:07:45,930 INFO [DefaultPartition] New Members : 0 ([])
12:07:45,931 INFO [DefaultPartition] All Members : 1 ([127.0.0.1:1099])
12:07:45,966 INFO [HANamingService] Started ha-jndi bootstrap jnpPort=1100, backlog=50,
bindAddress=/0.0.0.0
12:07:45,978 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on
0.0.0.0/0.0.0.0:1102, group=230.0.0.4, HA-JNDI address=127.0.0.1:1100
12:07:47,025 INFO [CorbaNamingService] Naming:
[IOR:000000000000002B49444C3A6F6D672E6F72672F436F734E616D696E672F4E616D696E67436F6E746578744578743A312E3000000000000200000000000000E0000102000000000A3132372E302E302E31000DC8000000114A426F73732F4E616D696E672F726F6F74000000000000050000000000000008000000004A414300000000010000001C00000000000100010000000105010001000101090000000105010001000000210000005C000000000000000100000000000000240000001C0000007E00000000000000010000000A3132372E302E302E31000DC900400000000000000000001004010008060667810201010100000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
12:07:47,156 INFO [CorbaTransactionService] TransactionFactory:
[IOR:000000000000003049444C3A6F72672F6A626F73732F746D2F69696F702F5472616E73616374696F6E466163746F72794578743A312E30000000000200000000000000E0000102000000000A3132372E302E302E31000DC8000000144A426F73732F5472616E73616374696F6E732F46000000050000000000000008000000004A414300000000010000001C00000000000100010000000105010001000101090000000105010001000000210000005C000000000000000100000000000000240000001C0000007E00000000000000010000000A3132372E302E302E31000DC900400000000000000000001004010008060667810201010100000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
12:07:48,014 INFO [Embedded] Catalina naming disabled
12:07:48,078 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the
classpath. Will load the default rule set.
12:07:48,079 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the
classpath. Will load the default rule set.
12:07:48,487 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
12:07:48,489 INFO [Catalina] Initialization processed in 409 ms
12:07:48,489 INFO [StandardService] Starting service jboss.web
12:07:48,492 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.20
12:07:48,540 INFO [StandardHost] XML validation disabled
12:07:48,589 INFO [Catalina] Server startup in 100 ms
12:07:48,784 INFO [TomcatDeployer] deploy, ctxPath=/invoker,
warUrl=.../deploy/http-invoker.sar/invoker.war/
12:07:49,129 INFO [WebappLoader] Dual registration of jndi stream handler: factory
already defined
12:07:49,712 INFO [TomcatDeployer] deploy, ctxPath=/,
warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
12:07:49,948 INFO [TomcatDeployer] deploy, ctxPath=/jbossws,
warUrl=.../tmp/deploy/tmp28230jbossws-context-exp.war/
12:07:50,132 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil,
warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
12:07:51,519 INFO [TomcatDeployer] deploy, ctxPath=/web-console,
warUrl=.../deploy/management/console-mgr.sar/web-console.war/
12:07:52,596 INFO [MailService] Mail Service bound to java:/Mail
12:07:52,839 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/jboss-ha-local-jdbc.rar
12:07:52,883 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/jboss-ha-xa-jdbc.rar
12:07:52,903 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/jboss-local-jdbc.rar
12:07:52,940 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/jboss-xa-jdbc.rar
12:07:52,996 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/jms/jms-ra.rar
12:07:53,034 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in
.../deploy/mail-ra.rar
12:07:53,978 WARN [ServiceController] Problem starting service
jboss:database=localDB,service=Hypersonic
java.sql.SQLException: User not found: SA
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:761)
at
org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:611)
at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:557)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
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:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy42.start(Unknown Source)
at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy8.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
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:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:490)
at java.lang.Thread.run(Thread.java:534)
12:07:54,335 INFO [ConnectionFactoryBindingService] Bound ConnectionManager
'jboss.jca:name=JmsXA,service=ConnectionFactoryBinding' to JNDI name
'java:JmsXA'
12:07:54,399 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console,
warUrl=.../deploy/jmx-console.war/
12:07:54,810 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss:database=localDB,service=Hypersonic
State: FAILED
Reason: java.sql.SQLException: User not found: SA
Depends On Me:
jboss.jca:name=DefaultDS,service=ManagedConnectionFactory
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:database=localDB,service=Hypersonic
State: FAILED
Reason: java.sql.SQLException: User not found: SA
Depends On Me:
jboss.jca:name=DefaultDS,service=ManagedConnectionFactory
12:07:55,113 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
12:07:55,250 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
12:07:55,262 INFO [JkMain] Jk running ID=0 time=0/35 config=null
12:07:55,271 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0
date=200610162339)] Started in 26s:76ms
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4036953#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...
7036
days inactive
7036
days old
0 comments
1 participants
participants (1)
-
junedkhan