tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Herchel Wojciech <W.Herc...@pzuzycie.com.pl>
Subject JDBCRealm again
Date Fri, 02 Mar 2001 07:28:59 GMT
I managed to force tomcat to reopen connection to auth data base and
authorization works fine, there's only one "but" - it cannot read roles
therefore denies accessed to resource... here's tomcat log:

----log----------
2001-03-02 08:04:53 - ContextManager: JDBCRealm: The database connection is
null or was found to be closed. Trying to re-open it.
2001-03-02 08:04:53 - ContextManager: JDBCRealm: JDBCRealm.authenticate:
SELECT user_pass FROM users WHERE user_name = ?
2001-03-02 08:04:53 - ContextManager: JDBCRealm: Authentication successful
for user wojtek
2001-03-02 08:04:53 - ContextManager: JDBCRealm: Auth ok, user=wojtek
2001-03-02 08:04:53 - ContextManager: JDBCRealm: Controled access for wojtek
R(  + /protected/panel.jsp + null) Ct
(jsp(org.apache.jasper.servlet.JspServlet/null) )
2001-03-02 08:04:53 - ContextManager: JDBCRealm: There was an SQLException
while in getUserRoles: wojtek
2001-03-02 08:04:53 - ContextManager: JDBCRealm: SQLException:
java.sql.SQLException: Communication link failure: java.io.IOException
2001-03-02 08:04:53 - ContextManager: JDBCRealm: Auth ok, user has no roles
2001-03-02 08:04:53 - ContextManager: JDBCRealm: UnAuthorized test

how can i fix it?

vVolf

Mime
View raw message