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 [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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 [EMAIL PROTECTED]:
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