Omnis PostgreSQL - Windows connection problem

[Bob Fiering]

I have set the  tcp_keepalives_idle=0 in the postgresql.config file.
I read that Windows looks different to this setting so i followed the instruction to set it to 0.



Op 10 dec. 2013, om 20:55 heeft Franco Maregotto <franco at hotelaqua.it> het volgende geschreven:

I also have set a reconnect code, like Andy.
I found that the bandit is my router. While I still have internet connection, the router (NetGear) closes connection of some ports (unused?).
I work in a Hotel, so "normal" ports, like 80 are used all over by staff and customers (guests), and I guess that the router almost never times-out that web ports.
It seems to be your case, expecially when you say that your customer have this trouble while you don't..
SSL (as far as I know) is not responsible

I also solved sending a SET tcp_keepalives_idle=300 command to the server, just after logging in.
Using PG 9.2 and OmnisStudio 5.2.3

HTH
Franco


Il giorno 10/dic/2013, alle ore 20:20, Bob Fiering <bob at maxolution.nl> ha scritto:

> We have a customer who is starting with our product and is having a lot of difficulties with the connection.
> Several times a day the connection is lost, where the internet connection is not lost.
> Only the connection to the database is lost.
> 
> When i connect with my mac to the same server everything is fine. No problems. 
> 
> Their network manager looked at things like sleep mode, ethernet settings and so on, but on their clients it seems ok.
> 
> As a last effort i switched of SSL and made changes to the pg_hba config file to see if tomorrow when they start working again the problem is solved.
> 
> PostgreSQL is version 9.3 and is running as a cluster on an Ubuntu 12.04 LTS server.
> Omnis is 5.2.3.
> 
> Any help what so ever would be very appreciated.
> 
> 
> Bob_____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com