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

[Andrew]

On Fri, Oct 5, 2012 at 5: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
>

Thomas,

I just came back to this and saw the posts about the config.xml not being
upgraded.  I went into that config and noticed it didn't copy my current
settings there and the L:/P: was mythtv/mythtv when it should have been
mythtv/mythconverg.  It's been mythtv/mythconverg as long as I can remember
for the default install so I just edited the config.xml back to my settings
and it worked.

The only problem I have now is that I had to change my host setting to
127.0.0.1 from the age old 192.168.0.1 setting i've had to connect to the
DB.

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121007/25251113/attachment.html>