Bingo! It's not the firewall causing the problems (same subnet here), but the MySQL configuration itself. The "bind-addess" was set to 127.0.0.1. Thanks for the help. I'll try to get this fixed....
-will On 08.06.2010, at 14:38, David Smith wrote: > > Next in line to test is the firewall. Does the box with the database accept > connections on port 3306?6 > > -- David > > On Jun 8, 2010, at 8:24 AM, Will Scheidegger <[email protected]> wrote: > >> >> Thanks Gregory and David! I guess I misunderstood the concept of the @-part >> of the username. I thought this would be the server where the user has >> access to, not the host from where he/she is allowed to access the db. >> Anyway, what I did now was >> >> grant all on mag_cms.* to 'magnolia'@'mag.server.ip.no' >> >> Then I tried again from "mag.server.ip.no": >> >> Connection conn = >> DriverManager.getConnection("jdbc:mysql://212.103.75.242:3306/mag_cms", >> "magnolia", "password"); >> conn.close(); >> >> Still, same java.net.ConnectException: Connection refused! >> Any other ideas what I could test? >> >> Thanks! >> -will >> >> On 08.06.2010, at 13:46, Grégory Joseph wrote: >> >>> >>> >>> On Jun 8, 2010, at 11:55, Will Scheidegger wrote: >>> >>>> grant all on mag_cms.* to 'magnolia'@'localhost'; >>> <...> >>>> DriverManager.getConnection("jdbc:mysql://serverip#:3306/mag_cms", >>>> "magnolia", "password"); >>> >>> There's the problem. You're granting access via localhost, but access the >>> server - either remotely or locally but via ip. >>> >>> -g >>> >>> >>> ---------------------------------------------------------------- >>> For list details see >>> http://www.magnolia-cms.com/home/community/mailing-lists.html >>> To unsubscribe, E-mail to: <[email protected]> >>> ---------------------------------------------------------------- >>> >> >> >> ---------------------------------------------------------------- >> For list details see >> http://www.magnolia-cms.com/home/community/mailing-lists.html >> To unsubscribe, E-mail to: <[email protected]> >> ---------------------------------------------------------------- >> > > ---------------------------------------------------------------- > For list details see > http://www.magnolia-cms.com/home/community/mailing-lists.html > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
