[Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-19 Thread Jim Morris
It turns out you can also turn off ssl in the database.yml file by adding sslmode: disable Although I have found no way to determine if the connection is SSL or not. On Dec 19, 1:30 pm, Tim Uckun wrote: > > I suspect what is happening in my case, (and maybe yours), is the SSL > > connection is

Re: [Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-19 Thread Tim Uckun
> I suspect what is happening in my case, (and maybe yours), is the SSL > connection is "renegotiating" and failing, which is documented > elsewhere (google postgresql ssl renogotiation) > > So far I have not seen this issue since I switched to a local > connection. Although I have two other older

[Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-19 Thread Jim Morris
Yea turn off ssl if you are on local network and see if that helps... I suspect what is happening in my case, (and maybe yours), is the SSL connection is "renegotiating" and failing, which is documented elsewhere (google postgresql ssl renogotiation) So far I have not seen this issue since I swi

Re: [Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-19 Thread Tim Uckun
On Sun, Dec 19, 2010 at 7:26 PM, Jim Morris wrote: > I've spent the day trying to track this down. I am not seeing it with > my older rails/activerecord app, only with the newer rails 3.0.3/ > sequel app. I am seeing it using activerecord on rails 3.0.3 The problem just occured and although the

[Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-18 Thread Jim Morris
I've spent the day trying to track this down. I am not seeing it with my older rails/activerecord app, only with the newer rails 3.0.3/ sequel app. I "think" it may be the ssl connection to postgresql. On newer Ubuntu systems a local tcp connection uses ssl by default (kind of odd but still). Wha

Re: [Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-18 Thread Tim Uckun
On Sat, Dec 18, 2010 at 11:05 AM, Jim Morris wrote: > I have recently deployed a similar setup, Ubuntu 10.04, pgsql 8.4, > rails 3.0.3, pg gem etc. > > I have started to see this error occasionally, that request fails then > subsequent requests are OK, the pgsql log says the client > disconnected!

[Rails] Re: Having problems with rails connectivity to postgres (libpq?)

2010-12-17 Thread Jim Morris
I have recently deployed a similar setup, Ubuntu 10.04, pgsql 8.4, rails 3.0.3, pg gem etc. I have started to see this error occasionally, that request fails then subsequent requests are OK, the pgsql log says the client disconnected! Sequel::DatabaseDisconnectError (PGError: server closed the co