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

[Martin Moores]

On 3 October 2012 21:15, Martin Moores <moores.martin at gmail.com> wrote:

>
> Steve,
>
> Thanks for the info.
>
> 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.
>
> 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.
>
> 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.
>
> Cheers
>


Well, think I have got to the bottom of everything now.  All seems to
evolve around the move from mysql.txt.

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:

mysql> grant all on mythconverg.* to 'mythtv'@'192.168.100.12' identified
by 'PASSWORDHERE';

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.

All seems fine now, thanks for the help, hope this is useful for someone
else.

Cheers

Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121003/dc39b1a8/attachment.html>