Parallels H-Sphere Documentation System Administrator Guide


Enabling Linked Tables in phpMyAdmin


Related Docs:   phpMyAdmin 2.6.0 Security Fix

Last modified: 18 Jan 2005


WARNING: This documentation covers Parallels H-Sphere versions up to 3.1. For the latest up-to-date Parallels H-Sphere documentation, please proceed to the official Parallels site.

New versions of phpMyAdmin give the following error if not configured accordingly:

The additional features for working with linked tables have been deactivated."

These features include bookmarks, comments, SQL-history, PDF generation, field contents transformation, etc. To enable them, do the following:

  1. Log into the web server as root. This must be the web server where phpMyAdmin is installed. The ID of this logical server is specified in /hsphere/local/home/cpanel/shiva/psoft_config/ on the CP server.
  2. Create phpmyadmin database.
    If you are running Web and MySQL servers on the same box:
    mysql -u root -p<password> < /hsphere/shared/apache/htdocs/phpMyAdmin/scripts/create_tables.sql
    If they are on different boxes:
    mysql -h <MYSQL_SERVER_IP> -u root -p<PASSWORD> < /hsphere/shared/apache/htdocs/phpMyAdmin/scripts/create_tables.sql
  3. Give necessary permissions to the controluser.
    If you are running Web and MySQL servers on different boxes, first log into the MySQL server as root.
    mysql# GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpuser'@'%';
  4. Enter the following values in the file /hsphere/shared/apache/htdocs/phpMyAdmin/ on the web server:
    $cfgServers[1]['pmadb'] = 'phpmyadmin';
    $cfgServers[1]['table_info'] = 'pma_table_info';
    $cfgServers[1]['pdf_pages'] = 'pma_pdf_pages';
    $cfgServers[1]['history'] = 'pma_history';
    $cfgServers[1]['column_info'] = 'pma_column_info';
    $cfgServers[1]['table_coords'] = 'pma_table_coords';
    $cfgServers[1]['relation'] = 'pma_relation';
    $cfgServers[1]['bookmarktable'] = 'pma_bookmark';

Related Docs:   phpMyAdmin 2.6.0 Security Fix

© Copyright 2018. Parallels Holdings. All rights reserved.