Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#32270 - psqlodbc driver unable to connect to socket in /run/postgresql

Attached to Project: Community Packages
Opened by David P. Riedel (dpriedel) - Sunday, 28 October 2012, 19:01 GMT
Last edited by Sergej Pupykin (sergej) - Tuesday, 30 October 2012, 09:50 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Sergej Pupykin (sergej)
Architecture All
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description:

Since PostgreSQL has been changed to put its socket in /run/postgresql, the psqlodbc driver is unable to open a connection to the database.

This appears to be because the psqlodbc driver is hard coded to look in /tmp for the sockets.

I have reported this to the psqlodbc project but have received no response from them as yet.

Additional info:
* package version(s)

postgreSQL: 9.2.1-2

psqlodbc-09.01.0200

* config and/or log files etc.


Steps to reproduce:

1. be sure postgreSQL database is running
2. try to connect with isql

isql <some database name> <database user> <database password>

result will be:

[08001][unixODBC]Could not connect to the server;
Could not connect to remote socket immedaitely
[ISQL]ERROR: Could not SQLConnect


the misspelled 'immedaitely' is found in the socket.c program from the psqlodbc driver source.
This task depends upon

Closed by  Sergej Pupykin (sergej)
Tuesday, 30 October 2012, 09:50 GMT
Reason for closing:  Fixed
Comment by Sergej Pupykin (sergej) - Tuesday, 30 October 2012, 09:49 GMT
DEFAULT_PGSOCKET_DIR was changed to "/run/postgresql" in 09.01.0200-2. Please check it

Loading...