You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by frasse <fr...@netscape.net> on 2003/05/19 20:36:51 UTC

MD5 with JDBCRealm

Hi all
I am using JDBCRealm  and msql for my user  with MD5 for encrypt the 
passworld.  my Realm tag in server.xml
is  as follow

<Realm className="org.apache.catalina.realm.JDBCRealm"
    debug="99" driverName="org.gjt.mm.mysql.Driver"
    connectionURL="jdbc:mysql://localhost/tomcatusers"
    connectionName="user" connectionPassword="user"
    digest="MD5"
    userTable="users"
    userNameCol="user_name"
    userCredCol="user_pass"
    userRoleTable="user_roles" roleNameCol="role_name" />

And i insert the user by using following SQL
insert into users values('user1', MD5('user1'));

I am geting the log in dialog but I can not log in. If  I just remove 
MD5 from SQL and server.xml all is working.

Any one know what is the problem.

Thx
Frasse


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


Re: MD5 with JDBCRealm

Posted by Norris Shelton <no...@yahoo.com>.
Sounds like the same MD5 is not being done.  I had the same
problem when I tried to use Digest mode with IE against data
digested via java.  Luckily I had read that this was a problem. 
My set-up (using Tomcat to digest password against a Oracle)
works.

My guess is to do a little research into the compatibility
between MySql and Tomcat MD5.

--- frasse <fr...@netscape.net> wrote:
> Hi all
> I am using JDBCRealm  and msql for my user  with MD5 for
> encrypt the 
> passworld.  my Realm tag in server.xml
> is  as follow
> 
> <Realm className="org.apache.catalina.realm.JDBCRealm"
>     debug="99" driverName="org.gjt.mm.mysql.Driver"
>     connectionURL="jdbc:mysql://localhost/tomcatusers"
>     connectionName="user" connectionPassword="user"
>     digest="MD5"
>     userTable="users"
>     userNameCol="user_name"
>     userCredCol="user_pass"
>     userRoleTable="user_roles" roleNameCol="role_name" />
> 
> And i insert the user by using following SQL
> insert into users values('user1', MD5('user1'));
> 
> I am geting the log in dialog but I can not log in. If  I just
> remove 
> MD5 from SQL and server.xml all is working.
> 
> Any one know what is the problem.
> 
> Thx
> Frasse
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 


=====

Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

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