<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span><br></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> David Moore <dmoo1790@ihug.co.nz><br> <b><span style="font-weight: bold;">To:</span></b> mythtvnz@lists.linuxnut.co.nz <br> <b><span style="font-weight: bold;">Sent:</span></b> Saturday, 2 June 2012 12:42 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [mythtvnz] I killed MYSQL now what?<br> </font> </div> <br>On 02/06/12 07:00, Steve V wrote:<br>><br>>
Ok I have moved on, I<br>><br>> sudo apt-get purge mysql-server<br>> and sudo apt-get purge mysql-client<br>> and sudo apt-get purge mysql-common<br>><br>> and I also deleted /etc/apparmor.d/usr.sbin.mysqld<br>><br>> before reinstalling.<br>><br>> it now seems that mysql is running, but now I am still having<br>> trouble with restoring my mythtv database.<br>><br>> I guess it may be database password related but I am not sure.<br>><br>> /usr/share/mythtv/mythconverg_restore.pl --verbose --directory<br>> /mythtvstorage3/recordings --filename<br>> mythconverg-1264-20120527075514.sql.gz<br>><br>> Configuring environment:<br>> - username: steve<br>> - HOME: /home/steve<br>> -
MYTHCONFDIR: /home/steve/.mythtv<br>><br>> Parsing configuration files:<br>> - checking: /home/steve/.mythtv/config.xml<br>> parsing: /home/steve/.mythtv/config.xml<br>> - checking: /home/steve/.mythtv/backuprc<br>><br>> Applying command-line arguments.<br>><br>> Checking configuration.<br>><br>> Database Information:<br>> DBHostName: 10.1.1.11<br><br><br>Is this the problem? Port number should be 3306. Also IP address should <br>be 127.0.0.1? See below.<br><br><br>> DBPort: 0<br>><br>><br>><br>><br>> mysql -u mythtv -p C1RFOKlE mythconverg<br>><br>> gives<br>><br>> mysql Ver 14.14 Distrib 5.1.62, for debian-linux-gnu (i686) using<br>> readline 6.2<br>> Copyright (c) 2000, 2011, Oracle
and/or its affiliates. All rights<br>......<br>> Variables (--variable-name=value)<br>> and boolean options {FALSE|TRUE} Value (after reading options)<br>> --------------------------------- -----------------------------<br>> port 3306<br><br>On my system the port number is set in /etc/mysql/my.cnf.<br><br>Also I think you should use the loopback address 127.0.0.1 if that's <br>what the bind-address is set to in /etc/mysql/my.cnf.<br><br>_______________________________________________<br>mythtvnz mailing list<br><a ymailto="mailto:mythtvnz@lists.linuxnut.co.nz" href="mailto:mythtvnz@lists.linuxnut.co.nz">mythtvnz@lists.linuxnut.co.nz</a><br><a href="http://lists.ourshack.com/mailman/listinfo/mythtvnz" target="_blank">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a><br>Archives <a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/"
target="_blank">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a><br><br>Yes you are correct, I fixed (at least I think it is fixed), by first changing the root mysql password, then changing the mythconverg password. </div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_19_133859868256163"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_19_133859868256163">Then I changed my.cnf so mysql binds on 10.1.1.11 cos I don't know how to make myth connect to 127.0.0.1.</div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_19_133859868256163"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_19_133859868256163">Looks like everything is working except Mythweb is not accepting my password, so I will have to try and figure out how I
protected it, from memory there are a few ways to do this. </div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;" class="yui_3_2_0_19_133859868256163"><br></div> </div> </blockquote></div> </div></body></html>