[dev.icinga.com #1107] add db socket as config option in ido2db.cfg for mysql and postgresql #507
Comments
Updated by mfriedrich on 2011-01-20 11:48:04 +00:00
libdbi mysql http://libdbi-drivers.sourceforge.net/docs/dbd\_mysql.pdf mysql_unix_socket so this might be implemented against mysql only. |
Updated by mfriedrich on 2011-03-16 17:44:05 +00:00
|
Updated by mfriedrich on 2011-03-23 13:28:38 +00:00
added db_socket in cfg, commented out db_port. then changed in my.cnf the default socket to something else.
give it the correct socket like from my.cnf
into ido2db.cfg
looks good :)
need to test that on pgsql too, where the port just gets overwritten. http://libdbi-drivers.sourceforge.net/docs/dbd\_pgsql/options.html |
Updated by mfriedrich on 2011-03-23 14:01:46 +00:00
the default pgsql socket is in /tmp/ named .s.PGSQL.5432 as it seems you can't change the name, but the unix_socket_directory in /var/lib/pgsql/data/postgresql.conf and restart the server. doing this, and using the db_socket directive with the appropriate value, it takes the socket and connects flawlessly. |
Updated by mfriedrich on 2011-03-23 14:06:22 +00:00
|
Updated by mfriedrich on 2011-03-23 15:10:58 +00:00
Applied in changeset b3422ee. |
Updated by mfriedrich on 2014-12-08 14:46:12 +00:00
|
This issue has been migrated from Redmine: https://dev.icinga.com/issues/1107
Created by mfriedrich on 2011-01-12 14:35:24 +00:00
Assignee: mfriedrich
Status: Resolved (closed on 2011-03-23 15:10:58 +00:00)
Target Version: 1.4
Last Update: 2014-12-08 14:46:12 +00:00 (in Redmine)
props to sven nierlein
evaluate if possible for libdbi/libpq/ocilib
Changesets
2011-03-23 14:09:30 +00:00 by mfriedrich b3422ee
The text was updated successfully, but these errors were encountered: