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.schumac...@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:ch...@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-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 > --------------------------------------------------------------------- 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
