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

Steven Adeff adeffs.mythtv at gmail.com
Sat Oct 6 01:45:03 UTC 2012 

On Fri, Oct 5, 2012 at 9:32 PM, Thomas Mashos <thomas at mashos.com> wrote:
> 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"?
>>
>
> 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,
>

$ more /etc/mythtv/config.xml
<Configuration>
  <Database>
    <PingHost>1</PingHost>
    <Host>127.0.0.1</Host>
    <UserName>mythtv</UserName>
    <Password>MX0mYIpH</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
  </Database>
  <WakeOnLAN>
    <Enabled>0</Enabled>
    <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
    <SQLConnectRetry>5</SQLConnectRetry>
    <Command>echo 'WOLsqlServerCommand not set'</Command>
  </WakeOnLAN>
</Configuration>


I never reset the DB info. the time stamp of my config.xml file is
from before my upgrade to 0.26, so that is what was in there before
and everything worked fine.

I'm going to try renaming the field names to what you show as being
what they should be and see if that fixes things.

-- 
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

More information about the mythtv-users mailing list