RE: [PHP] PHP and MSSQL on Linux

Are you running apache in a sandbox, I know on OpenBSD this is the default behavior for Apache. If this is the case then you need to copy the required libraries inside the sandbox. Nate Tobik (412)661-5700 x206 VigilantMinds -----Original Message----- From: php@swimwebs.com [mailto:php@swimwebs.com] Sent: Wednesday, November 02, 2005 1:30 PM To: php-general@lists.php.net Subject: Re: [PHP] PHP and MSSQL on Linux 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