|
路过高手请帮忙,RedHat3.0下_mysql4018连接问题如下,resin和j2sdk,apache都是好的,想来可能是权限的问题,在本机用mysql -uroot -p可进入,查mysql里的user表如下:
mysql> select user,host from user;
+------+----------------+
| user | host |
+------+----------------+
| | 61.234.228.136 |
| root | 61.234.228.136 |
| | localhost |
| root | localhost |
+------+----------------+
4 rows in set (0.00 sec)
用jsp连出错信息如下
500 Servlet Exception
java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:399)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at com.caucho.sql.XADataSourceAdapter.getXAConnection(XADataSourceAdapter.java:119)
at com.caucho.sql.XADataSourceAdapter.getPooledConnection(XADataSourceAdapter.java:141)
at com.caucho.sql.DBPool.createConnection(DBPool.java:1404)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1334)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1198)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
at _vod3._default__jsp._jspService(/vod3/default.jsp:16)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin 2.1.8 (built Thu Mar 6 11:50:23 PST 2003) |
|