No login possible after about 1 hour

[wape]

Hi,

I installed the OpenKM Community Edition 3.1 on a debian Linux Lenny system with MySQL 5.0.51a-19 for the OKMAuth with the following configuration:

<!-- OpenKM User Auth -->
<local-tx-datasource>
<jndi-name>OKMAuthDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/OKMAuth</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>dbuser</user-name>
<password>dbpassword</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
</local-tx-datasource>

After starting the OpenKM, it is possible to work with the system. But after logging out and waiting - lets say about 1 hour - no one can login. All users get the \"Authentication error\" message on the page: .../OpenKM/j_security_check.

After restarting the OpenKM on the server everything works fine again. Within the mysql.log I can\'t see any logging for the not working try to login.

Do you know any problems with MySQL? Which configuration values should be checked or modified?

I hope, you can help me.

Best regards,
Peter

[pavila]

I have no notice this error. Perhaps you can get more info in JBoss forum, because OpenKM authentication is managed by JBoss.

[jllort]

it could be some problem with driver ( are you using stable one ) ? and other problem could be on data source configuration <idle-timeout-minutes>0</idle-timeout-minutes> take a look at jboss forum about problems with mysql pool configuration, it\'s not a OpenKM problem.

[wape]

Thank you very much for your hints. I updated the mysql connector library from version 5.1.5 to 5.1.7 and now it works fine since the last weeks.

Best regards,
Peter