[mythtv-users] Installing only mythfrontend on Ubuntu

Harry Devine lifter89 at comcast.net
Thu Jan 6 00:07:11 UTC 2011


On 01/03/2011 07:43 PM, R. G. Newbury wrote:
> On 01/03/2011 07:21 PM, Harry Devine wrote:
>> On 01/03/2011 06:42 PM, John Drescher wrote:
>>>> OK, I was able to get it installed. Now when I run it, I get the 
>>>> "Cannot
>>>> log in" error. I'm putting in my master backend's IP address. Is this
>>>> not
>>>> correct? I've always had a combined BE/FE until now, and I'm adding 
>>>> this
>>>> occassional frontend.
>>>>
>>> When you setup the backend did you have it listen on 127.0.0.1 or
>>> localhost instead of the external ip address?
>>>
>>> John
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>
>> Nope. I used 192.168.1.200 and not localhost or 127.0.0.1.
>
> This is actually a mysql error. The usual setup is 'mythtv at localhost': 
> mysql only accepts a login from localhost.
>
> You need a remote user which is allowed to use the mysql server on 
> what is now a remote BE.
>
> Amend this as required to replace localhost with the new FE's name. 
> Remember to amend the /etc/hosts file on the BE, so it can resolve the 
> name:
> ****************
> CREATE DATABASE IF NOT EXISTS mythconverg;
> GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
> FLUSH PRIVILEGES;
> GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost 
> IDENTIFIED BY "mythtv";
> FLUSH PRIVILEGES;
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE 
> utf8_general_ci;
> *****************
>
> Save it as mc.sql, and call it (on the BE machine as the root mysql 
> user) using:
>
> #mysql -u root -p < mc.sql
>
> After this, if you log in to mysql as root, and do:
>
> mysql> use mysql;
> mysql> select host,user,password from user;
>
> You will see ALL of the allowed users and the hosts from which they 
> are allowed to contact the mysql server. If the users use the same 
> password, it will show up as the same hashed value.
>
> Geoff
>
>
>
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
I just upgraded my laptop to 0.24 (its what I'm trying to get the new 
mythfrontend working on).  I did what you suggested above, but I still 
can't login to the BE using "mysql -u mythtv -p -h 192.168.1.200".  On 
the master BE, when I examine the user table, I get the following:

mysql> select host,user,password from user;
+---------------+------------------+-------------------------------------------+
| host          | user             | 
password                                  |
+---------------+------------------+-------------------------------------------+
| localhost     | root             | 
*D874BA45BF4C7839679016184F6DEDAA604D15F4 |
| king          | root             | 
*D874BA45BF4C7839679016184F6DEDAA604D15F4 |
| 127.0.0.1     | root             | 
*D874BA45BF4C7839679016184F6DEDAA604D15F4 |
| localhost     | debian-sys-maint | 
*202BB8560091FA4A1F40203C4A6D9A4FA68A6931 |
| localhost     | mythtv           | 
*A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
| %             | mythtv           | 
*A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
| localhost     | phpmyadmin       | 
*CE7ADEA6DBCF7D159F5A1E59B6A902BED60419AE |
| 192.168.1.105 | mythtv           | 
*CC8F35F587CA5A556B4132C2407E556D92172FFC |
+---------------+------------------+-------------------------------------------+
8 rows in set (0.00 sec)


It looks like it should be allowing access from my laptop, but 
apparently its not.  So what should I do from here to get this working?

Thanks,
Harry



More information about the mythtv-users mailing list