I'm trying to set up Tomcat 5 to use a JDBCRealm that points to a MS SQL
Server 2000 instance. I also have a datasource set up to the same
database instance. I can get one or the other to work, but not both
together. If I move the JDBCRealm inside my Host or Context tag, the
datasource
Is there any way to intercept login information when using basic or form
based security and letting the container manage security?
For example, after someone logs in, I would like to write an audit record
to the database that contains that information so I can count number of
logins etc.
Funk [EMAIL PROTECTED]
11/19/2003 05:37 PM
Please respond to
Tomcat Users List [EMAIL PROTECTED]
To
Tomcat Users List [EMAIL PROTECTED]
cc
Subject
Re: JDBC Realm
Get rid of the single quotes.
userNameCol=USERNAME
-Tim
Justin Wesbrooks wrote:
I have a JDBCRealm set up
=jdbc:mysql://localhost:3306/cofc?user=root;password=root
userTable=users
userNameCol=username
userCredCol=userpass
userRoleTable=user_roles
roleNameCol='ur_rolename'/
HTH,
Jon
Justin Wesbrooks wrote:
When I get rid of the single quotes, the Mysql JDBC driver throws an
SQLException
' in 'where clause'
which should come from the attempt to get the roles for this user.
Greetings
Andreas Mohrig
-Original Message-
From: Justin Wesbrooks [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 3:59 PM
To: Tomcat Users List
Subject: Re: JDBC Realm
By the way,
I know my
java.sql.SQLException: Column not found, message from server: Unknown
column 'username' in 'where clause'
which should come from the attempt to get the roles for this user.
Greetings
Andreas Mohrig
-Original Message-
From: Justin Wesbrooks [mailto:[EMAIL PROTECTED]
Sent: Thursday, November
I have a JDBCRealm set up in Tomcat 4.1.29. The realm config is as
follows..
Realm className=org.apache.catalina.realm.JDBCRealm
debug=99 driverName=org.gjt.mm.mysql.Driver
connectionURL=jdbc:mysql://localhost:3306/cofc?user=root;password=root
userTable=users
userNameCol='USERNAME'
PROTECTED]
11/19/2003 05:37 PM
Please respond to
Tomcat Users List [EMAIL PROTECTED]
To
Tomcat Users List [EMAIL PROTECTED]
cc
Subject
Re: JDBC Realm
Get rid of the single quotes.
userNameCol=USERNAME
-Tim
Justin Wesbrooks wrote:
I have a JDBCRealm set up in Tomcat 4.1.29