Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: arflinux on September 21, 2006, 02:37:11 AM

Title: phpMyAdmin 2.8.2 error message
Post by: arflinux on September 21, 2006, 02:37:11 AM

Hi  all,

have install  phpmyadmin_multiuser from sleepy SME
but when i log in https://xxx.xxx.xxx.xxx/myadmin/
i get the following error message error message is the same for firefox and internet explorer

Cookies must be enabled past this point.

Invalid hostname for server 2. Please review your configuration.

Invalid hostname for server 3. Please review your configuration.

can any body tell what is going on and how to fix it

Thanks
Andrew

Title: Re: phpMyAdmin 2.8.2 error message
Post by: william_syd on September 21, 2006, 03:23:29 AM

Quote from: "arflinux"

Cookies must be enabled past this point.

can any body tell what is going on and how to fix it

Thanks
Andrew

I think cookies are your only problem. Do you have them turned off in your browsers or are you running some sort of internet security/anti virus software.

Title: phpMyAdmin 2.8.2 error message
Post by: arflinux on September 21, 2006, 06:10:32 AM

Cookies are turned on

Title: phpMyAdmin 2.8.2 error message
Post by: william_syd on September 21, 2006, 07:04:37 AM

Something here might help....

http://wiki.cihar.com/pma/cookie_login


Oh, any popup blockers installed?

Title: phpMyAdmin 2.8.2 error message
Post by: Teviot on September 21, 2006, 07:48:23 AM

I also have an error with this contrib.  The error I get is

Quote

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I get the same error when using admin as the login

Can somebody point me in the right direction to fix this as I don't know what to do?

Regards
Adrian

Title: phpMyAdmin 2.8.2 error message
Post by: william_syd on September 21, 2006, 08:39:00 AM

This is phpMyAdmin general not SME specific.

phpMyAdmin, at it's simplest best (single user) requires a MySQL user that has all privileges to connect.

So, at the shell,

Code: [Select]

mysql -uroot

now, at the mysql> prompt

Code: [Select]


mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
     > IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
     > quit


Now we add the above user (monty) and password (some_pass) to the phpmyadmin config file - config.inc.php

It maybe located in this directory..
/opt/administration/phpmyadminmulti

The parts to edit are

Code: [Select]

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = '';          // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed

Between the ' ' place config monty some_pass

Code: [Select]

$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'monty';          // MySQL user
$cfg['Servers'][$i]['password']      = 'some_pass';          // MySQL password (only needed

Save and now go to your phpmysql url.

It is now setup in the most basic way.

Now that it working, create another user that only you know.

Exit out and edit config.inc.php to how it's shown below. cookie blank blank

Code: [Select]

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = '';          // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed

Also, ensure this line is at the top somewhere...

Code: [Select]

$cfg['blowfish_secret'] = 'xf5g4+6x4g6n4x+fg4n+x4+9n-xg-h*-+-*-*+89gx-+8n-xgh-+x8-gd-xdg4n+-xgx7*g+-nx-g7n+';
Save and exit and return to your pma url.
Now login as the user you just created and delete the monty dude :)

You should now have something looking like this..
My phpMyAdmin (http://secure.magicwilly.info:8181/phpMyAdmin/)

Title: Re: phpMyAdmin 2.8.2 error message
Post by: william_syd on September 29, 2006, 11:13:40 AM

Quote from: "arflinux"

Hi  all,

have install  phpmyadmin_multiuser from sleepy SME
but when i log in https://xxx.xxx.xxx.xxx/myadmin/
i get the following error message error message is the same for firefox and internet explorer

Cookies must be enabled past this point.

Invalid hostname for server 2. Please review your configuration.

Invalid hostname for server 3. Please review your configuration.

can any body tell what is going on and how to fix it

Thanks
Andrew

There is no problem. Just login as admin/admin I just revisited that rpm.