ODBC Version supporting specif databases?

Hi All,

I am having connection issues with the 08.03.0100 version of the ODBC
driver.

What happens is that when I attempt to connect to an 8.2.6 PostgreSQL
database, using the 08.3.0100 ODBC driver then i get an error connecting
during authentication as follows:

------------------------------------------------------------ -------------
[28000][unixODBC]Communication error during authentication;
Error while reading from the socket.
[ISQL]ERROR: Could not SQLConnect
------------------------------------------------------------ -------------

However, if I use the 08.01.0200 version to connect to the same DSN, I
am able to successfully connect?

Is there a specific version of the ODBC driver that supports a specific
version of the PostgreSQL database.

The way the above two ODBC drivers were built are as follows:

OS: Solaris 10 Update 3
ODBC Manager : unixODBC v1.2.12

I'm not too sure which version of the libpq library was used, but I know
for certain that Solaris 10 Update 3 comes with a Sun built version of
PostgreSQL 8.1, the one on the system I am trying to build on is version
8.1.10.

Am I doing something wrong or are the versions of the odbc driver just
not compatible with the versions of libpq that i am using to build with,
and thus, unable to connect to the database, or, is it something
completely different.

If you need any additional info, please dont hesitate to ask.

Thanks
Bruce
--
+-------------------------------------------------------+
| Bruce McAlister Blueface Ltd |
| http://www.blueface.ie |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: ODBC Version supporting specif databases?

Woops, the unixODBC version below should read 2.2.12, not 1.2.12.

Bruce McAlister wrote:
> Hi All,
>
> I am having connection issues with the 08.03.0100 version of the ODBC
> driver.
>
> What happens is that when I attempt to connect to an 8.2.6 PostgreSQL
> database, using the 08.3.0100 ODBC driver then i get an error connecting
> during authentication as follows:
>
> ------------------------------------------------------------ -------------
> [28000][unixODBC]Communication error during authentication;
> Error while reading from the socket.
> [ISQL]ERROR: Could not SQLConnect
> ------------------------------------------------------------ -------------
>
> However, if I use the 08.01.0200 version to connect to the same DSN, I
> am able to successfully connect?
>
> Is there a specific version of the ODBC driver that supports a specific
> version of the PostgreSQL database.
>
> The way the above two ODBC drivers were built are as follows:
>
> OS: Solaris 10 Update 3
> ODBC Manager : unixODBC v1.2.12
>
> I'm not too sure which version of the libpq library was used, but I know
> for certain that Solaris 10 Update 3 comes with a Sun built version of
> PostgreSQL 8.1, the one on the system I am trying to build on is version
> 8.1.10.
>
> Am I doing something wrong or are the versions of the odbc driver just
> not compatible with the versions of libpq that i am using to build with,
> and thus, unable to connect to the database, or, is it something
> completely different.
>
> If you need any additional info, please dont hesitate to ask.
>
> Thanks
> Bruce

--
+-------------------------------------------------------+
| Bruce McAlister Blueface Ltd |
| http://www.blueface.ie |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: ODBC Version supporting specif databases?

Hi All,

Does anyone have any ideas/tips on how I could further debug this problem?

Thanks
Bruce

Bruce McAlister wrote:
> Hi All,
>
> I am having connection issues with the 08.03.0100 version of the ODBC
> driver.
>
> What happens is that when I attempt to connect to an 8.2.6 PostgreSQL
> database, using the 08.3.0100 ODBC driver then i get an error connecting
> during authentication as follows:
>
> ------------------------------------------------------------ -------------
> [28000][unixODBC]Communication error during authentication;
> Error while reading from the socket.
> [ISQL]ERROR: Could not SQLConnect
> ------------------------------------------------------------ -------------
>
> However, if I use the 08.01.0200 version to connect to the same DSN, I
> am able to successfully connect?
>
> Is there a specific version of the ODBC driver that supports a specific
> version of the PostgreSQL database.
>
> The way the above two ODBC drivers were built are as follows:
>
> OS: Solaris 10 Update 3
> ODBC Manager : unixODBC v1.2.12
>
> I'm not too sure which version of the libpq library was used, but I know
> for certain that Solaris 10 Update 3 comes with a Sun built version of
> PostgreSQL 8.1, the one on the system I am trying to build on is version
> 8.1.10.
>
> Am I doing something wrong or are the versions of the odbc driver just
> not compatible with the versions of libpq that i am using to build with,
> and thus, unable to connect to the database, or, is it something
> completely different.
>
> If you need any additional info, please dont hesitate to ask.
>
> Thanks
> Bruce

--
+-------------------------------------------------------+
| Bruce McAlister Blueface Ltd |
| http://www.blueface.ie |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: ODBC Version supporting specif databases?

Hi Bruce

I guess that you need first enable Mylog and commlog and send both files=20
to the list.
This will help to trace the source code for errors.


Bruce McAlister wrote:
> Hi All,
>
> Does anyone have any ideas/tips on how I could further debug this=20
> problem?
>
> Thanks
> Bruce
>
> Bruce McAlister wrote:
>> Hi All,
>>
>> I am having connection issues with the 08.03.0100 version of the ODBC=20
>> driver.
>>
>> What happens is that when I attempt to connect to an 8.2.6 PostgreSQL=20
>> database, using the 08.3.0100 ODBC driver then i get an error=20
>> connecting during authentication as follows:
>>
>> ------------------------------------------------------------ ----------=
---=20
>>
>> [28000][unixODBC]Communication error during authentication;
>> Error while reading from the socket.
>> [ISQL]ERROR: Could not SQLConnect
>> ------------------------------------------------------------ ----------=
---=20
>>
>>
>> However, if I use the 08.01.0200 version to connect to the same DSN,=20
>> I am able to successfully connect?
>>
>> Is there a specific version of the ODBC driver that supports a=20
>> specific version of the PostgreSQL database.
>>
>> The way the above two ODBC drivers were built are as follows:
>>
>> OS: Solaris 10 Update 3
>> ODBC Manager : unixODBC v1.2.12
>>
>> I'm not too sure which version of the libpq library was used, but I=20
>> know for certain that Solaris 10 Update 3 comes with a Sun built=20
>> version of PostgreSQL 8.1, the one on the system I am trying to build=20
>> on is version 8.1.10.
>>
>> Am I doing something wrong or are the versions of the odbc driver=20
>> just not compatible with the versions of libpq that i am using to=20
>> build with, and thus, unable to connect to the database, or, is it=20
>> something completely different.
>>
>> If you need any additional info, please dont hesitate to ask.
>>
>> Thanks
>> Bruce
>

--=20
Luiz K. Matsumura
Plan IT Tecnologia Inform=E1tica Ltda.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: ODBC Version supporting specif databases?

This is a multi-part message in MIME format.
--------------020006020404060103020703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Luiz,

I have attached the trace.log and there seems to be an issue in
SQLAllocHandle.c.

I tried to enable commlog and debug but i cant seem to find the files
that they are meant to generate. Just to verify, do I add the following
parameters to the dsn in odbc.ini?

Debug = 1
CommLog = 1

Thanks
Bruce

Luiz K. Matsumura wrote:
> Hi Bruce
>
> I guess that you need first enable Mylog and commlog and send both files
> to the list.
> This will help to trace the source code for errors.
>
>
> Bruce McAlister wrote:
>> Hi All,
>>
>> Does anyone have any ideas/tips on how I could further debug this
>> problem?
>>
>> Thanks
>> Bruce
>>
>> Bruce McAlister wrote:
>>> Hi All,
>>>
>>> I am having connection issues with the 08.03.0100 version of the ODBC
>>> driver.
>>>
>>> What happens is that when I attempt to connect to an 8.2.6 PostgreSQL
>>> database, using the 08.3.0100 ODBC driver then i get an error
>>> connecting during authentication as follows:
>>>
>>> ------------------------------------------------------------ -------------
>>>
>>> [28000][unixODBC]Communication error during authentication;
>>> Error while reading from the socket.
>>> [ISQL]ERROR: Could not SQLConnect
>>> ------------------------------------------------------------ -------------
>>>
>>>
>>> However, if I use the 08.01.0200 version to connect to the same DSN,
>>> I am able to successfully connect?
>>>
>>> Is there a specific version of the ODBC driver that supports a
>>> specific version of the PostgreSQL database.
>>>
>>> The way the above two ODBC drivers were built are as follows:
>>>
>>> OS: Solaris 10 Update 3
>>> ODBC Manager : unixODBC v1.2.12
>>>
>>> I'm not too sure which version of the libpq library was used, but I
>>> know for certain that Solaris 10 Update 3 comes with a Sun built
>>> version of PostgreSQL 8.1, the one on the system I am trying to build
>>> on is version 8.1.10.
>>>
>>> Am I doing something wrong or are the versions of the odbc driver
>>> just not compatible with the versions of libpq that i am using to
>>> build with, and thus, unable to connect to the database, or, is it
>>> something completely different.
>>>
>>> If you need any additional info, please dont hesitate to ask.
>>>
>>> Thanks
>>> Bruce
>>
>

--
+-------------------------------------------------------+
| Bruce McAlister Blueface Ltd |
| http://www.blueface.ie |
+-------------------------------------------------------+

--------------020006020404060103020703
Content-Type: text/plain;
name="trace.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="trace.log"

[ODBC][7248][__handles.c][447]
Exit:[SQL_SUCCESS]
Environment = 8067ac0
[ODBC][7248][SQLAllocHandle.c][358]
Entry:
Handle Type = 2
Input Handle = 8067ac0
[ODBC][7248][SQLAllocHandle.c][476]
Exit:[SQL_SUCCESS]
Output Handle = 80680e8
[ODBC][7248][SQLConnect.c][3586]
Entry:
Connection = 80680e8
Server Name = [blueface-services][length = 17 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][7248][SQLAllocHandle.c][331]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLConnect.c][1570]Error: IM005
[ODBC][7248][SQLError.c][476]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLError.c][424]
Entry:
Connection = 80680e8
SQLState = 8047a00
Native = 80479fc
Message Text = 8047a10
Buffer Length = 500
Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = IM005
Native = 80479fc -> 0
Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed]
[ODBC][7248][SQLError.c][424]
Entry:
Connection = 80680e8
SQLState = 8047a00
Native = 80479fc
Message Text = 8047a10
Buffer Length = 500
Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
Exit:[SQL_NO_DATA]
[ODBC][7248][SQLError.c][504]
Entry:
Environment = 8067ac0
SQLState = 8047a00
Native = 80479fc
Message Text = 8047a10
Buffer Length = 500
Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][541]
Exit:[SQL_NO_DATA]
[ODBC][7248][SQLFreeHandle.c][273]
Entry:
Handle Type = 2
Input Handle = 80680e8
[ODBC][7248][SQLFreeHandle.c][188]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLFreeHandle.c][324]
Exit:[SQL_SUCCESS]
[ODBC][7248][SQLFreeHandle.c][206]
Entry:
Handle Type = 1
Input Handle = 8067ac0

--------------020006020404060103020703
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--------------020006020404060103020703--

Re: ODBC Version supporting specif databases?

This is a multi-part message in MIME format.
--------------020107020301080403000405
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi All,

Sorry for cross-posting, but I would appreciate all the help I can get
to try and get to the bottom of this issue.

I have now tried 3 versions of the pgsqlODBC driver, of which

08.03.0100, and
08.02.0500

fail with the following error code when attempting to connect to a database:

[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed

The only driver that is able to successfully connect to the database is
the 08.01.0200 version of the driver.

To try and assist in finding what it is that is going wrong (or
potentially, what I am doing wrong), I will outline how I have built the
driver and how I am attempting to connect.

I have attached the script that I have used to build PostgreSQL 8.2.6,
and all three versions of the pgsqlODBC driver, this will illustrate the
environment and build options I have specified.

The OS I am building on is Solaris 10 Update 3. The version of unixODBC
I am using is v2.2.12 built from source. The database I am trying to
connect to is PostgreSQL v8.2.6.

my odbcinst.ini file looks like this:

------------------------------------------------------------ --------------
[ODBC]
Trace = yes
TraceFile = /tmp/trace.log

[PostgreSQL]
Description = PostgreSQL Official ODBC Driver
Driver = /opt/blueface/lib/psqlodbcw.so
Debug = 1
CommLog = 1
------------------------------------------------------------ --------------

my odbc.ini file looks like this:

------------------------------------------------------------ --------------
[blueface-services]
Description = Services Database
Driver = PostgreSQL
Database = blueface-service
Servername = 192.168.10.181
UserName = username
Password = password
Port = 5432
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
------------------------------------------------------------ --------------

I cannot find any commlog or debug logs for 08.03.0100 or 08.02.0500
anywhere. I assume this to be because the driver fails before it can
even initialize its own logging.

Here is the output of "ldd -r [pgsqlODBC driver]" for each of the three
deivers:

08.03.0100
------------------------------------------------------------ --------------
ldd -r ./psqlodbcw.so
libpq.so.5 => /opt/postgresql-8.2.6/lib/libpq.so.5
libpthread.so.1 => /lib/libpthread.so.1
libodbcinst.so.1 => /opt/blueface/lib/libodbcinst.so.1
libodbc.so.1 => /opt/blueface/lib/libodbc.so.1
libc.so.1 => /lib/libc.so.1
libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1
libssl.so.0.9.7 => /usr/sfw/lib/libssl.so.0.9.7
libcrypto.so.0.9.7 => /usr/sfw/lib/libcrypto.so.0.9.7
libsocket.so.1 => /lib/libsocket.so.1
libdl.so.1 => /lib/libdl.so.1
libthread.so.1 => /lib/libthread.so.1
libnsl.so.1 => /lib/libnsl.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libdoor.so.1 => /lib/libdoor.so.1
libuutil.so.1 => /lib/libuutil.so.1
libgen.so.1 => /lib/libgen.so.1
libm.so.2 => /lib/libm.so.2
------------------------------------------------------------ --------------

08.02.0500
------------------------------------------------------------ --------------
ldd -r ./psqlodbcw.so
libpq.so.5 => /opt/postgresql-8.2.6/lib/libpq.so.5
libpthread.so.1 => /lib/libpthread.so.1
libodbcinst.so.1 => /opt/blueface/lib/libodbcinst.so.1
libodbc.so.1 => /opt/blueface/lib/libodbc.so.1
libc.so.1 => /lib/libc.so.1
libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1
libssl.so.0.9.7 => /usr/sfw/lib/libssl.so.0.9.7
libcrypto.so.0.9.7 => /usr/sfw/lib/libcrypto.so.0.9.7
libsocket.so.1 => /lib/libsocket.so.1
libdl.so.1 => /lib/libdl.so.1
libthread.so.1 => /lib/libthread.so.1
libnsl.so.1 => /lib/libnsl.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libdoor.so.1 => /lib/libdoor.so.1
libuutil.so.1 => /lib/libuutil.so.1
libgen.so.1 => /lib/libgen.so.1
libm.so.2 => /lib/libm.so.2
------------------------------------------------------------ --------------

08.01.0200
------------------------------------------------------------ --------------
ldd -r ./psqlodbcw.so
libodbcinst.so.1 => /opt/blueface/lib/libodbcinst.so.1
libpq.so.5 => /opt/postgresql-8.2.6/lib/libpq.so.5
libc.so.1 => /lib/libc.so.1
libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1
libdl.so.1 => /lib/libdl.so.1
libthread.so.1 => /lib/libthread.so.1
libssl.so.0.9.7 => /usr/sfw/lib/libssl.so.0.9.7
libcrypto.so.0.9.7 => /usr/sfw/lib/libcrypto.so.0.9.7
libsocket.so.1 => /lib/libsocket.so.1
libpthread.so.1 => /lib/libpthread.so.1
libnsl.so.1 => /lib/libnsl.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libdoor.so.1 => /lib/libdoor.so.1
libuutil.so.1 => /lib/libuutil.so.1
libgen.so.1 => /lib/libgen.so.1
libm.so.2 => /lib/libm.so.2
------------------------------------------------------------ --------------

The failure messages I get are as follows:

08.03.0100
------------------------------------------------------------ --------------
isql -vvv blueface-services
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed
[ISQL]ERROR: Could not SQLConnect
------------------------------------------------------------ --------------

08.02.0500
------------------------------------------------------------ --------------
isql -vvv blueface-services
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed
[ISQL]ERROR: Could not SQLConnect
------------------------------------------------------------ --------------

I have attached the trace/commlog/debug logs of all three drivers, the
08.01.0200 logs are of a successful connection, the rest are failures.
In the case of the failures, there are no commlog/debug logs generated.

If you require any additional information, please dont hesitate to ask.

Thanks
Bruce

--------------020107020301080403000405
Content-Type: text/plain;
name="build_script.ksh"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="build_script.ksh"

#!/bin/ksh

PATH=/usr/xpg4/bin:/usr/bin:/usr/sbin:/usr/sfw/bin:/usr/ccs/ bin:/opt/sfw/bin:/opt/blueface/bin
export PATH

GNUCC='/usr/sfw/bin/gcc'
GNUCXX='/usr/sfw/bin/g++'
SUNCC='/opt/SUNWspro/bin/cc'
SUNCXX='/opt/SUNWspro/bin/CC'
CC=$GNUCC
CXX=$GNUCXX
export CC CXX

ASTCFLAGS='-I/usr/sfw/include -I/opt/blueface/include -I/opt/sfw/include'
ASTLDFLAGS='-L/usr/sfw/lib -R/usr/sfw/lib -L/opt/blueface/lib -R/opt/blueface/lib -L/opt/sfw/lib -R/opt/sfw/lib'
CFLAGS=$ASTCFLAGS
LDFLAGS=$ASTLDFLAGS
export ASTCFLAGS ASTLDFLAGS CFLAGS LDFLAGS

NOW='/var/tmp/timer.txt'
GLOBALBASE='/opt/blueface'
BASEDIR=${GLOBALBASE}

umask 022

# [ -d ${GLOBALBASE} ] && rm -rf ${GLOBALBASE}
# mkdir -p ${GLOBALBASE}
# [ -d /opt/asterisk ] && rm -rf /opt/asterisk
# mkdir -p /opt/asterisk

function build_pkg {

LDIR=$(pwd)

cd /var/tmp
echo "PKG=BFS${PKGNAME}" > ./pkginfo
echo "NAME=${NAME}" >> ./pkginfo
echo "ARCH=$(uname -p)" >> ./pkginfo
echo "CATEGORY=application" >> ./pkginfo
echo "VERSION=${SFWVERSION}" >> ./pkginfo
echo "VENDOR=${VENDORURL}" >> ./pkginfo
echo "EMAIL=support@blueface.ie" >> ./pkginfo
echo "DESC=${DESCRIPTION}" >> ./pkginfo

echo "" > ./depend
echo "" > ./copyright

(
echo "i pkginfo";
echo "i depend";
echo "i copyright";
) > /var/tmp/prototype
cd $BASEDIR
chown -R root:other ./*
find . -newer $NOW | pkgproto >> /var/tmp/prototype
cd /var/tmp
pkgmk -o -b $BASEDIR -a $(uname -p) BASEDIR=${BASEDIR}
pkgtrans -s /var/spool/pkg /tmp/${PKGFILENAME} BFS${PKGNAME}
rm -rf /var/spool/pkg/BFS${PKGNAME}
gzip -9 /tmp/${PKGFILENAME}
cd $LDIR
}

#
# psqlODBC
#

# [ -d ./postgresql-8.2.6 ] && rm -rf ./postgresql-8.2.6
# gtar zxf ../source/postgresql-8.2.6.tar.gz
# cd ./postgresql-8.2.6
# PGSRC=$(pwd)
# export CFLAGS="$CLAGS -I/usr/xpg4/include"
# export LDFLAGS="$LDFLAGS -L/usr/xpg4/lib -R/usr/xpg4/lib"
#
# ./configure --prefix=/opt/postgresql-8.2.6 \
# --enable-integer-datetimes \
# --enable-thread-safety \
# --with-tcl \
# --with-tclconfig=/usr/sfw/lib \
# --with-pam \
# --with-openssl \
# --enable-nls \
# --without-readline
#
# [ $? == 0 ] && gmake
# [ $? == 0 ] && gmake install
# cd ../

# [ -d ./psqlodbc-08.03.0100 ] && rm -rf ./psqlodbc-08.03.0100
# gtar zxf ../source/psqlodbc-08.03.0100.tar.gz
#
# cd ./psqlodbc-08.03.0100
#
#export PG_CONFIG='/opt/postgresql-8.2.6/bin/pg_config'
#
#./configure --prefix=/opt/blueface --with-unixodbc=/opt/blueface/bin/odbc_config --enable-iconv
#[ $? == 0 ] && gmake
#[ $? == 0 ] && gmake check
#[ $? == 0 ] && gmake install

#[ -d ./psqlodbc-08.02.0500 ] && rm -rf ./psqlodbc-08.02.0500
#gtar zxf ../source/psqlodbc-08.02.0500.tar.gz
#
#cd ./psqlodbc-08.02.0500
#
## export CFLAGS="-I${PGSRC}/include $CFLAGS"
#export PG_CONFIG='/opt/postgresql-8.2.6/bin/pg_config'
#
#./configure --prefix=/opt/blueface --with-unixodbc=/opt/blueface/bin/odbc_config --enable-iconv
#[ $? == 0 ] && gmake
#[ $? == 0 ] && gmake check
#[ $? == 0 ] && gmake install

[ -d ./psqlodbc-08.01.0200 ] && rm -rf ./psqlodbc-08.01.0200
gtar zxf ../source/psqlodbc-08.01.0200.tar.gz

cd ./psqlodbc-08.01.0200

# export CFLAGS="-I${PGSRC}/include $CFLAGS"
export PG_CONFIG='/opt/postgresql-8.2.6/bin/pg_config'

../configure --prefix=/opt/blueface --with-unixodbc
[ $? == 0 ] && gmake
[ $? == 0 ] && gmake check
[ $? == 0 ] && gmake install

--------------020107020301080403000405
Content-Type: application/octet-stream;
name="trace_debug_commlog.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="trace_debug_commlog.zip"

UEsDBBQAAgAIAEdAXTiRW1fgFAIAAJIIAAAeAAAAcGdzcWxvZGJjLTA4LjAy
LjA1MDAvdHJhY2UubG9n7VVdb5swFH1OfoXf2B4ymQQCjdRJFJiKRMgqwl4Q
Qh5xEiRqKmOi9N/PDtA0QD7avU3jCXzPPb4+55obLqwHMwrHmjzRojCOt4is
Mlx8S6JQUbRoOBjY+5TNQv/Jjf3ANG3fF4sDm+xSmpNnTBi4BzqcaiiBw/CE
jecYWZYnjwdOQTlR9QMlYfR1JmiqEFi+vmBOMxZLDnkpGagDt1Mr2vR8tYuS
tUl1iPUuqZkTghNW1zo9FgvePYKxBqY5OdK1MT6mO0yBh57FnuHvrMRrlOBR
wdfTBBdRmGGyYVselDXwRRTtLf2vUZsnKN6xeIHrdhBGybbciTRBdUUVjIcC
zzEXlg2CIiUbgEmSr8SL4ZuOAyTHX+i6ejeSJcClAQ1YCkx/NHZtaXjd0Ykc
2ZTmdAZE/Y73y3AdK340PMu1L+orqxpsUp05hGoXfYg25n5gl2PeWOm38FYb
36x8cn2GWNU7ioYg7EN5XP5dg7lbJ32YOS4KtOEtj/esYZN72R7K9Zob7zY9
ovZveiDiIPCT0bet0SVRpnL/TQE9T+vwB6PO4TrHH30H8By4pUMYliTdVzVb
NBX3Zo4IB9Co+pQKcNp9gHsmqq+aIOaZYI3SDK+i/w3xlw3hLWLLWBqXhFTh
FSF7B8S/rqSq3KzkD4rx8Tc61iafGIz9M+yUWdb1j/w6T5Mn9XXpDtVr54HT
S+eRLwz6P1BLAwQKAAAAAABHQF04AAAAAAAAAAAAAAAAFQAAAHBnc3Fsb2Ri
Yy0wOC4wMi4wNTAwL1BLAwQUAAIACADqQF04J32hixMCAACBCAAAHgAAAHBn
c3Fsb2RiYy0wOC4wMy4wMTAwL3RyYWNlLmxvZ+1VTY+bMBA9J7/CN9pDKpPw
tZFaiQWqRSKkK0IvCCGXOAkSa1bGRNl/vzaETULIR9tbVU7gefM8fm/MRHP7
0Yoj1ZC1OEqSDSLLHJdf0jhSFD0eDgbOLmPTKHj2kiC0LCcIxOLAIduMFuQF
Ewa+AgNqOkrhMDom4ylmnhfpU00pGCeqUTMSRt+mgqUJgcXbK+YsY7HkkteK
gX3gbmZF1y7XOq9Yl9OA2DjjtApCcMr2lWqHUsHRIwj3wKwgB7YuJsB0iynw
0YvYMvqVV3iFUjwq+XqW4jKOckzWbMODsg4+iZr9RfA57vKE5RGLH3reGcKs
2IbbkKVoX1ED46HQd6257YCwzMgaYJIWS/FiBpbrAskN5oahPoxkCXBlQAuW
QisYjT1HGt60cyLHDqUFnQJRvuv/ND3XTp5M3/aca+rKqg7bTHcGoXoGroOt
sffvcUgbK/323Wvhh43PXsAQa9pG0RGEfSifS79tMQ+rtA8zw2WJ1rzZ8Y61
bHIv22O1WnHTvbY/1P5NayIOAj8Y/dgaXdFEk/vvCOh5OmevXbqEOzv96BuA
l8AdGaKoItmuKdmmmbgyM0Q4gMbNp1SC084D3DJRfdMCCc8EK5TleBn/b4e/
agd/ntjmwrwiowpvyNg7Ff5xHVXlXh2/U4wPf8+xPvmDYdg7uE6JZcP4jV/m
ae5kf1HO5+iNw0Dt2mHkK5P9HVBLAwQKAAAAAADqQF04AAAAAAAAAAAAAAAA
FQAAAHBnc3Fsb2RiYy0wOC4wMy4wMTAwL1BLAwQUAAIACAARP104e31YHHwM
AAD3WQAAKAAAAHBnc3Fsb2RiYy0wOC4wMS4wMjAwL215bG9nX3Jvb3QxODUw
Ni5sb2ftHGtv2sj2O79ivpGsCLKNMYQVlbKEpJHyKiH3rlRFlrEH4ltjU9s0
YX/9PWfGb5uHvaFNWyJVhZk5cx5znjPDzCxnollek776rqZ6K8/XJhZVFy6d
mq/UI31SNwz1z3rt8+eHT9dnluXoHzXbsOjT0x/wR0yb3F+e3V+prGtofyPQ
WIN/9NX0M109snimMKJPxJastGVFkmE0n/mB+jDizPfdpyei+X5fEoSGxPsu
k33QXotIGTi2TXX/KYEnaOoRavvUNe1Zs9msMVKLBmXpaRAdusKWU7mt1Ia3
qgYi0DmI6dg94lFrugWK8D+ApAbwQ0zSF/iwkw/FSL3P5lO+j/GaZrOQw9mu
6zgYhKykJ4jbj4575PzhFkEm1pJONZ2eeNT9ZurUqzcIfqQu9oqnUlNUuk1R
aIpdEboWjutjR1tuSTjSs+aOQbEF6aAutBkaEKZ5tGh26F7CR1ubcxjH82cu
w7nQPO/FcY1+/RX/6rVwNewZ8R3iP9OQrIKeCCXMjs1psonmJeBr7KP5DyWm
B6oWT+fYuem8pa5TCuvb3HEUiNhynC/LhbqYqYDMY8qUXISEij7488wKPQxw
6T3fXeq+48Z9pKhTd6nmg+p5MA3Xp44od2Q5Zwocz7Mx0ZP628gDAvVoB6BY
Pp0Dbm4G/QxIPwbgSIavVD833Zy+QctKt0A+mfkSGO/Pz8Zn6tSloMeaq829
HiHD2/Fw1IhQd8S22FGSTCXxPacpasTI+nWYAcaQYBmOjusF9OqaZaGA456l
T+N1ChqKljDqAhY1l1DXdVzvzdnmuG6X8/tgXJIQJEF9Mf1nPguFHk8Fc3Ks
b9QAwpzFCnmLCCEhMnAgtsfWeen1xQaxqN0Xw+UtkBu4OexK4GLupnAg/j1Q
20DMD8Pr4WCcIACsJ7tg+tL1HFdFl9CvgydUB4+jrtA5bXe69ZoHE6lfl9Rd
octCG0xqI+soovf66q/7TyrlK8ThM8YEQe3TKGlPNRbNMm2F88yoT2xwwgQk
vbR8gkIhXJYgFKkYiP0H3Vlai0fDzD7xVwvw6kjsmjE6cATu3wGn7VFDdZ0X
8O9Lm9k02vJcWyyA3wznyQ4AQZpFDE/Wcm57OVDeDs1CqtkDGUxNahmQHUyd
HgkcesBWA2lHWbTZJ9Au+NIVTyE8QtxfLSBkQMOJiKswvs6vQqYtiXhKff05
pipC+E2DSAMN9zyigB6RblNqKqhxptJVThb6yRxmeGlJyOx8YVrgOicrcjkY
kJmuQ1Sl5Ai+HJNWU25K5IiNPvEWVDc16zihiT1iODZGE67jfGUTStADHQA9
YpSq/hLYhyau5Wg0dW7jJx94U1/ID4ZY6JPBFZiyZqhMzNBoL+fBZ7ZIN2fX
13cDMGWEUVk8g2bIqEjwuQtZFDPGFLUYuDgXIGofeeKyVCcmG+CltSXhjuRu
FyYPh6kaRhaMP5j0IG2BBvVFvobFsxd4YJf6S9eGxRDI1HXmaU8cjL9A8fRy
AYs7rJMP3BCDjpYsdGtzzV5qlhpYKNNwyDtUg+qWhnkKKhHqNIsqEFinHEEK
LBQQ2DuGepVr+hrptJnoZ2zgjqKZRbPWAvQwjrvjKUI6C9+LuGXCx5aTD6Es
g2DeaXfaoNOT5RTSr89PjC0uNUiqzwFFQHMueDPlCO2mvi/DqScjd0SRCawi
pQ0yHYzBz/ElYuqt+vw7Oo/vQB0GSVVjmmqDNwGFzFEx1f2IxP1TBFCT/yCW
G+21L0rd2vnw4uzxetwjgR/tQrLsu/uVCgviGIvVwcczyEoMyOLBJJI0xFSi
ZCRocWe86S9Q0JHzsl8KLx2fObMEhiAYgJ67LFbsEfsQazAds+8C/GDyEwoJ
eh2QhjnnBeR6uXw/l7xO7xZYYYCj+DRiPqiH1ff58GE8ehyM70a1MXr7a9Pb
1MF8TKIrmgrzTTKncwfilWmjXmO20BcFsXiMs/Tjjuys4DTPaVyMJOIEd8ws
xAWOWQi/Yw0SJ3C1s/vzbUmwfHqq1K62j2sLilAirT4bnV+wWMpGE8w3FUEg
E6jd5pr7pd8VlKkudWGYurTR4aIP95h0wLv3oaSMfLwYxUQGZYDFAtvUV7VM
8CsfWcHfoKMEdXhrSV0ySW1njcUoxpckCdk1H/59NcbkjKVGwLGfzh8O1e53
rnbBPuHbg78CKnyH1K8e7uqHmndTzStJcc1bLL21le/a4fBn+nWP3N6NiRbW
e0m5pJVqxwq3GN0PrHPFbXVuEcUVKlmoEsdhzUJeNI8EwAbfdvO86dKyVgQy
uLi2IYZpENvxg9oCOlchE+vrOMgDIP03SlcoeQcYoBIaobREDpeSyb/3JmtS
hG3hXqgQ7PfuuGb0q8O05O7i4uCzNu/TdZI+KyO4De4qP3JfniqD6X07qRSx
B/+E4ji4pqRr4sdtU8vRfNUwZ6bvobpIBye1MbFKOam1ItzgrjbB7MtxrcX5
vl3YGrIPziwvmLfdjdmHP/sN9lXoTvsqQryvIvyg/Q8h2P9Yu/MRnPVbzmHX
48ee8Tvgg5jZL2Z85/7lmboUDx/5ubLlHKqKjQFbljKn/ztJdPO9gF2n+GE3
BnYi8N3fJdiBi1/rlgEwHN0wUBI3DOQ3v17AMIVHfqLSkaXDPYDDPYB3ew9A
Ev79PQCm5Tsf2p/grbH0gbnSyE227YxdSZyxsxkzE6SOxOXo6BeWcEaJM/lf
4AV7gYkeTlx/1spAr3TiKvx2J65B3aE/a+wWggvMp3PDMlkQpA26ZWKUp7bu
oER+iiuURWT/WnlOnsMw7RFPE2mP8vZ5TxHm0Cc/ji+6P2cW9O49fPKHGzwd
StWcg8K+4OczF0ub/TrBe4qidtSU8g1iaQipPA5BKI+mVRpCrkJYeW465UHa
7fJSLs9Nuwr/5cWslCesPIgslF+XKuxXkHJ5PN3ySMqDnJaXsVhFYhW0rAKe
CjZWXgBiq4IApPLcKEIVQZc3GlGpgqeC3ZQHkauIWuhWAaqgB4JYZYUqKKlc
3t/IVdy6WAFP+UVVKphCeZkpFVSnvOLI5UGUCglHeeVUyq+/Ut4PKBVMujwv
UiUzK8+NVCWyiVUSCLGKi6qgBVIFu6lCWoUValeI1eVNulOBsCoFQZysXEHx
fdQSjmOYq9RWLwyfYgvuffY7nVpm2KJfF1pNQajzE7Xw50vsUYAJ7lzGoi6F
CSIcFK+Du9tbMhyN7kZQUAIr/RRoS8Df6Hh6Hwtq6rpQHgO6Uyh/v1rsLK3P
muferF9/tF2qOzMbCmODfKEr9tN7+Og7JKauJTTreZzJ/n0gzL9Asd+jdKUl
VDtKZ4BljtIZQPjUBWII3rrgfMZjcNNCTGzch0PXDdx1SnHXKcWdp5R2nVLa
ecrWrlNyd3Lv0oXm0kBJgm9rnwWJ+h/GN2OVbRidjYfnDXZSzuYLDpue9nX6
z5Rgpy1zpdP6nqf/LTlz+s92sY7+OA7uUpkLTWdN3p9k26n/NtDdT/tRXOtP
+yenQrnT/o2Evfvt7g3U/1q73gx9dL4vJF8QePN97gBXfMIvdU8PJ/yKLL/B
CT86VPBdfK974FhhKpZqy8XzhUtDJe3FJtKqFcLGx/rhgX8jAcOIZSdtKMX3
Rg5/9MnCEGdOMOhETz/FbSl62LEkUZi/FjYSl4h5fLZypOmcAma3eBkjdVQv
1ArJZEMhIzS9haWtmJKywVXZFLs8Lgnie+G0RwZ31483t+rt2c0QrZv5jvrv
wOE7tBx2EegpStTQAVEjcTsokXRjynAxHA8+qrfDv8fcu3L3i9kPuGaXfeuf
iLXC6Wz6wkax00Aed777rSJFUfZ5q4g7/J1vFR181y9k2cHtrqdtV8WYLWWv
ikG6VP19F6GRm2rbRTFhzWMsHDx1TQzEn305pR09nBKg2/LKSTvzyAlMWfjI
STDbvhwT3zUCXANctWDq8OvaajccgHXR+OOQjO7++9Ajfyx0lxHNE6Ibx6Xc
D4dOPdGSnppzB1Vremdm2y07XsP9CrfsOCdvdctOabd3ujumKJJQYsug4Jad
Dv7ox9yyW1tHlLplV0pSb3fLDtX93PT01LuscUPRrlCyV5uAluEOJ97psShE
/gWWq/BtwL81MpuFNW0K8+EAAHUhPQhlen+J27AJAgmL82u6+Cys2Mf92VRd
HCMvIJjVjgli8yPSt47Wu4P1z/NGLwmnhmWMh0EhJTFbOVntIsmtMogEnm5g
hhPvSD07lkFdL4KOqaoV8LJZRnkhsCeT8w8mE+RweLtGBOzRYEZPaghgZ/Ng
WHO+1P4PUEsDBBQAAgAIABE/XTi+xyopHAMAAIMHAAArAAAAcGdzcWxvZGJj
LTA4LjAxLjAyMDAvcHNxbG9kYmNfcm9vdDE4NTA2LmxvZ91Vz3PqNhC+56/Y
m6ADHtsQl+SNDxlI0szkQRqS9tDpeIS8GBchOZII0L++K7vkOY8mPfRWXWzt
7/32W3syn0KplvoSJvNpyhZyi0susG/RvJYCLev5NzQpiy7iIEpGQRQG0Shi
vUobl7Lz4SBmvXzBLZ56s97WetdKW1cYH6zi1u7ylO39YWfwdrSSB4OcVFNN
OVd6p8u/L0u+RrqUKsf9N7U9WMcXEmtJK5DQSmUWnStVYVPGerUAldAUoUjZ
7Omn68e2gzNcWcldqVWWS+ld2iJd+QdJz3wgSCEaDJPzi+F50oOH26uHu2xM
chSu8xGA8Hw3aWMAD79Ojgh0z26lXnAJszqNvYRf0Ng6YTgKwigI4zAklyU6
sUqjMOyB1WKNLqW3rVorvaNuyz/RpvH5sAcbvs9euRErbmpxOoouwkYstSre
qwZxC4bm5KX1oNZdb8jIpFEP1vZF++dWlS9bzJpB+LvFLEchucGmvvAknsO9
y7htJ28i1ZXb71VU6kJrWcsbW5hefb2eXD1d3V9P02R4koDiG54dyZBVVEq5
JzRYnmdfCLjv6QD/TAcvTVuTpT7NIWUWJU0WXpuZdLoNb36Dh2aY85/vjzqw
zlBA4gdrKUdBHCTEbSiTUdKvRH9DNrtB7OvaVKXEHBYHuB2PoRAiwD1Chy5d
GATDIIZObd23FYqSyy6D3z9Or7abBRqfnnJ6yw87cjDhDufuIBGcBnY3nzH2
mXmBL7q2nN3cfG7ZDGMpNXdZXhals94v/jd4ablhafQGqiJzhwpht0JDxR0q
xTe04FKzI/D33BQIs8UfRz/ax+THYfxZw3UOCi1kicq9zf7bNMe1Ao4KD+Lz
082IQYcESNekS/HHs+kUrh8fZ4+XsNwqkTbbf4vujr6fA6Jujlb4zwegMTSP
NA4vaF1fJHHTYVqLN5Y496wMCl0o2q8c1ngA/1WkV8KKRvoWMGDv2N7/D+dd
oBWq1waoYRIPmxVpA+fL3Vq/ptREZt3G0SU57b9d6/+9+c/JJfRWuc4P3YbF
tqy4qEX2C5xyv6HNpLSi+W+c/QVQSwMEFAACAAgAET9dOP4RU75FAwAAjxQA
AB4AAABwZ3NxbG9kYmMtMDguMDEuMDIwMC90cmFjZS5sb2ftWF1vmzAUfW5/
hd/STsoE2AHSaZMooSsSC21JJm0oiojjNEgEIjBd++9nPtImBAhJW3WdylNk
Xx+fe3x9HNs2e+fqyOblDieO7PF47vhTj0Sf8chGSBodHx1p9y49s61rY2wN
VVWzrKTxSPPv3DDwF8Sn4CuQOVFyMHdsb6CxMYrnBfgyxUwgYUdOIX0aPpwl
MFkXGDwsCYMRkibdX8YU5B3NoZEkVrM1Y1oElTkib4Oqge8TTHOu4hNZsPYl
iHmgG/hPcMUYi4R3JAR9Z5HMaU+8mMwcTNoRa3cxiUa2R/xbOmedvAROEtL9
gXU6KuIMozWU/tAwtiKUmM7ZSrjYyRllYaxr2NdVs6eBYeT6t4D4OJgmPxRL
1XXQ0i1TljvdNt8CTBqwCm4NVastGFrruFYhxItchea7VqsjwLpCgOWFUL5m
BWiey4usYSVI3c6kpLyuQrJ0wgyxK1QXgkUdSh63QQq2FXJtJEsSEY8JB3AQ
+/Tk0ymYhcECRO7SwWlT9AWsFQREawVRyw6KUtNF0O4JjmmWkwz3yqkWDCLU
lEI/XtyQKPaoGnipy/Co+yxxGU688IGaSJhGIQkLpMHEAqwgDQpfNssGPGh/
A/zbJDchzmsmx+ArkmPQCqWhO8kXXZC5l8iNUZ8we2MWWAy4cIk3Bfo0MbaZ
m8YkmfQ0Sx33dOvKUH6NLf23tgU8d0IHUzYg4ctGbU19Hs9mrNtYbbbtHcvy
ZC5ZHcBYk9DF4FGRXL4ulHcrJ3b4ptvlnxLdUM41Y6faiQwyt1NzyPEvojr3
oTcrO+md6v1fO+YFoXieJrX+t/egw/YRCiLuXdbyh2F/GPZrGMh3QnsOdbId
/MpSD5zwltDVHYVPdVYvlZsDlMuhfjrsTljt4UxfBgLMEOjsdrayG1SrAuru
4WM5U3Y54UVB7pbGMBJeCYnE8zpv5Hl9c9xTBkpJOdwEf1JvThmI4rPqgWFt
niMzVD+hAKXm0pegVxwjP4KQZGdV9DLCFgAhD5vKexESYtFFJi963nYzl/lb
BV8+z9qrkSTs/1hQVVQbyEhqbDQ9N8JPTx8Ch/Z7G9oFCFFjJpspCBI84Emt
nFJBdgEdSIkT6yjxNa98fwFQSwMECgAAAAAAET9dOAAAAAAAAAAAAAAAABUA
AABwZ3NxbG9kYmMtMDguMDEuMDIwMC9QSwECFAAUAAIACABHQF04kVtX4BQC
AACSCAAAHgAkAAAAAAABACAAAAAAAAAAcGdzcWxvZGJjLTA4LjAyLjA1MDAv
dHJhY2UubG9nCgAgAAAAAAABABgAcMN+ZKl6yAEAsn1kqXrIAQCyfWSpesgB
UEsBAhQACgAAAAAAR0BdOAAAAAAAAAAAAAAAABUAJAAAAAAAAAAQAAAAUAIA
AHBnc3Fsb2RiYy0wOC4wMi4wNTAwLwoAIAAAAAAAAQAYAACyfWSpesgBALJ9
ZKl6yAHwhhNaqXrIAVBLAQIUABQAAgAIAOpAXTgnfaGLEwIAAIEIAAAeACQA
AAAAAAEAIAAAAIMCAABwZ3NxbG9kYmMtMDguMDMuMDEwMC90cmFjZS5sb2cK
ACAAAAAAAAEAGABwJWYaqnrIAdCeZBqqesgB0J5kGqp6yAFQSwECFAAKAAAA
AADqQF04AAAAAAAAAAAAAAAAFQAkAAAAAAAAABAAAADSBAAAcGdzcWxvZGJj
LTA4LjAzLjAxMDAvCgAgAAAAAAABABgA0J5kGqp6yAHQnmQaqnrIAVAa/5Op
esgBUEsBAhQAFAACAAgAET9dOHt9WBx8DAAA91kAACgAJAAAAAAAAQAgAAAA
BQUAAHBnc3Fsb2RiYy0wOC4wMS4wMjAwL215bG9nX3Jvb3QxODUwNi5sb2cK
ACAAAAAAAAEAGACQ0T+ZqHrIATCbIZmoesgBMJshmah6yAFQSwECFAAUAAIA
CAARP104vscqKRwDAACDBwAAKwAkAAAAAAABACAAAADHEQAAcGdzcWxvZGJj
LTA4LjAxLjAyMDAvcHNxbG9kYmNfcm9vdDE4NTA2LmxvZwoAIAAAAAAAAQAY
AOD1G5moesgBwMUWmah6yAHAxRaZqHrIAVBLAQIUABQAAgAIABE/XTj+EVO+
RQMAAI8UAAAeACQAAAAAAAEAIAAAACwVAABwZ3NxbG9kYmMtMDguMDEuMDIw
MC90cmFjZS5sb2cKACAAAAAAAAEAGACwYiCZqHrIASADH5moesgBIAMfmah6
yAFQSwECFAAKAAAAAAARP104AAAAAAAAAAAAAAAAFQAkAAAAAAAAABAAAACt
GAAAcGdzcWxvZGJjLTA4LjAxLjAyMDAvCgAgAAAAAAABABgAMJshmah6yAEw
myGZqHrIAcDL2o2oesgBUEsFBgAAAAAIAAgAfAMAAOAYAAAAAA==

--------------020107020301080403000405
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--------------020107020301080403000405--