Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi,
Is it possible to connect via unix socket to PGSQL, from Projeqtor?
Cheers,
Verncon.
Got it sorted, all is OK.
Hi, VERNCon
If you found a trick, please share with the community, it could help someone.
Thanks in advance.
Hi,
It was much simpler than I expected....
In the parameters.php file, at $paramDbHost value, all I needed to do was enter the Unix Sockets directory for the connection.
In my case (Fedora with PGSQL), I entered "/var/run/postgresql/" and re-started the httpd Service.
You need to have the database listening on the appropriate Unix Sockets - the default for PGSQL is /var/run/postgresql/ and /tmp.
The code used in this software is obviously much "nicer" than others, as I did the "usual" and I replaced the / 's with %2f, but then it complained that it could not parse the value.
I tried the straight text string including the forward-slash, it happily accepted it and the database connection came straight up. You still need to correctly edit the pg_hba.conf file correctly to control the access.
Cheers,
Verncon.