[mythtv-users] 0.26 upgrade "no database selected"

[Thomas Mashos]

On Wed, Oct 3, 2012 at 7:53 AM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On Wed, Oct 3, 2012 at 9:28 AM, Martin Moores <moores.martin at gmail.com> wrote:
>> On 3 October 2012 14:17, Matt Emmott <memmott at gmail.com> wrote:
>>>
>>> I believe that starting with 0.26 the mysql.txt is no longer used.
>>
>>
>> Thanks Matt.
>>
>> Your quite right and I remember reading about this on the list, just
>> couldn't find the threads.
>>
>> So I looked in config.xml as well, replacement for mysql.txt.  The password
>> was wrong in there, so I updated that, but still the same error message.  I
>> also tried some different "host" values (127.0.0.1, 192.168.10.12,
>> localhost), but that didn't help either.
>>
>> Cheers
>
> it's a packaging issue with Ubuntu. you have to manually edit the
> post-install script for the mythdatabase package with your specific
> information. I put it in manually as I didn't want to take the time to
> figure out how they're "extracting" the info. It's really quite
> annoying.
>
>
> --
> Steve
> http://www.mythtv.org/wiki/User:Steveadeff
> Before you ask, read the FAQ!
> http://www.mythtv.org/wiki/Frequently_Asked_Questions
> then search the Wiki, and this list,
> http://www.gossamer-threads.com/lists/mythtv/
> Mailinglist etiquette - http://www.mythtv.org/wiki/Mailing_List_etiquette
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users


I'm completely unable to reproduce the issue using a fresh 12.04.1
install (upgraded using default repos), enabling 0.26 repo, then doing
an upgrade there. So it would seem to me that it is not a packaging
issue. The code you are questioning is as follows


CONFIG=/etc/mythtv/config.xml
if [ -e $CONFIG ]; then
    db_set mythtv/mysql_mythtv_dbname "`xpath  -q -e
'string(//DBName)' $CONFIG 2>/dev/null`"
    db_set mythtv/mysql_mythtv_user "`xpath  -q -e
'string(//DBUserName)' $CONFIG 2>/dev/null`"
    db_set mythtv/mysql_mythtv_password "`xpath  -q -e
'string(//DBPassword)' $CONFIG 2>/dev/null`"
    db_set mythtv/mysql_host "`xpath  -q -e 'string(//DBHostName)'
$CONFIG 2>/dev/null`"
fi


Which says to read the /etc/mythtv/config.xml file and set the value
to what is returned (and throw away error messages). So if you run the
following commands and don't get returns of your DBName, DBUserName,
DBPassword, and DBHostName, then there is something wrong with your
config.xml file.

xpath  -q -e 'string(//DBName)' /etc/mythtv/config.xml 2>/dev/null
xpath  -q -e 'string(//DBUserName)' /etc/mythtv/config.xml 2>/dev/null
xpath  -q -e 'string(//DBPassword)' /etc/mythtv/config.xml 2>/dev/null
xpath  -q -e 'string(//DBHostName)' /etc/mythtv/config.xml 2>/dev/null


For instance, on this VM I just setup, I get

thomas at tmashos-testboxen5:~$ xpath  -q -e 'string(//DBName)'
/etc/mythtv/config.xml 2>/dev/null
mythconverg
thomas at tmashos-testboxen5:~$ xpath  -q -e 'string(//DBUserName)'
/etc/mythtv/config.xml 2>/dev/null
mythtv
thomas at tmashos-testboxen5:~$ xpath  -q -e 'string(//DBPassword)'
/etc/mythtv/config.xml 2>/dev/null
Nal0pMRh
thomas at tmashos-testboxen5:~$ xpath  -q -e 'string(//DBHostName)'
/etc/mythtv/config.xml 2>/dev/null
localhost
thomas at tmashos-testboxen5:~$

Thanks,

Thomas Mashos