[gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Joseph]

I have this strange problem with phpmyadmin, error:
The phpMyAdmin configuration storage is not completely configured, some extended features 
have been deactivated. To find out why click here.

I solve it in the past by generating phpmyadmin database and controluser, instruction in 
this link:
http://www.phpfreaks.com/forums/index.php?topic=335580.0

Though I'm going through this procedure again and it doesn't work.

my config.ing.php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */

$cfg['blowfish_secret'] = '4ee6286bdb41d1.96573143';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;

/* configuration storage */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass'] = 'xxxxxxxxxxxx';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

-- 
Joseph

Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Michael Hampicke]

Does the mysql user 'phpmyadmin' exist, and does he have access to the
mysql database 'phpmyadmin'? Have you tried connection manually to the
phpmyadmin db?

Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Paul Hartman]

On Mon, Dec 12, 2011 at 11:05 AM, Joseph <syscon780@gmail.com> wrote:
> I have this strange problem with phpmyadmin, error:
> The phpMyAdmin configuration storage is not completely configured, some
> extended features have been deactivated. To find out why click here.
>
> I solve it in the past by generating phpmyadmin database and controluser,
> instruction in this link:
> http://www.phpfreaks.com/forums/index.php?topic=335580.0
>
> Though I'm going through this procedure again and it doesn't work.

There is a script create_tables.sql to create all of the additional
tables that it's complaining about. On my system it is located in
/usr/share/webapps/phpmyadmin/3.4.7/htdocs/scripts

Also be sure that if you're upgraded MySQL/MariaDB to run the upgrade
script otherwise it can have weird permissions errors.

And of course test that the phpmyadmin user can actually login and has
been granted the appropriate access to those tables.

Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Joseph]

On 12/12/11 18:10, Michael Hampicke wrote:
>Does the mysql user 'phpmyadmin' exist, and does he have access to the
>mysql database 'phpmyadmin'? Have you tried connection manually to the
>phpmyadmin db?
>

Yes, user phpmyadmin exists but when I try to connect to database I get error:
mysql -u phpmyadmin -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'phpmyadmin'@'localhost'

When I delete the generated hash from controlpass in config.ini.php I get an error message on web interface
that control user can not connect etc.
When I put the password back that error message disappears so I assume the password is correct. 
However, I can still not connect as -u phpmyadmin -p 

-- 
Joseph

Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Joseph]

On 12/12/11 11:17, Paul Hartman wrote:
>On Mon, Dec 12, 2011 at 11:05 AM, Joseph <syscon780@gmail.com> wrote:
>> I have this strange problem with phpmyadmin, error:
>> The phpMyAdmin configuration storage is not completely configured, some
>> extended features have been deactivated. To find out why click here.
>>
>> I solve it in the past by generating phpmyadmin database and controluser,
>> instruction in this link:
>> http://www.phpfreaks.com/forums/index.php?topic=335580.0
>>
>> Though I'm going through this procedure again and it doesn't work.
>
>There is a script create_tables.sql to create all of the additional
>tables that it's complaining about. On my system it is located in
>/usr/share/webapps/phpmyadmin/3.4.7/htdocs/scripts
>
>Also be sure that if you're upgraded MySQL/MariaDB to run the upgrade
>script otherwise it can have weird permissions errors.
>
>And of course test that the phpmyadmin user can actually login and has
>been granted the appropriate access to those tables.

The whole process worked. 
The trick is to Log OUT/IN in order to take effect :-/

-- 
Joseph

Re: [gentoo-user] The phpMyAdmin configuration storage is not completely configured,

[Michael Hampicke]

> mysql -u phpmyadmin -p
> Enter password: ERROR 1045 (28000): Access denied for user
> 'phpmyadmin'@'localhost'

The ting about mysql is, that it's not enough to just create a user and
give him a password. you also have to grant this user access to the
database you wish to connect to.
Last thing is: you also have to set the hosts from this user may be
allowed to access the database, in your case I guess that would be
'localhost'