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:

"Error
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/hsphere.properties 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/config.inc.php 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 2017. Parallels Holdings. All rights reserved.