Skip to Content.
Sympa Menu

freetds - Re: Updating freetds 0.53 -> 0.60

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Erik Anderson <eanders AT pobox.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Updating freetds 0.53 -> 0.60
  • Date: Wed, 18 Sep 2002 20:14:55 -0500

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')



  




Archive powered by MHonArc 2.6.24.

Top of Page