The web server and PostgreSQL are both on the same box. Before I added the hit counter, I could always get to the home page and the timeout only occurred (about once or twice a week) on the page that connects to PostgreSQL. So, that eliminates the possibility of any network problem. I never have a problem with pgadmin, which is also running on the same box and also runs across the network (to my work computer several miles from here), it's always up and running (which eliminates any problem with PostgreSQL, network, and PHP connections to PostgreSQL).
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Figueiredo Jr. Sent: Thursday, June 30, 2005 3:09 PM To: mono-list@lists.ximian.com Subject: RE: [Mono-list] Time out using Npgsql --- Carl Olsen <[EMAIL PROTECTED]> escreveu: > I can't figure out where it is failing, because it just times out. It's > happening on all of my page now, since I have a session hit counter in the > global.asax.cs file that writes to PostgreSQL every time someone visits the > site. Before I added the hit counter, it was only occurring on the page > that had data connections to PostgreSQL. It only happens occasionally, not > all the time. Restarting Apache fixes it. I'm not sure if the problem is > Npgsql or Apache, or both. > Hi Carl. Can you check if your webserver box is having network problems with your postgresql box? This may mean some type of firewall or some network program which could temporarily disable access to your postgresql box. Also, could you try some console app in your webserver box to connect to your postgresql box? This test could make you sure that you are being able to get data from postgresql. It would also be good if you could put this console app to keep all day trying connections to postgresql in order to check if you get network down just sometimes. I hope it helps. Regards, Francisco Figueiredo Jr. _______________________________________________________ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ _______________________________________________ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
