The perl-odbc-maxdb connection now works.
By setting the environment variable PERL_DL_NONLAZY=1
the segmentation fault has disappeard.
Thank you Christian Jung for the tip.
"...With PERL_DL_NONLAZY set to 1, Perl resolves all
unresolved symbols at startup time ..."
Thanks again,
Filip Sergeys
On Mon, 2004-01-26 at 12:36, Robson Paniago wrote:
> I needed to set LD_ASSUME_KERNEL=2.4.1 before starting my perl program (my
> system is a RedHat 9.0) to get it working.
>
>
> >From: "Filip Sergeys" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Problem with odbc on Linux
> >Date: 26 Jan 2004 09:54:05 +0100
> >
> >Just a thought, have you tested that the odbc link itself is working?
> >You can test it with isql DSN UID PWD options
> >where DSN is in your case apparently maxdb. For options: "-v" for
> >verbose is interesting.
> >If you can connect with isql; your odbc configuration is OK, if you
> >can't maybe these suggestions can help:
> >In your /etc/odbcinst.ini:
> >I found that the Setup variable had to point to the unixODBC template
> >file. Setup = /usr/lib/unixODBC/libsapdbS.so.1.0.0 Although I think this
> >parameter is only important for the unixODBC gui tool.
> >
> >Your /etc/odbc.ini file seems OK.
> >
> >What I also found out is that I need a symlink from
> >/etc/unixODBC/odbc.ini (or /etc/odbc.ini in your case) to .odbc.ini in
> >my home directory for isql to work.
> >
> >But here start the problems for me too.
> >I want to connect to maxdb with perl using DBI and DBD::odbc but I
> >can't get it to work although the odbc connection is OK.
> >
> >Greetz,
> >
> >Filip
> >
> >
> >On Sat, 2004-01-24 at 09:35, Christian Welzel wrote:
> > > Good morning,
> > >
> > > i have the following problem:
> > >
> > > i'm trying to get maxdb 7.5.0.5 with Apache-SSL 1.3.26, PHP 4.1.2 and
> >unixODBC
> > > 2.1.1 working. the webserver is running on a debian stable machine, the
> > > db-server is a debian unstable machine.
> > >
> > > after a day of work i got maxdb running with TST database.
> > > I installed unixodbc on our webserver and configured it:
> > >
> > > --- /etc/odbcinst.ini ---
> > > [ODBC]
> > > Trace = No
> > > Trace File = /tmp/sql.log
> > > Pooling = No
> > >
> > > [maxdb]
> > > Description = Max DB
> > > Driver = /usr/local/lib/libsqlod.so
> > > Setup = /usr/lib/libodbcdinst.so.1
> > > FileUsage = 1
> > > ----------
> > >
> > > The /usr/local/lib/libsqlod.so is the one from 7.5.0.5 tgz ball.
> > >
> > > --- ~www-data/.odbc.ini ---
> > > [maxdb]
> > > Description=Max-DB
> > > Driver=maxdb
> > > ServerNode=<db-server-ip>
> > > ServerDB=TST
> > > -----------
> > >
> > > Now i have written a little php-test-script:
> > > <?
> > > $conn = odbc_connect("maxdb", "test", "test");
> > > odbc_close($conn);
> > > ?>
> > >
> > > Now i can see in "x_server -i -D 3 start" :
> > > ---- snipp ---
> > > 12872 XSERVER Accepted connection, socket: 5 Id 1
> > > 12873 XSERVER 1 | Client node '<www-server-fqdn>'
> > > 12857 SERVER Forked child pid 1580
> > > 12874 XSERVER 1 | INFO request(51) Ref 0 Peer Ref 0
> > > 12875 XSERVER 1 | Service USER(0) DB TST Ref 135336024 Peer Ref
> >16384
> > > 12876 XSERVER 1 | INFO reply(52)
> > > 12858 SERVER Exiting pid 1580 exit code 0
> > > 12872 XSERVER Accepted connection, socket: 5 Id 2
> > > 12873 XSERVER 2 | Client node '<www-server-fqdn>'
> > > 12857 SERVER Forked child pid 1581
> > > 12874 XSERVER 2 | USER CONNECT request(61) Ref 0 Peer Ref 0
> > > 12875 XSERVER 2 | Service USER(0) DB TST Ref 135336024 Peer Ref
> >36736
> > > 12876 XSERVER 2 | USER CONNECT reply(62)
> > > 12858 SERVER Exiting pid 1581 exit code 10
> > > 12872 XSERVER Accepted connection, socket: 5 Id 3
> > > 12873 XSERVER 3 | Client node '<www-server-fqdn>'
> > > 12857 SERVER Forked child pid 1582
> > > 12874 XSERVER 3 | INFO request(51) Ref 0 Peer Ref 0
> > > 12875 XSERVER 3 | Service USER(0) DB TST Ref 135336024 Peer Ref
> >16384
> > > 12876 XSERVER 3 | INFO reply(52)
> > > 12858 SERVER Exiting pid 1582 exit code 0
> > > 12872 XSERVER Accepted connection, socket: 5 Id 4
> > > 12873 XSERVER 4 | Client node '<www-server-fqdn>'
> > > 12857 SERVER Forked child pid 1583
> > > 12874 XSERVER 4 | USER CONNECT request(61) Ref 0 Peer Ref 0
> > > 12875 XSERVER 4 | Service USER(0) DB TST Ref 135336024 Peer Ref
> >36736
> > > 12876 XSERVER 4 | USER CONNECT reply(62)
> > > 12858 SERVER Exiting pid 1583 exit code 10
> > > ---- snipp ----
> > >
> > > And then something dies.
> > > The Browser says: Connection to host www was lost.
> > >
> > > I'm new to odbc and maxdb, so my question:
> > > can someone tell me the reason for this behavior ?
> > > what does exitcode 10 mean?
> > > how can i fix that ?
> > >
> > > thanks in advance.
> > >
> > > --
> > > MfG, Christian Welzel
> > > (Sektionsvorsitzender und Admin AG DSN Gerokstrasse)
> > >
> > > GPG-Key:
> >http://www.wh9.tu-dresden.de/~gawain/www.camlann.de/key.asc
> > > Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
> >--
> >*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> >* System Engineer, Verzekeringen NV *
> >* www.verzekeringen.be *
> >* Oostkaai 23 B-2170 Merksem *
> >* 03/6416673 - 0477/340942 *
> >*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> >
> >
> >--
> >MaxDB Discussion Mailing List
> >For list archives: http://lists.mysql.com/maxdb
> >To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
