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