File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes JDBCRealm problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBCRealm problem" Watch "JDBCRealm problem" New topic
Author

JDBCRealm problem

Raj Puri
Ranch Hand

Joined: Apr 24, 2003
Posts: 189
I have tables users, user_roles, role created as per documentation and connect string is right too for JDBCRelam. But when I start application it keeps prompting for network id/password. The log files says:

sss(i.e. user name) authenticated.[THIS MUST BE A WRONG MESSGAE AS REALLY I AM NOT AUTHENTICATED]
Table or view does not exist.
other regular java dump.... below...

What does that mean? I can use connect string when I do not force
JDBCRealm so that is not a problem. Some thing going wrong here. I have those there tables also needed by tomcat to look up user name/pswd/roles etc and I really connect with DBA login in connect string. I am running against Oracle(9i). Any clues?
Surasak Leenapongpanit
Ranch Hand

Joined: May 10, 2002
Posts: 341
Try to check your Realm elements in server.xml, is it correct?
Raj Puri
Ranch Hand

Joined: Apr 24, 2003
Posts: 189
Those are right as I tested on my stand alone PC, only thing I am doing is putting JDBCRealm clause on my UNIX server copied from my PC - like I said connect string is right too. There is some thing missing I can not fgure out ..
 
GeeCON Prague 2014
 
subject: JDBCRealm problem