[Pkg-nagios-devel] Bug#679338: Bug#679338: icinga-web: Agavi tries to connect via TCP to DB, though Sockets was selected in dbconfig-common

[Markus Frosch]

tags 679338 + pending
thanks

Hello Chris,
> As you already told in other bugs, you only want to support the setup,
> where the databases are local, right?

No, that's actually a feature that causes no problems.

> So then it makes sense to access them via sockets and not via TCP.

The default php5 feature Debian utilizes is the mod_php5 inside
apache2 and therefore a socket does not work with the standard peer
authentication. (Except you want to give www-data rights in
Postgres...)

Though the next upload 1.7.1-2 allows sockets, but you have to
configure the user and permissions on your own.

> My problem now is the settings in:
> /etc/icinga-web/conf.d/database*.xml
>
> These get DSN set that try to use TCP, even though I selected sockets.
>
> I'd expect the change to set the correct DSN for sockets is simple and
> I'd have simply overwritten the value,... but I don't know the format
> for such a DSN.
> All I tried failed and Agavi seems to provide no useful docs.
> Do you have an idea?
> And if so, could you please modify your scripts, to set such DSN,
> if unix/sockets was selected?

This is fixed also.

For quick help: use "%2Fvar%2Frun%2Fpostgresql" for the server part of the DSN.

Regards
Markus

-- 
Markus Frosch
markus at lazyfrosch.de
http://www.lazyfrosch.de