topic Re: long idle cause connection to database lost in Nuxeo Forum

long idle cause connection to database lost

James_wong — Mon, 28 Jul 2014 17:00:16 GMT

The version is 5.9.4, everything runs well. But if I leave the server idle for overnight, the next day I won't be able to login, the error is: Failed to connect to authentication database

My temp solution is to stop nuxeo server then restart, everything become normal again after restart. The problem repeat if long idle happens.

I am confused with this and hope some of you can help. Thanks.

James

Re: long idle cause connection to database lost

Florent_Guillau — Mon, 28 Jul 2014 17:30:22 GMT

What database are you using?

Re: long idle cause connection to database lost

James_wong — Tue, 29 Jul 2014 02:05:38 GMT

I am using mysql, version 5.1.73

Re: long idle cause connection to database lost

Florent_Guillau — Tue, 29 Jul 2014 17:20:03 GMT

Have you read [Configuring MySQL](http

Re: long idle cause connection to database lost

James_wong — Fri, 01 Aug 2014 02:49:45 GMT

Thanks Florent. The problem is solved following your suggestion. I add wait_timeout=31536000 in /etc/my.cnf (Centos) and restarted the mysql service and system works fine now