Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

mythweb not working after mysql password changed

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


scram69 at gmail

Jul 27, 2012, 10:49 PM

Post #1 of 5 (667 views)
Permalink
mythweb not working after mysql password changed

Hi all-

Changed the mysql password for mythtv user from the default "mythtv".
Frontends successfully connect using the new password. I can even log
into phpmyadmin using the new password.
I put the new password into
/usr/share/mythtv/mythweb/mythweb.conf.apache and restarted apache2.
However, mythweb still gives me the dreaded "Access denied for user
'mythtv'@'localhost' (using password: YES) [#1045]" page.

mythweb was working fine before the change (using the default "mythtv"
password in mythweb.conf.apache).

Is there another file lurking somewhere with the default password that
I need to go and edit?
--
________________________
"destroying the fundamental underpinnings of the broadcast television ecosystem"
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users


mythtv-users at lists

Jul 28, 2012, 1:26 AM

Post #2 of 5 (657 views)
Permalink
Re: mythweb not working after mysql password changed [In reply to]

scram69 wrote:
> Changed the mysql password for mythtv user from the default "mythtv".
> Frontends successfully connect using the new password. I can even log
> into phpmyadmin using the new password.
> I put the new password into
> /usr/share/mythtv/mythweb/mythweb.conf.apache and restarted apache2.
> However, mythweb still gives me the dreaded "Access denied for user
> 'mythtv'@'localhost' (using password: YES) [#1045]" page.
>
> mythweb was working fine before the change (using the default "mythtv"
> password in mythweb.conf.apache).
>
> Is there another file lurking somewhere with the default password that
> I need to go and edit?

Mythweb might take the password either from the config.xml or mysql.txt
in /etc/mythtv...

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users


myth797 at gmail

Jul 28, 2012, 3:43 AM

Post #3 of 5 (655 views)
Permalink
Re: mythweb not working after mysql password changed [In reply to]

On 28/07/12 06:49, scram69 wrote:
> Hi all-
>
> Changed the mysql password for mythtv user from the default "mythtv".
> Frontends successfully connect using the new password. I can even log
> into phpmyadmin using the new password.
> I put the new password into
> /usr/share/mythtv/mythweb/mythweb.conf.apache and restarted apache2.
> However, mythweb still gives me the dreaded "Access denied for user
> 'mythtv'@'localhost' (using password: YES) [#1045]" page.
>
> mythweb was working fine before the change (using the default "mythtv"
> password in mythweb.conf.apache).
>
> Is there another file lurking somewhere with the default password that
> I need to go and edit?
It's worth checking here:

/etc/apache2/sites-available/mythweb.conf
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users


scram69 at gmail

Jul 28, 2012, 8:21 AM

Post #4 of 5 (646 views)
Permalink
Re: mythweb not working after mysql password changed [In reply to]

On Sat, Jul 28, 2012 at 1:26 AM, Thomas Boehm
<mythtv-users [at] lists> wrote:
> scram69 wrote:
>> Changed the mysql password for mythtv user from the default "mythtv".
>> Frontends successfully connect using the new password. I can even log
>> into phpmyadmin using the new password.
>> I put the new password into
>> /usr/share/mythtv/mythweb/mythweb.conf.apache and restarted apache2.
>> However, mythweb still gives me the dreaded "Access denied for user
>> 'mythtv'@'localhost' (using password: YES) [#1045]" page.
>>
>> mythweb was working fine before the change (using the default "mythtv"
>> password in mythweb.conf.apache).
>>
>> Is there another file lurking somewhere with the default password that
>> I need to go and edit?
>
> Mythweb might take the password either from the config.xml or mysql.txt
> in /etc/mythtv...
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://www.mythtv.org/mailman/listinfo/mythtv-users

HI Thomas-
On my backend (Mythbuntu 12.04), those files appear to have been
auto-generated with the correct password when I changed the password
from the mysql command line ... yet mythweb still doesn't work.



--
________________________
"destroying the fundamental underpinnings of the broadcast television ecosystem"
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users


scram69 at gmail

Jul 28, 2012, 8:25 AM

Post #5 of 5 (648 views)
Permalink
Re: mythweb not working after mysql password changed [In reply to]

On Sat, Jul 28, 2012 at 3:43 AM, nemo <myth797 [at] gmail> wrote:
> On 28/07/12 06:49, scram69 wrote:
>>
>> Hi all-
>>
>> Changed the mysql password for mythtv user from the default "mythtv".
>> Frontends successfully connect using the new password. I can even log
>> into phpmyadmin using the new password.
>> I put the new password into
>> /usr/share/mythtv/mythweb/mythweb.conf.apache and restarted apache2.
>> However, mythweb still gives me the dreaded "Access denied for user
>> 'mythtv'@'localhost' (using password: YES) [#1045]" page.
>>
>> mythweb was working fine before the change (using the default "mythtv"
>> password in mythweb.conf.apache).
>>
>> Is there another file lurking somewhere with the default password that
>> I need to go and edit?
>
> It's worth checking here:
>
> /etc/apache2/sites-available/mythweb.conf
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://www.mythtv.org/mailman/listinfo/mythtv-users

Brilliant! That was the one. It appears in Mythbuntu, mythweb
ignores the correct password set in at least three other intuitive
locations, and will only connect to the DB if this file has the
correct password!
Thanks!
--
________________________
"destroying the fundamental underpinnings of the broadcast television ecosystem"
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.