Okay - so I notice that MySQL database isn't updating my recording file size correctly after I get done stripping out commercials because 'mythtv'@'localhost' doesn't seem to have access. So I google how to go into MySQL and add access and I find the following:



After I do this now I go to MythWeb and get:



So I look up .htaccess on the wiki (totally out of date for R5F1) and isn't helpful. I nano .htaccess in the /usr/share/mythtv/mythweb/ directory of which is also not very helpful. And I'm out of ideas... It appears that all recordings have stopped but the backend is online.

Any help would be greatly appreciated - I know I can do a reinstall and reconfigure everything - but I'd really rather not have to resort to that when this looks like a password adjustment somewhere.

i'm just guessing here, but give this a go:

ensure that you can access mysql using user mythtv and password mythtv:



that should just show some mysql version information and verfity that you can connect to the server. if you can't connect, you better fix this because it's likely that mythtv is not very functional at all.

also, check that /var/www/mythweb/.htaccess contains something similar to the following:



that's a start...

_________________
os: knoppmyth r5e50
mobo: asus p5pe-vm
cpu: intel celeron 2.66 d
memory: 256mb ddr ram
video: asus geforce 6200 agp
tuner: hauppauge pvr 150 mce
disk: seagate 250gb sata

trippin - I poked around for about 2 hours - gave up and re-installed. I'm going to do at home what I do at work and build a test box (basically mimic-ing the production/test environment) and play around with it in order to figure out how to mess around with MySQL. Eventually the test box will turn into a front end but at least I can figure out how to make stuff work. Thanks for the help.

if you want to get really crazy, try installing mySQL administrator and mySQL query browser....cool apps and great for snooping around. i haven't really used them for myth yet, but it's on my to-do list.

if you dont' want to install them on your myth box, you can connect remotely with them. just make sure that the mySQL server on the myth box is set to accept remote connections.

_________________
os: knoppmyth r5e50
mobo: asus p5pe-vm
cpu: intel celeron 2.66 d
memory: 256mb ddr ram
video: asus geforce 6200 agp
tuner: hauppauge pvr 150 mce
disk: seagate 250gb sata