Hi

Apologies if this is not in the appropriate category and it relates mostly to MySQL and phpMyAdmin together....

Before I start, let me say that I have already installed XOOPS successfully, and previously installed and ran phpMyAdmin.

I recently recovered from a rather serious XOOPS system failure, and suffice to say I had to flush the root privilages of the MySQL server etc to get it back on line. It now works again.

Anyway, when I went to my phpMyAdmin folder (which worked fine before the crash) I got blank screens or 'No Input File Specified' if I addressed a specific file like install.php. The latter I'd had before and it related to my IIS configuration and permissions, but seeing as XOOPS works fine now I fail to see how it could be that.

I read the phpMyAdmin docs as well as various other forums and they suggested ensuring that permissions were set for IUSER_[MACHINE] which they were. It went on ....

Change OBGZipdirective to FALSE in the phpMyAdmin configuartion file. Did that.

Changed the reference to 'localhost' to our specific domain and the phpMyAdmin path (http://fct.local/phpmyadmin/. Did that.

Changed the cgi.force_pathname value to 1 instead 0. Did that.

Tried typing in the browser :

http://fct.local/phpmyadmin/
http://fct.local/phpmyadmin
http://fct.local/phpmyadmin/install
http://fct.local/phpmyadmin/install.php
http://fct.local/phpmyadmin/index
http://fct.local/phpmyadmin/index.php


All of this, and it still doesn't work! Even though before I just copied it to the folder and navigated to it, and it worked brilliantly. I just don't get it.

There is some light however. When I downloaded and installed the XOOPS Modular version that works a treat, but only for the XOOPS database. I want phpMyAdmin to maintain the whole of MySQL on our server. So why does the XOOPS module work, but the main one doesn't? Bizarre.

Versions :
IIS6
Windows 2003 Server
php 4.3.6
phpMyAdmin 2.5.7 (Global Version - unsure what XOOPS module is but got to it from www.iis-resources.com in the dowloads section)
MySQL 4.0.20
Xoops 2.0.6

Any ideas what may be causing this? I would like global database control using phpMyAdmin

What happens if you create and run a simple test file within the phpmyadmin directory? For example:

phpinfo.php



Or here's another one that tries to connect to the MySQL server:

connect.php



You would replace DBHOST, DBUSER and DBPW with the appropriate values.

<?php phpinfo() ?>
displays the php configuration page as it should

The database file says that it Connected Successfully, but follows with a PHP Notice :

"Use of undefined constant host - Assumed 'localhost', Use of undefined constant 'root' - assumed 'root', etc.

In other words, I think both are OK?

It sounds like both are ok. That notice probably means you didn't quote those strings.

I don't know how to solve the original problem. I just wanted to eliminate a couple of possibilities.

Its a mystery indeed. Well thanks for your help anyway. If anyone happens to know the answer please can you e-mail me at tedsmith28@yahoo.co.uk. Thanks