I suggest you read the JDBC realm documentation and be exact about what it says. Do you have a table called USERS? Make sure its populated correctly. do you have a table called USER_ ROLES? Make sure it is populated correctly. You should be able to understand the relationships between the two tables Username to Username/Role I think you are close but off just a bit. again follow the quick start guide in the documentation and you should have it. good luck, Andy Gordon
±ç¬±³õ <[EMAIL PROTECTED]> wrote: However I go into http://localhost:8080/erp It is ok. I have added record to user_profile, user_role Table: user_role usernm role_name admin Administrator admin Manager admin admin The error message becomes "Access to the requested resource has been denied" Why? 2005/9/22, æ¢ç³å ´ : > However I go into http://localhost:8080/erp > It is ok. > > I have added record to user_profile, user_role > > Table: user_role > usernm role_name > admin Administrator > admin Manager > admin admin > > The error message becomes > "Access to the requested resource has been denied" > > Why? > > > 2005/9/22, andy gordon : > > if you enable the jdbc realm then authentication and authorizaiton comes > > from a jdbc datasource not the tomcat.uses.xml file. This is why tomcat > > keeps asking you for a user name and password. I suggest you read the realm > > how to on the tomcat website so you can correct your problem. > > > > - andy > > > > ±ç¬±³õ wrote: > > I have enabled JDBCRealm with MD5 in server.xml Tomcat 5.5. > > Then I am not able to login "Tomcat Manager". > > When I click "Tomcat Manager", > > I input the username and password in tomcat-users.xml, > > it keeps on prompting me username and password. > > I wonder if the old password is not encrypted by MD5. > > Then I encrypt the password by MD5 and put into tomcat-users.xml. > > > > > > > > Still the same? > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
