phpMyAdmin -Storage is not complete+ controluser failed Erro

[sionandes]

Hello friends,

I'm trying out new Vestacp on New VPS to see if all goes well with it or not.

So first install the Debian Wheezy (7.9) on VPS and tried to test it. and I found these errors on both Debian Wheezy (7.9) & Debian 8 Jessie, which I installed due to this problem but the issue is same..

here You can see the Dropbox Screenshot:

https://www.dropbox.com/s/t192gmmgngbfg ... -Issue.PNG

Code: Select all

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

Code: Select all

Connection for controluser as defined in your configuration failed.

kindly assist me how to get this issue resolve.

Thank You
Sion

[skurudo]

1) look at /usr/share/doc/phpmyadmin/examples
2) gunzip config.sample.inc.php.gz & mv ./config.sample.inc.php /etc/phpmyadmin/config.inc.php
3) import in phpmyadmin -- create_tables.sql.gz
4) uncomment advanced features

[sionandes]

1) look at /usr/share/doc/phpmyadmin/examples
2) gunzip config.sample.inc.php.gz & mv ./config.sample.inc.php /etc/phpmyadmin/config.inc.php
3) import in phpmyadmin -- create_tables.sql.gz
4) uncomment advanced features

Thank Skurudo for Your help. but I'm confused on point number 3
i.e

3) Import in phpMyAdmin -- create_tables.sql.gz

How to import it ? I can see in /usr/share/doc/phpmyadmin/examples there is a file create_tables.sql.gz So You mean to import this file via command by using this command

Code: Select all

mysql -u username -p database < /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz

if I'm going right then, will You please tell me brother here which username and database to use ? or if I'm wrong please advise me what does here means by Import in phpmyadmin -- create_tables.sql.gz

Thanks brother for help. :-)

[kerfiseining]

http://stackoverflow.com/questions/1150 ... myadmin-xa

1. Open phpMyAdmin in a browser and log in as root.

2. Create a database called phpmyadmin

3. Create a user called pma and set the "host" to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full control over the phpmyadmin database. It is recommended that this user does not have access to anything other than this database.

4. Go to the phpMyAdmin installation directory, where you should find a sub-directory called examples.

5. In examples you will find a file called create_tables.sql. Open it in a text editor.

6. In phpMyAdmin, select the phpmyadmin database and click on the "SQL" tab.

7. Copy/paste the entire text from create_tables.sql into the text box, and run the query.

8. Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):

Code: Select all

$cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][1]['controluser'] = 'pma';
$cfg['Servers'][1]['controlpass'] = '<your password>';

$cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][1]['relation'] = 'pma_relation';
$cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][1]['table_info'] = 'pma_table_info';
$cfg['Servers'][1]['column_info'] = 'pma_column_info';
$cfg['Servers'][1]['history'] = 'pma_history';
$cfg['Servers'][1]['recent'] = 'pma_recent';
$cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][1]['tracking'] = 'pma_tracking';
$cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';

Save and close the file.

Log out of phpMyAdmin
Log in again
Problem solved.

[BBuchanan1013]

http://stackoverflow.com/questions/1150 ... myadmin-xa

1. Open phpMyAdmin in a browser and log in as root.

2. Create a database called phpmyadmin

3. Create a user called pma and set the "host" to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full control over the phpmyadmin database. It is recommended that this user does not have access to anything other than this database.

4. Go to the phpMyAdmin installation directory, where you should find a sub-directory called examples.

5. In examples you will find a file called create_tables.sql. Open it in a text editor.

6. In phpMyAdmin, select the phpmyadmin database and click on the "SQL" tab.

7. Copy/paste the entire text from create_tables.sql into the text box, and run the query.

8. Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):

Code: Select all

$cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][1]['controluser'] = 'pma';
$cfg['Servers'][1]['controlpass'] = '<your password>';

$cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][1]['relation'] = 'pma_relation';
$cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][1]['table_info'] = 'pma_table_info';
$cfg['Servers'][1]['column_info'] = 'pma_column_info';
$cfg['Servers'][1]['history'] = 'pma_history';
$cfg['Servers'][1]['recent'] = 'pma_recent';
$cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][1]['tracking'] = 'pma_tracking';
$cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';

Save and close the file.

Log out of phpMyAdmin
Log in again
Problem solved.

Though for some this is a good start, I found that some of this didn't pertain. Like I couldn't find t he create_tables.sql.gz or anything in the examples.

I did manage to fix my control user stuff:
1. Login to phpmyadmin
2. create the phpmyadmin database
3. create the pma user
4. select the phpmyadmin database and grant all for pma user only

This is where I got stuck because of no sql file....thankfully, there's a repository on github: https://github.com/phpmyadmin/phpmyadmi ... tables.sql
5. Copied the sql into the tab SQL
6. Hit go
7. Changed the info in

Code: Select all

/etc/phpMyAdmin/config.inc.php

8. Logged out and Logged in to phpmyadmin
9. Noticed the info at the bottom stating that it wasn't completely setup
10. Click on the phpmyadmin database
11. Clicked on Operations
12. Clicked on create
13. Done

[skurudo]

Autofix for functions and controluser:
viewtopic.php?f=14&t=10307