Re: Using HSQLDB for Authentication
Sorry, further testing showed that Tomcat was locating one of my databases, but not the one I thought. It was locating a database in %CATALINA_HOME%/data. So the database location and connectionURL which I posted previously are not consistent. Here is the corrected database location: * Locate the HSQLDB database files in %CATALINA_HOME%/data Here is the complete corrected Info: * Locate hsqldb.jar in %CATALINA_HOME%/common/lib * Locate the HSQLDB database files in %CATALINA_HOME%/data * Use the following Realm element in server.xml: -- View this message in context: http://www.nabble.com/Using-HSQLDB-for-Authentication-tf4208687.html#a12478808 Sent from the Tomcat - User mailing list archive at Nabble.com. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Using HSQLDB for Authentication
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert, > * Correct: connectionURL="jdbc:hsqldb:data/Auth" > * Incorrect: connectionURL="jdbc:hsqldb:/localhoast/data/Auth" Thanks for posting a followup to this when you found the answer. Often, dead threads will end in no solution as the OP will disappear thinking that the community doesn't care. We do care; it's just that nobody that read your post knew what to do ;) Now it's in the archives, so hopefully someone will find it when searching. Nice job, - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGzZhD9CaO5/Lv0PARAv9kAJ4kJ+06o4pf6CzW3xAGpd5j6UUhLgCfRjER AseWX5z6dP+VIzsmhgVd5IU= =6FzY -END PGP SIGNATURE- - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Using HSQLDB for Authentication
remmons wrote: > > I am trying to use HSQLDB for container authentication in Tomcat. When > I start Tomcat, I get this message in the catalina.-MM-DD.log: > > INFO: Starting Servlet Engine: Apache Tomcat/5.5.23 > Aug 2, 2007 3:10:29 PM org.apache.catalina.realm.JDBCRealm start > SEVERE: Exception opening database connection > java.sql.SQLException: The database is already in use by another > process: [EMAIL PROTECTED] > =\\localhost\data\Auth.lck, exists=false, locked=false, valid=false, fl > =null]: java.io.FileNotFoundException: \\localhost\data\Auth.lck (The > network path was not found) > > Apparently, Tomcat cannot find my database files. Without success, I > have located them in various places: > > webbapps/MyApp/WEB-INF/data > webbapps/MyApp/WEB-INF/classes/data > webbapps/MyApp/WEB-INF/lib/data > webapps/data > > I am using the following connectionURL: > > connectionURL="jdbc:hsqldb://localhost/data/Auth" > > where Auth is the name of my HSQLDB database with the following files: > > data/Auth.log > data/Auth.properties > data/Auth.script > > I setup my realm in server.xml as follows: > > driverName="org.hsqldb.jdbcDriver" > connectionURL="jdbc:hsqldb://localhost/data/Auth" > connectionName="SA" connectionPassword="" > userTable="USER" userNameCol="USERNAME" > userCredCol="PASSWORD" > userRoleTable="USER_ROLE" roleNameCol="ROLENAME" /> > > Can someone tell me where to put the database files so Tomcat can find > them? I am using Tomcat 5.5. > > -- > Robert Emmons, P.E., Aurigen Inc. > [EMAIL PROTECTED], http://www.aurigen.com > Computer Programming and Consulting > > > - > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > In case anyone is interested, I found the secrets to getting Tomcat to use my HSQLDB database for container authentication: * Locate hsqldb.jar in %CATALINA_HOME%/common/lib * Locate the HSQLDB database files in webapps/myApp/data * Use the following Realm element in server.xml: That is the same Realm element as I used above, except for the connectionURL: * Correct: connectionURL="jdbc:hsqldb:data/Auth" * Incorrect: connectionURL="jdbc:hsqldb:/localhoast/data/Auth" -- View this message in context: http://www.nabble.com/Using-HSQLDB-for-Authentication-tf4208687.html#a12293244 Sent from the Tomcat - User mailing list archive at Nabble.com. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Using HSQLDB for Authentication
I am trying to use HSQLDB for container authentication in Tomcat. When I start Tomcat, I get this message in the catalina.-MM-DD.log: INFO: Starting Servlet Engine: Apache Tomcat/5.5.23 Aug 2, 2007 3:10:29 PM org.apache.catalina.realm.JDBCRealm start SEVERE: Exception opening database connection java.sql.SQLException: The database is already in use by another process: [EMAIL PROTECTED] =\\localhost\data\Auth.lck, exists=false, locked=false, valid=false, fl =null]: java.io.FileNotFoundException: \\localhost\data\Auth.lck (The network path was not found) Apparently, Tomcat cannot find my database files. Without success, I have located them in various places: webbapps/MyApp/WEB-INF/data webbapps/MyApp/WEB-INF/classes/data webbapps/MyApp/WEB-INF/lib/data webapps/data I am using the following connectionURL: connectionURL="jdbc:hsqldb://localhost/data/Auth" where Auth is the name of my HSQLDB database with the following files: data/Auth.log data/Auth.properties data/Auth.script I setup my realm in server.xml as follows: userTable="USER" userNameCol="USERNAME" userCredCol="PASSWORD" userRoleTable="USER_ROLE" roleNameCol="ROLENAME" /> Can someone tell me where to put the database files so Tomcat can find them? I am using Tomcat 5.5. -- Robert Emmons, P.E., Aurigen Inc. [EMAIL PROTECTED], http://www.aurigen.com Computer Programming and Consulting - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]