Bug#679338: [Pkg-nagios-devel] Bug#679338: icinga-web: Agavi tries to connect via TCP to DB, though Sockets was selected in dbconfig-common
Hi Markus. The code you've added in the postinst seems to be valid and I wanted to try this out, but the files are not written again, when I do a reconfigure. Even when I delete them (the database-*.xml files) they are not regenerated. Is this some issue with ucf and because I had already manually changed the files before? Cheers, Chris. smime.p7s Description: S/MIME cryptographic signature
Bug#679338: [Pkg-nagios-devel] Bug#679338: icinga-web: Agavi tries to connect via TCP to DB, though Sockets was selected in dbconfig-common
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 mar...@lazyfrosch.de http://www.lazyfrosch.de -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#679338: [Pkg-nagios-devel] Bug#679338: icinga-web: Agavi tries to connect via TCP to DB, though Sockets was selected in dbconfig-common
Hi Markus. Am 28.06.2012 09:06, schrieb Markus Frosch: 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...) Yeah,.. well I guess though there are some users using either CGI or FastCGI, the former mainly for user privilege separation as I do, the later mostly for speed (but also some user privilege separataion is possible)... Anyway, it's quite easy (that's an even _I_ could do it q.e.d. ;-) ) to set up one's PHP to run as non www-data and then do (e.g. Postgres) authentication based on the user. Though the next upload 1.7.1-2 allows sockets, but you have to configure the user and permissions on your own. Of course... actually I wouldn't like if that is done automatically :) This is fixed also. I really hate it, that you always reply (and even fix things) that fast, which takes me all excuses and makes me doing _work_ again ;-) For quick help: use %2Fvar%2Frun%2Fpostgresql for the server part of the DSN. Ah... will try that. Thx :) Many thanks, Chris. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org