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

[Steven Adeff]

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