I had a few problems with phpMyAdmin under SME8 until I spotted the Wiki about the old version. Once I removed the old phpmyadmin and smeserver-phpmyadmin and then reinstalled the newer 3.5.2 version most of the problems were solved except for one. I now get the following message on the phpMyAdmin main page:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
When I click there I get the following info:
$cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled
$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled
$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled
$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled
$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
SQL history: Disabled
$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled
$cfg['Servers'][$i]['recent'] ... not OK [ Documentation ]
Persistent recently used tables: Disabled
$cfg['Servers'][$i]['table_uiprefs'] ... not OK [ Documentation ]
Persistent tables' UI preferences: Disabled
$cfg['Servers'][$i]['tracking'] ... not OK [ Documentation ]
Tracking: Disabled
$cfg['Servers'][$i]['userconfig'] ... not OK [ Documentation ]
User preferences: Disabled
Quick steps to setup advanced features:
Create the needed tables with the examples/create_tables.sql.
Create a pma user and give access to these tables.
Enable advanced features in configuration file (config.inc.php), for example by starting from config.sample.inc.php.
Re-login to phpMyAdmin to load the updated configuration file.
I've downloaded and run the create_tables.sql file (I figured the 3.5.3 version would work with 3.5.2) and created the pma user and given it full access to the phpmyadmin database and select access to the mysql database per the documentation at the phpMyAdmin web site.
My question is: how do I properly set up the config.inc.php file under SME8 with the setup information so that phpMyAdmin can use the database and quit complaining about the setup being incomplete? I assume I need to create a new custom template somewhere but where exactly and what does it need to be named?