0 Replies Latest reply on May 4, 2005 1:24 PM by Axl Rose

    JBossMQ using MySQL

    Axl Rose Newbie

      I am trying to change the database used by jbossMQ to mysql. I have taken the following steps.

      1.Copied $JBOSS_HOME/server/default directory to $JBOSS_HOME/server/jbossmq_mysql;
      2.Added mysql-connector-java-3.1.8-bin.jar to jbossmq_mysql/lib
      3.Copied /docs/examples/jca/mysql-ds.xml to jbossmq_mysql/deploy/
      4.Copied /docs/examples/jms/mysql-jdbc2-service.xml to jbossmq_mysql/deploy/jms/
      5.Removed hsqldb-jdbc2-service.xml
      6.Renamed jbossmq_mysql/deploy/jms/hsql-jdbc2-state-service.xml to mysql-jdbc2-state-service.xml
      7.Modified mysql-ds.xml. Changed connection-url,username and password.
      8.Modified DefaultDS to MySqlDS(jndi-name in mysql-ds.xml) in:
      jbossmq_mysql/conf/standardjaws.xml
      jbossmq_mysql/conf/standardjbosscmp-jdbc.xml
      jbossmq_mysql/conf/login-config.xml
      jbossmq_mysql/deploy/jms/mysql-jdbc2-state-service.xml
      9.Also modified type mapping to mySQL(type-mapping in mysql-ds.xml) in
      jbossmq_mysql/conf/standardjaws.xml

      When I do a ./run.sh -c jbossmq_mysql i get the following error

      11:28:53,743 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
      MBeans waiting for other MBeans:
      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      state: CONFIGURED
      I Depend On: jboss:service=TransactionManager
      jboss.jca:name=DefaultDS,service=DataSourceBinding

      Depends On Me:

      MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
      ObjectName: jboss.jca:name=DefaultDS,service=DataSourceBinding
      state: NOTYETINSTALLED
      I Depend On:
      Depends On Me: jboss:service=KeyGeneratorFactory,type=HiLo


      I did not find this line anywhere in the jbossmq_mysql directory ?jboss:service=KeyGeneratorFactory? . May be it's in rar file or something. Can anyone tell me what i might be missing or point to some resources where i can read about this service.
      The datasource works fine and jboss successfully created the following tables on startup:
      | jms_messages | jms_roles | jms_subscriptions | jms_transactions |
      | jms_users | timers |


      The complete output for ./run.sh -c jbossmq_mysql:

      =========================================================================

      JBoss Bootstrap Environment

      JBOSS_HOME: /services/jboss

      JAVA: /services/support/java/bin/java

      JAVA_OPTS: -server -Xms512m -Xmx512m -Dprogram.name=run.sh

      CLASSPATH: /services/jboss/bin/run.jar:/services/support/java/lib/tools.jar

      =========================================================================

      11:28:37,233 INFO [Server] Starting JBoss (MX MicroKernel)...
      11:28:37,234 INFO [Server] Release ID: JBoss [Zion] 4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)
      11:28:37,235 INFO [Server] Home Dir: /services/jboss-4.0.1sp1
      11:28:37,235 INFO [Server] Home URL: file:/services/jboss-4.0.1sp1/
      11:28:37,235 INFO [Server] Library URL: file:/services/jboss-4.0.1sp1/lib/
      11:28:37,236 INFO [Server] Patch URL: null
      11:28:37,236 INFO [Server] Server Name: jbossmq_mysql
      11:28:37,236 INFO [Server] Server Home Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql
      11:28:37,237 INFO [Server] Server Home URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/
      11:28:37,237 INFO [Server] Server Data Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql/data
      11:28:37,237 INFO [Server] Server Temp Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql/tmp
      11:28:37,237 INFO [Server] Server Config URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/conf/
      11:28:37,237 INFO [Server] Server Library URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/lib/
      11:28:37,238 INFO [Server] Root Deployment Filename: jboss-service.xml
      11:28:37,241 INFO [Server] Starting General Purpose Architecture (GPA)...
      11:28:37,648 INFO [ServerInfo] Java version: 1.4.2_07,Sun Microsystems Inc.
      11:28:37,648 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.4.2_07-b05,Sun Microsystems Inc.
      11:28:37,648 INFO [ServerInfo] OS-System: Linux 2.4.21-27.0.4.ELsmp,i386
      11:28:38,012 INFO [Server] Core system initialized
      11:28:40,110 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
      11:28:40,207 INFO [WebService] Using RMI server codebase: http://myndi.net.ku.edu:8083/
      11:28:40,452 INFO [NamingService] Started jndi bootstrap jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
      11:28:44,654 INFO [Embedded] Catalina naming disabled
      11:28:45,498 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
      11:28:45,538 INFO [Catalina] Initialization processed in 760 ms
      11:28:45,540 INFO [StandardService] Starting service jboss.web
      11:28:45,546 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.0.28
      11:28:45,581 INFO [StandardHost] XML validation disabled
      11:28:45,608 INFO [Catalina] Server startup in 69 ms
      11:28:45,824 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/http-invoker.sar/invoker.war/
      11:28:46,810 INFO [TomcatDeployer] deploy, ctxPath=/ws4ee, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/tmp/deploy/tmp54004jboss-ws4ee.war/
      11:28:46,931 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jbossweb-tomcat50.sar/ROOT.war/
      11:28:47,101 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
      11:28:49,146 INFO [MailService] Mail Service bound to java:/Mail
      11:28:49,595 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jboss-local-jdbc.rar
      11:28:49,807 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jboss-xa-jdbc.rar
      11:28:50,020 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jms/jms-ra.rar
      11:28:50,335 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/mail-ra.rar
      11:28:50,875 INFO [ConnectionFactoryBindingService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=JmsXA,service=ConnectionFactoryBinding to JNDI name 'java:JmsXA'
      11:28:51,193 INFO [WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=MySqlDS,service=DataSourceBinding to JNDI name 'java:MySqlDS'
      11:28:52,427 INFO [A] Bound to JNDI name: queue/A
      11:28:52,431 INFO [B] Bound to JNDI name: queue/B
      11:28:52,435 INFO [C] Bound to JNDI name: queue/C
      11:28:52,439 INFO [D] Bound to JNDI name: queue/D
      11:28:52,443 INFO [ex] Bound to JNDI name: queue/ex
      11:28:52,493 INFO [testTopic] Bound to JNDI name: topic/testTopic
      11:28:52,498 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
      11:28:52,502 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
      11:28:52,508 INFO [primaryCDR] Bound to JNDI name: topic/primaryCDR
      11:28:52,513 INFO [gnr] Bound to JNDI name: topic/gnr
      11:28:52,518 INFO [testQueue] Bound to JNDI name: queue/testQueue
      11:28:52,619 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
      11:28:52,707 INFO [DLQ] Bound to JNDI name: queue/DLQ
      11:28:52,758 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jmx-console.war/
      11:28:52,976 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/management/web-console.war/
      11:28:53,743 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
      MBeans waiting for other MBeans:
      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      state: CONFIGURED
      I Depend On: jboss:service=TransactionManager
      jboss.jca:name=DefaultDS,service=DataSourceBinding

      Depends On Me:

      MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
      ObjectName: jboss.jca:name=DefaultDS,service=DataSourceBinding
      state: NOTYETINSTALLED
      I Depend On:
      Depends On Me: jboss:service=KeyGeneratorFactory,type=HiLo


      11:28:53,866 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      11:28:54,007 INFO [ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
      11:28:54,013 INFO [JkMain] Jk running ID=0 time=0/48 config=null
      11:28:54,031 INFO [Server] JBoss (MX MicroKernel) [4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)] Started in 16s:586ms