Re: Re: [PHP-DB] PHP and MSSQL on Linux

I ran it as the apache user and it worked fine (from the command line). I do notice that when I run a system command using the exec or system functions, I get nothing back on some of the commands (primarily traceroute and ping). Others do work (whoami) Robbert Micah Stevens <micah@raincross-tech.com> wrote on 11/02/2005, 07:58:55 PM: > > 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