You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by danox <da...@cucurucho.org> on 2003/05/15 06:14:22 UTC

JDBC Realm

Hi all,

I am having trouble getting my JDBC authorisation realm to work.
I have used the following realm in my server.xml file:

    <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
        driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
        
connectionURL="jdbc:microsoft:sqlserver://<removed>;SelectMethod=direct;DatabaseName=<removed>"
        connectionName="tsuser"
        connectionPassword="tsuser"
        userTable="Registrations"
        userNameCol="userName"
        userCredCol="password"
        userRoleTable="vUserGroups"
        roleNameCol="groupName" />

Authentication is failing no matter what user I enter, I'm happy to try 
and debug this but I'm not sure how to. Now I have specified a debug 
level of 99 so I'm assuming there must be some form of debug logging 
going on, but I can't find it anywhere. This the only change I have made 
to the server.xml file, the rest is the defaul file from a tomcat 4.1.24 
installation. If anyone can tell me where to look to try and trace where 
my authorisation is breaking, I would appreciate this a lot.



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: JDBC Realm

Posted by Seb Esp <ha...@ml1.net>.
If you look the source code of that class, you will notice it does 
little logging, no matter what level you are using.
I suggest you configuring logging/trace in SQL server and see what is 
happening in that side.

A more complex choice is programming your own Realm, you can use 
JDBCRealm as a reference. This will give you the opportunity to log and 
trace anything, and when the problem is solved then you can use Tomcat's 
implementation.


danox wrote:

> Hi all,
>
> I am having trouble getting my JDBC authorisation realm to work.
> I have used the following realm in my server.xml file:
>
>    <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
>        driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>        
> connectionURL="jdbc:microsoft:sqlserver://<removed>;SelectMethod=direct;DatabaseName=<removed>" 
>
>        connectionName="tsuser"
>        connectionPassword="tsuser"
>        userTable="Registrations"
>        userNameCol="userName"
>        userCredCol="password"
>        userRoleTable="vUserGroups"
>        roleNameCol="groupName" />
>
> Authentication is failing no matter what user I enter, I'm happy to 
> try and debug this but I'm not sure how to. Now I have specified a 
> debug level of 99 so I'm assuming there must be some form of debug 
> logging going on, but I can't find it anywhere. This the only change I 
> have made to the server.xml file, the rest is the defaul file from a 
> tomcat 4.1.24 installation. If anyone can tell me where to look to try 
> and trace where my authorisation is breaking, I would appreciate this 
> a lot.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org