[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