5 Replies Latest reply on Aug 28, 2002 4:04 PM by Dain Sundstrom

    Connection to MySql denied

    Southin Simphoukham Newbie

      Hi:

      I am trying to determine why my connection to mysql db on a Linux 7.2 machine is denied.

      I get the following message:

      [XADataSourceLoader] Starting
      [WPower] java.sql.SQLException: Server configuration denies access to data sourc
      e
      [WPower] Pool WPower factory org.jboss.pool.jdbc.xa.XAConnectionFactory@267649 u
      nable to create new object!
      [WPower] java.sql.SQLException: Server configuration denies access to data sourc
      e
      [WPower] Pool WPower factory org.jboss.pool.jdbc.xa.XAConnectionFactory@267649 u
      nable to create new object!
      [WPower] java.sql.SQLException: Server configuration denies access to data sourc
      e
      [WPower] Pool WPower factory org.jboss.pool.jdbc.xa.XAConnectionFactory@267649 u
      nable to create new object!
      [WPower] java.sql.SQLException: Server configuration denies access to data sourc
      e
      [WPower] Pool WPower factory org.jboss.pool.jdbc.xa.XAConnectionFactory@267649 u
      nable to create new object!

      When I run Jboss 2.4.4 with Tomcat 4.0 on the Linux machine it works fine.

      I am trying to connect from a Windows 2000 machine.

      I have installed the mm.mysql-2.0.8.jar in the lib/ext folder.


      My Jboss jcml is:

      <!-- ==================================================================== -->
      <!-- JDBC -->
      <!-- ==================================================================== -->


      org.hsqldb.jdbcDriver,org.gjt.mm.mysql.Driver



      1476
      true
      default
      false



      DefaultDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:hsqldb:hsql://localhost:1476
      1200000
      sa
      10

      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0



      WPower
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:mysql://192.168.1.202:3306/WPOWER
      1200000
      XXXXXX
      50
      XXXXX
      true
      true
      false
      true
      120000
      1800000
      false
      true
      1.0
      10


      I read from
      http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ i need to change my password in the mysql database. I need that and still it does not work.

      Any ideas?

      Thanks,

      Southin