Re: FreeTDS - PHP - Mac OS X Leopard Server

Thank you for the suggestions. I was actually able to get it somewhat
working using Entropy - it installs FreeTDS along with it. I did not realize
this before and was trying to install FreeTDS along side it. However, I am
left again with a problem connecting to the SQL server, the FreeTDS log
shows:
09:32:55.683647 631 (net.c:264):tds_open_socket: connect(2) returned
"Operation now in progress"
09:32:55.684355 631 (net.c:303):tds_open_socket() succeeded
09:32:55.684395 631 (util.c:162):Changed query state from DEAD to IDLE
09:32:55.684414 631 (login.c:735):quietly sending TDS 7+ login packet
09:32:55.684526 631 (token.c:312):tds_process_login_tokens()
09:32:55.686159 631 (util.c:334):tdserror(0x103d28900, 0x103d2f610, 20017,
0)
09:32:55.686188 631 (dblib.c:7782):dbperror(0x100972200, 20017, 0)
09:32:55.686209 631 (dblib.c:7835):20017: "Unexpected EOF from the server"
09:32:55.686224 631 (dblib.c:7856):"Unexpected EOF from the server", client
returns 2 (INT_CANCEL)
09:32:55.686239 631 (util.c:368):tdserror: client library returned
TDS_INT_CANCEL(2)
09:32:55.686254 631 (util.c:389):tdserror: returning TDS_INT_CANCEL(2)
09:32:55.686297 631 (util.c:162):Changed query state from IDLE to DEAD

tsql connects fine, its just when I try to connect using PHP when this
happens.



On Fri, Sep 25, 2009 at 9:46 AM, Eloy Lafuente <[email protected]> wrote:

> I'd suggest you to use the MacPorts way:
>
> http://www.macports.org/
>
> It's a really handy "downloader/compiler/installer" for all
> those of things, looking for dependencies, configuring...
> lots easier than the manual way. I used to be "manual-guy"
> until discovered it. Once intalled, something like this will
> do the whole work:
>
> port install php52 +apache2 +mssql +mysql5 +postgresql83
> (see variants for options available on each package)
>
> That is my current php5 port, it installs the freetds php
> driver by default.
>
> Ciao, stronk7 :-)
>
> Daniel Fazekas escribió:
> > On Sep 25, 2009, at 14:59, Nikhil wrote:
> >
> >> Does anyone have a successful FreeTDS installation with Leopard
> >> Server? The built-in PHP module in Leopard is not configured for
> >> MSSQL and I cannot seem to get PHP to talk with FreeTDS.
> >
> > You'll have to build and install the mssql php extension.
> >
> > First you have to get the PHP source code matching the version on your
> > system.
> > It's probably easiest to go to
> > http://www.opensource.apple.com/
> >
> > Select the Mac OS X version you got, and look for the package named
> > "apache_mod_php-*"
> >
> > Expand the archive until you get to the actual PHP source code, then
> > it should be as simple as:
> >
> > cd ext/mssql
> > phpize && ./configure && make && sudo make install
> >
> > Then edit /etc/php.ini to get your freshly installed extension loaded:
> > extension = mssql.so
> >
> > Finally you may have to reload Apache so that the changes could take
> > place.
> > sudo apachectl graceful
> >
> >
> > Or you could try to use the ODBC driver in FreeTDS as PHP on Mac OS X
> > already comes with the odbc extension built in.
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
> --
> /// Moodle - open-source software for collaborative learning
> ///
> /// Free software, community, information: http://moodle.org
> /// Commercial support and other services: http://moodle.com
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>