phpMyAdmin installtion problem

raport

dear friends,

i installed phpMyAdmin-2.6.4-pli in redhat 9. prior to its installation i installed mysql 4.1.14, apache2 and php5.05. i followed the instructions in the phpmyadmin documentations. But when i tried to open the file in the browser http://localhost/<path_to_phpmyadmindir>/index.php nothing is displayed by my browser-mozilla, until it timed out.

i changed $cfg['OBGZip'] directive to FALSE in the phpMyAdmin configuration file as suggested in the documentation but the problem persists.

have you encountered similar problem?

thanks for any suggestion.

raport

Doug_G

Is your mysql server running properly using the included mysql client programs?

Is your apache & php working properly for other html & php pages?

<edit>Remove some windows ideas after re-reading the question </edit>

raport

yes because i already created a database using mysql . the mysql rpm files i installed are client, devel, shared and server all mysql-4.1.14.0-.i386. i use the /etc/init.d/mysql start| at root because it won't kick if not in root it posts an error.

with regards tp php and apache i think its okay, because when i make the <?php phpinfo(); ?> php page which i placed in the document root , info on php and related configuration including apache and mysql is present in the browser.

i tried some database tutorial using text editor same problem occured when connecting to mysql. the browser timed out posting " connection timed out cannot connect to www.localhost.com" something like this . however when i use the terminal to check the mysql database, i saw the table created by php present in the database.

i hope i'm not complicating the problem.

thanks for any help.

raport

Doug_G

I guess double-check your phpmyadmin config file and make sure you've used the proper database user/password to connect.

Also you might want to get a tool like MySQL Administrator and use it to verify you can connect to the database.

raport

installed mysql adminstrator using mysql-administrator-1.0.22a-linux.tar.gz. if followed the instructions as follows:
tar --directory=/opt -xzvf mysql-administrator-version-linux.tar.gz
This installs the application binary in /opt/mysql-administrator/bin. Change into that directory and run mysql-administrator to start the application.

after i run the mysql-admintrator i got this error:

./mysql-administrator-bin: /lib/libgcc_s.so.1: version `GCC_3.3' not found (required by ./mysql-administrator-bin)

i tried also to install the rpm package of the mysql-administrator but i got this error:

error: mysql-administrator-1.0.22a-1.rh9.i386.rpm: MD5 digest: BAD Expected(f47864c07f3d8b8240872f5d21203287) != (f057e77b61934d37d477b2ed349ab1f8)

thanks for any help.

Doug_G

Well, that didn't go too well did it 🙂 RH9 is getting a bit old, perhaps MySQLA doesn't run so well on it.

Can you connect to your database server using the cli mysql program?

I use the included mysql/apache/php that comes with Fedora Core 4 without any problems like you're having. Maybe you're having some kind of firewall issue, you could try turning off your firewall for testing purposes.

Since phpinfo(); works I'm suspecting something in the mysql area is your problem.

nickadeemus2002

http://localhost/<path_to_phpmyadmindir>/index.php

excuse my ignorance here, but is 'index.php' a valid phpMyAdmin page to work with mysql databases? did you have to customize the settings to get an 'index.php' page? i've always used "http://localhost (or remote host)/phpMyAdmin/" to bring up the main page and have never had problems.

Doug_G

nickadeemus2002 wrote:
excuse my ignorance here, but is 'index.php' a valid phpMyAdmin page to work with mysql databases? did you have to customize the settings to get an 'index.php' page? i've always used "http://localhost (or remote host)/phpMyAdmin/" to bring up the main page and have never had problems.

index.php is the start page for phpMyAdmin. Most web servers will use index.php as a default document when you don't specify a page in your url. So you are going to index.php anyway.

raport

i tried to work around. i did already installed mysql administrator and mysql query browser after i replaced it with new download. likewise is successfully opened the database viewing its contents using mysql administrator and query browser.

moreso previously i already created a database using mysql in redhat 9. the mysql rpm files i installed are client, devel, shared and server all mysql-4.1.14.0-.i386. i use the /etc/init.d/mysql start| at root because it won't kick if not in root it posts an error.

with regards to php and apache i think its okay, because when i make the <?php phpinfo(); ?> php page which i placed in the document root , info on php and related configuration including apache and mysql is present in the browser.

i tried some database tutorial using text editor same problem occured when connecting to mysql. the browser timed out posting " "The operation timed out when attempting to contact www.localhost.com. " however when i use the terminal to check the mysql database, i saw the table created by php present in the database.

the codes i used are:

<?
$user="root";
$password="password";
$database="bedrock";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts1 (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";

mysql_query($query);
$query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','johnsmith@gowansnet.com','http://www.gowansnet.com')";
mysql_query($query);
mysql_close();
?>

why is it that the browser is looking for www.localhost.com not localhost?

thanks for any help.

raport

dear friends,

i simplified the matter by reinstalling my redhat9 and used all the package it offers for mysql, apache and php.
and that solved the problem. later, i'll just migrate to newer versions if needed.

thanks for your concern.