registry team mailing list archive

["John M. Rasor" <jmrasor@xxxxxxxxxxxxxxxx>]

I logged what I did yesterday to provoke this bug:

	Installed phpMyAdmin. mysql and php Apache mod came with it. [operator error: did not install mysql-server. See below.] Installation failed; did not accept any proposed password; suggested abort. Surf to http://elbereth/phpmyadmin: 404. [Elbereth is my workstation, the machine affected.] There's no myphpadmin stuff in /etc/apache2/conf.d; there is on testserver. [A test server running Lucid server edition 32-bit, LAMP, fully updated].
	Using package manager, re-install. Ended quietly, no password request. No http://elbereth/phpmyadmin, either. No /etc/apache2/conf.d/phpmyadmin.conf as there is on testserver. Copied /etc/phpmyadmin/apache.conf into /etc/apache2/conf.d: after restarting Apache, http://elbereth/phpmyadmin shows up. Can't log in.
	Re-do installation with sudo dpkg-reconfigure -plow phpmyadmin. This runs interactive setup script. 
	Re-install database.
	Use local unix socket.
	Database administrator: root.
	His password: xxxxx.
	MySQL database owner: phpmyadmin.
	Name of MySQL database: phpmyadmin.
	Web server: apache2. Error 2002: bad socket /var/run/mysqld/mysqld.sock. Retry.
	Configure with dbconfig-common.
	tcp/ip socket.
	Host is localhost.
	Port number: leave blank.
	Database administrator: root.
	MySQL database owner: phpmyadmin.
	Name of MySQL database: phpmyadmin. That finished with warning about overlapping Alias in /etc/apache2/conf.d/phpmyadmin.conf at line 3. Restart Apache: same gripe. Can't log in to main or to setup page. Set $dbuser='phpmyadmin', $dbpass='xxxxx' in /etc/phpmyadmin/config-db.php: no help.
	Reboot: no help. Dpkg-reconfigure again.
	Re-install database.
	tcp/ip socket.
	Host is localhost.
	Default port.
	Database administrator: root. Password: xxxxx.
	Database owner: phpmyadmin.
	Database name: 
	Web server: apache2.
	New /etc/phpmyadmin/config-db.php is available, but existing copy is locally modified. Install package maintainer's version. ERROR 2002 (HY000): Can't connect to local MySQL server through socket   '/var/run/mysqld/mysqld.sock. There is no /var/run/mysqld. As root, make /var/run/mysqld and touch mysqld.sock in there. Retry (skip questions): overlapping Alias. Login fails with no message, just presents login dialog again. From command line, mysql: same bad socket message.
	Is mysql running? Try sudo /etc/init.d/mysql start: nope, no mysql script in there. It is running on testserver. That server has a serious-looking /etc/init.d/mysql. On Elbereth, mysqld –verbose –help: looks like it's not installed.
	Using package manager, completely remove mysql-client and phpmyadmin. Error: tried to erase existing database, failed. Install: mysql-client, mysql-server, phpmyadmin. Installed, twice asked for root mysql user's password, finished without a whimper. Mysql user root can log in with xxxxx.
	Create database “directory”. Create 5-field table on it. Add integer field “founded” at end. Populate with a couple of houses. http://elbereth/directory-database/show_houses.htm doesn't show them, because users are not set up.
	Switch to database mysql. Look at table “user”. Add one: public on localhost, with no password. Nope,  “#1582 - Incorrect parameter count in the call to native function 'UNHEX'”. Use UUID instead of UNHEX in bottom 3 fields.
       [Then follows several attempts to set up a public user privileged to SELECT on database "directory". Today, an oft-deleted public user is still in mysql.user.]

-- 
package phpmyadmin 4:3.3.1-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 10
https://bugs.launchpad.net/bugs/563256
You received this bug notification because you are a member of Registry
Administrators, which is the registrant for Debian.