LinHES Forums
http://forums.linhes.org/

MythWeb - Database Access Denied - R5F1
http://forums.linhes.org/viewtopic.php?f=5&t=15411		 Page 1 of 1
Author:  whoa [ Tue May 29, 2007 10:11 am ]
Post subject:  MythWeb - Database Access Denied - R5F1
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:

Code:
mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;


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

Code:
Database Access Denied
You are most likely receiving this message because you
have failed to configure mythweb's database login info.

Please see .htaccess for instructions.


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.
Author:  imstr8trippin [ Tue May 29, 2007 9:56 pm ]
Post subject: 
i'm just guessing here, but give this a go:

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

Code:
mysqladmin -umythtv -pmythtv version


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:

Code:
        setenv db_server        "localhost"
        setenv db_name          "mythconverg"
        setenv db_login         "mythtv"
        setenv db_password      "mythtv"


that's a start...
Author:  whoa [ Thu May 31, 2007 5:38 am ]
Post subject: 
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.
Author:  imstr8trippin [ Thu May 31, 2007 6:39 am ]
Post subject: 
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.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/