7 Replies Latest reply on Dec 6, 2007 6:02 PM by rodosa

    MySQL & JBoss jBPM

    rodosa
    rodosa Dec 6, 2007 6:31 AM

      Hello!

      I have a problem. I have configured jBPM to run with MySQL, but it doesn't work. When I try if the configuration is right (running this example http://labs.jboss.com/file-access/default/members/jbossas/freezone/docs/Getting_Started_Guide/beta422/html/creating_a_jdbc_client.html) this exception is thrown:

      Exception thrown org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user 'user'@'localhost' (using password: YES)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user 'user'@'localhost' (using password: YES)))

      I've check my personal data (user & password) in mysql-ds.xml and logging.config.xml files and they are correct. Any idea of a posible solution of this problem?


      Thanks a lot!

      Regards

      • 1156 Views
      • Tags:
        • 1. Re: MySQL & JBoss jBPM
          kukeltje
          kukeltje Dec 6, 2007 7:10 AM (in response to rodosa)

          This is not jbpm or even jbossas related. Your db user is just not configured with the correct rights.

            • Actions
          • 2. Re: MySQL & JBoss jBPM
            dleerob
            dleerob Dec 6, 2007 7:54 AM (in response to rodosa)

            Ronald is correct, set up your MySQL user properly.

            Access denied for user 'user'@'localhost' (using password: YES));


            Try creating the user in MySQL using a SQL command on your database similair to: 
            GRANT ALL ON *.* TO 'user'@'localhost' identified by 'yourpassword';


            Of course you may only want to grant access to your specific database, and not all of them, but I dont know what your database is called :)

              • Actions
            • 3. Re: MySQL & JBoss jBPM
              rodosa
              rodosa Dec 6, 2007 10:00 AM (in response to rodosa)

              I've configured the user. The user have asignated the privileges but it doesn't work. I don't know what's wrong!

                • Actions
              • 4. Re: MySQL & JBoss jBPM
                rodosa
                rodosa Dec 6, 2007 10:11 AM (in response to rodosa)

                I' ve forgotten tell us that when the Jboss server starts throws several exceptions. The first exception is the following:

                2007-12-06 15:56:41,343 DEBUG [org.jboss.security.auth.login.XMLLoginConfigImpl] Failed to load config as XML
org.jboss.xb.binding.JBossXBException: Failed to parse source: Open quote is expected for attribute "name" associated with an element type "application-policy". @ *unknown*[180,29]
 at org.jboss.xb.binding.parser.sax.SaxJBossXBParser.parse(SaxJBossXBParser.java:154)
 at org.jboss.xb.binding.UnmarshallerImpl.unmarshal(UnmarshallerImpl.java:183)
 at org.jboss.xb.binding.UnmarshallerImpl.unmarshal(UnmarshallerImpl.java:175)
 at org.jboss.security.auth.login.XMLLoginConfigImpl.loadXMLConfig(XMLLoginConfigImpl.java:322)
 at org.jboss.security.auth.login.XMLLoginConfigImpl.loadConfig(XMLLoginConfigImpl.java:287)
 at org.jboss.security.auth.login.XMLLoginConfigImpl.loadConfig(XMLLoginConfigImpl.java:267)
 at org.jboss.security.auth.login.XMLLoginConfig.startService(XMLLoginConfig.java:176)
 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:585)
 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.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: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:1007)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)
 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: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:464)
 at java.lang.Thread.run(Thread.java:595)
Caused by: org.xml.sax.SAXException: Open quote is expected for attribute "name" associated with an element type "application-policy". @ *unknown*[180,29]
 at org.jboss.xb.binding.parser.sax.SaxJBossXBParser$MetaDataErrorHandler.fatalError(SaxJBossXBParser.java:328)
 at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
 at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
 at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
 at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source)
 at org.apache.xerces.impl.XMLScanner.scanAttributeValue(Unknown Source)
 at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown Source)
 at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
 at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
 at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
 at org.jboss.xb.binding.parser.sax.SaxJBossXBParser.parse(SaxJBossXBParser.java:150)
 ... 54 more


                  • Actions
                • 5. Re: MySQL & JBoss jBPM
                  rodosa
                  rodosa Dec 6, 2007 10:30 AM (in response to rodosa)

                  Hello everybody!!!

                  It's works! I've solucionate. I think that I have to rest. The error was in a letter. The password was bad. I didn't realised of that in the numeral ocasions that I reviwed the data :S .


                  Well, it seems that work!!!! But ... the exception that I post in the previws post didn't disappear. Any idea about that??


                  Thanks a lot!!

                  Regards

                    • Actions
                  • 6. Re: MySQL & JBoss jBPM
                    kukeltje
                    kukeltje Dec 6, 2007 12:28 PM (in response to rodosa)

                    Yes, I have an idea, but it is totally *not* jbpm related. There is a config/format error in login-config.xml

                      • Actions
                    • 7. Re: MySQL & JBoss jBPM
                      rodosa
                      rodosa Dec 6, 2007 6:02 PM (in response to rodosa)

                      Thank you kukeltje! You're right. There was a problem in this file, relationated with a type of quotation mark. It's works!

                      Thank you a lot!

                      Regards

                        • Actions