Hi Rick,
You should take a look at SQLALCHEMY_POOL_SIZE and SQLALCHEMY_POOL_TIMEOUT
http://flask-sqlalchemy.pocoo.org/2.0/config/
Here you might increase the timeout.
Kind regardsCornelius
Cornelius KölbelCornelius.koelbel@netknights.it+49 151 2960 1417
NetKnights GmbHhttp://netknights.itLandgraf-Karl-Str. 19, 34131 Kassel, GermanyTel: +49 561 3166797, Fax: +49 561 3166798
Amtsgericht Kassel, HRB 16405Geschäftsführer: Cornelius Kölbel-------- Ursprüngliche Nachricht --------
Von: RickP rick.a.poston@gmail.com
Datum: 03.12.2015 15:07 (GMT+01:00)
An: privacyidea privacyidea@googlegroups.com
Betreff: Re: PostgreSQL
there are no errors in the logs, it works ‘ok’ but it closes the connection to the PG database within the minute so the next authentication somewhere has to reconnect the web/api system to the PG instance and significantly delays key retrieval
Our questions are from the pi.cfg file URI is there methods to pass any of the connection timeout or pooling parameters
Our current URI line
SQLALCHEMY_DATABASE_URI = ‘postgresql+psycopg2://svcprivid:somepasswd@pwslpidpg03.domain.com:5432/privacyidea’
SQLALCHEMY options
http://docs.sqlalchemy.org/en/latest/core/engines.html#postgresql
–
You received this message because you are subscribed to the Google Groups “privacyidea” group.
To unsubscribe from this group and stop receiving emails from it, send an email to privacyidea+unsubscribe@googlegroups.com.
To post to this group, send email to privacyidea@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/privacyidea/1d510dba-e75c-4526-9a0b-f6a8c22e70da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.