phpmyadmin problem

[bootneck]

Been trying to get this working for 4 days now with limited success,

As in one of the post I have read on phpmyadmin when I go to http://127.0.0.1/phpmyadmin all I get is a directory list. I have tried adding index.php to that and now only 404 error. I have followed 3 different tutorials and still can,t get the thing to work.

I know php is working under the server as I can get the PHP admin pages

any suggestions please as I am on the verge of giving up, I have even uninstalled and re installed php5, mysql5 and phpmyadmin. I know I could try ver 4 of the software but it seems a backwards step.

Thanks in advance,, old aged newbie

[pkSML]

What happens if you click on index.php from the directory listing?
_________________
Stephen
Need a LitlURL?

http://CodeBin.yi.org

[bootneck]

Hi

Its not shown in the directory listing

I have
check_lang.php
convertcfg.pl
create-release.sh
creat_tables_mysql

and several other in the same vain

[pkSML]

Forgive me for sounding dumb, but is there an index.php file in the folder?!?
_________________
Stephen
Need a LitlURL?

http://CodeBin.yi.org

[bootneck]

sorry I should have said, no .

I have clicked on setup php in the folder and get a phpmyadmin 2.9.1.1 setup page

witht the errors connot load or save configuration files, please create webserver writable folder in config phpmyadmin top level dir

[Moxxnixx]

phpMyAdmin should have come with an index.php.
Please re-download from phpmyadmin.net.

[pkSML]

That sounds pretty self-explanatory. :)

If you're running Windows, this is really strange.
However, if you're running *nix, you need to chmod your phpmyadmin dir to allow writing files.
_________________
Stephen
Need a LitlURL?

http://CodeBin.yi.org

[bootneck]

Running windows xp. If I got to the dir the index file is there , but when I go there with the browser to start phpmyadmin its not.

Looks like I will just delete the lot and start again

Thanks for your replies all

[AbyssUnderground]

Visit www.abyssunderground.co.uk/tutorials.php and follow those. You will be up and running in no time.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk

[bootneck]

Thanks for that , I did follow your tutorial php working, mysql working, abyss working all with your tutorials, I just can,t get phpmyadmin working

[AbyssUnderground]

The phpMyAdmin tutorial works. You need to follow it exactly. Use one of the download links provided and use that version.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk

[bootneck]

Hi I am sorry about this I have followed the tutorials but still cannot past phpadmin displaying as just a directory listing. I am now trying to set it up going down a slightly different route, by using the phpmyadmin set up web interface screen. this seems to configure OK, however as soon as I go back to httP://127.0.0.1/phpmyadmin all I get is the directory listing again, with set up and no index file. I know I am being a little bit dense somewhere along the line, but these pages are my only help as I live on a remote Scottish island, so no one else to ask or take a look at the code.

Thanks

Lee

[AbyssUnderground]

If it is not working you have not followed the tutorial correctly. Hundreds of people have followed it and it has worked for them. Follow it again WORD FOR WORD following the diagrams. If at any point you dont see on your screen the same as in the diagram, go back and find out why. It will only be your mistake, not the tutorials.

Add me on msn if you wish.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk

[bootneck]

Hi Thanks for that and yep I know your tutorials are good and I am following them, I know I must be making a mistake somewhere I just can,t find out where. I have deleted and re installed phpmyadmin 4 times and as far as I can tell followed the tutorial. Its not difficult to follow, well it might be for me as I don,t seem to get the right out come. I know php is working as I have checked with the info page
mysql is working as I have logged in using the command line interface.

getting to the stage where I have down loaded 2 other php admin interfaces to see if I make the same mistake on them.

I must nearly be there getting the index page but displayed as a directory.

I will struggle on It will work eventually

thanks again

[Moxxnixx]

bootneck,
Can you post a screenshot of this directory listing?

[bootneck]

Yes I will get on copped over asp, thanks

I have deleted phpmyadmin again and down loaded the version used by abyssunderground,, and I am still getting the same error, ie the index page as a directory.

[AbyssUnderground]

[bootneck]

Hi Here is the copy of my config.inc file,



Mod Edit: Please don't post config files that long as it makes the forum look untidy. If its needed we will ask for it and you can e-mail it. Thanks.

[AbyssUnderground]

[bootneck]

Hi sorry I was asked to post it by one of the replies above, how much of the config file can I post please. I am completly new to php ect

[bootneck]

Hi yes I went back into Aybss config and deleted and re entered all the data

[bootneck]

Hi is this ok cut out all the rest of the stuff :oops:




$cfg['PmaAbsoluteUri'] = 'http://127.0.0.1/phpmyadmin/';

/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;

/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/
$cfg['blowfish_secret'] = '***';

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).

Mod Notice: Please edit existing posts if yours is the last post instead of posting a new one. Thanks.

[AbyssUnderground]

[bootneck]

Many thanks I will do it again , word for word now

[AbyssUnderground]

[bootneck]

I have followed the tutorial word for word each time. I know its not your tutorial at fault as you say its been followed hundreds of times. I have deleted all my phpmyadmin files and reinstalled with the ver form the link on your site. I have again followed the tutorial word for word and am still only getting the dir listing displayed in IE. if I browse and try and open the index.php the config.inc opens in word pad.

I am honestly not thick, I have followed everything word for word as you can see in the config.inc above. I have renamed the folder in the for phpmyadmin.. to just phpmyadmin. I have copied the config.default.inc up into the htdocs folder. I have edited it there using, word pad. saved it to the same file. I then browse with my browser to http://127.0.0.1/phpmyadmin and I get the directory listing.
INDEX of phpmyadmin/

followed by
../
check_lang.php
convercfg.pl
create-release.sh
create_tables.sql
create_tables_mysql 4 1 2 +.sql
decode_bug.php
find_unused_messages.sh
remove_control_m.sh
setup.php ( I can run this which gives me a limited graphic interface.)
upgrade.pl
upgrade_tables_mysql 4 1 2+.sql.
under this I have the normal powered by abyss web server x 2

I know mysql is running as I can create databases by the command line interface and have done so.
I know php is running as I have tested a php page.

The PC server is not wired into the network or Internet as yet as I thought It would be easier to work on it next to me than sat in the loft.

Many many thanks for your help, but this thing is just getting on top of me as it looks and seems so simple to set up and I can,t get it to work :(

[Moxxnixx]

Those are NOT the contents of phpmyadmin.
They are the contents of phpmyadmin/scripts.

You have setup phpmyadmin alias to the wrong directory in your console.

[bootneck]

Many thanks for that , I am getting some where, even if it to an error page
phpmyadmin -error
cannot load extension. please check php configuration. I have read about this error some where on the web and now Reading the documentation.

Thank you very much moxxnixx and thanks aybssunderground for you help and great tutorials.

Have ordered a few php, msql books of amozon to read a little deeper, so I might not have to be such a pain in future.

ah found it on abyssunderground faq,, thanks again :)

[Moxxnixx]

Phew! It usually is something simple that is overlooked.
Glad you finally got it working. ;)

[Marty]

[bootneck]

Hi Marty, thanks for the reply, I have checked the mb string.dll its ok

what I am getting is cannot load mysql extension, I have checked in the php.ini that it has the semi colon removed as per the FAQ on abyss-underground also the extension_dir = "ext" which was set to c:/PHP/ext but now changed to just "ext"

first of my book arrived today php for dummies which seems to fit me very well at the moment

Added later same day

I found this on a web site, before I give it a go any comments
I searched the solution to the problem all over and all did not work. Now finally I found the correct answer.

1. Get ZIPPED version of PHP for windows from www.php.net
2. Extract the contents.
3. Find php_mysql.dll in EXT folder.
4. Copy and paste it in C:WINNT/SYSTEM32
5. Modify php.ini in C:WINNT as below.

extension_dir = "C:\WINNT\SYSTEM32"
extension=php_mysql.dll

nope nothin only the same fault

I also tried this from the My SQL site forums
I have discovered how to fix this.
You need to have the libmysql.dll and php_mysql.dll/mysql.so.
Go into the windows control panel and find system, open it and click advanced.
Now click Environment Variables.

Now for the part you need to do:
Click 'new' under system variables, the name of it is
PHPRC
The value is where you installed php, for example, I installed it into C:\PHP, so the value was
C:\PHP

NO joy just the same error page

[aprelium]

bootneck,

We strongly suggest that you install and use the preconfigured PHP5 package available from http://www.aprelium.com/abyssws/php5win.html . It has all the extensions required by PhpMyAdmin enabled by default.
_________________
Support Team
Aprelium - http://www.aprelium.com

[bootneck]

Hi thanks for that, I think I will take that route, though i was eager to find out where I had gone wrong on my instal.

[Tom Chapman]

It's great to see that you got it working with help from fellow communers. I was going to ask if you had even created a configuartion file see as though as far as I could see you hadn't. You have obviously!

May I also add that the blue mod text is becoming somewhat common! lol It's great too see. ^.^

[AbyssUnderground]

[bootneck]

Many many thanks to all who helped me with this all is now working

php 520
MySql 5
myphpadmin

Now for phpbb :)

[AbyssUnderground]

[bootneck]

Thanks all again,,

I have everything working

php 5
mysql5
phpmyadmin
and phpbbs thanks to abyssundergrounds great tutorials

Thanks