Re(2): Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()
[EMAIL PROTECTED] writes: I'm confused as to what exactly you have done here. You say it compiled without any errors using -with-mysql=/usr But then your config from phpinfo() shows: --with-mysql=shared My advice is to do a clean installation: delete your current php src directory, extract the php tarball into a new directory then run configure make stop webserver make install restart webserver -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Jason, I just deleted the current php src directory and extracted a new downloaded version 4.06 from PHP.NET. I did the following: attempt 1.) ./configure --with-mysql=/usr/lib/mysql result 1.) configure: error: Cannot find header files under /usr/lib/mysql attempt 2.) ./configure --with-mysql=/usr/include/mysql result 2.) configure: error: Cannot find header files under /usr/include/mysql attempt 3.) ./configure --with-mysql=/usr result 3.) everything will compile find except that the configure command from phpinfo() reads: [SNIP] --with-mysql=shared' ' I am not sure where to point --with-mysql=[DIR]. How do I know I am pointing it to the correct directory? Regards, Adrian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re(2): Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()
On Wednesday 13 March 2002 23:22, mailing list wrote: [EMAIL PROTECTED] writes: I'm confused as to what exactly you have done here. You say it compiled without any errors using -with-mysql=/usr But then your config from phpinfo() shows: --with-mysql=shared If there are no particular reason why you want to use the headers and libs that come with mysql, then I suggest you just use the ones that come with PHP. Thus: --with-mysql would (should) work. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Falling in love is a lot like dying. You never get to do it enough to become good at it. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re(2): [PHP-DB] Fatal Error using mysql_connect()
On Wednesday 13 March 2002 03:56, mailing list wrote: [EMAIL PROTECTED] writes: Looks like MySQL support was not compiled into PHP. If you are using a linux based system you need to run the configure script with the --with-mysql flag in order to utilize the MySQL function set. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 X289 [EMAIL PROTECTED] Sam, I recompiled using the following commands ./configure --with-mysql=/usr/lib/mysql but I am getting the following error while it compiles: configure: error: Cannot find header files under /usr/lib/mysql Try: -with-mysql=/usr -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence diminishes mediocre passions and increases great ones, as the wind blows out candles and fans fires. -- La Rochefoucauld */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()
[EMAIL PROTECTED] writes: Try: -with-mysql=/usr -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Absence diminishes mediocre passions and increases great ones, as the wind blows out candles and fans fires. -- La Rochefoucauld */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php It compiled without any errors using -with-mysql=/usr However I still receive an error while trying to connect to my mysql database: Fatal error: Call to undefined function: mysql_connect() in /www/meyercousa/pages/view_data.php on line 13 I have pasted my configuration from phpinfo(). Hope this helps './configure' 'i386-redhat-linux' '--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' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-curl' '--with-db3' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-gd' '--with-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-ttf' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared' '--with-pgsql=shared' '--with-unixODBC=shared' '--with-apxs=/usr/sbin/apxs' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()
On Wednesday 13 March 2002 04:50, mailing list wrote: It compiled without any errors using -with-mysql=/usr However I still receive an error while trying to connect to my mysql database: Fatal error: Call to undefined function: mysql_connect() in /www/meyercousa/pages/view_data.php on line 13 I have pasted my configuration from phpinfo(). Hope this helps [snip] '--with-ldap=shared' '--with-mysql=shared' '--with-pgsql=shared' '--with-unixODBC=shared' '--with-apxs=/usr/sbin/apxs' I'm confused as to what exactly you have done here. You say it compiled without any errors using -with-mysql=/usr But then your config from phpinfo() shows: --with-mysql=shared My advice is to do a clean installation: delete your current php src directory, extract the php tarball into a new directory then run configure make stop webserver make install restart webserver -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* My only love sprung from my only hate! Too early seen unknown, and known too late! -- William Shakespeare, Romeo and Juliet */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php