Re: PHP, MYSQL and Apache

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

 



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@xxxxxxxxxxxxx>
To: KM <thalor@xxxxxxxxxxx>
Cc: bitslayer@xxxxxxxxxxx,  php-windows@xxxxxxxxxxxxx
Date: Tue, 07 Aug 2007 08:53:02 -0400
Subject: Re:  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@xxxxxxxxxxx] 
> > Sent: Monday, August 06, 2007 9:56 PM
> > To: 'KM'
> > Cc: php-windows@xxxxxxxxxxxxx
> > Subject: RE:  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@xxxxxxxxxxx] 
> > Sent: Monday, August 06, 2007 9:22 PM
> > To: 'Carlton Whitehead'
> > Cc: php-windows@xxxxxxxxxxxxx
> > Subject: RE:  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@xxxxxxxxxxxx] 
> > Sent: Monday, August 06, 2007 9:01 PM
> > To: KM
> > Cc: php-windows@xxxxxxxxxxxxx
> > Subject: Re:  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@xxxxxxxxxxxx] 
> >> Sent: Monday, August 06, 2007 5:11 PM
> >> To: KM
> >> Cc: php-windows@xxxxxxxxxxxxx
> >> Subject: Re:  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@xxxxxxxxxxx>
> >> To: php-windows@xxxxxxxxxxxxx
> >> Sent: Monday, August 6, 2007 4:58:36 PM (GMT-0500) America/New_York
> >> Subject:  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
> >  
> >
> >   
> 
> 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux