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

[Andrew]

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....
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121005/211d40ae/attachment-0001.html>