[unixODBC-support] Datasource not found under Fedora 6 with Postgres

paul_deg paul_deg at yahoo.com
Fri Jun 15 23:46:00 BST 2007


Sorry, I was playing around with data source names and
forgot to change it back. But it's still failing with
the correct one.

odbc.ini 

[PostgreSQL-asterisk]
 Description         = Test to Postgres
 Driver              = /usr/lib64/libodbcpsql.so
 DNS                 = PostgreSQL-asterisk
 Trace               = Yes
 TraceFile           = sql.log
 Database            = asterisk
 Servername          = localhost
 UserName            = admin
 Password            = admin
 Port                = 5432
 Protocol            = 7.4
 ReadOnly            = No
 RowVersioning       = No
 ShowSystemTables    = No
 ShowOidColumn       = No
 FakeOidIndex        = No
 ConnSettings        =


odbcinst.ini

# Example driver definitinions
#
#

# Included in the unixODBC package
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib64/libodbcpsql.so
Setup           = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1


# Driver from the MyODBC package
# Setup from the unixODBC package
#[MySQL]
#Description    = ODBC for MySQL
#Driver         = /usr/lib/libmyodbc.so
#Setup          = /usr/lib/libodbcmyS.so
#FileUsage      = 1

[ODBC]
TraceFile = /tmp/sql.log
Trace = Yes

I used strace isql -v PostgreSQL-asterisk 2>slog.
The new log is attached.  



--- Nick Gorham <nick.gorham at easysoft.com> wrote:

> paul_deg wrote:
> 
> >Done. Still I can't tell what the problem is, the
> >trace is attached. There is a couple of places in
> the
> >file which I am concernd of:
> >
> >connect(3, {sa_family=AF_FILE,
> >path="/var/run/nscd/socket"}, 110) = -1 ENOENT (N
> >o such file or directory)
> >
> >  
> >
> Looking at that, its failing to find a section
> called PostgreSQL-test in 
> /etc/odbc.ini
> 
> Let us see your /etc/odbc.ini and /etc/odbcinst.ini
> again
> 
> -- 
> Nick Gorham
> Easysoft Limited
> http://www.easysoft.com, http://www.unixODBC.org
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
>
http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 



 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slog
Type: application/octet-stream
Size: 19095 bytes
Desc: 2204175874-slog
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20070615/a51b5db7/attachment.obj>


More information about the unixODBC-support mailing list