<div dir="ltr">On Sat, Jul 13, 2013 at 3:46 AM, Enno Middelberg <span dir="ltr"><<a href="mailto:enno.middelberg@gmail.com" target="_blank">enno.middelberg@gmail.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hello, and apologies for the delayed reply.<br>
<br>
Both /etc/mythtv/config.xml and /home/enno/.mythtv/config.xml have the<br>
same user/password combination, which is mythtv/mythtv.<br>
<br>
<br>
The data base still exists at /var/lib/mysql - it must be possible to<br>
tell the backend where it is!<br>
<br>
<br>
Cheers,<br>
<br>
Enno<br>
<br>
<br>
<br>
2013/7/12 Thomas Mashos <<a href="mailto:thomas@mashos.com">thomas@mashos.com</a>>:<br>
> On Thu, Jul 11, 2013 at 3:00 PM, Mike Perkins <<a href="mailto:mikep@randomtraveller.org.uk">mikep@randomtraveller.org.uk</a>><br>
> wrote:<br>
>><br>
>> On 11/07/13 18:48, Thomas Mashos wrote:<br>
>>><br>
>>> On Thu, Jul 11, 2013 at 10:42 AM, Enno Middelberg<br>
>>> <<a href="mailto:enno.middelberg@gmail.com">enno.middelberg@gmail.com</a><br>
>>>><br>
>>>> wrote:<br>
>>><br>
>>><br>
>>>> Hello,<br>
>>>><br>
>>>><br>
>>>> 2013/7/10 Jon Heizer <<a href="mailto:jheizer@gmail.com">jheizer@gmail.com</a>>:<br>
>>>>>>><br>
>>>>>>> $ mysql -u root mythconverg<br>
>>>>>>> mysql> grant all on mythconverg.* to mythtv@"%" identified by<br>
>>>><br>
>>>> "mythtv";<br>
>>>>>>><br>
>>>>>>> mysql> flush privileges;<br>
>>>>>><br>
>>>>>><br>
>>>>>> I tried this, but didn't go anywhere:<br>
>>>><br>
>>>><br>
>>>> Ok, so I have tried this now:<br>
>>>><br>
>>>> mysql -u root -p mythconverg<br>
>>>> Enter password:<br>
>>>> Reading table information for completion of table and column names<br>
>>>> You can turn off this feature to get a quicker startup with -A<br>
>>>><br>
>>>> Welcome to the MySQL monitor. Commands end with ; or \g.<br>
>>>> Your MySQL connection id is 121<br>
>>>> Server version: 5.5.28-1 (Debian)<br>
>>>><br>
>>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights<br>
>>>> reserved.<br>
>>>><br>
>>>> Oracle is a registered trademark of Oracle Corporation and/or its<br>
>>>> affiliates. Other names may be trademarks of their respective<br>
>>>> owners.<br>
>>>><br>
>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
>>>> statement.<br>
>>>><br>
>>>> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>
>>>> Query OK, 0 rows affected (0.00 sec)<br>
>>>><br>
>>>> mysql> flush privileges;<br>
>>>> Query OK, 0 rows affected (0.00 sec)<br>
>>>><br>
>>>> mysql> quit<br>
>>>><br>
>>>><br>
>>>> sudo /etc/init.d/mysql restart<br>
>>>> [sudo] password for enno:<br>
>>>> [ ok ] Stopping MySQL database server: mysqld.<br>
>>>> [ ok ] Starting MySQL database server: mysqld ..<br>
>>>> [info] Checking for tables which need an upgrade, are corrupt or were<br>
>>>> not closed cleanly..<br>
>>>><br>
>>>> sudo /etc/init.d/mythtv-backend restart<br>
>>>> Restarting MythTV server: mythbackend No /usr/bin/mythbackend found<br>
>>>> running; none killed.<br>
>>>> .<br>
>>>> .<br>
>>>><br>
>>>> Cannot login to database<br>
>>>><br>
>>>> Would you like to configure the database connection now? [no]<br>
>>>> [console is not interactive, using default 'no']<br>
>>>><br>
>>>><br>
>>>><br>
>>>> So this looks pretty much like what I had started with. What can I do<br>
>>>> to get this going?<br>
>>>><br>
>>><br>
>>><br>
>>> Might want to set the password for the mythtv user in the database, then<br>
>>> fix it in config.xml<br>
>>><br>
>> That's what the "grant all" operation does. It sets the password for the<br>
>> mythtv user to "mythtv".<br>
>><br>
>> Now I recall that ubuntu, like debian, likes to think up some new password<br>
>> combination when you install mythtv. Perhaps that's what happened here.<br>
>><br>
>> --<br>
>><br>
>> Mike Perkins<br>
>><br>
>> _______________________________________________<br>
>> mythtv-users mailing list<br>
>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
>> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
><br>
><br>
> You're right, I didn't look up the password change syntax as I thought I<br>
> remembered it correctly. Whoops.<br>
><br>
> The password is only set on install for the mythtv user, shouldn't be reset.<br>
> And even then, he manually reset the password on it (which IMO is the wrong<br>
> way to do it on ubuntu/debian). Perhaps he should check<br>
> /home/mythtv/.mythtv/config.xml and see if the right password exists there.<br>
><br>
> Thanks,<br>
><br>
> Thomas Mashos<br>
><br>
><br>
><br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">That was not a typo. I'd assume that the user that runs the backend is the 'mythtv' user. Please check the settings for the mythtv user, which is at <span style="font-size:13px;font-family:arial,sans-serif">/home/mythtv/.mythtv/config.</span><span style="font-size:13px;font-family:arial,sans-serif">xml</span></div>
<div class="gmail_extra"><span style="font-size:13px;font-family:arial,sans-serif"><br></span></div><div class="gmail_extra"><font face="arial, sans-serif">If those credentials are the same. Are you able to login to mysql at the command line using those credentials with something like</font></div>
<div class="gmail_extra"><font face="arial, sans-serif"><br></font></div><div class="gmail_extra"><font face="arial, sans-serif">mysql -u mythtv -p mythconverg</font></div><div class="gmail_extra"><div class="gmail_extra">
<br clear="all"><div>Thanks,<br><br>Thomas Mashos</div></div></div><div class="gmail_extra"><br></div></div>