[mythtv-users] what in the world is going on with database password??
Jim Abernathy
jfabernathy at gmail.com
Wed Oct 31 10:00:52 UTC 2018
On 10/30/18 11:27 PM, Bill Meek wrote:
> On 10/30/18 10:01 PM, James Abernathy 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.
>
> To be clear, ~mythtv/.mythtv/config.xml and ~/.mythtv/config.xml are
> linked to /etc/mythtv/config.xml
> not the other way around. Your blog has the correct format.
>
>> 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
>
> 1st, remove MythTV from the picture:
>
> mysql --host=localhost --user=mythtv --password=yourPasswordHere
> mythconverg
Using the password in /etc/mythtv/config.xml I get into the database
with the command above.
Jim A
>
> If that fails, it's a DB configuration issue.
>
> If it works, then I'd start here:
> https://www.mythtv.org/wiki/Config.xml#Troubleshooting
>
More information about the mythtv-users
mailing list