<div dir="ltr">Thanks Bill.<br><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Mar 10, 2013 at 4:20 PM, Bill Meek <span dir="ltr"><<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">On 03/10/2013 04:10 AM, UB40D wrote:<br>
...<div class="im"><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
# apt-get install mysql-server mysql-server-5.5<br>
</blockquote></div>
...<br>
<br>
Hi;<br>
<br>
Not sure if it hurts, but I never try to install the meta package and<br>
the package itself, so you could retry Igor's -P suggestion to get a<br>
fresh (uninstalled) start and then "apt-get install mysql-server" only<br>
(which will select the -5.5 package.)<br>
<br></blockquote><div><br></div><div style>OK, I attempted that.</div><div style>In the spirit of leaving no stone unturned I did so in two variants:</div><div style>1) without setting a password (hoping it would make it all simpler)</div>
<div style>2) setting a password (hoping it would make it closer to the std case)</div><div style>but could get neither to work. Details below, with my comments inlined.</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
You can google as well as I can, but see things like:<br>
<br>
sudo dpkg-reconfigure mysql-server-5.5<br>
<br>
from: <a href="http://askubuntu.com/questions/21231/why-is-mysql-unable-to-configure" target="_blank">http://askubuntu.com/<u></u>questions/21231/why-is-mysql-<u></u>unable-to-configure</a><br>
<br>
after searching for:<div class="im"><br>
<br>
dpkg: error processing mysql-server-5.5 (--configure):<br></div></blockquote><div><br></div><div style>Tried that too, did no good---see below at the end. </div><div><br></div><div><br></div><div># dpkg -P mysql-server-5.5 mysql-server<br>
</div><div>(Reading database ... 322308 files and directories currently installed.)</div><div>Removing mysql-server-5.5 ...</div><div>Purging configuration files for mysql-server-5.5 ...</div><div>dpkg: warning: while removing mysql-server-5.5, directory '/usr/share/doc/mysql-server-5.5' not empty so not removed</div>
<div>Removing mysql-server ...</div><div>Processing triggers for man-db ...</div><div>Processing triggers for ureadahead ...</div><div><br></div><div>------------------</div><div style>Did it work? Usually seems to.</div>
<div style>------------------</div><div><br></div><div># dpkg -l mysql-server mysql-server-5.5 </div><div>Desired=Unknown/Install/Remove/Purge/Hold</div><div>| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend</div>
<div>|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)</div><div>||/ Name Version Architecture Description</div><div>+++-==============-============-============-=================================</div>
<div>un mysql-server <none> (no description available)</div><div>dpkg-query: no packages found matching mysql-server-5.5</div><div><br></div><div><br></div><div>--------------</div><div style>Looks like it worked, but still unclear why it can't find the second package.</div>
<div style>Next I'll install mysql-server, with no root password.<br></div><div style>--------------</div><div><br></div><div><br></div><div># apt-get install mysql-server</div><div>Reading package lists... Done</div>
<div>Building dependency tree </div><div>Reading state information... Done</div><div>The following extra packages will be installed:</div><div> mysql-server-5.5</div><div>Suggested packages:</div><div> tinyca mailx</div>
<div>The following NEW packages will be installed:</div><div> mysql-server mysql-server-5.5</div><div>0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.</div><div>Need to get 0 B/8,851 kB of archives.</div><div>
After this operation, 32.8 MB of additional disk space will be used.</div><div>Do you want to continue [Y/n]? </div><div>Preconfiguring packages ...</div><div>Selecting previously unselected package mysql-server-5.5.</div>
<div>(Reading database ... 322221 files and directories currently installed.)</div><div>Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...</div><div>Selecting previously unselected package mysql-server.</div>
<div>Unpacking mysql-server (from .../mysql-server_5.5.29-0ubuntu0.12.10.1_all.deb) ...</div><div>Processing triggers for ureadahead ...</div><div>Processing triggers for man-db ...</div><div>Setting up mysql-server-5.5 (5.5.29-0ubuntu0.12.10.1) ...</div>
<div>start: Job failed to start</div><div>invoke-rc.d: initscript mysql, action "start" failed.</div><div>dpkg: error processing mysql-server-5.5 (--configure):</div><div> subprocess installed post-installation script returned error exit status 1</div>
<div>No apport report written because MaxReports is reached already</div><div> dpkg: dependency problems prevent configuration of mysql-server:</div><div> mysql-server depends on mysql-server-5.5; however:</div>
<div> Package mysql-server-5.5 is not configured yet.</div><div><br></div><div>dpkg: error processing mysql-server (--configure):</div><div> dependency problems - leaving unconfigured</div><div>No apport report written because MaxReports is reached already</div>
<div> Processing triggers for ureadahead ...</div><div>Errors were encountered while processing:</div><div> mysql-server-5.5</div><div> mysql-server</div><div>E: Sub-process /usr/bin/dpkg returned an error code (1)</div>
<div><br></div><div><br></div><div>----------------------------</div><div style>During the above, it asked for a root password 3 times, with a box that said:</div><div style><div><br></div><div>| While not mandatory, it is highly recommended that you set a password</div>
<div>| for the MySQL administrative "root" user.</div><div>| If this field is left blank, the password will not be changed. <br></div></div><div style><br></div><div style>I always pressed enter. </div><div style>
Clearly this didn't work.</div><div style>----------------------------</div><div><br></div><div># dpkg -l mysql-server mysql-server-5.5 Desired=Unknown/Install/Remove/Purge/Hold</div><div>| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend</div>
<div>|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)</div><div>||/ Name Version Architecture Description</div><div>+++-==============-============-============-=================================</div>
<div>iU mysql-server 5.5.29-0ubun all MySQL database server (metapackag</div><div>iF mysql-server-5 5.5.29-0ubun amd64 MySQL database server binaries an</div><div><br></div><div><br></div><div>---------------------------------</div>
<div style>The packages are there, but both in a bad condition (uppercase=bad)</div><div style>Let's get rid of them and try again, this time with a test password.</div><div style>--------------------------------</div>
<div><br></div><div><br></div><div># dpkg -P mysql-server-5.5 mysql-server</div><div>(Reading database ... 322308 files and directories currently installed.)</div><div>Removing mysql-server-5.5 ...</div><div>Purging configuration files for mysql-server-5.5 ...</div>
<div>dpkg: warning: while removing mysql-server-5.5, directory '/usr/share/doc/mysql-server-5.5' not empty so not removed</div><div>Removing mysql-server ...</div><div>Processing triggers for man-db ...</div><div>
Processing triggers for ureadahead ...</div><div><br></div><div># dpkg -l mysql-server mysql-server-5.5 </div><div>Desired=Unknown/Install/Remove/Purge/Hold</div><div>| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend</div>
<div>|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)</div><div>||/ Name Version Architecture Description</div><div>+++-==============-============-============-=================================</div>
<div>un mysql-server <none> (no description available)</div><div>dpkg-query: no packages found matching mysql-server-5.5</div><div><br></div><div><br></div><div>-------------------------------</div>
<div style>Below, I installed with a test password.</div><div style>-------------------------------</div><div><br></div><div># apt-get install mysql-server<br></div><div>Reading package lists... Done</div><div>Building dependency tree </div>
<div>Reading state information... Done</div><div>The following extra packages will be installed:</div><div> mysql-server-5.5</div><div>Suggested packages:</div><div> tinyca mailx</div><div>The following NEW packages will be installed:</div>
<div> mysql-server mysql-server-5.5</div><div>0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.</div><div>Need to get 0 B/8,851 kB of archives.</div><div>After this operation, 32.8 MB of additional disk space will be used.</div>
<div>Do you want to continue [Y/n]? </div><div>Preconfiguring packages ...</div><div>Selecting previously unselected package mysql-server-5.5.</div><div>(Reading database ... 322221 files and directories currently installed.)</div>
<div>Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...</div><div>Selecting previously unselected package mysql-server.</div><div>Unpacking mysql-server (from .../mysql-server_5.5.29-0ubuntu0.12.10.1_all.deb) ...</div>
<div>Processing triggers for ureadahead ...</div><div>Processing triggers for man-db ...</div><div>Setting up mysql-server-5.5 (5.5.29-0ubuntu0.12.10.1) ...</div><div>start: Job failed to start</div><div>invoke-rc.d: initscript mysql, action "start" failed.</div>
<div>dpkg: error processing mysql-server-5.5 (--configure):</div><div> subprocess installed post-installation script returned error exit status 1</div><div>dpkg: dependency problems prevent configuration of mysql-server:</div>
<div> mysql-server depends on mysql-server-5.5; however:</div><div> Package mysql-server-5.5 is not configured yet.</div><div><br></div><div>dpkg: error processing mysql-server (--configure):</div><div> dependency problems - leaving unconfigured</div>
<div>Processing triggers for ureadahead ...</div><div>No apport report written because the error message indicates its a followup error from a previous failure.</div><div> Errors were encountered while processing:</div>
<div> mysql-server-5.5</div><div> mysql-server</div><div>E: Sub-process /usr/bin/dpkg returned an error code (1)</div><div><br></div><div><br></div><div>-------------------------------------------------</div><div style>It popped up this dialog box once:</div>
<div style><br></div><div><div><div>| While not mandatory, it is highly recommended that you set a password</div><div>| for the MySQL administrative "root" user.</div><div>| If this field is left blank, the password will not be changed. <br>
</div></div></div><div><br></div><div style>I inserted the test password. It asked for it again. I did. Then it mumbled to itself a bit more and issued another dialog:</div><div style><br></div><div style><div> │ Unable to set password for the MySQL "root" user </div>
<div> │ </div><div> │ An error occurred while setting the password for the MySQL </div><div> │ administrative user. This may have happened because the account already </div>
<div> │ has a password, or because of a communication problem with the MySQL </div><div> │ server. </div><div> │ </div>
<div> │ You should check the account's password after the package installation. </div><div> │ </div><div> │ Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for </div>
<div> │ more information. </div></div><div><br></div><div style>and concluded with the above error message.</div><div style>-----------------------------------------------</div><div style><br></div><div><br></div><div>
# dpkg -l mysql-server mysql-server-5.5 Desired=Unknown/Install/Remove/Purge/Hold<br></div><div>| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend</div><div>|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)</div>
<div>||/ Name Version Architecture Description</div><div>+++-==============-============-============-=================================</div><div>iU mysql-server 5.5.29-0ubun all MySQL database server (metapackag</div>
<div>iF mysql-server-5 5.5.29-0ubun amd64 MySQL database server binaries an</div><div><br></div><div><br></div><div>----------------------------------</div><div><div style>Still broken, obviously.</div><div>I read the specified readme, which among other things said:</div>
<div><br></div><div><div>| * PASSWORDS:</div><div>| ============</div><div>| It is strongly recommended to set a password for the mysql root user (which</div><div>| /usr/bin/mysql -u root -D mysql -e "update user set password=password(</div>
<div>| 'new-password') where user='root'"</div><div>| /usr/bin/mysql -u root -e "flush privileges"</div><div>| If you already had a password set add "-p" before "-u" to the lines above.</div>
</div></div><div><br></div><div style>So I tried that too, both without and with -p.</div><div>------------------------------------</div><div><br></div><div><br></div><div># /usr/bin/mysql -u root -D mysql -e "update user set password=password('test') where user='root'"</div>
<div>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</div><div><br></div><div><br></div><div># /usr/bin/mysql -p -u root -D mysql -e "update user set password=password('test') where user='root'"</div>
<div>Enter password: </div><div>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</div><div><br></div><div> </div><div>--------------------------</div><div style>
Still no good.</div><div style>Finally I tried your last suggestion:</div><div style>--------------------------</div><div style><br></div><div style><div># dpkg-reconfigure mysql-server-5.5</div><div>/usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed</div>
<div><br></div><div><br></div><div><br></div><div>--------------------------</div><div style>What other hope have I got?</div><div style><br></div><div style>I would have thought that if dpkg -P really gets rid of the packages (which it seems to) then it shouldn't be such a big deal just to install mysql on an allegedly clean system, right? What am I doing wrong here?</div>
<div style>---------------------------</div><div><br></div></div></div></div></div>