[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
>>> http://www.gossamer-threads.com/lists/mythtv/users/402902
>>> I need to change it to 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=, 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',
> '', null);

Or better, use MythXML:

wget -O result.xml 

(just change the value for my_host)


More information about the mythtv-users mailing list