Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion Help please with DBD::ODBC on SUSE-Linux
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
"Martin J. Evans"  
View profile  
 More options Aug 15 2012, 10:50 am
Newsgroups: perl.dbi.users
From: martin.ev...@easysoft.com ("Martin J. Evans")
Date: Wed, 15 Aug 2012 15:50:28 +0100
Local: Wed, Aug 15 2012 10:50 am
Subject: Re: Help please with DBD::ODBC on SUSE-Linux
On 15/08/12 15:32, Jeff Tate wrote:

> Couldn't find odbcinst. Compiled test code as instructed. Result of a.out
> is:

> size of SQLLEN is 8

Ok, so this /should be/ good. It means that compiling DBD::ODBC with those header files means SQLLEN and SQLULEN are 8 bytes in size and one /would hope/ if teradata was compiled the same way it was also using SQLLEN/SQLULEN of 8 bytes. If this is the case my guess is wrong.

BTW, I spoke to lead developer for unixODBC and he thinks the ODBC driver manager that comes with teradata might actually be unixODBC as he had some contact with teradata some time ago.

> As for decision to install Teradata odbc rather than SUSE odbc, that was
> made by the sysadmin team. I am just a user. I will however ask them if
> there is the possibility to install unixodbc - is that target neutral or is
> there some additional work they would have to do to enable a Teradata
> connection.

If above is correct you should not need to install unixODBC separately.

So, the problem remains why is this segfaulting - it gets harder now. I'm kind of tempted to say "ask teradata" but I'll try and give you some suggestions so we might try and track it down.

t/03dbatt.t was the first test to fail so we'll start with this one. Assuming it is unixODBC you are using edit your odbcinst.ini file (/opt/teradata/client/ODBC_64/odbcinst.ini assuming you still have ODBCINSTINI set as in your first post) and at the top add:

[ODBC]
Trace=yes
TraceFile=/tmp/unixodbc.log

Now go to the dir where you are building and running DBD::ODBC test suite and do:

prove -vb t/03dbatt.t

If you are using unixODBC it should write something to /tmp/unixodbc.log. If it does post the last 100 lines.

Do:

which perl

which should output something like:

/usr/bin/perl

then assuming you have gdb (or install it) do:

gdb /usr/bin/perl    <---- replace with which output

and at the prompt do:

run -Iblib/lib -Iblib/arch t/03dbatt.t

when it crashes type "bt" for a back trace and post it.

Even if we cannot get a clue from this it will be useful if you go to teradata.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.