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