Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBCRealm problem

 
Raj Puri
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try to check your Realm elements in server.xml, is it correct?
 
Raj Puri
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ..
 
Without deviation from the norm, progress is not possible - Zappa. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!