<div class="gmail_quote">On 3 October 2012 21:15, Martin Moores <span dir="ltr"><<a href="mailto:moores.martin@gmail.com" target="_blank">moores.martin@gmail.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="gmail_quote"><div class="im"></div><div><br>Steve,<br><br>Thanks for the info.<br><br>It did help, I got past that step eventually, although not straight away, lots of messing around and not sure what solved it in the end. I think I have mysql issues.<br>
<br>Just a general question, how many entries do people have for their mythtv user in mysql? For example, one for "localhost", "127.0.0.1", then one for remote frontends to connect? So another entry with the master backend's IP as host name? Maybe I'm doing this wrong.<br>
<br>Anyway, database updated when I entered mythtv-setup, then the local frontend updated the database again for myth music changes. Now, mythweb does not work and I cannot for the life of me get my remote frontend to connect. Not my best upgrade experience, might go back tot the backup I made this morning if I can't get things sorted tonight.<br>
<br>Cheers<br></div></div>
</blockquote></div><br><br>Well, think I have got to the bottom of everything now. All seems to evolve around the move from mysql.txt.<br><br>For the frontend connecting, it was Mysql users that was the issue, I had mythtv user added with "192.168.100.12" as the host, but I had not granted it full permissions on mythconverg. I think I had tidied these up after the upgrade, hence broke it. The following command did the trick:<br>
<br>mysql> grant all on mythconverg.* to 'mythtv'@'192.168.100.12' identified by 'PASSWORDHERE';<br><br>With mythweb, I'm not sure, but maybe it was getting its info from mysql.txt previously? Anyway, I had to edit /etc/apache2/sites-available/mythweb.conf and add my database details in there. Before that, I had to purge and remove php, apache2 and mythweb, as something else was screwed and was getting a 404 error when accessing mythweb.<br>
<br>All seems fine now, thanks for the help, hope this is useful for someone else.<br><br>Cheers<br><br>Martin<br>