[mythtv-users] Mythweb - PHP Fatal Error

[Mark Perkins]

RESOLVED

Turns out that mysql config - specifically host config - was the problem. Even though I had:
            setenv db_server        "localhost"

in the mythweb.conf file apache2 would not connect via localhost. So even though my mysql mythtv user config was:
host                 | user
.......................................
localhost          | mythtv
192.168.1.%     | mythtv
192.168.0.%     | mythtv
mark-ep35-ds3 | mythtv  

It failed to authenticate.

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:

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;And that was that, site came up straight away.

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.

I swear those icons have never looked so good.......
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131219/6c6e5dc1/attachment.html>