[Bug 857459] New: PHP can't access Postgres DB if apache is started via systemd
https://bugzilla.novell.com/show_bug.cgi?id=857459 https://bugzilla.novell.com/show_bug.cgi?id=857459#c0 Summary: PHP can't access Postgres DB if apache is started via systemd Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: i586 OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: Basesystem AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: markus@gaugusch.at QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0 I run a davical server on my openSUSE 13.1 installation. It is configured to use a postgres92 server. Everything was running fine on openSUSE 12.3, I updated it using "zypper dup". Since this upgrade, davical can no longer access the postgres database, showing the following messages: Jan 05 23:03:01 zephyrus httpd2-prefork[8835]: Unable to connect to database: SQLSTATE[08006] [7] could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?... Jan 05 23:03:01 zephyrus httpd2-prefork[8835]: PHP Fatal error: PDO connection error 'pgsql:dbname=davical port=5432 user=davical_app': SQLSTATE[08006] [7] could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? in /usr/share/awl/inc/AwlDBDialect.php on line 81... The DB is running fine, I can connect using psql. Even more weird: If I don't start apache using "service apache2 start", but use the commandline shown from "ps aux" after starting it via systemd, there is no problem: # /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL -DMAILMAN -DPNP4NAGIOS -DTRAC_MODPYTHON -D SYSTEMD -DFOREGROUND -k start The socket file exists in /tmp and is readable by user wwwrun. I have no idea what's wrong, but it seems that systemd is the culprit. There are no error messages except the one above shown in journalctl Reproducible: Always Steps to Reproduce: 1. start apache via systemd 2. open url which causes access to postgres DB Actual Results: error message in journalctl -f, PHP web app fails Expected Results: No failure, function as with 12.3 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c
zhang jiajun
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c2
Victor Kasatkin
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c3
--- Comment #3 from Victor Kasatkin
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c
Xiyuan Liu
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c4
systemd maintainers
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c5
Markus Gaugusch
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c
Stefan Fent
https://bugzilla.novell.com/show_bug.cgi?id=857459
https://bugzilla.novell.com/show_bug.cgi?id=857459#c6
Reinhard Max
participants (1)
-
bugzilla_noreply@novell.com