Hi,
I tried now to setup webical but I failed.
My system is FreeBSD 7 with tomcat 6.0.14, mysql-connector-java-5.1.6
and diablo-jdk-1.5.0.07.01_9 installed.
I created a symlink for the mysql-connector in the directory apache-
tomcat-6.0/lib
0 lrwxr-xr-x 1 root wheel 54 Apr 7 19:17 mysql-connector-
java.jar -> /usr/local/share/java/classes/mysql-connector-java.jar
Then I created a database webical and created a user webical which can
access that database (with a different password like in the
documentation).
Then I imported the two sql files into the database so that the tables
are created and the first user for authentification is created (there
I changed the username and password, like in the manual described).
Tested with the tool mysql if the user can connect with the password
to that database and everything works fine.
Then I deployed the webical.war with the tomcat manager interface and
edited the file webical/META-INF/context.xml to use the correct
password.
<Realm className="org.apache.catalina.realm.JDBCRealm"
debug="4"
driverName="com.mysql.jdbc.Driver"
connectionName="webical"
connectionPassword="deleted here"
connectionURL="jdbc:mysql://localhost:3306/webical?
autoReconnect=true"
userTable="_auth_user"
userNameCol="username"
userCredCol="userpass"
userRoleTable="_auth_userrole"
roleNameCol="role"/>
<Resource
name="jdbc/calendarDataBase"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
username="webical"
password="deleted here"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/webical?
autoReconnect=true" />
Then I restarted my tomcat that everything will be loaded freshly, but
I got a lot of error lines in log/webical.log, I think the important
ones are:
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
413)
Caused by:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could
not create connection to database server. Attempted reconnect 3 times.
Giving up.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
980)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
926)
at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:
718)
at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
282)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:
38)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:
294)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:
1247)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:
1221)
... 45 more
Caused by: java.sql.SQLException: Access denied for user
'webical'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
... 52 more
2008-04-08 17:24:50,224 WARN JDBCExceptionReporter - SQL Error: 0,
SQLState: null
It looks like it cannot access the database, but username, password,
database everything looks fine in that file.
Do you have an idea how to solve that problem?
Best regards,
Matthias
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"webical-developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/webical-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
