[jboss-user] [Datasource Configuration] - Re: MySQL problem with multiple instances of JBOSS

[Unmesh Kulkarni]

Unmesh Kulkarni [http://community.jboss.org/people/unmesh_kulkarni] created the discussion

"Re: MySQL problem with multiple instances of JBOSS"

To view the discussion, visit: http://community.jboss.org/message/585066#585066

--------------------------------------------------------------
One strange thing is happening.

If I keep URL jdbc:mysql://192.168.6.128:3306/testenv1 in ds1.xml then connection is successful but if I change it to 
jdbc:mysql://192.168.6.*129*:3306/testenv1 then connection is failing.

Same way,

If I keep URL jdbc:mysql://192.168.6.129:3306/testenv2 in ds2.xml then connection is successful but if I change it to 
jdbc:mysql://192.168.6.*128*:3306/testenv2 then connection is failing.

So looks like MySQL is available on both the IPs (192.168.6.128 & 192.168.6.129) but if I make connection from  
JDBC client running on one IP to MySQL server available on same server then only connection is possible

In simple words

 128 (JDBC client ) to 128 ( MySQL Server) ==== > Pass
 129 (JDBC client ) to 129 ( MySQL Server) ==== > Pass

 128 (JDBC client ) to 129 ( MySQL Server) ==== > Fail
 129 (JDBC client ) to 128 ( MySQL Server) ==== > Fail

Has anyone noticed something similar to this?
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/585066#585066]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110203/24c22aef/attachment.html