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

[Thomas Mashos]

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