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

Sat Oct 6 01:32:16 UTC 2012

On Fri, Oct 5, 2012 at 4:54 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On Fri, Oct 5, 2012 at 6:38 PM, Thomas Mashos <thomas at mashos.com> wrote:
>> On Fri, Oct 5, 2012 at 3:34 PM, Andrew <mythtv at heathsworld.com> wrote:
>>> On Fri, Oct 5, 2012 at 4:01 PM, Thomas Mashos <thomas at mashos.com> wrote:
>>>>
>>>> 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
>>>> _______________________________________________
>>>> mythtv-users mailing list
>>>> mythtv-users at mythtv.org
>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>
>>>
>>>
>>> It bit me big time and is the exact error in the start of this thread.
>>> 12.04.1 LTS.  Still haven't got it to work....
>>>
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>
>>
>> Did you verify that the 4 commands I posted return appropriate values?
>> Did you test logging into mysql with all 4 of those values?
>>
>> Thanks,
>>
>> Thomas Mashos
>
> I wonder if it has to do with /etc/mythtv/config.xml not being "upgraded"?
>
> --
> 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

Ok, now you're just guessing. That doesn't make any sense, your DB
credentials don't change during an upgrade, so there wouldn't be any
reason to "upgrade" the file. Further, as I've said before, on a clean
install the upgrade works fine, so it's something specific to your
system.

I'll ask again, this time to you. Did you verify that the 4 commands I
posted return appropriate values? Did you test logging into mysql with
all 4 of those values?

If I were to guess what may have happened, it's that at some point in
the past you reset your DB info and didn't update
/etc/mythtv/config.xml, and because mythtv no longer uses mysql.txt in
0.26 you are just now seeing the issue on package upgrade.

Thanks,

Thomas Mashos