phpmyadmin: save query history to central server -
i trying setup central phpmyadmin server multiple db servers.
was reading these:
signon works fine both localhost(phpmyadmin.example.com) , remote server(db1.example.com) , users able login both. have created phpmyadmin database , pma_* tables in phpmyadmin.example.com. history gets saved sql queries on localhost. when user logs in db1, sees error:
the additional features working linked tables have been deactivated.
more details:
$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 the documentation says possible save history in central server. doing right? tried create set of pma_* tables , point db1 configuration them. didn't help. feel configuration trying save history db1 in db1 , have create pma_* tables in db1 (which want avoid). how can point servers' history phpmyadmin.example.com?
here config.inc.php
$i = 0; $i++; * read configuration dbconfig-common * can regenerate using: dpkg-reconfigure -plow phpmyadmin */ if (is_readable('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); } if (!empty($dbname)) { /* authentication type */ $cfg['servers'][$i]['auth_type'] = 'signon'; $cfg['servers'][$i]['signonsession'] = 'signonsession'; $cfg['servers'][$i]['signonurl'] = 'https://phpmyadmin.example.com/console.php'; /* server parameters */ if (empty($dbserver)) $dbserver = 'localhost'; $cfg['servers'][$i]['host'] = $dbserver; if (!empty($dbport)) { $cfg['servers'][$i]['connect_type'] = 'tcp'; $cfg['servers'][$i]['port'] = $dbport; } /* select mysqli if server has */ $cfg['servers'][$i]['extension'] = 'mysqli'; /* optional: user advanced features */ $cfg['servers'][$i]['controluser'] = $dbuser; $cfg['servers'][$i]['controlpass'] = $dbpass; /* optional: advanced phpmyadmin features */ $cfg['servers'][$i]['pmadb'] = $dbname; $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]['designer_coords'] = 'pma_designer_coords'; $cfg['servers'][$i]['tracking'] = 'pma_tracking'; } $i++; $cfg['servers'][$i]['verbose'] = ''; $cfg['servers'][$i]['host'] = 'db1.example.com'; $cfg['servers'][$i]['port'] = ''; $cfg['servers'][$i]['socket'] = ''; $cfg['servers'][$i]['connect_type'] = 'tcp'; $cfg['servers'][$i]['extension'] = 'mysqli'; $cfg['servers'][$i]['auth_type'] = 'signon'; $cfg['servers'][$i]['signonsession'] = 'signonsession'; $cfg['servers'][$i]['signonurl'] = 'https://phpmyadmin.example.com/console.php'; $cfg['servers'][$i]['pmadb'] = $dbname; $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]['designer_coords'] = 'pma_designer_coords'; $cfg['servers'][$i]['tracking'] = 'pma_tracking'; $cfg['uploaddir'] = ''; $cfg['savedir'] = ''; $cfg['queryhistorydb'] = true; $cfg['defaultlang'] = 'en-utf-8'; $cfg['serverdefault'] = 1;
i don't see you've configured $cfg['servers'][$i]['controlhost'], needed tell phpmyadmin server use central database. see http://docs.phpmyadmin.net/en/latest/config.html#cfg_servers_controlhost. suspect once add line, you'll have better luck.
Comments
Post a Comment