Results 1 to 9 of 9

Thread: phpMyAdmin tool is giving me error message after logging into the tool?

  1. #1

    Default phpMyAdmin tool is giving me error message after logging into the tool?

    Hello world,

    I love LINUX. I am a newbie. I am huge fan of LINUX. I need help with phpMyAdmin installation issue.

    When I log into phpMyAdmin tool. After logging in I am getting this message below.

    Code:
    
    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click

    I have tried rebooting the server. I have restarted apache, mysql, and clear cache, cookies, browsing history, reset browser settings. It is still giving me error message. When I click on the click here button,

    This is output I get?

    Code:
    $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]['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
    $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.
    • 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.

    Any help is greatly appreciated.

    thanks in advance
    -------------------------------------------------------------------------------------------------------------
    Linux Newbie - Information is Power!
    May the Linux force be with you!

  2. #2
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    25,240

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Hello,

    Please allways tell at least which version of openSUSE you use.

    When you use a desktop, allways tell which one (KDE, Gnome, ...).

    All things we realy can not guess.
    Henk van Velden

  3. #3

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Quote Originally Posted by hcvv View Post
    Hello,

    Please allways tell at least which version of openSUSE you use.

    When you use a desktop, allways tell which one (KDE, Gnome, ...).

    All things we realy can not guess.

    sorry, my first post,

    I am using openSUSE 13.1, KDE desktop.

  4. #4
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,452

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Did you get phpmyadmin from the openSUSE repos or from elsewhere? Either way, the messages you are receiving are predictable:

    http://software.opensuse.org/package...erm=phpmyadmin says
    phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual.
    That is what it says at the end of your error message:
    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.


  5. #5

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Quote Originally Posted by john_hudson View Post
    Did you get phpmyadmin from the openSUSE repos or from elsewhere? Either way, the messages you are receiving are predictable:

    http://software.opensuse.org/package...erm=phpmyadmin says

    That is what it says at the end of your error message:
    [/FONT][/COLOR][/LIST]
    [/FONT][/COLOR]

    Do you know what I need to do to remove the error. I installed the phpmyadmin using "zypper install phpMyAdmin" command. How can I fix this error? I log in every time using username ROOT and password. And root has all the privileges. I don't know how to create a table with examples_tables.sql?

    Not sure what to do next?

  6. #6

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Quote Originally Posted by cyberdome View Post
    Do you know what I need to do to remove the error. I installed the phpmyadmin using "zypper install phpMyAdmin" command. How can I fix this error? I log in every time using username ROOT and password. And root has all the privileges. I don't know how to create a table with examples_tables.sql?

    Not sure what to do next?

    This message shows up ONLY on the 4.1 phpMyAdmin versions. I have other Linux machines that run phpMyAdmin perfectly fine but they are running 3.5 versions. In order solve this issue. If you have no need for the extra storage features for MariaDB and phpMyAdmin. To solve this I disabled all the features in the config.inc.php file.

    These are the lines you must disable and there is also one line where you must set the condition to true to disable warning messages. Hope this helps anyone else having these annoying issues.



    Code:
    /*
     * 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';                                          <<<--------------------   Last line of the storage features disable
    
    
    
    
    
    
    
    =================================================================
    
    /*
     * phpMyAdmin configuration storage settings.
     */
    
    
    /*
    $cfg['Servers'][$i]['controlhost']         = 'localhost';
    $cfg['Servers'][$i]['controluser']         = '';
    $cfg['Servers'][$i]['controlpass']         = '';
    $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_cords';
    $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]['table_uiprefs']       = 'pma__table_uiprefs';
    $cfg['Servers'][$i]['tracking']            = 'pma__tracking';
    $cfg['Servers'][$i]['designer_coords']     = 'pma__designer_coords';
    $cfg['Servers'][$i]['userconfig']          = 'pma__userconfig';
    $cfg['Servers'][$i]['recent']              = 'pma__recent';
    $cfg['Servers'][$i]['users']               = 'pma__users';
    $cfg['Servers'][$i]['usergroups']          = 'pma__usergroups';
    $cfg['Servers'][$i]['navigationhiding']    = 'pma__navigationhiding';
    $cfg['Servers'][$i]['auth_swekey_config']  = '/etc/phpMyAdmin/swekey-pma_02.conf';
    */

  7. #7

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Quote Originally Posted by cyberdome View Post
    This message shows up ONLY on the 4.1 phpMyAdmin versions. I have other Linux machines that run phpMyAdmin perfectly fine but they are running 3.5 versions. In order solve this issue. If you have no need for the extra storage features for MariaDB and phpMyAdmin. To solve this I disabled all the features in the config.inc.php file.

    These are the lines you must disable and there is also one line where you must set the condition to true to disable warning messages. Hope this helps anyone else having these annoying issues.



    Code:
    /*
     * 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';                                          <<<--------------------   Last line of the storage features disable
    
    
    
    
    
    
    
    =================================================================
    
    /*
     * phpMyAdmin configuration storage settings.
     */
    
    
    /*
    $cfg['Servers'][$i]['controlhost']         = 'localhost';
    $cfg['Servers'][$i]['controluser']         = '';
    $cfg['Servers'][$i]['controlpass']         = '';
    $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_cords';
    $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]['table_uiprefs']       = 'pma__table_uiprefs';
    $cfg['Servers'][$i]['tracking']            = 'pma__tracking';
    $cfg['Servers'][$i]['designer_coords']     = 'pma__designer_coords';
    $cfg['Servers'][$i]['userconfig']          = 'pma__userconfig';
    $cfg['Servers'][$i]['recent']              = 'pma__recent';
    $cfg['Servers'][$i]['users']               = 'pma__users';
    $cfg['Servers'][$i]['usergroups']          = 'pma__usergroups';
    $cfg['Servers'][$i]['navigationhiding']    = 'pma__navigationhiding';
    $cfg['Servers'][$i]['auth_swekey_config']  = '/etc/phpMyAdmin/swekey-pma_02.conf';
    */
    Hello and good afternoon.

    What do you do when commenting does not work?

    I have created the tables, created the control user, ensured that the php5 folder and config.inc.php have the proper permissions but phpMyAdmin still gives me the error stating "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.", "The configuration file now needs a secret passphrase (blowfish_secret)." and "Server running with Suhosin. Please refer to documentation for possible issues."

    I recently upgraded from opensuse 11.4 to 12.1 and I am not sure if this has anything to do with it, but I did not have the blowfish_secret message in that version.

    As I stated, commenting the options above does not solve the issue.

    It's as if the config.inc.php file is not being read.

  8. #8
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    25,240

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    Quote Originally Posted by reason View Post

    I recently upgraded from opensuse 11.4 to 12.1 .....
    Oh please, The original thread above is about 13.1. Also it is already a year old and not very many people will still watch it.

    Thus it is best to start a new thread with a good title to draw the attention of the helpers you need.

    And btw both openSUSE 11.4 and 12.1 are way out of support. thus the chance that there are people having the same version still running is almost nil.
    Henk van Velden

  9. #9
    Join Date
    Sep 2010
    Location
    Germany
    Posts
    21

    Default Re: phpMyAdmin tool is giving me error message after logging into the tool?

    reason wrote:

    >
    >
    > cyberdome;2640302 Wrote:
    >> This message shows up ONLY on the 4.1 phpMyAdmin versions. I have other
    >> Linux machines that run phpMyAdmin perfectly fine but they are running
    >> 3.5 versions. In order solve this issue. If you have no need for the
    >> extra storage features for MariaDB and phpMyAdmin. To solve this I
    >> disabled all the features in the config.inc.php file.
    >>
    >> These are the lines you must disable and there is also one line where
    >> you must set the condition to true to disable warning messages. Hope
    >> this helps anyone else having these annoying issues.

    > What do you do when commenting does not work?
    >
    > I have created the tables, created the control user, ensured that the
    > php5 folder and config.inc.php have the proper permissions but
    > phpMyAdmin still gives me the error stating "The phpMyAdmin
    > configuration storage is not completely configured, some extended
    > features have been deactivated.", "The configuration file now needs a
    > secret passphrase (blowfish_secret)." and "Server running with Suhosin.
    > Please refer to 'documentation'
    > (https://192.168.1.3:8080/phpmyadmin/...n.html#faq1_38) for
    > possible issues."
    >
    > I recently upgraded from opensuse 11.4 to 12.1 and I am not sure if
    > this has anything to do with it, but I did not have the blowfish_secret
    > message in that version.
    >
    > As I stated, commenting the options above does not solve the issue.
    >
    > It's as if the config.inc.php file is not being read.


    openSUSE 11.4 and 12.1 is out of life.
    Last stable ist 13.2

    And official phpMyAdmin-Version in 13.1, 13.2, Leap, Tumbleweed is 4.4.15.

    Have you read the docs and the doc at error messages?
    Have you create the database?
    Have you run one script from /usr/share/doc/packages/phpMyAdmin/sql?
    Have you change config.php (database, password etc.)?

    Regards
    Eric


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •