Hi all, Thx for all the answers. I deleted my context file, the login.jsp, the data from the db and configured everything again (using localDataSource="true" to be able to use the local data source) . Now the auth is working!!! I'm pretty sure, as u said, that I had a problem or in my jsp login file or in the db. I really can't tell what really happened, but i'm sure it was my mistake...
Thx again for everything!!! Nicolas Gonzalez Buenos Aires - Argentina On 10/8/07, Christopher Schultz <[EMAIL PROTECTED]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Nicolas, > > Nicolas Gonzalez wrote: > > I have a DB with users and user-roles tables and data in those tables > but > > every time I try > > to log in my application it will fail with no reason, nor log either! > > Care to give us the database schema you are using? Please only show > those tables that are relevant (USERS and USER_ROLES). You might want to > provide sample contents for the user you are using as a test. > > > I started thinking that any kind of authentication wasn't going to work, > so > > I tried using the > > BASIC based one, which surprisingly worked :) > > Well, that's telling. I'm guessing your <form> isn't done correctly. > Would you like to show us the form you are using, or should we keep > guessing? > > > validationQuery="select * from TEST" > > Ouch! I wouldn't do that if I were you. > > > <Realm className="org.apache.catalina.realm.JDBCRealm" > > Since you've got a JNDI connection pool already configured, why not use > that for your Realm (DataSourceRealm) instead of a JDBCRealm. That way, > everything uses the same set of connections instead of one separate one > for logins. > > > (as u may see, the realm is not a DataSourceRealm because it doesn't > work at > > all, at least in my > > case!!! Another problem for another thread I guess...) > > I'm guessing that your form is the problem, not the database. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFHCqUw9CaO5/Lv0PARAjlHAJ9PuW+DT9/4KlXsj6px3EDhGVoiiACeIu7+ > 7DkzhMXZechE6HdiRa0Ai88= > =1A0q > -----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] > >
