• I followed this http://www.studytrails.com/blog/installing-wordpress-on-j2ee-app-serveer-apache-tomcat-using-quercus/ tutorial to install WordPress on Tomcat using Quercus. I installed wordpress in the site directory (/opt/tomcat/webapps/site/). I configured it by adding the database details in the wp-config.php file. Then to connect to mysql by Quercus, I added the https://dev.mysql.com/downloads/connector/j/ mysql connector to /webapps/site/WEB-INF/lib/ directory. But when I go to http://myserver/site to follow the instructions to install wordpress, I get this error:

    
    /opt/tomcat/webapps/site/wp-includes/wp-db.php:1531: Warning: A link to the server could not be established. url=jdbc:mysql://localhost/?jdbcCompliantTruncation=false&characterSetResults=ISO8859_1&characterEncoding=ISO8859_1&useServerPrepStmts=true driver=com.mysql.jdbc.Driver java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. [mysqli_real_connect] /opt/tomcat/webapps/dotways/wp-includes/wp-db.php:792: Warning: Connection is not available: null [mysqli_query]
    
    Can’t select database We were able to connect to the database server (which means your username and password is okay) but not able to select the dbsite database.
    
Viewing 1 replies (of 1 total)
  • Sorry if this clue is silly, but does the database user you created have all the necessary privileges to change things in the DB? If the connection to the server is fine, the next two failure points i can think of is invalid login or invalid privileges.

Viewing 1 replies (of 1 total)

The topic ‘WordPress in Quercus on tomcat: Error database connection’ is closed to new replies.