Connection to MySql denied

[southin]

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

[roadrunner]

I could not find an error in your jboss-config. So, I think your database is not configured to accept connections from remote.
- change your mysql-config
- Do you have a firewall ?
- Does "C:\telnet 192.168.1.202 3306" work ?
Or are you getting "Connection refused"

bye
Sven

[southin]

Sven:

Thank you for the reply and suggestions. I have tried most of your suggestions with no success.

I have drop my Linux firewall by making changes to the ipchain file, basically accepting any and all input from my home network. But yet I am unable to telnet to the my linux server or successfully connect to the mysql server. I have also diabled my firewall on the Windows 2000 server, the calling compugter. My next thing to do is to check the documentation for Mysql. I did look at the Mysql config file and specified the port to be 3306, but no success. I don't believe there is anything wrong with my network but more with setting up mysql.

Southin

[micahr]

If your mysql server is behind your gateway then you will need to forward the port 3306 back to the server. Look at the ip masquerading documentation for details on how to forward ports. If you have already done this or removed the gateway then you need to make sure that your remote system has permissions to access the linux system. Check hosts.allow and hosts.deny.

[kuma]

Have you added so called anonymous user to MySql?

MySql JDBC driver(or JBoss) seems to connect to MySql as anonymous user.

Kuma

[dsundstrom]

Please, take this discusstion to the "Datasource Configuration" forum.