PHP and MSSQL on Linux

I originally posted this to the general discussion but wanted to see if
anyone on this list had an idea. The issue is trying to connect to the
MSSQL with PHP from a linux box (Fedora Core 4 in this instance)

> An interesting development. I found some reference to running my PHP
> script from the command line to take Apache out of the picture. Lo and
> behold, the script worked. I was able to connect to the server. So the
> issue seems to be related with Apache. Any idea what I would need to do
> there to make the script work via the web?
>
> Robbert
>
> php@swimwebs.com wrote on 11/02/2005, 05:50:01 PM:
> >
> > Thanks for your help. I'd love to hear if you have any success with the
> > RPMs. Something I've seen over and over again in the documentation is
> > the compilation of php adding "--with-mssql". My PHP info output does
> > not include that marker.
> >
> > The output is as follows
> > './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux'
> > '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
> > '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
> > '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
> > '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
> > '--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
> > '--infodir=/usr/share/info' '--cache-file=../config.cache'
> > '--with-libdir=lib' '--with-config-file-path=/etc'
> > '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
> > '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
> > '--with-freetype-dir=/usr' '--with-png-dir=/usr'
> > '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp'
> > '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png'
> > '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr'
> > '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp'
> > '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem'
> > '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars'
> > '--enable-trans-sid' '--enable-yp' '--enable-wddx'
> > '--with-pear=/usr/share/pear' '--with-kerberos'
> > '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr'
> > '--enable-memory-limit' '--enable-shmop' '--enable-calendar'
> > '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic'
> > '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml'
> > '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd'
> > '--without-odbc' '--disable-dom' '--disable-dba'
> >
> > Howver, under additional .ini files parsed, I see the mssql file:
> > /etc/php.d/ldap.ini, /etc/php.d/mssql.ini, /etc/php.d/mysql.ini,
> > /etc/php.d/mysqli.ini, /etc/php.d/odbc.ini
> >
> > And further on down are the mssql configuration settings.
> > Rick Emery wrote on 11/02/2005, 05:19:06 PM:
> > > Quoting php@swimwebs.com:
> > >
> > > >
> > > > Yup, I thought that was the problem too but when I added my server to
> > > > the conf file, there was no change. When you set up your MSSQL
> > > > connection in fedora, did you install anything else other than MSSQL
> > > > and PHP-MSSQL? Or did you have to set anything in your php.ini file to
> > > > use the new extension?
> > >
> > > Well, I didn't have the rpms; I compiled from source. I don't have that
> > > box available anymore, but I've checked my notes. First, I compiled
> > > freetds (nothing special in the configure line), then I compiled php
> > > using "--with-mssql=/usr" (to point to the freetds libraries). All of
> > > this should have been handled within the rpms, though, and if phpinfo
> > > is showing the mssql extension loaded, I'm not sure why it wouldn't be
> > > working. I don't remember modifying php.ini at all for the mssql stuff.
> > >
> > > Hopefully over the next couple of days I'll have some time to set up a
> > > test box and try the rpms to which you pointed me, to see if I run into
> > > the same trouble.
> > >
> > > Rick
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP and MSSQL on Linux

Run it from the command line as the apache user. See if that makes a
difference. I'd guess not though.

Apache's php module doesn't really put any restrictions that I know of on the
scripting.. that's a strange effect..

On Wednesday 02 November 2005 10:54 am, php@swimwebs.com wrote:
> I originally posted this to the general discussion but wanted to see if
> anyone on this list had an idea. The issue is trying to connect to the
> MSSQL with PHP from a linux box (Fedora Core 4 in this instance)
>
> > An interesting development. I found some reference to running my PHP
> > script from the command line to take Apache out of the picture. Lo and
> > behold, the script worked. I was able to connect to the server. So the
> > issue seems to be related with Apache. Any idea what I would need to do
> > there to make the script work via the web?
> >
> > Robbert
> >
> > php@swimwebs.com wrote on 11/02/2005, 05:50:01 PM:
> > > Thanks for your help. I'd love to hear if you have any success with
> > > the RPMs. Something I've seen over and over again in the documentation
> > > is the compilation of php adding "--with-mssql". My PHP info output
> > > does not include that marker.
> > >
> > > The output is as follows
> > > './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux'
> > > '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
> > > '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
> > > '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
> > > '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
> > > '--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
> > > '--infodir=/usr/share/info' '--cache-file=../config.cache'
> > > '--with-libdir=lib' '--with-config-file-path=/etc'
> > > '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
> > > '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
> > > '--with-freetype-dir=/usr' '--with-png-dir=/usr'
> > > '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp'
> > > '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png'
> > > '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr'
> > > '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp'
> > > '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem'
> > > '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars'
> > > '--enable-trans-sid' '--enable-yp' '--enable-wddx'
> > > '--with-pear=/usr/share/pear' '--with-kerberos'
> > > '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr'
> > > '--enable-memory-limit' '--enable-shmop' '--enable-calendar'
> > > '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic'
> > > '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml'
> > > '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd'
> > > '--without-odbc' '--disable-dom' '--disable-dba'
> > >
> > > Howver, under additional .ini files parsed, I see the mssql file:
> > > /etc/php.d/ldap.ini, /etc/php.d/mssql.ini, /etc/php.d/mysql.ini,
> > > /etc/php.d/mysqli.ini, /etc/php.d/odbc.ini
> > >
> > > And further on down are the mssql configuration settings.
> > >
> > > Rick Emery wrote on 11/02/2005, 05:19:06 PM:
> > > > Quoting php@swimwebs.com:
> > > > > Yup, I thought that was the problem too but when I added my server
> > > > > to the conf file, there was no change. When you set up your MSSQL
> > > > > connection in fedora, did you install anything else other than
> > > > > MSSQL and PHP-MSSQL? Or did you have to set anything in your
> > > > > php.ini file to use the new extension?
> > > >
> > > > Well, I didn't have the rpms; I compiled from source. I don't have
> > > > that box available anymore, but I've checked my notes. First, I
> > > > compiled freetds (nothing special in the configure line), then I
> > > > compiled php using "--with-mssql=/usr" (to point to the freetds
> > > > libraries). All of this should have been handled within the rpms,
> > > > though, and if phpinfo is showing the mssql extension loaded, I'm not
> > > > sure why it wouldn't be working. I don't remember modifying php.ini
> > > > at all for the mssql stuff.
> > > >
> > > > Hopefully over the next couple of days I'll have some time to set up
> > > > a test box and try the rpms to which you pointed me, to see if I run
> > > > into the same trouble.
> > > >
> > > > Rick
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php