I'm having a problem connecting to postgres via a CGI program. I can connect just fine using the same connect string in a non-cgi perl program as in the perl cgi program. The error I get is this:
ERROR: Unable to connect to dbname testdb2, err: could not connect to server: Permission denied
Is the server running on host "jacensolo.red.dsic.com" (192.168.10.16) and accepting
TCP/IP connections on port 5432?
I tried adding postgres to the apache user's groups, because I saw something on google that said that that is needed for the socket connection to work, but it didn't help.
I just tried stopping and restarting apache, and when I try to start I get this:
apachectl start
(13)Permission denied: make_sock: could not bind to address [::]:80
(13)Permission denied: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
I took away the group permission for postgres, just in case that had messed up something, but it didn't help. Now I can't even start apache.
But, if I do:
[scassidy@jacensolo init.d]$ ps auxww|grep http
apache 15426 0.0 0.0 186416 2740 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15427 0.0 0.0 186416 2720 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15428 0.0 0.0 186416 3004 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15429 0.0 0.0 186416 2740 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15430 0.0 0.0 186416 2724 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15431 0.0 0.0 186416 2740 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15432 0.0 0.0 186416 2988 ? S Jan19 0:00 /usr/sbin/httpd -k start
apache 15433 0.0 0.0 186416 2988 ? S Jan19 0:00 /usr/sbin/httpd -k start
root 18778 0.0 0.0 184208 2408 ? Ss 2013 2:25 /usr/sbin/httpd -k start
I'm seeing processes that apparently shouldn't be there. Maybe that's why it can't connect, because it is already connected?
Should I just kill those processes, do you think?
What could have happened? It was working just fine before.
Very mysterious.
Susan