6 Replies Latest reply on Jul 15, 2002 11:40 AM by rolfen

    mysql-connector missing user/pwd?

    rolfen
    rolfen Jul 8, 2002 1:13 PM

      I tried to adapt mysql-service.xml but I get
      java.sql.SQLException: General error: Access denied
      for user: '@' to database 'Jive'
      although I configured valid values for "UserName" and "Password".
      Any idea whats missing?


      mysql-service.xml(snippet):

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->

      OldForumDS


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://161.71.70.38/Jive</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">xx</config-property>
      <config-property name="Password" type="java.lang.String">xx</config-property>



      <!--Below here are advanced properties -->
      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



      • 14895 Views
      • Tags:
        • 1. Re: mysql-connector missing user/pwd?
          rolfen
          rolfen Jul 8, 2002 1:15 PM (in response to rolfen)

          MySqlDbRealm (from template) is commented out - no indirection required

            • Actions
          • 2. Re: mysql-connector missing user/pwd?
            rolfen
            rolfen Jul 11, 2002 12:54 PM (in response to rolfen)

            No help?
            Meanwhile I downloaded and adapted template mysql-service.xml (see below) from jboss-all.zip source archive but now I even don't get a jndi-registration "OldForumDS"
            -checked with http://localhost:8082/ViewObjectRes//jboss%3Aservice%3DJNDIView
            What has happened to Jboss Datasource support? For gurus only?

            Regards
            Rolf




            <!--make the rar deploy! hack till better deployment-->
            jboss.jca:service=RARDeployer


            <depends optional-attribute-name="ManagedConnectionFactoryName">
            <!--embedded mbean-->

            <!--hack-->
            <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter

            <!--real attributes-->


            <config-property>
            <config-property-name>ConnectionURL</config-property-name>
            <config-property-type>java.lang.String</config-property-type>
            <config-property-value>jdbc:mysql://161.71.70.38/Jive</config-property-value>
            </config-property>
            <config-property>
            <config-property-name>DriverClass</config-property-name>
            <config-property-type>java.lang.String</config-property-type>
            <config-property-value>org.gjt.mm.mysql.Driver</config-property-value>
            </config-property>
            <config-property>
            <config-property-name>UserName</config-property-name>
            <config-property-type>java.lang.String</config-property-type>
            <config-property-value>username</config-property-value>
            </config-property>
            <config-property>
            <config-property-name>Password</config-property-name>
            <config-property-type>java.lang.String</config-property-type>
            <config-property-value>pwd</config-property-value>
            </config-property>



            OldForumDS



            <depends optional-attribute-name="ManagedConnectionPool">
            <!--embedded mbean-->


            0
            50
            5000
            15
            ByContainer



            <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

            <!-- Include a login module configuration named MySqlDbRealm.
            -->
            <!--comment out this line if you want component managed security or want
            to use the default values in the ManagedConnectionFactoryProperties -->
            <!--
            java:/jaas/MySqlDbRealm
            -->
            java:/TransactionManager




              • Actions
            • 3. Re: mysql-connector missing user/pwd?
              davidjencks
              davidjencks Jul 11, 2002 7:27 PM (in response to rolfen)

              Your second try looks extremely obsolete. I wouldn't trust any source download packages, they seem to be of unpredictable ages.

              I recommend you use 3.0.1 and start with the example provided there. If it does not work, please ask again stating the exact jboss version and showing the entire config file and log from deployment of the adapter and mysql-service file.

                • Actions
              • 4. Re: mysql-connector missing user/pwd?
                rolfen
                rolfen Jul 12, 2002 2:04 PM (in response to rolfen)


                OK, tried mysql-service.xml from CVS - but also didn't get JNDI registration.
                Next, I copied and adapted hsql-service.xml --> xxx-service.xml -> at least I get "denied for user: '@' to database 'Jive' " again.
                Below is console output from deploying xxx-service.xml to occurence of error message (DB-access from webapp)

                I use Jboss3.0.0/Tomcat4.0.3 release version

                Hope you have an idea ;-)


                console output
                ---------------
                2002-07-12 18:58:30,679 INFO [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,679 DEBUG [org.jboss.deployment.MainDeployer] Starting deployment (init step) of package at: file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,689 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/tmp/deploy/server/p.base/deploy/xxx-service.xml/88.xxx-service.xml
                2002-07-12 18:58:30,689 DEBUG [org.jboss.mx.loading.UnifiedLoaderRepository] UnifiedLoaderRepository adding org.jboss.mx.loading.UnifiedClassLoader@6433d{ url=file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/tmp/deploy/server/p.base/deploy/xxx-service.xml/88.xxx-service.xml }
                2002-07-12 18:58:30,689 DEBUG [org.jboss.deployment.MainDeployer] using deployer org.jboss.deployment.SARDeployer@34bed0
                2002-07-12 18:58:30,699 DEBUG [org.jboss.deployment.SARDeployer] about to copy 0 local directories
                2002-07-12 18:58:30,709 DEBUG [org.jboss.deployment.MainDeployer] found 0 subpackages of file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,709 DEBUG [org.jboss.deployment.MainDeployer] Watching new file: file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,709 DEBUG [org.jboss.deployment.MainDeployer] create step for deployment file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,709 DEBUG [org.jboss.deployment.SARDeployer] Deploying SAR, create step: url file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:30,709 DEBUG [org.jboss.deployment.SARDeployer] Registering service UCL=jmx.loading:UCL=410429
                2002-07-12 18:58:30,709 DEBUG [org.jboss.mx.loading.UnifiedLoaderRepository] UnifiedLoaderRepository skipping duplicate org.jboss.mx.loading.UnifiedClassLoader@6433d{ url=file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/tmp/deploy/server/p.base/deploy/xxx-service.xml/88.xxx-service.xml }
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] About to create bean: jboss.jca:service=LocalTxCM,name=OldForumDS
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] code: org.jboss.resource.connectionmanager.LocalTxConnectionManager
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] Created bean: jboss.jca:service=LocalTxCM,name=OldForumDS
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] About to create bean: jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] code: org.jboss.resource.connectionmanager.RARDeployment
                2002-07-12 18:58:30,719 DEBUG [org.jboss.system.ServiceCreator] Created bean: jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] JndiName set to OldForumDS in jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] ManagedConnectionFactoryProperties set to
                <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://161.71.70.38/Jive</config-property>
                <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
                <config-property name="UserName" type="java.lang.String">Root</config-property>
                <config-property name="Password" type="java.lang.String" />
                in jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxDS,name=OldForumDS depends on jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] considering OldRarDeployment with object name jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxCM,name=OldForumDS depends on jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] considering ManagedConnectionFactoryName with object name jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceCreator] About to create bean: jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceCreator] code: org.jboss.resource.connectionmanager.JBossManagedConnectionPool
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceCreator] Created bean: jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] MinSize set to 0 in jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] MaxSize set to 50 in jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] BlockingTimeoutMillis set to 5000 in jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,849 DEBUG [org.jboss.system.ServiceConfigurator] IdleTimeoutMinutes set to 15 in jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,970 DEBUG [org.jboss.system.ServiceConfigurator] Criteria set to ByContainer in jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxCM,name=OldForumDS depends on jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceConfigurator] considering ManagedConnectionPool with object name jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxCM,name=OldForumDS depends on jboss.jca:service=CachedConnectionManager
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceConfigurator] considering CachedConnectionManager with object name jboss.jca:service=CachedConnectionManager
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxCM,name=OldForumDS depends on jboss.security:name=JaasSecurityManager
                2002-07-12 18:58:30,990 DEBUG [org.jboss.system.ServiceConfigurator] considering JaasSecurityManagerService with object name jboss.security:name=JaasSecurityManager
                2002-07-12 18:58:31,100 DEBUG [org.jboss.system.ServiceConfigurator] TransactionManager set to java:/TransactionManager in jboss.jca:service=LocalTxCM,name=OldForumDS
                2002-07-12 18:58:31,100 DEBUG [org.jboss.system.ServiceController] recording that jboss.jca:service=LocalTxCM,name=OldForumDS depends on jboss.jca:service=RARDeployer
                2002-07-12 18:58:31,100 DEBUG [org.jboss.system.ServiceConfigurator] considering with object name jboss.jca:service=RARDeployer
                2002-07-12 18:58:31,110 DEBUG [org.jboss.system.ServiceController] waiting in create jboss.jca:service=LocalTxCM,name=OldForumDS waiting on jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:31,110 WARN [org.jboss.system.ServiceController] jboss.jca:service=LocalTxDS,name=OldForumDS does not implement any Service methods
                2002-07-12 18:58:31,110 DEBUG [org.jboss.system.ServiceController] waiting in create jboss.jca:service=LocalTxCM,name=OldForumDS waiting on jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:31,110 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Creating
                2002-07-12 18:58:31,110 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Created
                2002-07-12 18:58:31,110 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Creating
                2002-07-12 18:58:31,110 DEBUG [org.jboss.management.j2ee.J2EEManagedObject] getObjectName(), name: jboss.management.single:J2EEServer=Single,JCAResource=JCA,j2eeType=JCAConnectionFactory,name=OldForumDS-LocalTxCM
                2002-07-12 18:58:31,110 DEBUG [org.jboss.management.j2ee.J2EEManagedObject] postRegister(), parent: jboss.management.single:J2EEServer=Single,j2eeType=JCAResource,name=JCA
                2002-07-12 18:58:31,110 DEBUG [org.jboss.management.j2ee.J2EEManagedObject] getObjectName(), name: jboss.management.single:j2eeType=JCAManagedConnectionFactory,name=OldForumDS-LocalTxDS
                2002-07-12 18:58:31,120 DEBUG [org.jboss.management.j2ee.J2EEManagedObject] postRegister(), parent: jboss.management.single:J2EEServer=Single,JCAResource=JCA,j2eeType=JCAConnectionFactory,name=OldForumDS-LocalTxCM
                2002-07-12 18:58:31,120 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Created
                2002-07-12 18:58:31,120 DEBUG [org.jboss.deployment.MainDeployer] Done with create step of deploying xxx-service.xml
                2002-07-12 18:58:31,120 DEBUG [org.jboss.deployment.MainDeployer] start step for deployment file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:31,120 DEBUG [org.jboss.deployment.SARDeployer] Deploying SAR, start step: url file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:31,120 DEBUG [org.jboss.system.ServiceController] waiting in start jboss.jca:service=LocalTxCM,name=OldForumDS on jboss.jca:service=LocalTxDS,name=OldForumDS
                2002-07-12 18:58:31,120 DEBUG [org.jboss.system.ServiceController] waiting in start jboss.jca:service=LocalTxCM,name=OldForumDS on jboss.jca:service=LocalTxPool,name=OldForumDS
                2002-07-12 18:58:31,120 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Starting
                2002-07-12 18:58:31,120 INFO [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started
                2002-07-12 18:58:31,120 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Starting
                2002-07-12 18:58:31,270 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property ConnectionURL to value jdbc:mysql://161.71.70.38/Jive
                2002-07-12 18:58:31,400 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property DriverClass to value org.gjt.mm.mysql.Driver
                2002-07-12 18:58:31,540 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property UserName to value Root
                2002-07-12 18:58:31,651 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property Password to value
                2002-07-12 18:58:31,651 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.OldForumDS] Binding object 'org.jboss.resource.adapter.jdbc.local.LocalDataSource@6136f0' into JNDI at 'java:/OldForumDS'
                2002-07-12 18:58:31,651 INFO [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.OldForumDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/OldForumDS'
                2002-07-12 18:58:31,651 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Started
                2002-07-12 18:58:31,651 DEBUG [org.jboss.deployment.MainDeployer] Final (start) deployment step successfully completed on package: xxx-service.xml
                2002-07-12 18:58:31,651 INFO [org.jboss.deployment.MainDeployer] Successfully completed deployment of package: file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:58:31,661 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml -> file:/W:/jboss-3.0.0_tomcat-4.0.3/server/p.base/deploy/xxx-service.xml
                2002-07-12 18:59:27,180 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
                2002-07-12 18:59:27,180 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1026493617180, new next: 1026493617180
                2002-07-12 18:59:27,180 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=Root, password=}
                2002-07-12 18:59:27,180 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Checking driver for URL: jdbc:mysql://161.71.70.38/Jive
                2002-07-12 18:59:27,191 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for url: jdbc:mysql://161.71.70.38/Jive
                2002-07-12 18:59:27,301 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not yet registered for url: jdbc:mysql://161.71.70.38/Jive
                2002-07-12 18:59:27,301 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver already registered for url: jdbc:mysql://161.71.70.38/Jive
                2002-07-12 18:59:27,401 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
                2002-07-12 18:59:27,401 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=true
                2002-07-12 18:59:27,401 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
                2002-07-12 18:59:27,401 INFO [STDOUT] DbConnectionManager: ERROR -->
                2002-07-12 18:59:27,401 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: General error: Access denied for user: '@' to database 'Jive'); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: General error: Access denied for user: '@' to database 'Jive'))
                2002-07-12 18:59:27,401 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:126)
                2002-07-12 18:59:27,401 ERROR [STDERR] at com.coolservlets.forum.database.DbConnectionManager.getConnection(Unknown Source)
                2002-07-12 18:59:27,401 ERROR [STDERR] at com.coolservlets.forum.database.DbAuthorizationFactory.loadUserIDFromDB(Unknown Source)
                2002-07-12 18:59:27,401 ERROR [STDERR] at com.coolservlets.forum.database.DbAuthorizationFactory.getAuthorization(Unknown Source)
                2002-07-12 18:59:27,401 ERROR [STDERR] at org.apache.jsp.login$jsp._jspService(login$jsp.java:98)
                2002-07-12 18:59:27,401 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
                2002-07-12 18:59:27,411 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                2002-07-12 18:59:27,411 ERROR [STDERR] at




                xxx-service.xml
                -----------------


                <!-- ==================================================================== -->
                <!-- New ConnectionManager setup for default hsql dbs -->
                <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
                <!-- ==================================================================== -->



                <!-- Include a login module configuration named HsqlDbRealm.
                Update your login-conf.xml, here is an example for a
                ConfiguredIdentityLoginModule:

                <application-policy name = "HsqlDbRealm">

                <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
                <module-option name = "principal">sa</module-option>
                <module-option name = "userName">sa</module-option>
                <module-option name = "password"></module-option>
                <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=hsqldbDS</module-option>
                </login-module>

                </application-policy>

                NOTE: the application-policy name attribute must match
                SecurityDomainJndiName, and the
                module-option name = "managedConnectionFactoryName"
                must match the object name of the ConnectionManager you are configuring here.
                -->
                <!--uncomment out this line if you are using the DB2DbRealm above
                HsqlDbRealm
                -->

                <depends optional-attribute-name="ManagedConnectionFactoryName">
                <!--embedded mbean-->


                OldForumDS


                <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://161.71.70.38/Jive</config-property>
                <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
                <config-property name="UserName" type="java.lang.String">Root</config-property>
                <config-property name="Password" type="java.lang.String"></config-property>



                <!--Below here are advanced properties -->
                <!--hack-->
                <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper

                <!-- jboss:service=Hypersonic -->



                <depends optional-attribute-name="ManagedConnectionPool">
                <!--embedded mbean-->


                0
                50
                5000
                15
                <!--criteria indicates if Subject (from security domain) or app supplied
                parameters (such as from getConnection(user, pw)) are used to distinguish
                connections in the pool. Choices are
                ByContainerAndApplication (use both),
                ByContainer (use Subject),
                ByApplication (use app supplied params only),
                ByNothing (all connections are equivalent, usually if adapter supports
                reauthentication)-->
                ByContainer


                <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

                <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager

                java:/TransactionManager

                <!--make the rar deploy! hack till better deployment-->
                jboss.jca:service=RARDeployer




                <!-- Moved to end to test anonymous depends -->

                  • Actions
                • 5. Re: mysql-connector missing user/pwd?
                  davidjencks
                  davidjencks Jul 13, 2002 1:49 AM (in response to rolfen)

                  Everything looks ok to me. Why is it reporting user @ rather than Root??? Is Root an accepable user for mysql?

                  How are you trying to get the connection?

                    • Actions
                  • 6. Re: mysql-connector missing user/pwd?
                    rolfen
                    rolfen Jul 15, 2002 11:40 AM (in response to rolfen)

                    I'm sorry for blaming Jboss JCA, but it was my fault:
                    user-id was "root", not "Root". Previous mySQL installation or previous JDBC driver was NOT case sensitive, so ....
                    Diagnostics of mySQL when trying to connect "Root" was really misleading ;-(

                      • Actions