tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luc DALLEMANE <ldallem...@alaloop.com>
Subject RE: JDBC authentication problem
Date Tue, 03 Feb 2015 11:29:17 GMT
Hi,

Thanks for the reply, I tried to add the options you told me about (testWhileIdle, timeBetweenEvictionRunsMillis,
and maxConnLifetimeMillis), but I'm still unable to log after un hour ... 

I'm having this problem for 2 weeks and still unable to find a way to go around this problem...

I thought that the firewall dropped my connexions, but no solutions for this problem seems
to work. 

"(again I assume it is the firewall, that corrupts your connections and I assume you are using
a connection pool managed by tomcat)". You were right, I'm using it.

The only thing I haven't test is to not use the pool, but this doesn't seems a really good
option for me.

I'm new to Tomcat so I don't know it very well, but this should have worked...

We are thinking of asking a guy from another company (who knows tomcat and network better
than I), because nobody have a solution for this in mine.

Thank you for your help !! And if you have another idea... you're welcome again.

Regards, Luc.


________________________________________
De : Felix Schumacher <felix.schumacher@internetallee.de>
Envoyé : lundi 2 février 2015 18:59
À : Tomcat Users List
Objet : Re: JDBC authentication problem

Am 02.02.2015 um 17:03 schrieb Luc DALLEMANE:
> Thanks for the reply,
>
> No I haven't got any exceptions, and there is no more logs until I restart tomcat manually.
>  From the web page, you can see that it keeps loading the page indefinitely... and never
tells if the authentication fails or not. (This part works when I restart tomcat).
>
> I'm using the DataSourceRealm provided with Tomcat7.
First of all, I wouldn't trust the network guys :) The firewall might be
OK, but OK might mean, that it drops connections, when they are idle for
too long.

That said, you have a few options to drive around such a limitation.

You could set "testWhileIdle" to true, so that you generate network
traffic and thus keep open the firewall (again I assume it is the
firewall, that corrupts your connections and I assume you are using a
connection pool managed by tomcat). I believe you have to set
"timeBetweenEvictionRunsMillis" to a postive value, or no idle testing
will be done.

You might try the "maxConnLifetimeMillis" setting, so that old
connections from the pool will not be used.

You might try to size the pool, so that it keeps no idle connections
(but why should I use a pool then?).

Hope this helps
  Felix
>
>
> -----Message d'origine-----
> De : Christopher Schultz [mailto:chris@christopherschultz.net]
> Envoyé : lundi 2 février 2015 16:19
> À : Tomcat Users List
> Objet : Re: JDBC authentication problem
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Luc,
>
> On 2/2/15 6:11 AM, Luc DALLEMANE wrote:
>> I tried to switch to DataSourceRealm but my problem is here again.
>>
>> After a while, the authentication is still impossible. Maybe i have
>> missed something about the DataSource in the doc but I'm able to login
>> several times. It's only after about one hour of inactivity.
>>
>> The network admin looked the firewall config and told me the config
>> was OK ...
> Are there any exceptions in the log files? Or do you simply get a refused authentication?
Are you using Tomcat's built-in authenticator?
> Which one?
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> Comment: GPGTools - http://gpgtools.org
>
> iQIcBAEBCAAGBQJUz5VWAAoJEBzwKT+lPKRY7i8P/jS1NIa4jKCrONMdyxSpibQo
> Ce+s6EO3li8LY8TqTvcB6F6lABHMvFu7izDkA9K5wdAfUX0zqNTliUnfEUy+rf2C
> 92NEeyoXKVkphaFnhYhfBXU6c4DQDhSvq+ZNb8r3exH0y7fbclZzDG/6d6YnxL3i
> DHUiq/iPG5xB+5H4a6WQgudQoKiMC+rEmrXhkYGnAbTscw43tkQqkyW7KlkIF610
> CUultPN3gw1coAVSHXulzW+AqIUCM1GOtsY2qT5xobGTM3oO/YsE6YCRCQC6s8ZJ
> Sa6TC1sMCnqALS1T5rJrwHU9jCN7pPRT0SjToU6gPF8rIzVzejAunJpiwKtTNwW3
> 8tuAfaTLOwBTAq1ddF8rwk93pFB2EYM3htWQ0u6GzLsWHDqBU0zkAkYz6m/6qvfR
> egZMFuCkPjmxmoObbuAwHZ73HfosXeGUwkGeXgeD3a6DD5g7wXlSXGixkZ65Hifi
> FyM/RmUat4IVOiIXe2poVmwiOnFL9hDarkWCrybpTH4xlPhgv98feKvKxudkJsM/
> o6U3lpB/q//SEQ3PGuddJX1znCjXkIWFlfqZ3avrB5OTIuxAdTrSC5GaSiTK+L48
> ieN8K6SxnOo5pmdgoTcFiYXiH0qvIOFJ0Ez36+ZE3X987ysTvylxMJdpP4y81miO
> TY2PAwTlHfFyUFLQahlg
> =3+Xk
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message