FreeTDS Development Group

[Dan Harris <coronadh AT coronasolutions.com>]

/usr/local/freetds/lib is in /etc/ld.so.conf.. 

I should probably restate that nothing in freetds has changed.  It was 
working 
perfectly before I upgraded apache and php.   So interfaces file, TDS 
version, sqsh, etc.. are all the same as when they were functioning 
correctly.  I also tried going back to 4.1.1 using the same configure 
parameters I had stored and I get the same probblems.  mssql_connect does not 
return a connection handle but also doesn't return an error until I try and 
query on that handle.

As for the cgi stuff, I tried this:

./configure --with-sybase=/usr/local/freetds

I made a standalone php and ran it.. It gave this:

Call to undefined function:  mssql_connect()

Did I forget something?

Thanks for your help on this guys.

On Wednesday 26 June 2002 07:53 pm, you wrote:
> LD_LIBRARY_PATH should usually include /usr/local/freetds/lib unless
> you've modified ld.so.conf and run ldconfig.  The PHP cgi version is what
> you get if you don't compile it with --with-apache=/path/to/apache, it
> gives you an executable that can be run from the command line.
>
> Also, double check to make sure that the tds version is correctly set.
> You can force it by setting TDSVER to 4.2|5.0|7.0 before lauching apache.
>
> Brian
>
> On Wed, 26 Jun 2002, Dan Harris wrote:
> > php_info() reports sybase module is loaded and shows the correct
> > --with-sybase=/usr/local/freetds
> >
> > I dont know how to do the cgi version that you mentioned
> >
> > $SYBASE=/usr/local/freetds
> > $LD_LIBRARY_PATH is not set.. what should it be?
> >
> > sqsh connects and lets me run queries normally.
> >
> > Thanks!!
> >
> > On Wednesday 26 June 2002 07:30 pm, Brian Bruns wrote:
> > > It works as far as I know.  A couple things to try.  first write a
> > > script to call php_info() to see if php is detecting the module
> > > properly. Compile a cgi version of php and try running from the command
> > > line.  If you are using interfaces files, delete the freetds.conf and
> > > insure that $SYBASE and $LD_LIBRARY_PATH are set properly before
> > > launching apache, otherwise just the LD_LIBRARY_PATH.  Grab SQSH and
> > > make sure your connections are working before trying to debug PHP.
> > >
> > > Post back any results from these steps, I'll keep an eye on my email
> > > for the next few hours.
> > >
> > > Brian
> > >
> > > On Wed, 26 Jun 2002, Dan Harris wrote:
> > > > I am trying to upgrade apache+php to fix the recent vulnerabilities.
> > > > However, I am not able to get my freetds connections working now.  I
> > > > compiled --with-sybase=/usr/local/freetds but I get this:
> > > >
> > > > Warning: Sybase: Unable to connect in /usr/cadmine/functions.php on
> > > > line 128
> > > >
> > > > Nothing has changed other than installing a new version of php.  The
> > > > system was working fine before the new apache (1.3.26) and php
> > > > (4.2.1). sqsh can connect to the server and run queries fine.  Is
> > > > there a known problem with this?  Any help would be appreciated as
> > > > I've tried everything I can think of and can't leave my office until
> > > > this is fixed
> > > >
> > > > :(
> > > >
> > > > Thanks!
> > > >
> > > > -Dan
> > > >
> > > > ---
> > > > You are currently subscribed to freetds as: [camber AT ais.org]
> > > > To unsubscribe, forward this message to
> > > > $subst('Email.Unsub')
> > >
> > > ---
> > > You are currently subscribed to freetds as: [dan AT drivefaster.net]
> > > To unsubscribe, forward this message to
> > > $subst('Email.Unsub')
> >
> > ---
> > You are currently subscribed to freetds as: [camber AT ais.org]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
>
> ---
> You are currently subscribed to freetds as: [dan AT drivefaster.net]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')