Re(2): Re(2): Re(2): [PHP-DB] Fatal Error using mysql_connect()

2002-03-13 Thread mailing list

[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()

2002-03-13 Thread Jason Wong

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()

2002-03-12 Thread Jason Wong

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()

2002-03-12 Thread mailing list

[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()

2002-03-12 Thread Jason Wong

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