Mysql controls access by user and hostname of the system the client is
on. So you'll have to fix it by either creating a user
'magnolia'@'server2' or if you are really confident the database is
well protected, use % in the hostname of the user account as a
wildcard (by itself or as part of a dns name).
-- David
On Jun 8, 2010, at 1:46 PM, Will Scheidegger <[email protected]>
wrote:
Hm... so our server admins fixed the network rules. I can telnet
from server2 to the MySQL-DB on server1:
srv02:~> telnet server1 3306
[...]
Escape character is '^]'.
[...]
?ScwN_tI,O3MlXTz-nc&0Connection closed by foreign
host.
And I granted the neccessary rights. But now I'm getting a different
error message:
2010-06-08 19:45:10,887 ERROR .ContainerBase.[Catalina].[localhost].
[/cms].[jsp]: Servlet.service() for servlet jsp threw exception
java.sql.SQLException: Access denied for user
'magnolia'@'server2' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
....
Any further ideas?
Thanks,
-will
----------------------------------------------------------------
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]>
----------------------------------------------------------------
