<br><br><div><span class="gmail_quote">On 9/14/05, <b class="gmail_sendername">Nick</b> <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 15/09/05, Analabha Roy <<a href="mailto:hariseldon99@gmail.com">hariseldon99@gmail.com</a>> wrote:<br>> Okay, I deleted the mythconverg database and restarted the whole config of<br>> mysql then mythtv-setup as per the instructions on
<br>><br>> <a href="http://wilsonet.com/mythtv/HOWTO-fc3.php">http://wilsonet.com/mythtv/HOWTO-fc3.php</a><br>><br>> As you can see, running mythfilldatabase gives a whole bunch of errors,<br>> and running mythtv-frontend gives no pic or sound...
<br>><br>><br>> I would greatly appreciate any advise in this matter. Can anyone tell me<br>> what I'm doing wrong?<br><br>MySQL is not correctly setup for one thing I reckon.<br><br>Did the SQL error messages start any warning bells? There are 2 errors
<br>on the first screenshot - Privileges has a typo...<br><br>First, check your current user info<br><br>$ mysql -u root -p<br>mysql> USE mysql;<br>mysql> SELECT Host,User FROM user;</blockquote><div><br>
Thanks for your help.<br>
<br>
<br>
<br>
[daneel@landau ~]$ mysql -u root -p<br>
Enter password: <br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 2 to server version: 3.23.58<br>
<br>
Type 'help;' or '\h'<br>
<br>
mysql> USE mysql;<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Database changed<br>
mysql> SELECT Host,User FROM user;<br>
+--------------------+--------+<br>
| Host | User |<br>
+--------------------+--------+<br>
| landau.localdomain | |<br>
| landau.localdomain | root |<br>
| localhost | |<br>
| localhost | mythtv |<br>
| localhost | root |<br>
+--------------------+--------+<br>
5 rows in set (0.00 sec)<br>
for help. Type '\c' to clear the buffer.<br>
<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Please post the output.<br><br>Make sure all mythtv users (called mythtv) who need to can connect to
<br>the database (assuming your local network is 192.168.1/24). From the<br>mythtv offical docs, try<br><br>$ mysql -u root mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified<br>
by "mythtv";<br>mysql> flush privileges;</blockquote><div><br>
<br>
I will need a password to access a database in sql. Could that be creating problems?<br>
<br>
[daneel@landau ~]$ mysql -p -u root mythconverg<br>
Enter password: <br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 4 to server version: 3.23.58<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
<br>
mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified<br>
-> by "mythtv";<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> flush privileges;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> <br>
<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">There is also an error in the mc.sql script which needs to be<br>addressed before you go any further. Please send a copy to me. I'm
<br>sure it's related to user access in mysql too.</blockquote><div><br>
<br>
I've posted it at:<br>
<a href="http://www.ph.utexas.edu/~daneel/mythtv-hell/mc.sql">http://www.ph.utexas.edu/~daneel/mythtv-hell/mc.sql</a><br>
<br>
<br>
btw I'm running the frontend as user 'daneel' (my regular login).
User 'mythtv' is configged as a system user (login shell:/bin/nologin)<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I would *seriously* consider wiping completely and starting over<br>following Jarod's guide from the beginning if this doesn't give any
<br>progress.<br><br>Nick<br></blockquote></div><br>