<div class="gmail_quote">On Fri, Oct 5, 2012 at 5:38 PM, Thomas Mashos <span dir="ltr"><<a href="mailto:thomas@mashos.com" target="_blank">thomas@mashos.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On Fri, Oct 5, 2012 at 3:34 PM, Andrew <<a href="mailto:mythtv@heathsworld.com">mythtv@heathsworld.com</a>> wrote:<br>
> On Fri, Oct 5, 2012 at 4:01 PM, Thomas Mashos <<a href="mailto:thomas@mashos.com">thomas@mashos.com</a>> wrote:<br>
>><br>
>> On Wed, Oct 3, 2012 at 7:53 AM, Steven Adeff <<a href="mailto:adeffs.mythtv@gmail.com">adeffs.mythtv@gmail.com</a>><br>
>> wrote:<br>
>> > On Wed, Oct 3, 2012 at 9:28 AM, Martin Moores <<a href="mailto:moores.martin@gmail.com">moores.martin@gmail.com</a>><br>
>> > wrote:<br>
>> >> On 3 October 2012 14:17, Matt Emmott <<a href="mailto:memmott@gmail.com">memmott@gmail.com</a>> wrote:<br>
>> >>><br>
>> >>> I believe that starting with 0.26 the mysql.txt is no longer used.<br>
>> >><br>
>> >><br>
>> >> Thanks Matt.<br>
>> >><br>
>> >> Your quite right and I remember reading about this on the list, just<br>
>> >> couldn't find the threads.<br>
>> >><br>
>> >> So I looked in config.xml as well, replacement for mysql.txt. The<br>
>> >> password<br>
>> >> was wrong in there, so I updated that, but still the same error<br>
>> >> message. I<br>
>> >> also tried some different "host" values (127.0.0.1, 192.168.10.12,<br>
>> >> localhost), but that didn't help either.<br>
>> >><br>
>> >> Cheers<br>
>> ><br>
>> > it's a packaging issue with Ubuntu. you have to manually edit the<br>
>> > post-install script for the mythdatabase package with your specific<br>
>> > information. I put it in manually as I didn't want to take the time to<br>
>> > figure out how they're "extracting" the info. It's really quite<br>
>> > annoying.<br>
>> ><br>
>> ><br>
>> > --<br>
>> > Steve<br>
>> > <a href="http://www.mythtv.org/wiki/User:Steveadeff" target="_blank">http://www.mythtv.org/wiki/User:Steveadeff</a><br>
>> > Before you ask, read the FAQ!<br>
>> > <a href="http://www.mythtv.org/wiki/Frequently_Asked_Questions" target="_blank">http://www.mythtv.org/wiki/Frequently_Asked_Questions</a><br>
>> > then search the Wiki, and this list,<br>
>> > <a href="http://www.gossamer-threads.com/lists/mythtv/" target="_blank">http://www.gossamer-threads.com/lists/mythtv/</a><br>
>> > Mailinglist etiquette -<br>
>> > <a href="http://www.mythtv.org/wiki/Mailing_List_etiquette" target="_blank">http://www.mythtv.org/wiki/Mailing_List_etiquette</a><br>
>> > _______________________________________________<br>
>> > mythtv-users mailing list<br>
>> > <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
>> > <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
>><br>
>><br>
>> I'm completely unable to reproduce the issue using a fresh 12.04.1<br>
>> install (upgraded using default repos), enabling 0.26 repo, then doing<br>
>> an upgrade there. So it would seem to me that it is not a packaging<br>
>> issue. The code you are questioning is as follows<br>
>><br>
>><br>
>> CONFIG=/etc/mythtv/config.xml<br>
>> if [ -e $CONFIG ]; then<br>
>> db_set mythtv/mysql_mythtv_dbname "`xpath -q -e<br>
>> 'string(//DBName)' $CONFIG 2>/dev/null`"<br>
>> db_set mythtv/mysql_mythtv_user "`xpath -q -e<br>
>> 'string(//DBUserName)' $CONFIG 2>/dev/null`"<br>
>> db_set mythtv/mysql_mythtv_password "`xpath -q -e<br>
>> 'string(//DBPassword)' $CONFIG 2>/dev/null`"<br>
>> db_set mythtv/mysql_host "`xpath -q -e 'string(//DBHostName)'<br>
>> $CONFIG 2>/dev/null`"<br>
>> fi<br>
>><br>
>><br>
>> Which says to read the /etc/mythtv/config.xml file and set the value<br>
>> to what is returned (and throw away error messages). So if you run the<br>
>> following commands and don't get returns of your DBName, DBUserName,<br>
>> DBPassword, and DBHostName, then there is something wrong with your<br>
>> config.xml file.<br>
>><br>
>> xpath -q -e 'string(//DBName)' /etc/mythtv/config.xml 2>/dev/null<br>
>> xpath -q -e 'string(//DBUserName)' /etc/mythtv/config.xml 2>/dev/null<br>
>> xpath -q -e 'string(//DBPassword)' /etc/mythtv/config.xml 2>/dev/null<br>
>> xpath -q -e 'string(//DBHostName)' /etc/mythtv/config.xml 2>/dev/null<br>
>><br>
>><br>
>> For instance, on this VM I just setup, I get<br>
>><br>
>> thomas@tmashos-testboxen5:~$ xpath -q -e 'string(//DBName)'<br>
>> /etc/mythtv/config.xml 2>/dev/null<br>
>> mythconverg<br>
>> thomas@tmashos-testboxen5:~$ xpath -q -e 'string(//DBUserName)'<br>
>> /etc/mythtv/config.xml 2>/dev/null<br>
>> mythtv<br>
>> thomas@tmashos-testboxen5:~$ xpath -q -e 'string(//DBPassword)'<br>
>> /etc/mythtv/config.xml 2>/dev/null<br>
>> Nal0pMRh<br>
>> thomas@tmashos-testboxen5:~$ xpath -q -e 'string(//DBHostName)'<br>
>> /etc/mythtv/config.xml 2>/dev/null<br>
>> localhost<br>
>> thomas@tmashos-testboxen5:~$<br>
>><br>
>> Thanks,<br>
>><br>
>> Thomas Mashos<br>
>> _______________________________________________<br>
>> mythtv-users mailing list<br>
>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
>> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
><br>
><br>
><br>
> It bit me big time and is the exact error in the start of this thread.<br>
> 12.04.1 LTS. Still haven't got it to work....<br>
><br>
><br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
><br>
<br>
</div></div>Did you verify that the 4 commands I posted return appropriate values?<br>
Did you test logging into mysql with all 4 of those values?<br>
<div class="HOEnZb"><div class="h5"><br>
Thanks,<br>
<br>
Thomas Mashos<br></div></div></blockquote><div><br></div><div>Thomas,</div><div><br></div><div>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.</div>
<div><br></div><div>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.</div><div><br></div><div>Andrew</div></div><br>