Port80 Forums Ilisys Web Hosting Fast Hit Web Hosting

Our Platinum Sponsors:


Go Back   Port80 Forums > Development & Code > php & mySQL

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2012, 04:16 PM
paulc paulc is offline
Junior Member
 
Join Date: Jun 2010
Location: perth
Posts: 4
paulc is on a distinguished road
Default The phpMyAdmin configuration storage is not completely configured

I have followed all the instructions for configuring for extended features but keep getting the following when logging into phpMyAdmin:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.

The message I get is:

$cfg['Servers'][$i]['pmadb'] … OK
$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]['tracking'] … not OK [ Documentation ]
Tracking: Disabled

$cfg['Servers'][$i]['userconfig'] … not OK [ Documentation ]
User preferences: Disabled

My config.inc.php is

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @package phpMyAdmin
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'my_blowfish_secret'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = True;

/*
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
* Defines whether a user should be displayed a "show all (records)"
* button in browse mode or not.
* default = false
*/
//$cfg['ShowAll'] = true;

/**
* Number of rows displayed when browsing a result set. If the result
* set contains more rows, "Previous" and "Next".
* default = 30
*/
//$cfg['MaxRows'] = 50;

/**
* Use graphically less intense menu tabs
* default = false
*/
//$cfg['LightTabs'] = true;

/**
* disallow editing of binary fields
* valid values are:
* false allow editing
* 'blob' allow editing except for BLOB fields
* 'all' disallow editing
* default = blob
*/
//$cfg['ProtectBinary'] = 'false';

/**
* Default language to use, if not browser-defined or user-defined
* (you find all languages in the locale folder)
* uncomment the desired line:
* default = 'en'
*/
//$cfg['DefaultLang'] = 'en';
//$cfg['DefaultLang'] = 'de';

/**
* default display direction (horizontal|vertical|horizontalflipped)
*/
//$cfg['DefaultDisplay'] = 'vertical';


/**
* How many columns should be used for table display of a database?
* (a value larger than 1 results in some information being hidden)
* default = 1
*/
//$cfg['PropertiesNumColumns'] = 2;

/**
* Set to true if you want DB-based query history.If false, this utilizes
* JS-routines to display query history (lost by window close)
*
* This requires configuration storage enabled, see above.
* default = false
*/
//$cfg['QueryHistoryDB'] = true;

/**
* When using DB-based query history, how many entries should be kept?
*
* default = 25
*/
//$cfg['QueryHistoryMax'] = 100;

/*
* You can find more configuration options in Documentation.html
* or here: http://wiki.phpmyadmin.net/pma/Config
*/
?>

What could possibly I miss? Any ideas?

Last edited by paulc; 10-05-2012 at 05:08 PM.
Reply With Quote
  #2  
Old 16-05-2012, 11:52 AM
patricktt's Avatar
patricktt patricktt is offline
Senior Member
AWIA Member
 
Join Date: May 2009
Location: Waroona, WA, Australia
Posts: 341
patricktt is on a distinguished road
Default

this give you any help? http://www.phpfreaks.com/forums/inde...367#msg1581367
__________________
Templeman Twells
Reply With Quote
  #3  
Old 26-09-2012, 07:49 AM
Zen Zen is offline
Senior Member
 
Join Date: Apr 2010
Location: NSW, Australia
Age: 19
Posts: 130
Zen is on a distinguished road
Default

for the sake of my eyes, please, code tags.
__________________
PHP | Django
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +8. The time now is 07:23 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.