[Pkg-erlang-devel] Bug#598525: erlang-odbc: odbc:connect(ConnStr, Options) fails with timeout

[Christian Adams]

Package: erlang-odbc
Version: 1:14.a-dfsg-2
Severity: important

When I try to setup an odbc-connection to a local installed postgresql(8.4) database i get the following:

---- snip ----
Erlang R14A (erts-5.8) [source] [rq:1] [async-threads:0] [hipe] [kernel-poll:false]

Eshell V5.8  (abort with ^G)
1> odbc:start().
ok
2> odbc:connect("DSN=postgres;UID=username;PWD=passwd", [{scrolling_cursors, off}, {trace_driver, on}]).

=ERROR REPORT==== 29-Sep-2010::18:54:26 ===
** Generic server <0.39.0> terminating 
** Last message in was {<0.32.0>,
                        {connect,[1,1,1,1,1,2,
                                  "DSN=postgres;UID=username;PWD=passwd"],
                                 on,on},
                        infinity}
** When Server state == {state,#Port<0.629>,
                               {<0.32.0>,#Ref<0.0.0.39>},
                               <0.32.0>,undefined,on,undefined,undefined,on,
                               connecting,undefined,0,
                               [#Port<0.627>,#Port<0.628>],
                               undefined,undefined}
** Reason for termination == 
** timeout
{error,connection_closed}

---- snap ----

/etc/odbcinst.ini:
---- snip ----
[PostgreSQL ANSI]
Description             = PostgreSQL ODBC driver (ANSI version)
Driver          = /usr/lib/odbc/psqlodbca.so
Setup           = /usr/lib/odbc/libodbcpsqlS.so
Debug           = 1
CommLog         = 1
UsageCount      = 1

[PostgreSQL Unicode]
Description             = PostgreSQL ODBC driver (Unicode version)
Driver          = /usr/lib/odbc/psqlodbcw.so
Setup           = /usr/lib/odbc/libodbcpsqlS.so
Debug           = 1
CommLog         = 1
UsageCount      = 1
---- snap ----

/etc/odbc.ini:
---- snip ----
[postgres]
Description     = PostgreSQL ANSI
Driver          = PostgreSQL ANSI
Trace           = Yes
TraceFile       = /tmp/sql.log
Port            = 5432
Servername      = localhost
Database        = template1
---- snap ---- 

neither /tmp/sql.log is found nor a SQL.LOG which should have been written with the option {trace_driver, on}.

Cheers, Christian Adams

-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (900, 'testing'), (750, 'testing'), (750, 'stable'), (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.30 (SMP w/1 CPU core; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages erlang-odbc depends on:
ii  erlang-base-hipe           1:14.a-dfsg-2 Erlang/OTP HiPE enabled virtual ma
ii  libc6                      2.11.2-6      Embedded GNU C Library: Shared lib
ii  unixodbc                   2.2.14p2-1    ODBC tools libraries

erlang-odbc recommends no packages.

Versions of packages erlang-odbc suggests:
ii  erlang                     1:14.a-dfsg-2 Concurrent, real-time, distributed
ii  erlang-doc                 1:14.a-dfsg-2 Erlang/OTP HTML/PDF documentation
ii  erlang-manpages            1:14.a-dfsg-2 Erlang/OTP manual pages

-- no debconf information