FreeTDS Development Group

[Erik Anderson <eanders AT pobox.com>]

Here is the info:

[root@UNIXWORK lib]# pwd
 /usr/local/freetds/lib
[root@UNIXWORK lib]# ls -la
total 4904
drwxr-xr-x    2 root     root         4096 Sep 16 18:01 .
drwxr-xr-x    7 root     root         4096 Sep 16 17:35 ..
-rw-r--r--    1 root     root       903868 Sep 16 18:01 libct.a
-rwxr-xr-x    1 root     root          692 Sep 16 18:01 libct.la
lrwxrwxrwx    1 root     root           14 Sep 16 18:01 libct.so -> libct.so.0.0.0
lrwxrwxrwx    1 root     root           14 Sep 16 18:01 libct.so.0 ->
libct.so.0.0.0
-rwxr-xr-x    1 root     root       393926 Sep 16 17:35 libct.so.0.0
-rwxr-xr-x    1 root     root       310045 Sep 16 18:01 libct.so.0.0.0
-rw-r--r--    1 root     root       996482 Sep 16 18:01 libsybdb.a
-rwxr-xr-x    1 root     root          713 Sep 16 18:01 libsybdb.la
lrwxrwxrwx    1 root     root           17 Sep 16 18:01 libsybdb.so ->
libsybdb.so.1.0.0
lrwxrwxrwx    1 root     root           17 Sep 16 18:01 libsybdb.so.1 ->
libsybdb.so.1.0.0
-rwxr-xr-x    1 root     root       473961 Sep 16 17:35 libsybdb.so.1.0
-rwxr-xr-x    1 root     root       336495 Sep 16 18:01 libsybdb.so.1.0.0
-rw-r--r--    1 root     root       659480 Sep 16 18:01 libtds.a
-rwxr-xr-x    1 root     root          699 Sep 16 18:01 libtds.la
lrwxrwxrwx    1 root     root           15 Sep 16 18:01 libtds.so -> libtds.so.0.0.0
lrwxrwxrwx    1 root     root           15 Sep 16 18:01 libtds.so.0 ->
libtds.so.0.0.0
-rwxr-xr-x    1 root     root       318398 Sep 16 17:35 libtds.so.0.0
-rwxr-xr-x    1 root     root       236234 Sep 16 18:01 libtds.so.0.0.0
-rw-r--r--    1 root     root       151728 Sep 16 18:01 libtdssrv.a
-rwxr-xr-x    1 root     root          720 Sep 16 18:01 libtdssrv.la
lrwxrwxrwx    1 root     root           18 Sep 16 18:01 libtdssrv.so ->
libtdssrv.so.0.0.0
lrwxrwxrwx    1 root     root           18 Sep 16 18:01 libtdssrv.so.0 ->
libtdssrv.so.0.0.0
-rwxr-xr-x    1 root     root        72879 Sep 16 17:35 libtdssrv.so.0.0
-rwxr-xr-x    1 root     root        66921 Sep 16 18:01 libtdssrv.so.0.0.0
[root@UNIXWORK lib]# nm libsybdb.so | grep -i dbdead
00007a90 T DBDEAD
[root@UNIXWORK lib]# nm libsybdb.so.1.0 | grep -i dbdead
00008e70 T dbdead

As you see the dbdead() us exported in the libsybdb.so but not in the libsybdb.so.1.0

I did configure FreeTDS0.60 with the --prefix as follows.
./configure --with-tdsver=8.0 --prefix=/usr/local/freetds

I configured PHP as follows
./configure --enable-ftp --enable-calendar --with-java=/usr/java/jdk1.3.1
--with-apxs --with-mysql --enable-track-vars --with-sybase=/usr/local/freetds
--enable-sockets --with-mcrypt=/storage/archive/mcrypt/libmcrypt-2.5.2

Apache is an RPM install.

My /etc/ld.so.conf has the entry
/usr/local/freetds/lib

Just looks like it is a versioning problem with your so libraries.

It looks like I could "tweak" a symbolic link and be happy with it but since
everything is working with FreeTDS-0.53 I am reluctant to tweak when an older
default install works.

My system is tweaked enough by using mCrypt to encrypting PHP web page source
with mCrypt DES3 cyphers and MD5 hashes.  SQL Server 2000 is running in a
VMWare virtual Operating System on the same Linux box.

In interest of keeping my sanity from all my other tweaks I will wait for
a patch before I upgrade to FreeTDS-0.6x.

Erik

Lowden, James K wrote:
> > From: Erik Anderson [mailto:eanders AT pobox.com]
> > Sent: September 18, 2002 10:08 AM
> >
> > When I compile freetds-0.60 into Apache I get the following error when
> > starting Apache.
> >
> > [root@UNIXWORK modules]# /etc/init.d/httpd start
> > Starting httpd: Syntax error on line 57 of /etc/httpd/conf/httpd.conf:
> > Cannot load /etc/httpd/modules/libphp4.so into server:
> > /etc/httpd/modules/libphp4.so: undefined symbol: dbdead
> >                                                            [FAILED]
> >
> > I have freetds-0.53 php-4.1.2, apache 1.3.20-23, and MS SQL Server 2000
> > all working together but not the FreeTDS-0.60
> >
> > My guess is wait for a new patch to fix the dbdead(), DBDEAD() problem.
> >   
> Erik, 
>
> I think this is a simple matter of readjusting your runtime linker.  (Bear
> in mind the new default installation directories.)  
>
> Using nm(1), you should be able to confirm that FreeTDS 0.60 exports
> dbdead().  
>
> Using ldd(1), you should be able to confirm that Apache is linked to FreeTDS
> 0.60.  
>
> Could you please check those and let us know?  
>
> All, 
>
> Does anyone have an explanation for this?  
>
> We have now 2 PRs for a missing dbdead() function.  That practically makes
> it a FAQ.  
>
> dbdead() -- lowercase -- is in fact exported by FreeTDS 0.60.  FreeTDS 0.53
> exported DBDEAD().  
> (Use nm to check.)  Apache linked to 0.60 should find dbdead().  
>
> The only  explanation I can come up with is misconfiguration at the client.
> I  think the runtime linker is finding 0.53 after Apache is recompiled with
> the 0.60 header files.  
>
> Could someone suggest how to confirm/deny my hypothesis?  How best to
> determine what the runtime linker is doing?  What best to do?  
>
> Does ldd(1) work on these systems? 
>
> --jkl
>
>
>
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that for certain accounts we do not accept
> orders and/or instructions by e-mail, and for those accounts we will not be
> responsible for carrying out such orders and/or instructions. Kindly refrain
> from sending orders or instructions by e-mail unless you have confirmed that
> we accept such communications for your account. Please also note that to
> satisfy regulatory requirements we review the outgoing and incoming e-mail
> correspondence of staff members serving certain functions.
>
>
>
> ---
> You are currently subscribed to freetds as: [eanders AT pobox.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')