surely :) follow the steps described in the attached file.
vVolf
> -----Oryginalna wiadomość-----
> Od: Chris Andreou [mailto:[EMAIL PROTECTED]]
> Wysłano: 2 marca 2001 15:59
> Do: '[EMAIL PROTECTED]'
> Temat: RE: JDBCRealm again
>
>
> Wolf,
>
> I am new tomcat user. Would you mind taking some time and write some
> quiedlines how to setup JDBCReal?
>
> Thanks
>
> Chris
>
>
> -----Original Message-----
> From: Herchel Wojciech [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 1:29 AM
> To: 'Tomcat'
> Subject: JDBCRealm again
>
>
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
JDBCRealm.howto
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
