Re: PHP, MYSQL and Apache

This is from my apache error.log [Tue Aug 07 09:53:47 2007] [notice] Parent: Received shutdown signal -- Shutting down the server. [Tue Aug 07 09:53:47 2007] [notice] Child 2796: Exit event signaled. Child process is ending. [Tue Aug 07 09:53:48 2007] [notice] Child 2796: Released the start mutex [Tue Aug 07 09:53:49 2007] [notice] Child 2796: Waiting for 250 worker threads to exit. [Tue Aug 07 09:53:49 2007] [notice] Child 2796: All worker threads have exited. [Tue Aug 07 09:53:49 2007] [notice] Child 2796: Child process is exiting [Tue Aug 07 09:53:49 2007] [notice] Parent: Child process exited successfully. [Tue Aug 07 09:53:50 2007] [notice] Apache/2.2.4 (Win32) PHP/5.2.3 configured -- resuming normal operations [Tue Aug 07 09:53:50 2007] [notice] Server built: Jan 9 2007 23:17:20 [Tue Aug 07 09:53:50 2007] [notice] Parent: Created child process 4720 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Apache2\\PHP5\\ext\\php_mysql.dll' - The specified module could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Apache2\\PHP5\\ext\\php_mysqli.dll' - The specified module could not be found.\r\n in Unknown on line 0 [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Child process is running [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Acquired the start mutex. [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Starting 250 worker threads. [Tue Aug 07 09:53:50 2007] [notice] Child 4720: Starting thread to listen on port 80. The path doesnt look correct should there be double \ between each folder? ----- Original Message ----- From: Thomas Hearn <tomh@nsoftware.com> To: KM <thalor@comcast.net> Cc: bitslayer@comcast.net, php-windows@lists.php.net Date: Tue, 07 Aug 2007 08:53:02 -0400 Subject: Re: [PHP-WIN] PHP, MYSQL and Apache > This sounds very typical of a problem with WHERE in your path MySQL is set. > > Open up your PATH env variable, and look to see if your PHP ext > directory (with the mysql ext) is listed in the path BEFORE your actual > MySQL installation. If it isn't, then add it. The dlls that are used > by PHP and MySQL have variation and are not actually the same DLL. The > path not found error with MySQL is generally a result of a mismatch > between dll versions of MySQL, often caused by the location in the > path. Same goes for MSSQL. > > Hopefully that helps. > > Tom > > KM wrote: > > Yes the directory is in the PATH.... > > And yes on the second as well.... > > > > Keith > > > > -----Original Message----- > > From: Jeff White [mailto:bitslayer@comcast.net] > > Sent: Monday, August 06, 2007 9:56 PM > > To: 'KM' > > Cc: php-windows@lists.php.net > > Subject: RE: [PHP-WIN] PHP, MYSQL and Apache > > > > Hello Keith, > > > > I realize this may seem a bit tedious, but is your PHP directory in the > > Windows PATH environment variable? And, if so, is the "libmysql.dll" file > in > > the PHP directory? > > > > Jeff > > > > > > > > -----Original Message----- > > From: KM [mailto:thalor@comcast.net] > > Sent: Monday, August 06, 2007 9:22 PM > > To: 'Carlton Whitehead' > > Cc: php-windows@lists.php.net > > Subject: RE: [PHP-WIN] PHP, MYSQL and Apache > > > > Configuration File (php.ini) Path C:\WINDOWS > > Loaded Configuration File C:\WINDOWS\php.ini > > > > This is indeed the ini file I am editing and saving. > > And yes, any time I've made changes to it, I have restarted apache. > > > > Thanks > > Keith > > > > > > > > -----Original Message----- > > From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com] > > Sent: Monday, August 06, 2007 9:01 PM > > To: KM > > Cc: php-windows@lists.php.net > > Subject: Re: [PHP-WIN] PHP, MYSQL and Apache > > > > Keith, > > > > Are you sure that's the same php.ini that is referenced by your > > phpinfo(); script? > > > > Have you restarted Apache since you enabled the extensions? > > > > Regards, > > Carlton Whitehead > > > > > > KM wrote: > > > >> Here is the section of my php.ini that contains the information > >> > >> ;extension=php_bz2.dll > >> ;extension=php_curl.dll > >> ;extension=php_dba.dll > >> ;extension=php_dbase.dll > >> ;extension=php_exif.dll > >> ;extension=php_fdf.dll > >> ;extension=php_gd2.dll > >> ;extension=php_gettext.dll > >> ;extension=php_gmp.dll > >> ;extension=php_ifx.dll > >> ;extension=php_imap.dll > >> ;extension=php_interbase.dll > >> ;extension=php_ldap.dll > >> ;extension=php_mbstring.dll > >> ;extension=php_mcrypt.dll > >> ;extension=php_mhash.dll > >> ;extension=php_mime_magic.dll > >> ;extension=php_ming.dll > >> ;extension=php_msql.dll > >> ;extension=php_mssql.dll > >> extension=php_mysql.dll > >> extension=php_mysqli.dll > >> ;extension=php_oci8.dll > >> ;extension=php_openssl.dll > >> ;extension=php_pdo.dll > >> ;extension=php_pdo_firebird.dll > >> ;extension=php_pdo_mssql.dll > >> ;extension=php_pdo_mysql.dll > >> ;extension=php_pdo_oci.dll > >> ;extension=php_pdo_oci8.dll > >> ;extension=php_pdo_odbc.dll > >> ;extension=php_pdo_pgsql.dll > >> ;extension=php_pdo_sqlite.dll > >> ;extension=php_pgsql.dll > >> ;extension=php_pspell.dll > >> ;extension=php_shmop.dll > >> ;extension=php_snmp.dll > >> ;extension=php_soap.dll > >> ;extension=php_sockets.dll > >> ;extension=php_sqlite.dll > >> ;extension=php_sybase_ct.dll > >> ;extension=php_tidy.dll > >> ;extension=php_xmlrpc.dll > >> ;extension=php_xsl.dll > >> ;extension=php_zip.dll > >> > >> Is there something else I am missing? > >> > >> Keith > >> > >> > >> -----Original Message----- > >> From: Carlton Whitehead [mailto:carlton.whitehead@cebesius.com] > >> Sent: Monday, August 06, 2007 5:11 PM > >> To: KM > >> Cc: php-windows@lists.php.net > >> Subject: Re: [PHP-WIN] PHP, MYSQL and Apache > >> > >> Keith, > >> > >> Browse to your phpinfo(); page, and search it for mysql. Is it listed? > >> > > If not, the mysql module isn't enabled, and you shouldn't expect a > > mysql_connect command to work. You may need to edit your php.ini and > enable > > the php_mysql.dll module. > > > >> Refer to the results of phpinfo(); for the path to the active php.ini > >> > > file, since sometimes this can be an unexpected location on Windows > > machines, at least in my experience. > > > >> Regards, > >> Carlton Whitehead > >> > >> ----- Original Message ----- > >> From: "KM" <thalor@comcast.net> > >> To: php-windows@lists.php.net > >> Sent: Monday, August 6, 2007 4:58:36 PM (GMT-0500) America/New_York > >> Subject: [PHP-WIN] PHP, MYSQL and Apache > >> > >> I am attempting to use the following together.. > >> > >> > >> > >> MYSQL 5.0 > >> > >> Apache 2.2.4 > >> > >> PHP 5.2.3 > >> > >> > >> > >> PHP info I can get. I get the following statement whenever trying to get > >> > > to > > > >> mysql > >> > >> > >> > >> > >> > >> Here is the PHP code for what I'm trying to do. > >> > >> > >> > >> <?php > >> > >> // Connect to the database > >> > >> $dbhost = 'localhost'; > >> > >> $dbusername = 'root'; > >> > >> $dbpasswd = 'joker'; > >> > >> $database_name = 'simple'; > >> > >> $connection = > >> mysql_connect("$dbhost","$dbusername","$dbpasswd") > >> > >> or die ('Couldn\'t connect to server.'); > >> > >> $db = mysql_select_db("$database_name", $connection) > >> > >> or die('Couldn\'t select database.'); > >> > >> > >> > >> // Generate SQL code to store data on database. > >> > >> $insert_sql = 'INSERT INTO simple_table (text) VALUES (\'test text, > >> 1,2,3\')'; > >> > >> > >> > >> // Execute SQL code. > >> > >> mysql_query( $insert_sql ) > >> > >> or die ( 'It Didn\'t Work: ' . mysql_error() ); > >> > >> > >> > >> // Tell User we are done. > >> > >> echo 'Code Inserted'; > >> > >> ?> > >> > >> > >> > >> > >> > >> Fatal error: Call to undefined function mysql_connect() in C:\Program > >> Files\Apache Software Foundation\Apache2.2\htdocs\test_insert_mysql.php > on > >> line 7 > >> > >> > >> > >> Anyone had this before and have a solution, it would be appreciated. > >> > >> > >> > >> Keith > >> > >> > >> No virus found in this outgoing message. > >> Checked by AVG Free Edition. > >> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 > >> 4:16 PM > >> > >> > >> No virus found in this incoming message. > >> Checked by AVG Free Edition. > >> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 > >> > > 4:16 PM > > > >> > >> > >> No virus found in this outgoing message. > >> Checked by AVG Free Edition. > >> Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 > >> > > 4:16 PM > > > >> > >> > >> > > > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 > > 4:16 PM > > > > > > No virus found in this outgoing message. > > Checked by AVG Free Edition. > > Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 > > 4:16 PM > > > > > > > >