[SOLVED] installation not going so well

[onefootswill]

For reasons unknown, I cannot get the mysqli libraries enabled in php on my laptop. When I load a page that call phpinfo(), MySQL and MySQLi are not listed at all.

 

Some details

OS - XP

PHP version - 5.2.5

MySQL version - 5.0.45

Apache version - 2.2.6

 

What Is Working

Apache is up and running fine. I can view a php page which calls phpinfo()

MySQL  is up and running fine. I can access my databases with no problems.

 

What I have tried

I have modified php.ini in the following ways:

• I have uncommented the following extensions:
  extension=php_gd2.dll
  extension=php_mbstring.dll
  extension=php_mysql.dll
  extension=php_mysqli.dll
  extension=php_pdo.dll
  extension=php_pdo_mysql.dll
  extension=php_pdo_sqlite.dll
  extension=php_pdo_sqlite_external.dll
  
• I have made the extensions directory "C:\php\ext\" (also tried it without the trailing slash)
  
• The info page is showing that the ini file at C:\php\php.ini is being loaded
  

I have restarted apache and the laptop itself several times.

 

If anyone can help me solve this, I would be very grateful.

 

Cheers

 

 

[PFMaBiSmAd]

Add c:\php to the Windows PATH statement so that the auxiliary dll that mysql/mysqli needs can be found. Reboot (or log off/log on) to get any changes made to the Windows PATH statement to take effect.

[onefootswill]

I should have mentioned that. I had added C:\php to the windows path.

 

I also made sure that there was no existing php.ini file in C:\WINDOWS or C:\WINDOWS\system32 . But that was a moot point really, because it is definitely loading the php.ini in C:\php.

 

I also grabbed the native php connectors from the MySQL site. Made no difference.

[4daysilnevergetback]

If you were using Linux I could help you out. But I can give you an easy out.

Doing anything with XP and your asking for problems but.. this might be a quick solution for you or maybe you already know about this.

 

It's called Xampp

 

www.apachefriends.org/en/xampp.html

 

It's sorta a all in one and I have never had anyone comeback to me with issues.

 

I recommend it to all my customers who choose to use a windows based OS.

 

But if your doing it to learn then this may not be what your looking for but is still a good example to learn from. Super easy to install, Super easy to manage and contains the following...

 

XAMPP for Windows

The distribution for Windows 98, NT, 2000, 2003, XP and Vista. This version contains: Apache, MySQL, PHP + PEAR, Perl, mod_php, mod_perl, mod_ssl, OpenSSL, phpMyAdmin, Webalizer, Mercury Mail Transport System for Win32 and NetWare Systems v3.32, Ming, JpGraph, FileZilla FTP Server, mcrypt, eAccelerator, SQLite, and WEB-DAV + mod_auth_mysql.

 

 

 

 

[onefootswill]

Hi there. I am aware of xampp. It is my preference to get this running without the need for the xampp package. I've done it heaps of times on my other PC. But my laptop is just not playing ball.

 

Also, I am a huge Linux fan. If my university was not so Microsoft-centric, I'd be running a desktop Linux distro for sure. In fact, when I finish up this year, I'm planning to run a distro with the new KDE 4 (probably openSuse). KDE 4 is awesome!!!

[PFMaBiSmAd]

A couple of things you have not told us is if the various extension .dll's are actually in the ext folder (what php package did you download?) and if the libmysql.dll is in the php folder.

 

Check your web server log file for errors to see what problem is being reported.

[onefootswill]

I have solved the problem.

 

The spanner in the works was the fact that I tried on a shortcut whereby I copied across the httpd.conf file from my other computer. This worked fine to get a server up and running and with php generally, but apparently not with MySQL.

 

After I restored the httpd.conf file that was installed with this instance of Apache, and hand-made all of the required configuration changes again, phpinfo() suddenly enabled the mysql stuff.

 

So, a bit of a learning experience there. Whilst you can probably copy across a php.ini file without any hassles, you need to work with the Apache httpd.conf that is installed.

 

Sorry if I wasted anyone's time on this. It was a long road of trouble-shooting before I posted here.