[mythtv-users] what in the world is going on with database password??

[Yann Lehmann]

Le 31 octobre 2018 11:39:15 Jim Abernathy <jfabernathy at gmail.com> a écrit :
>
> On 10/31/18 12:27 AM, Mark Perkins wrote:
>>
>>
>> On 31 October 2018 1:43:49 pm James Abernathy <jfabernathy at gmail.com> wrote:
>>> I’m now having problems with mythtv-setup not connecting to the database.  
>>> I’m following the instructions I documented in the following blog:
>>>
>>>
>>> https://mythtvinstall.blogspot.com/2018/10/creating-mythtv-v29-frontendbackend-on.html
>>>
>>>
>>> The first time I did this, no problems.  I complete started over again to 
>>> verify things. Since I link /etc/mythtv/config.xml to 
>>> $HOME/.mythtv/config.xml before I run mythtv-setup, I never had to look at 
>>> the database password.
>>>
>>>
>>> I ran mythtv-setup after setting up XMLTV json per the wiki as I’ve done 
>>> before and documented.  I had no problems connecting then, but after I 
>>> finished, I ran mythfilldatabase and it also bombed due to not connecting 
>>> with the database.  I tried mythtv-setup again and this time it couldn’t 
>>> connect.
>>>
>>>
>>> It’s like I follow the same instructions, but it randomly fails.
>>>
>>>
>>> when I run mythfilldatabase now I see this:
>>>
>>>
>>> 2018-10-30 22:57:55.639274 I  Start up testing connections. DB 
>>> 192.168.0.251, BE , attempt 0, status dbAwake
>>> 2018-10-30 22:57:56.641275 I  Start up testing connections. DB 
>>> 192.168.0.251, BE , attempt 1, status dbAwake
>>> 2018-10-30 22:58:01.650478 I  Start up testing connections. DB 
>>> 192.168.0.251, BE , attempt 2, status dbAwake
>>> 2018-10-30 22:58:06.659712 I  Start up testing connections. DB 
>>> 192.168.0.251, BE , attempt 3, status dbAwake
>>> 2018-10-30 22:58:11.668891 I  Start up testing connections. DB 
>>> 192.168.0.251, BE , attempt 4, status dbAwake
>>>
>>>
>>> Jim A
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>> MythTV Forums: https://forum.mythtv.org
>> I can't speak for Xubuntu, but vanilla install of mysql / mariadb sometimes 
>> only bind to localhost as it is default more secure. Have you checked for 
>> bind-address? Or:
>> netstat -peanut | grep 3306
> Okay, problem solved, but it brings up questions about what should be 
> changed when configuring the backend the first time. What I do and document 
> is changing General-> Primary IP to 192.168.0.250, which is the IP address 
> of the backend and LOCALHOST. I'm guessing that change now made it 
> important to change the #bind-address=:: to bind-address=::
> With that solved I ran the FE and it worked but had no guide data.  So I 
> ran mythtv-setup which stopped the BE then I exited and it asked about 
> running mythfilldatabase.  That failed due to me running mythtv-setup and 
> thereby mythfilldatabase as 'jim'.  I had configured XMLTV as 'mythtv'.
> So I ran mythfilldatabase as 'mythtv'. problem solved.
> This brings up what should be done to make this work all the time.
> 1. Either leave General -> Primary IP as 127.0.0.1 or always do the 
> bind-address=:: fix
> 2. When doing mythtv-setup as "jim" don't run mythfilldatabase as part of 
> exiting. Then sudo su mythtv and then run mythfilldatabase
> 3. Or do I run the XMLTV setup stuff as "jim" and then link all the .xmltv 
> stuff in /home/mythtv/.xmltv back to /home/jim/.xmltv
> #3 is a good idea IMHO. I always link the config file of xmltv from the 
> /home/user/.mythtv folder of the user performing maintenance on the backend 
> to the /home/mythtv/.mythtv folder. That way, mythfilldatase works for both 
> (or none if there is a problem).
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20181031/13bf6703/attachment.html>