OK So I tried to use DataSourceRealm. Seems simple enough. but I get the
following exception:
Oct 7, 2012 9:54:51 AM org.apache.catalina.realm.DataSourceRealm open
SEVERE: Exception performing authentication
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
Here is my configuration. context.xml is unchanged from previous setup
(works well for pooled database access within the app)
{catalina-base}\conf\context.xml:
<Resource
name="jdbc/MyAppDB"
auth="Container"
driverClassName="com.mysql.jdbc.Driver"
logAbandoned="true"
maxActive="100"
maxIdle="30"
maxWait="10000"
password="password"
username="user"
removeAbandoned="true"
removeAbandonedTimeout="60"
type="javax.sql.DataSource"
url="jdbc:mysql://localhost:3306/databasename"
/>
Server.xml replaces the JDBCRealm with the DataSourceRealm as below
{catalina-base}\conf\server.xml:
<Realm className="org.apache.catalina.realm.LockOutRealm">
<Realm className="org.apache.catalina.realm.DataSourceRealm"
dataSourceName="jdbc/MyAppDB"
userTable="users"
userNameCol="username"
userCredCol="password"
userRoleTable="roles"
roleNameCol="rolename"
digest="MD5"
/>
</Realm>
Have I missed a configuration somewhere ?
Thanks.
On Sun, Oct 7, 2012 at 9:36 AM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:
>
>
> Aladin Dajani <aladin.daj...@gmail.com> schrieb:
>
> >Hello List,
> >
> >My application is configured for JDBCRealm authentication uses a MySQL
> >database.
> >For my own use inside the application, I have setup a connection pool
> >to
> >access the database, However, the configuration of JDBCRealm in
> >server.xml
> >uses astand-alone connection. Since MySQL times-out connections after
> >8
> >hours, I get the following error in tomcat logs as I try to log-in
> >after
> >the connection times out:
> >
> >Oct 7, 2012 8:36:51 AM org.apache.catalina.realm.JDBCRealm getPassword
> >SEVERE: Exception performing authentication
> >com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> >No
> >operations allowed after connection closed.Connection was implicitly
> >closed
> >by the driver.
> >
> >Users do not notice this error (I presume tomcat's JDBCRealm will
> >create a
> >new connection), but it US disconcerting to have all these exceptions
> >in
> >tomcat logs, especially that when the server goes into production mode,
> >I
> >fear this will have adverse effects.
> >
> >Is it possible to have JDBDRealm use the same connection pool which my
> >application uses (which is setup in tomcat's context.xml so it should
> >be accessible to all applications in tomcat).
>
> Have a look at DatasourceRealm.
>
> Regards
> Felix
> >
> >Thanks.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
