Extended Features Deactivated

[kendall7858]

Hi:

I just installed the latest Xampp version from the Apache.org website. The version is Xampp-Win32-1.8.3-4-VC-11. This is the error message I get at the Xampp myadmin interface.
At the bottom of the page it reads " The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here".
When I click on the prompt it says:

"$cfg['Servers'][$i]['users'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ]
Configurable menus: Disabled

$cfg['Servers'][$i]['navigationhiding'] ... not OK [ Documentation ]
Hide/show navigation items: Disabled


Quick steps to setup advanced features:

Create the needed tables with the examples/create_tables.sql. Documentation
Create a pma user and give access to these tables. Documentation
Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation
Re-login to phpMyAdmin to load the updated configuration file."

Now I really need help with this. I know that it says to create the needed tables, etc. but I don't know enough about the software to follow these instructions. How do you create the pma user and give access to the tables? How do you enable the advanced features in the file (config.inc.php)? I mean I can read the instructions but I am so new to the software that I don't know how to do this. Could someone please walk me through this? I would really appreciate any help. I have researched this and I have tried may things. I just don't know the correct procedure to import the files. I can find all the files mentioned and I know how to text edit them with notepad++. However, I don't know enough to about the phpmyadmin to do what is required to do. Again, please help with this.

Kendall

[JJ_Tagy]

If you don't know how to create users or grant them access or run SQL files provided, I doubt you will be concerned with using the advanced features of phpmyadmin. If those aren't configured, it will be ok in your test environment to ignore those messages.

[kendall7858]

Hi All:

I want to sound the trumpets, PRAISE BE TO GOD!

I continually had the following error message upon installing Xampp-Win32-1.8.3-4-VC-11.

$cfg['Servers'][$i]['users'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ]
Configurable menus: Disabled

$cfg['Servers'][$i]['navigationhiding'] ... not OK [ Documentation ]
Hide/show navigation items: Disabled


Quick steps to setup advanced features:

Create the needed tables with the examples/create_tables.sql. Documentation
Create a pma user and give access to these tables. Documentation
Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php. Documentation
Re-login to phpMyAdmin to load the updated configuration file.

I am the type that cannot stand errors. I guess it is a habit. However, I searched high and low for an answer and I found it. The problem lies in the config.inc.php file in phpmyadmin. There is a bit of code missing that configures the tables used in the root/localhost directory. I inserted the following bit of code before the end of the file and it now runs true. If anyone can benefit from this it will make your day. I know it made mine. This needs to be inserted before the end of the file:

/*
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found <<<----------------- Disable warning messages!
*/
$cfg['PmaNoRelation_DisableWarning'] = true;





/*
* phpMyAdmin configuration storage settings. <<<----------------------- Disable all storage features!
*/
//$cfg['Servers'][$i]['controlhost'] = 'localhost';


// MySQL control user settings (this user must have read-only
// access to the "mysql/user" and "mysql/db" tables).
// The controluser is also used for all relational features (pmadb)
//$cfg['Servers'][$i]['controluser'] = '';


// The password needed for the controluser to login
// (see $cfg['Servers'][$i]['controluser'])
//$cfg['Servers'][$i]['controlpass'] = '';


// Database used for Relation, Bookmark and PDF Features
// (see _docdir/examples/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';


// Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
//$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';


// table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
//$cfg['Servers'][$i]['relation'] = 'pma__relation';


// table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
//$cfg['Servers'][$i]['table_info'] = 'pma__table_info';


// table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
//$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';


// table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'pma_pdf_pages'
//$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';


// table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
//$cfg['Servers'][$i]['column_info'] = 'pma__column_info';


// table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
//$cfg['Servers'][$i]['history'] = 'pma__history';


// Table to store user interface enhancement data.
// - Leave blank to disable.
// DEFAULT: 'pma_table_uiprefs'
//$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';


// Table to store version/change tracking data
// - leave blank to disable
// DEFAULT: 'pma_tracking'
//$cfg['Servers'][$i]['tracking'] = 'pma__tracking';


// Table in which to store information for the designer feature.
// DEFAULT: 'pma_designer_coords'
//$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';


// Table to store user preferences -- allows users to set most
// preferences by themselves and store them in the phpMyAdmin
// configuration storage database.
// If you don't allow for storing preferences in pmadb, users can
// still personalize phpMyAdmin, but settings will be saved in
// browser's local storage, or, it is is unavailable, until the end
// of session.
// DEFAULT: 'pma_userconfig'
//$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';


// Table to store a list of recently used tables to be shown in the
// left navigation frame. It helps you to jump across table directly,
// without the need to select the database, and then select the table.
// Using $cfg['LeftRecentTable'] you can configure the maximum number
// of recent tables shown.
// Without configuring the storage, you can still access the recently
// used tables, but it will disappear after you logout.
// DEFAULT: 'pma_recent'
//$cfg['Servers'][$i]['recent'] = 'pma__recent';


// You can create different user groups with menu items attached to them.
// Users can be assigned to these groups and the logged in user
// would only see menu items configured to the usergroup he is assigned to.
// To do this it needs two tables “usergroups” (storing allowed menu items for each user group)
// and “users” (storing users and their assignments to user groups).
// DEFAULT: 'pma_users'
// DEFAULT: 'pma_usergroups'
//$cfg['Servers'][$i]['users'] = 'pma__users';
//$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';


// You can hide/show items in the navigation tree.
// DEFAULT: 'pma_navigationhiding'
//$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';


/* Contrib / Swekey authentication */
// The name of the file containing Swekey ids and login names for
// hardware authentication. Leave the string empty to deactivate this
// feature.
// see _docdir/examples/swekey.sample.conf
//$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/phpMyAdmin/swekey-pma.conf';

If I can save anyone half the aggravation that I have had searching for this answer, it will render my speachless. I have search high and low to fix this. May God have the glory and peace be unto you.

Kendall

[Victorious]

Praise God indeed Kendall!

and I praise God for you. Somebody has finally made sense! I guess I shouldn't actually say that. The gurus are making sense all the time, it's just that some of us [me] don't have enough technical savvy, to make sense from the sense.

Anyway, it's good to know it's an advanced feature and I probably don't even need it. (Apache may want to noticeably point that out somewhere -- it'll just make their great product even better).

At any rate, since I've taken out much time to get to this point, I'd like to go ahead and implement the fix. A couple questions on the solution you came up with though.

1) I can get to the config.inc php file........ xamp\phpmyadmin\config.inc

2) But now what exactly are we entering and where are we entering it.

3) Unless I've got the wrong file I don't see where you disable warning messages. Or am I in the wrong location altogether?

4) Do we copy down and paste the entire body of instructions starting with the

/*
* Disable the default warning

..................and ending with.................

swekey-pma.conf';

Just a little confused. It looks like there's a few additional adjustments somewhere. Maybe there's another config location where all this takes place.

Anyway, if you can simplify it a bit more for me (exactly where and how you implemented your solution) your right... that'd go along way to alleviating a headache.

thanks so much for all your effort
Victorious