Mailing List Archive

Hi,

Fatal error: PDO connection error 'pgsql:dbname=davical port=5432
> user=davical_app': SQLSTATE[08006] [7] could not connect to server:
> Permission denied Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
> in /usr/share/webapps/davical/inc/AwlDBDialect.php on line 69
>

Since version 0.9.8 you need also the PDO drivers for postgresql. You didn't
mention the install of those, so...

Vincent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100414/82f9ab6d/attachment.htm>
-------------- next part --------------

On Wed, 2010-04-14 at 11:24 +0200, Jeroen wrote:
> Hi,
>
> This is probably a very trivial problem, I just don't see it...
> Re-Installation is manual on a Gentoo box, which phased out with sync,
> so I decidedf to put everything on fresh. Installation of the local
> postgresql 8.4 server went without a problem, and Davical 0.9.8.4 also
> looked quite ok...
> Opening a web page though gives me this::
>
> Fatal error: PDO connection error 'pgsql:dbname=davical port=5432
> user=davical_app': SQLSTATE[08006] [7] could not connect to server:
> Permission denied Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
> in /usr/share/webapps/davical/inc/AwlDBDialect.php on line 69
>
> When pg_hba.conf has:
>
> local all all trust
>
> in it, the server will start immediately, however, when I write this:
>
> local davical davical_app trust
> local davical davical_dba trust
>
> in it, the psql server notifies a 'could not start server' after a 90
> seconds to start. However it starts, as 'ps ax' will tell.
>
> Davical should have access either way though, I imagine (socket connection).
>
> The browser error doesn't change for either case.
> I'd be very happy with any pointers, this takes me some much time.

Hi Jeroen,

There's a couple of things I can think of that might be going on - all
of them pretty unlikely though. Firstly, I assume that you have HUP'd
the PostgreSQL server after changing the pg_hba.conf file.

Did you check the PostgreSQL error log? Not sure where that is on
Gentoo, but on Debian it's in /var/log/postgresql . Authentication
failure reasons are usually very clear once you find this.

The location of your lines in the pg_hba.conf is important. The
narrower the privilege specification, the closer it should be to the top
of the file, with the general catch-all specifications at the bottom, so
if you added the:

local davical davical_app trust

somewhere near the bottom some other rule may well be in effect sooner.

Is that the correct location of the PostgreSQL unix domain socket? You
can usually find it with something like:

netstat | grep 5432

if that doesn't show the location then perhaps something in PHP needs
changing to find the correct one.


Hope that helps,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Today's weirdness is tomorrow's reason why.
-- Hunter S. Thompson

------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100414/265c8de7/attachment.pgp>
-------------- next part --------------

Hi,

Maybe it is not *that* trivial after all...
I decided to do a fresh restart, so I dumped all the manually installed
davical stuff and went with the sunrise overlay for gentoo.
After getting past a broken checksum (delete manifest and regenerate the
checksum), it installed pretty seemless.
First succes: I got the "the Good the Bad and the Dubious"-page in the
browser, so hurray! I thought... after installing the

/etc/davical/10.0.0.200-conf.php

with one line:
$c->pg_connect[] = 'dbname=davical user=davical_app';


file being asked for, I got the "Fatal error" window again. ???
When I take it away, I get back to the "the Good the Bad... etc" page.

Any ideas somebody??

Very welcome!!

Best, Jeroen





On 14.04.2010 11:24, Jeroen wrote:
> Hi,
>
> This is probably a very trivial problem, I just don't see it...
> Re-Installation is manual on a Gentoo box, which phased out with sync,
> so I decidedf to put everything on fresh. Installation of the local
> postgresql 8.4 server went without a problem, and Davical 0.9.8.4 also
> looked quite ok...
> Opening a web page though gives me this::
>
> Fatal error: PDO connection error 'pgsql:dbname=davical port=5432
> user=davical_app': SQLSTATE[08006] [7] could not connect to server:
> Permission denied Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
> in /usr/share/webapps/davical/inc/AwlDBDialect.php on line 69
>
> When pg_hba.conf has:
>
> local all all trust
>
> in it, the server will start immediately, however, when I write this:
>
> local davical davical_app trust
> local davical davical_dba trust
>
> in it, the psql server notifies a 'could not start server' after a 90
> seconds to start. However it starts, as 'ps ax' will tell.
>
> Davical should have acces either way though, I imagine (socket connection).
>
> The browser error doesn't change for either case.
> I'd be very happy with any pointers, this takes me some much time.
>
> Best, Jeroen
>

So I reinstalled php for the third time (only thing different being

*USE="pdo_dblib"* emerge php

which it didn't install) and now it's working. It was probably some
Gentoo feature.

Thanks for your suggestions anyway!

Best, Jeroen



On 15.04.2010 01:24, Jeroen wrote:
> Hi,
>
> Maybe it is not *that* trivial after all...
> I decided to do a fresh restart, so I dumped all the manually installed
> davical stuff and went with the sunrise overlay for gentoo.
> After getting past a broken checksum (delete manifest and regenerate the
> checksum), it installed pretty seemless.
> First succes: I got the "the Good the Bad and the Dubious"-page in the
> browser, so hurray! I thought... after installing the
>
> /etc/davical/10.0.0.200-conf.php
>
> with one line:
> $c->pg_connect[] = 'dbname=davical user=davical_app';
>
>
> file being asked for, I got the "Fatal error" window again. ???
> When I take it away, I get back to the "the Good the Bad... etc" page.
>
> Any ideas somebody??
>
> Very welcome!!
>
> Best, Jeroen
>
>
>
>
>
> On 14.04.2010 11:24, Jeroen wrote:
>> Hi,
>>
>> This is probably a very trivial problem, I just don't see it...
>> Re-Installation is manual on a Gentoo box, which phased out with sync,
>> so I decidedf to put everything on fresh. Installation of the local
>> postgresql 8.4 server went without a problem, and Davical 0.9.8.4 also
>> looked quite ok...
>> Opening a web page though gives me this::
>>
>> Fatal error: PDO connection error 'pgsql:dbname=davical port=5432
>> user=davical_app': SQLSTATE[08006] [7] could not connect to server:
>> Permission denied Is the server running locally and accepting
>> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>> in /usr/share/webapps/davical/inc/AwlDBDialect.php on line 69
>>
>> When pg_hba.conf has:
>>
>> local all all trust
>>
>> in it, the server will start immediately, however, when I write this:
>>
>> local davical davical_app trust
>> local davical davical_dba trust
>>
>> in it, the psql server notifies a 'could not start server' after a 90
>> seconds to start. However it starts, as 'ps ax' will tell.
>>
>> Davical should have acces either way though, I imagine (socket connection).
>>
>> The browser error doesn't change for either case.
>> I'd be very happy with any pointers, this takes me some much time.
>>
>> Best, Jeroen
>>

On Fri, 2010-04-16 at 00:37 +0200, Jeroen wrote:
> So I reinstalled php for the third time (only thing different being
>
> *USE="pdo_dblib"* emerge php
>
> which it didn't install) and now it's working. It was probably some
> Gentoo feature.

OK - good to know!

The need for the PDO libraries arrived with 0.9.8 of DAViCal, and
possibly the Gentoo folk need to update their ebuild in some way to
indicate that particular PHP dependency...

Cheers,
Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Accent on helpful side of your nature. Drain the moat.
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100416/c17932e5/attachment.pgp>
-------------- next part --------------

Jeroen wrote:
> So I reinstalled php for the third time (only thing different being
>
> *USE="pdo_dblib"* emerge php
>
> which it didn't install) and now it's working. It was probably some
> Gentoo feature.
>
> Thanks for your suggestions anyway!
>
> Best, Jeroen
>

Hi Jeroen,

I maintain the davical ebuild in the sunrise overlay.
The pdo_dblib USE doesn't seem to have any impact when installing php.
The correct USE is pdo (and it's enforced in the ebuild since january 17
with davical 0.9.8) so davical installation should have stopped and
complained the pdo was missing from your php installation.

I am very interested in details of the problem you had. Can you file the
steps to reproduce it and your emerge --info in the davical thread on
the gentoo bugzilla (http://bugs.gentoo.org/show_bug.cgi?id=195118)

Can you try with to install the ebuild I committed on sunrise last
monday? Its version number is davical-0.9.8.4-r1

Regards,
--
Fran?ois P?richon
Gestion des identit?s num?riques
Universit? Lille 2 - Droit & Sant?
Centre de Ressources Informatiques
http://cri.univ-lille2.fr
tel: +33 3 20 96 52 28