<br><br><div class="gmail_quote">On Wed, Sep 29, 2010 at 2:53 AM, R. G. Newbury <span dir="ltr"><<a href="mailto:newbury@mandamus.org">newbury@mandamus.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">On 09/28/2010 03:33 PM, OLO wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi All,<br>
got mythbuntu FE/BE combined on a single machine, all was perfectly working<br>
fine till about 3 weeks ago.<br>
</blockquote>
<br>
</div><div class="im"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Couldnt log in to mysql so managed to set root password and now it lets me<br>
in only as root, -umyhttv doesnt seems to work, which i would thought might<br>
be a problem but checked all mysql.txt and all seems to have same settings<br>
(passwords) and the frontend does show some of DB (like upcoming recordings<br>
etc.) Live TV also works fine. All recordings are physically on my hdd as<br>
thats the only way to watch them now.<br>
<br>
Any more ideas what it might be?<br>
</blockquote>
<br></div>
This sounds like it is purely a mysql problem.<br>
<br>
It is "mysql -u mythtv -pmythtv mythconverg" you need one space before the username, and NO space before the password.<br>
<br>
I presume you have run '<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>' and that the tables have been found to be good.<br>
In which case it is an access issue.<br>
<br>
FIRST.<br>
Run 'dh -h' and make sure that your /var partition is not full. If /var is in the '/' partition, when things fill up, the box crashes. If /var is on its own partition, mysql stops working, but myth (and the OS) don't seem to crash... but it stops working properly!. (A good reason to have your mysql databases NOT in the /var partition).<br>
<br>
SECOND.<br>
Since you can get to mysql console as root, then run:<br>
<br>
mysql> use mysql;<br>
mysql> select host,user,password from user;<br>
<br>
You should see something like:<br>
+-------------------+--------+------------------+<br>
| host | user | password |<br>
+-------------------+--------+------------------+<br>
| localhost | root | 1b3ab4920bfa6d2a |<br>
| 192.168.1.81 | root | 1b3ab4920bfa6d2a |<br>
| localhost | mythtv | 0476fc026afffe24 |<br>
| 192.168.1.81 | mythtv | 0476fc026afffe24 |<br>
+-------------------+--------+------------------+<br>
<br>
Obviously the password is a hash.<br>
<br>
If you don't see an entry for mythtv, then you need to re-run the mythtv user set script mc.sql again, (or set up a 'mythtv' user in mysql from the command line).<br>
<br>
THIRD.<br>
If those check out, then:<br>
mysql> use mythconverg;<br>
mysql> select distinct hostname,count(hostname) from settings;<br>
+-------------------+-----------------+<br>
| hostname | count(hostname) |<br>
+-------------------+-----------------+<br>
| <a href="http://tor6.mandamus.org" target="_blank">tor6.mandamus.org</a> | 448 |<br>
+-------------------+-----------------+<br>
1 row in set (0.01 sec)<br>
<br>
If you see '1 row in set', then you do NOT have a duplicate hostname. One problem avoided.<br>
<br>
FOURTH<br>
mysql> select value,data from settings where value like "%ServerIP";<br>
+-----------------+--------------+<br>
| value | data |<br>
+-----------------+--------------+<br>
| MasterServerIP | 192.168.1.81 |<br>
| BackendServerIP | 192.168.1.81 |<br>
+-----------------+--------------+<br>
2 rows in set (0.00 sec)<br>
<br>
On a BE/FE system, these should be the same, and there should NOT be duplicate 'value' entries.<br>
quit mysql<br>
FIFTH<br>
<br>
At the console:<br>
<br>
# less /etc/hosts | grep <a href="http://tor6.mandamus.org" target="_blank">tor6.mandamus.org</a><br>
<br>
using the hostname listed in 'THIRD' above.<br>
If all this checks out, from the mysql end then you must done the incantation wrong!<br>
<br>
<br>
R. Geoffrey Newbury <div><div></div><div class="h5"><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>ad. FIRST<br><br>still got some space left (it fills up slowly as the backend is recording but when problem ocured there was much more space)<br> df -h<br>Filesystem Size Used Avail Use% Mounted on<br>
/dev/sda1 227G 210G 5.2G 98% /<br><br>ad. SECOND<br>Looks ok to me <br>+-----------+------------------+--------------<br>| host | user | password |<br>+-----------+------------------+--------------<br>
| localhost | root | *734F96084C<br>| terranova | root | *734F96084C<br>| 127.0.0.1 | root | *734F96084C<br>| localhost | debian-sys-maint | *8B993C<br>| localhost | mythtv | *ADEB9DF9<br>
| % | mythtv | *ADEB9DF9<br>+-----------+------------------+-------------<br><br>ad. THIRD<br>again, seems ok<br><br>+----------+-----------------+<br>| hostname | count(hostname) |<br>+----------+-----------------+<br>
| mythbox | 450 |<br>+----------+-----------------+<br>1 row in set (0.00 sec)<br><br>ad. FOURTH<br>There might be some problem, duplicate entry?<br>+-----------------+-----------+<br>| value | data |<br>
+-----------------+-----------+<br>| BackendServerIP | 127.0.0.1 |<br>| MasterServerIP | 127.0.0.1 |<br>| BackendServerIP | 127.0.0.1 |<br>+-----------------+-----------+<br>3 rows in set (0.00 sec)<br><br>ad. FIFTH<br>Theres different IP address in here then i thought it should be:<br>
less /etc/hosts | grep mythbox<br>127.0.1.1 mythbox<br><br>Thanks a lot for Your help<br><br clear="all"><br>-- <br><font color="#888888">--<br>
Two rules for life:<br>
1. Don't tell people everything you know.<br>
2.<br>
</font><br>