<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>RESOLVED<br><br>Turns out that mysql config - specifically host config - was the problem. Even though I had:<br> setenv db_server "localhost"<br><br>in the mythweb.conf file apache2 would not connect via localhost. So even though my mysql mythtv user config was:<br>host | user<br>.......................................<br>localhost | mythtv<br>192.168.1.% | mythtv<br>192.168.0.% | mythtv<br>mark-ep35-ds3 | mythtv <br><br>It failed to authenticate.<br><br>I had trawled through a lot of google material over the last several hours but vaguely recalled someone complaining that apache2 was reporting local host connections on 127.0.1.1 so I added additional mythtv hosts as follows:<br><br><pre>create user 'mythtv'@'127.0.0.%' identified by 'mythtv';
create user 'mythtv'@'127.0.1.%' identified by 'mythtv';
set password for 'mythtv'@'127.0.0.%' = password('mythtv');
set password for 'mythtv'@'127.0.1.%' = password('mythtv');
connect mythconverg;
grant all privileges on *.* to 'mythtv'@'127.0.0.%' with grant option;
grant all privileges on *.* to 'mythtv'@'127.0.1.%' with grant option;
flush privileges;
exit;</pre>And that was that, site came up straight away.<br><br>And just to add some icing to that cake I got a warning straight away that /mythweb/data/tv_icons/ directory was not writeable so a quick chmod 775 (group www-data that I had set previously) and all the icons appeared for the first time in my mythweb life.<br><br>I swear those icons have never looked so good.......<br> </div></body>
</html>