[mythtv-users] Mythbuntu 9.10 LCDServerHost able to edit in database?
Michael T. Dean
mtdean at thirdcontact.com
Fri Nov 6 21:41:38 UTC 2009
On 11/06/2009 03:57 PM, Douglas Mackay wrote:
> 2009/11/6 Douglas Mackay:
>> 2009/11/6 steve.goodey:
>>> I wonder if someone can help me please.
>>> Can anyone give me a clue about editing the entry LCDServerHost in the
>>> database? From this post
>>> I need to change it to 127.0.0.1. I have the userid and password for mysql
>>> but am unable to find the commands to allow editing of the required field,
>>> which does not appear to be editable in mythweb.
>> Thought it only me that had the problem. The LCDServerHost value might
>> not exist in you database (it didn't in mine).
>> In the settings table within the mythconverg database there are three
>> fields :- value, data, hostname so to add the LCDServerHost setting
>> you would create a new row with
>> value=LCDServerHost, data=127.0.0.1, hostname=<think this can be set
>> to null to apply to all hosts or you can specify an individual host>
>> I used phpMyAdmin to insert the value to the settings table however
>> you you should be able use the mysql tools to do the same.
> If you don't have phpMyAdmin installed it's probaly easier just to use
> mysql. The following should work :-
> mysql -u mythtv -p
> <enter password>
> use mythconverg;
> insert into settings (value,data,hostname) values ('LCDServerHost',
> '127.0.0.1', null);
Or better, use MythXML:
wget -O result.xml
(just change the value for my_host)
More information about the mythtv-users