Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <5071A0C8.1070509@yahoo.com>
Date: Sun, 07 Oct 2012 08:33:28 -0700
From: Mark Eggers <its_toasted@yahoo.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: JDBCRealm conection timeout failure on getPassword
References: 
 <CAHt=FYn1yXp7KM8yJuZKjdZE_eA5QrGouR1x_BvQ_6Jxmb=AJg@mail.gmail.com>
 <d4507436-04e9-4171-a12b-fe61fba85bf1@email.android.com>
 <CAHt=FY=dxYtQkM3_pDuhuHpvj6-xWLiMvsmehnKEV9_vmk=2Xg@mail.gmail.com>
 <-1074036205031100349@unknownmsgid>
In-Reply-To: <-1074036205031100349@unknownmsgid>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 10/7/2012 8:22 AM, Pid * wrote:
> On 7 Oct 2012, at 15:26, Aladin Dajani <aladin.dajani@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

Here's the Wiki document on the various combinations:

http://wiki.apache.org/tomcat/TomcatDataSourceRealms

/mde/

>>
>> Thanks.
>> On Sun, Oct 7, 2012 at 9:36 AM, Felix Schumacher <
>> felix.schumacher@internetallee.de> wrote:
>>
>>>
>>>
>>> Aladin Dajani <aladin.dajani@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org