今天,我设法使用Scalr.net重新创建服务器场,显然在几次重新启动tomcat并解决问题后,我又一次收到此错误。问题是我在整个服务器上使用MySQL进行全新安装,其中包括Java 6.1_24,Tomcat 5.5.33,Sakai 2.7.1。当我在MySQL实例中拥有此用户的事实时,我一直遇到的问题被用户拒绝,并使用sakai @%给予它完全的远程访问权限,即使自发布以来大约一个小时前,它也无法正常工作被制造。

... Continued from above log, everything before logs just fine
2011-03-31 18:31:14,120  WARN main org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy - Could not retrieve default auto-commit and transaction isolation settings
org.apache.commons.dbcp.SQLNestedException: Error preloading the connection pool
... continued over 400+ lines...


这是关于拒绝访问错误的另一个错误...

2011-03-31 18:31:16,854  WARN main org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
java.sql.SQLException: Access denied for user 'sakai'@'ec2-50-17-184-70.compute-1.amazonaws.com' (using password: YES)
.... continued....


现在,每次启动时都会出现此错误,这是全新安装的tomcat / sakai

SEVERE: Unable to set localhost. This prevents creation of a GUID. Cause was: ec2-72-44-56-167.compute-1.amazonaws.com: ec2-72-44-56-167.compute-1.amazonaws.com
java.net.UnknownHostException: ec2-72-44-56-167.compute-1.amazonaws.com: ec2-72-44-56-167.compute-1.amazonaws.com


(这个最近的错误(Localhost)只是通过重新启动amazon aws实例而修复的。值得庆幸的是)尽管我在进行全新安装时仍然遇到相同的错误……几乎就像是从缓存中刷新信息一样……或者某事

最佳答案

与最后一个问题you posted on this topic一样,错误消息看起来也很清楚:用户'sakai'@...无权登录到您已将其设置为数据库。建议您查看the Mysql documentation,以了解如何管理用户帐户,以了解是否错过了允许该帐户访问的设置。

10-06 01:20