Package: phpmyadmin Version: 4:3.2.2-1 Severity: normal
At the phpmyadmin home page, I see the warning that additional features related to linked tables have been deactivated. Following the link, I get $cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ] $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 Bookmarked SQL query: Disabled Browser transformation: Disabled $cfg['Servers'][$i]['history'] ... not OK [ Documentation ] SQL history: Disabled $cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ] Designer: Disabled Following the documentation for the linked tables infrastructure, I've created the pma user; imported create_tables.sql to create the pmadb; set all of the appropriate settings in config.inc.php; and restarted Apache. Nevertheless, I still get the same warnings at login. In config.inc.php, I have $i = 1; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['connect_type'] = 'socket'; //$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'thepassword'; $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]['designer_coords']= 'pma_designer_coords'; In phpmyadmin, going to Privileges > pma > edit, I see that user pma has all except grant privileges on the phpmyadmin database. The phpmyadmin database has all of the tables named above, and they appear to have the right structure. Many people are reporting this problem around the net. The most commonly reported solutions are: (1) use a different browser than Firefox; (2) clear your browser cache and cookies; and (3) run 'dpkg-reconfigure phpmyadmin'. I've tried all of these solutions, and the problem remains. Aside: phpmyadmin has been the very definition of making MySQL easy to use. It's astonishing to me that for this particular component, the developers have made configuration so manual and hackish, with the result that an awful lot of people are struggling with it. There's *got* to be an automated way of setting this up for people. But, we can leave that for another day. Any help would be appreciated. Thanks, Andrew. -- System Information: Debian Release: squeeze/sid APT prefers testing APT policy: (990, 'testing'), (500, 'unstable'), (400, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.26 (SMP w/3 CPU cores; PREEMPT) Locale: LANG=en_US, LC_CTYPE=en_US (charmap=UTF-8) (ignored: LC_ALL set to en_US) Shell: /bin/sh linked to /bin/bash Versions of packages phpmyadmin depends on: ii dbconfig-common 1.8.41 common framework for packaging dat ii debconf [debconf-2.0] 1.5.27 Debian configuration management sy ii libapache2-mod-php5 5.2.9.dfsg.1-4 server-side, HTML-embedded scripti ii perl 5.10.0-25 Larry Wall's Practical Extraction ii php5 5.2.9.dfsg.1-4 server-side, HTML-embedded scripti ii php5-cgi 5.2.9.dfsg.1-4 server-side, HTML-embedded scripti ii php5-mcrypt 5.2.9.dfsg.1-4 MCrypt module for php5 ii php5-mysql 5.2.9.dfsg.1-4 MySQL module for php5 ii ucf 3.0022 Update Configuration File: preserv Versions of packages phpmyadmin recommends: ii apache2 2.2.13-2 Apache HTTP Server metapackage ii apache2-mpm-prefork [http 2.2.13-2 Apache HTTP Server - traditional n ii mysql-client 5.1.37-2 MySQL database client (metapackage ii mysql-client-5.1 [mysql-c 5.1.37-2 MySQL database client binaries ii php5-gd 5.2.9.dfsg.1-4 GD module for php5 Versions of packages phpmyadmin suggests: ii mysql-server 5.1.37-2 MySQL database server (metapackage ii mysql-server-5.1 [mysql-serve 5.1.37-2 MySQL database server binaries -- debconf information: phpmyadmin/remove-error: abort phpmyadmin/setup-username: admin phpmyadmin/db/app-user: phpmyadmin phpmyadmin/remote/host: * phpmyadmin/dbconfig-install: true phpmyadmin/remote/port: phpmyadmin/dbconfig-upgrade: true phpmyadmin/missing-db-package-error: abort phpmyadmin/upgrade-error: abort phpmyadmin/dbconfig-reinstall: false phpmyadmin/db/dbname: phpmyadmin phpmyadmin/database-type: mysql phpmyadmin/dbconfig-remove: * phpmyadmin/mysql/method: unix socket phpmyadmin/purge: false phpmyadmin/install-error: abort * phpmyadmin/reconfigure-webserver: apache2 phpmyadmin/mysql/admin-user: root phpmyadmin/internal/reconfiguring: false phpmyadmin/remote/newhost: phpmyadmin/internal/skip-preseed: true phpmyadmin/upgrade-backup: true phpmyadmin/passwords-do-not-match: -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
