[mythtv-users] 0.26 upgrade "no database selected"
Steven Adeff
adeffs.mythtv at gmail.com
Sat Oct 6 02:11:57 UTC 2012
On Fri, Oct 5, 2012 at 10:06 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On Fri, Oct 5, 2012 at 9:45 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>> 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.
>>
>
> upgrade went fine this time, however, I still get this:
>
> Oct 5 19:04:31 MythCenter mythlogserver: mythbackend[29430]: E
> CoreContext mythdbcon.cpp:217 (OpenDatabase) Driver error was
> [1/1045]:#012QMYSQL: Unable to connect#012Database error
> was:#012Access denied for user 'mythtv'@'localhost' (using password:
> YES)
>
> mysql -u mythtv -p mythconverg
> using the password in config.xml works fine however.
>
if I replace the fields with the previous ones (like I show above) the
backend starts.
so mythbackend likes the "old" style, but the upgrade script likes
what you listed...
--
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