FreeTDS Development Group

[carl dotsch <cardosur AT cardosur.com>]

carl dotsch wrote:

> Brian Bruns wrote:
>
> > sybtcl in config_vars.mk does need to be removed, so I'd say all is well
> > there.
> >
> > You'll want to make sure that the linker can find libct.so by either
> > adding it to your LD_LIBRARY_PATH=/usr/local/freetds/lib (before starting
> > apache!) or editing the /etc/ld.so.conf file and running ldconfig.
> >
> > you can check this by running ldd against the apache binary.
> >
> > from the message it sounds like it is getting this far, but just want to
> > make sure.  The second thing is ditch the interfaces format, it's old and
> > has some environment variable requirements.  Use the freetds.conf file
> > instead.
> >
> > Brian
> >
> > > >1) use --with-sybase-ct it is the same API but uses ctlib as the
> > > >underlying implementation.
> > >
> > > Seems like this would be the cleanest and best solution. I have run into
> > > another problem though. Below is a summary of what I did, as well as the
> > > outcome...
> > >
> > > 1) I configured PHP (4.0.6) with --with-sybase-ct insteadof 
> > > --with-sybase
> > > 2) I followed the steps in
> > > http://www.freetds.org/userguide/x1076.htm#AEN1112 (which needs updated 
> > > for
> > > "ct" support?) and edited the Zend/Makefile leaving the -lct library, 
> > > and
> > > removing the others listed.
> > > 3) I did a make
> > >
> > > Everything seems to work great, until the final linking process...when I
> > > end up with this:
> > >
> > > /bin/sh /usr/local/apache/localhost/src/php-4.0.6/libtool --silent
> > > --mode=link gcc  -I. -I/usr/local/apache/localhost/src/php-4.0.6/
> > > [skipped]  -D_POSIX_PTHREAD_SEMANTICS -DSOLARIS2=280 -DUSE_EXPAT
> > > -DSHARED_CORE -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21 -g -O2   -o libphp4.la
> > > -rpath /usr/local/apache/localhost/src/php-4.0.6/libs -avoid-version
> > > -L/usr/ucblib [skipped] -L/usr/local/freetds/lib  -R /usr/ucblib 
> > > [skipped]
> > > -R /usr/local/freetds/lib stub.lo  Zend/libZend.la 
> > > sapi/apache/libsapi.la
> > > [skipped] ext/sybase_ct/libsybase_ct.la [skipped] -lpam [skipped] 
> > > -lsybtcl
> > > -lintl -lcomn -lct -lcs [skipped]
> > > /usr/local/bin/ld: cannot find -lsybtcl
> > > collect2: ld returned 1 exit status
> > > make[1]: *** [libphp4.la] Error 1
> > >
> > > where did -lsybtcl come from?
> > >
> > > I did a quick grep of the files in PHP, and found the following 
> > > contained
> > > "sybtcl"
> > >
> > > ./ext/sybase_ct/config.m4
> > > ./configure
> > > ./config.log
> > > ./config_vars.mk
> > > ./config.status
> > >
> > > I edited config_vars.mk and removed the same libraries as were removed 
> > > from
> > > the Zend/Makefile. The compile finished fine. What are the chances that 
> > > it
> > > will actually work?
> > >
> > > I did try, and things kind of seem to work. There does seem to be a 
> > > problem
> > > connecting though...
> > >
> > > I have
> > >
> > > <?
> > > $ms_conn=mssql_connect("interface_name",'username','password);
> > > ?>
> > >
> > > It comes back with "Warning: Sybase: Unable to connect in
> > > /usr/local/apache/localhost/htdocs/go.php on line 2"
> > >
> > > It almost seems like it doesn't know where the interfaces file is. I do
> > > have the interfaces file defined in the php.ini as
> > >
> > > sybase.interface_file="/usr/local/freetds/interfaces"
> > >
> > > though, I don't know that the sybase-ct will use the sybase directives.
> > > Anyone have any idea?
> > >
> > > benji
> > >
> > > ---
> > > Ben Spencer
> > > Web Support
> > > bspencer AT moody.edu
> > > x 2288
> >
> > ---
> > You are currently subscribed to freetds as: [cardosur AT cardosur.com]
> > To unsubscribe, forward this message to $subst('Email.Unsub')
>
> ---
> You are currently subscribed to freetds as: [cardosur AT cardosur.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')