1 Reply Latest reply on Apr 6, 2009 2:55 AM by anil.saldhana

    SOS! Error:Access denied for user ''@'localhost' (using pass

    michaelfgh

      Hi, all,

      I use the JBoss5.0.0GA version, when I make my datasource encryption, I have as follows exception,

      MySQL5.1:

      18:11:13,337 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO))

      Oracle 11g:
      18:37:41,171 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-01017: invalid username/password; logon denied


      this situation it can't work, my configuration as follows:

      <mbean code="org.jboss.security.auth.login.DynamicLoginConfig" display-name="..." name="...">
       <attribute name="AuthConfig">login-config.xml</attribute>
       <depends optional-attribute-name="LoginConfigService">jboss.security:service=XMLLoginConfig</depends>
       <depends optional-attribute-name="SecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
       </mbean>


      in my login-config.xml, it has the database information,

      <application-policy name="fgdb-password-encrypted">
       <authentication>
       <login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required">
       <module-option name="username">jb5b</module-option>
       <module-option name="password">298399ffe7e4289f</module-option>
       <module-option name="managedConnectionFactoryName">fg.ds:service=LocalTxCM,name=fg_framework.fgdbPool</module-option>
       </login-module>
       </authentication>
       </application-policy>


      if I don't use datasource encryption, my server works very well.
      I don't how to solve this problem,
      Can someone give me some hints?
      any help can be appreciated.