On 7 Oct 2012, at 15:26, Aladin Dajani <aladin.daj...@gmail.com> wrote:
> 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 ?
Yes, define the Resource in GlobalResources in server.xml.
p
>
> 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
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
