Re: PHP and MSSQL on Linux

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx 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@xxxxxxxxxxxx:
> > 
> > >
> > > 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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux