We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
phpMyAdmin -Storage is not complete+ controluser failed Erro
phpMyAdmin -Storage is not complete+ controluser failed Erro
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
kindly assist me how to get this issue resolve.
Thank You
Sion
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.
Thank You
Sion
Re: phpMyAdmin -Storage is not complete+ controluser failed
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
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
Thank Skurudo for Your help. but I'm confused on point number 3skurudo 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
i.e
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 command3) Import in phpMyAdmin -- create_tables.sql.gz
Code: Select all
mysql -u username -p database < /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz
Thanks brother for help. :-)
-
- Posts: 2
- Joined: Fri Nov 20, 2015 11:55 pm
Re: phpMyAdmin -Storage is not complete+ controluser failed Erro
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):
Save and close the file.
Log out of phpMyAdmin
Log in again
Problem solved.
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';
Log out of phpMyAdmin
Log in again
Problem solved.
-
- Posts: 139
- Joined: Thu Jan 07, 2016 12:01 am
Re: phpMyAdmin -Storage is not complete+ controluser failed Erro
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.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):
Save and close the file.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';
Log out of phpMyAdmin
Log in again
Problem solved.
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
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
Autofix for functions and controluser:
viewtopic.php?f=14&t=10307
viewtopic.php?f=14&t=10307