problem connecting to mysql db

[koski757]

Long story short, a Linux server that was running FreeRADIUS for wireless authentication died. It was replaced with a new server (Server B), but Server A (also Linux), could no longer add/remove users via web interface on our Intranet. Web interface running Apache/Tomcat/Jakarta/Java.

When I try to add a new user, it says:
"There was an error adding the MAC Address to the database:
[Problem checking for duplicate MAC addresses
java.sql.SQLException: Cannot connect to MySQL server on b.b.b.b:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException), HelpDesk::AddMAC::Insert: java.sql.SQLException: Cannot connect to MySQL server on b.b.b.b:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)]"

It acts like it doesn't connect to the db or even see the db, yet...

on server A:
ServerA.39390 ServerB.3306 5840 0 49640 0 ESTABLISHED
ServerA.39391 ServerB.3306 5840 0 49640 0 ESTABLISHED

on server B:
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 b.b.b.b:3306 a.a.a.a:39390 ESTABLISHED
tcp 0 0 b.b.b.b:3306 a.a.a.a:39391 ESTABLISHED

Thank you in advance for any suggestions you may have.

 

[IRudebwoy]

You might need to do a GRANT in MySQL to allow the proper access to the DB.