7 Replies Latest reply on Dec 6, 2007 6:02 PM by Sara Rodríguez Dorrego

    MySQL & JBoss jBPM

    Sara Rodríguez Dorrego Novice

      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

        • 1. Re: MySQL & JBoss jBPM
          Ronald van Kuijk Master

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

          • 2. Re: MySQL & JBoss jBPM
            David Roberts Apprentice

            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 :)

            • 3. Re: MySQL & JBoss jBPM
              Sara Rodríguez Dorrego Novice

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

              • 4. Re: MySQL & JBoss jBPM
                Sara Rodríguez Dorrego Novice

                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


                • 5. Re: MySQL & JBoss jBPM
                  Sara Rodríguez Dorrego Novice

                  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

                  • 6. Re: MySQL & JBoss jBPM
                    Ronald van Kuijk Master

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

                    • 7. Re: MySQL & JBoss jBPM
                      Sara Rodríguez Dorrego Novice

                      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