Page 1 of 1
phpMyAdmin -Storage is not complete+ controluser failed Erro
Posted: Fri Nov 13, 2015 8:31 am
by 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
Re: phpMyAdmin -Storage is not complete+ controluser failed
Posted: Fri Nov 13, 2015 11:13 am
by 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
Re: phpMyAdmin -Storage is not complete+ controluser failed
Posted: Mon Nov 16, 2015 5:41 pm
by sionandes
skurudo wrote: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. :-)
Re: phpMyAdmin -Storage is not complete+ controluser failed Erro
Posted: Sun Nov 22, 2015 5:07 pm
by 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.
Re: phpMyAdmin -Storage is not complete+ controluser failed Erro
Posted: Wed Jan 13, 2016 12:58 pm
by BBuchanan1013
kerfiseining wrote: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
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
Re: phpMyAdmin -Storage is not complete+ controluser failed Erro
Posted: Fri Jan 15, 2016 8:15 pm
by skurudo
Autofix for functions and controluser:
viewtopic.php?f=14&t=10307
