List:Eventum General Discussion« Previous MessageNext Message »
From:M  IN BLR SISL Srivathsan Date:August 3 2009 7:25am
Subject:RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2
View as plain text  
Hi all,

Thanks to Barry and Bryan for their replies.  But the grand anti-climax is, whatever I did
began to work after I restarted the XP box!!!

Now, I really like the Linux way of "/etc/init.d/<service> start/stop/restart"

Thanks and rgds,
Watson

-----Original Message-----
From: Barry-Home [mailto:rumpole6@stripped]
Sent: Fri, 31-Jul-2009 18:12
To: Srivathsan, M IN BLR SISL
Subject: Re: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2

Hi Watson,

Check these things:


    Installation on Windows Systems


    PHP 4

The PHP MySQL extension is compiled into PHP.


    PHP 5+

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be
enabled inside of php.ini. Also, PHP needs access to the MySQL client
library. A file named libmysql.dll is included in the Windows PHP
distribution and in order for PHP to talk to MySQL this file needs to be
available to the Windows systems PATH. See the FAQ titled "How do I add
my PHP directory to the PATH on Windows
<http://us3.php.net/manual/en/faq.installation.php#faq.installation.addtopath>"
for information on how to do this. Although copying libmysql.dll to the
Windows system directory also works (because the system directory is by
default in the system's PATH), it's not recommended.

As with enabling any PHP extension (such as php_mysql.dll), the PHP
directive extension_dir
<http://us3.php.net/manual/en/ini.core.php#ini.extension-dir> should be
set to the directory where the PHP extensions are located. See also the
Manual Windows Installation Instructions
<http://us3.php.net/manual/en/install.windows.manual.php>. An example
extension_dir value for PHP 5 is /c:\php\ext/

*Note*: If when starting the web server an error similar to the
following occurs: /"Unable to load dynamic library './php_mysql.dll'"/,
this is because php_mysql.dll and/or libmysql.dll cannot be found by the
system.


Srivathsan, M IN BLR SISL wrote:
> Hi all,
>
> A small correction.  "mysql" and "mysqli" were listed out in the command line output
> for "php -m" but not mentioned anywhere in the "phpinfo();" output.  Is this is a clue?
>
> Thanks and rgds,
> Watson
>
> -----Original Message-----
> From: Srivathsan, M IN BLR SISL [mailto:M.Srivathsan@stripped]
> Sent: Fri, 31-Jul-2009 13:41
> To: Eventum
> Subject: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2
>
> Hi all,
>
> This completely beats me!
>
> A couple of days back, I installed Apache 2.2.11, MySQL 5.1.35 community edition and
> PHP 5.2.10 on a fresh WinXP SP2 machine.  Then I migrated my Eventum application from an
> older machine (with 5.0.51 community edition, Apache 2.2.8 and PHP 5.2.6) to this new one
> - I have already done quite a number of such successful migrations with the DB restored
> properly and I had also changed the <Eventum2.2>/Config/Config.php accordingly.
>
> But now, after the migration (DB + App) and the necessary changes in the Config.php,
> I am getting a Database Error which reads something like "There seems to be a problem
> connecting to the database server specified in your configuration file. Please contact
> your local system administrator for further assistance".  The error message was more
> informative when tried to run the setup (<Eventum2.2>/misc/setup.php) and it said
> something like "The following problems were found: The MySQL extension needs to be enabled
> in your PHP.INI file in order for Eventum to work properly. Please resolve the issues
> described above. For file permission errors, please provide the appropriate permissions to
> the user that the web server run as to write in the directories and files specified
> above".
>
> The above 2nd message is quite confounding as I could see in the phpinfo report that
> both "mysql" and "mysqli" modules were loaded and also the "php_pdo_mysql".  The Error log
> also says the same thing - the entry of which is given below:
> [Fri Jul 31 07:29:08 2009] An error was found on line '70' of script 'E:\Watson's
> Documents\My Website\HeaR-IT-ALPHA\include\class.db_api.php'.
>
> The error message passed to us was:
>
> 'DB Error: extension not found'
>
> A more detailed error message follows:
>
> ' [DB Error: extension not found] ** mysql(mysql)://root:PASSWORD@localhost/hear_it'
>
> A backtrace is available:
>
> E:\Watson's Documents\My Website\HeaR-IT-ALPHA\include\db_access.php:33
>   DB_API->DB_API()
> E:\Watson's Documents\My Website\HeaR-IT-ALPHA\init.php:173
>   include_once((string )'E:\Watson's Documents\My
> Website\HeaR-IT-ALPHA\include\db_access.php')
> E:\Watson's Documents\My Website\HeaR-IT-ALPHA\index.php:31
>   require_once((string )'E:\Watson's Documents\My Website\HeaR-IT-ALPHA\init.php')
>
> Could anyone shed some light?  Is it something to do with MySQL 5.1 or with PHP
> 5.2.10 which is quite new?  Thanks in advance.
>
> Thanks and rgds,
> Watson
>
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.392 / Virus Database: 270.13.36/2272 - Release Date: 07/30/09 05:58:00
>
>

Thread
A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan31 Jul
  • RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan31 Jul
    • Re: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2Bryan Alsdorf31 Jul
RE: A confounding error with MySQL 5.1 and PHP 5.2.10, on WinXP SP2M  IN BLR SISL Srivathsan3 Aug