News:

Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com

Main Menu

Access denied for user 'mythtv'@'localhost' (using password: YES)

Started by nite_man, February 03, 2008, 09:31:26 PM

Previous topic - Next topic

nite_man

Hi,

Try to play with 0710 beta 3 and have a problem with mythtv. It says
Access denied for user 'mythtv'@'localhost' (using password: YES)
I suspect that it cause the problem with rebuilding MD image. The process waits something. According to Dan's post it might be because router is locked by mythbackend starting script.

BTW, I choose VDR as a media center. Why router tried to run mythtvbackend?
Michael Stepanov,
My setup: [url="http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup"]http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup[/url]
Russian LinuxMCE community: [url="http://linuxmce.ru"]http://linuxmce.ru[/url]

nite_man

Moreover, mythweb also doesn't work anymore because access to the database is denied.
Michael Stepanov,
My setup: [url="http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup"]http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup[/url]
Russian LinuxMCE community: [url="http://linuxmce.ru"]http://linuxmce.ru[/url]

domotiqa.com

[url="http://www.domotiqa.com"]http://www.domotiqa.com[/url] - home automation

juargin

I had the same problem. It appeared as if the upgrade (I used the amd64 dvd to upgrade from i386 704) did not fully register the myth password. I fixed it by changing the password used by mythtv in the following places:

On the command line, log in to mysql and run the following commands (changing 'password' to something else.):
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by "password";
mysql> flush privileges;

mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by "password";
mysql> flush privileges;

Then edit /etc/mythtv/mysql.txt and change the following line:
DBPassword=password
replacing the 'password' with your selected password.

And finally edit /etc/mythtv/mythweb.htaccess and change the following line:
setenv db_password     "password"
again replacing the 'password' with your password.

Finally reboot the system. This jump started mythtv and allowed mythweb to work as well for me.

nite_man

Thanks a lot, juargin! I think that my problem is similar to your. I'll try to fix it according to your suggestions tonight.
Michael Stepanov,
My setup: [url="http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup"]http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup[/url]
Russian LinuxMCE community: [url="http://linuxmce.ru"]http://linuxmce.ru[/url]

domotiqa.com

When I'm starting mythtvbackend from the Kde menu, I have to choose the langage, then the db parameters for my sql db !
I put root and blank password, and everything goes well now !
[url="http://www.domotiqa.com"]http://www.domotiqa.com[/url] - home automation

nite_man

I grant permissions as juargin suggested and now mythtv starts ok.
Michael Stepanov,
My setup: [url="http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup"]http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup[/url]
Russian LinuxMCE community: [url="http://linuxmce.ru"]http://linuxmce.ru[/url]

infaze3

Juargin

Why can't I find the file mythweb.htaccess?

"And finally edit /etc/mythtv/mythweb.htaccess and change the following line:"

In the /mythtv/ folder there is a file mythweb-htaccess but file type is unknown.

Any suggestions?

Thanks

710B3 DVD installation, ASUS M2N-VM, AMD 4400X2, Hdhomerun

Zaerc

Quote from: domotiqa.com on February 05, 2008, 02:59:59 PM
When I'm starting mythtvbackend from the Kde menu, I have to choose the langage, then the db parameters for my sql db !
I put root and blank password, and everything goes well now !

Eventhough that works, it is not the correct way to fix this problem. 

Quote from: infaze3 on February 26, 2008, 05:52:39 AM
Juargin

Why can't I find the file mythweb.htaccess?

"And finally edit /etc/mythtv/mythweb.htaccess and change the following line:"

In the /mythtv/ folder there is a file mythweb-htaccess but file type is unknown.

Any suggestions?

Thanks

710B3 DVD installation, ASUS M2N-VM, AMD 4400X2, Hdhomerun

I only see a "mythweb-htaccess" as well, try editing that one instead.  Maybe "mythweb.htaccess" was changed recently or it could have been a type-o, I don't know.
"Change is inevitable. Progress is optional."
-- Anonymous

[url=http://petition.stopsoftwarepatents.eu/181001941347/][/url]

infaze3

When I try to edit /etc/mythtv/mythweb-htaccess I am denied permission.
I am using a fresh install so the passwords should be default.
Can you suggest how I can get the permissions to edit this file?

Thanks

orionsune

sudo vi /etc/mythtv/mythweb-htaccess
gives you access denied?
entia non sunt multiplicanda praeter necessitatem