[11:47] <ComradeHaz`> Hi guys, how do I set my mythbackend database to accept connections from other frontends?
[12:01] <ComradeHaz`> OK, found it in mybuntu control center but when I check the appropriate box and press apply for the dialog that appears when I press apply, the control center crashes.
[12:15] <ComradeHaz`> http://pastebin.com/LHK15UJF
[12:15] <Zinn> [pastebin.com] tom@ares:~$ sudo mythbuntu-control-centre [sudo]
[12:16] <ComradeHaz`> I first tried running as 'me' and then as root, same thing happens.
[13:30] <ComradeHaz`> So I have now tried to configure the database manually as per http://www.mythtv.org/docs/mythtv-HOWTO-6.html but while being sure I have done all it suggests I still cannot access it
[13:30] <Zinn> [www.mythtv.org] MythTV, Open Source DVR
[13:32] <patdk-wk> ComradeHaz`, note second paragraph from the bottom
[13:33] <ComradeHaz`> patdk-wk: noted. Done.
[13:33] <patdk-wk> netstat -atnp | grep mysql, shows what?
[13:34] <ComradeHaz`> tom@ares:~$ netstat -atnp | grep mysql
[13:34] <ComradeHaz`> (Not all processes could be identified, non-owned process info
[13:34] <ComradeHaz`>  will not be shown, you would have to be root to see it all.)
[13:35] <patdk-wk> heh, guess you not root
[13:35] <patdk-wk> sudo netstat -atnp | grep mysql, shows what?
[13:35] <ComradeHaz`> tcp        0      0 10.0.0.6:3306           0.0.0.0:*               LISTEN      2779/mysqld
[13:35] <ComradeHaz`> Sorry, stupid
[13:35] <patdk-wk> your telling your frontend to access it via 10.0.0.6 for mysql?
[13:35] <ComradeHaz`> Correct.
[13:35] <patdk-wk> any firewall configured?
[13:35] <ComradeHaz`> No.
[13:36] <patdk-wk> sudo iptables -L -nv, is blank?
[13:36] <ComradeHaz`> Not blank, but looks uninteresting.
[13:37] <patdk-wk> well, should only be like 3 lines of stuff
[13:37] <patdk-wk> or was it 6, forget
[13:37] <ComradeHaz`> 3 pairs.
[13:37] <ComradeHaz`> INPUT, FORWARD, OUTPUT
[13:37] <patdk-wk> hmm
[13:38] <ComradeHaz`> indeed, 'tis most odd.
[13:39] <ComradeHaz`> The my.cnf config file mentions machines running apparmor may need to mess with another file
[13:40] <ComradeHaz`> I've looked at the file it mentions, it doesn't seem to be the sort of thing that's applicable
[13:40] <patdk-wk> dunno, I don't use apparmor
[13:40] <ComradeHaz`> I believe it is standard on mythbuntu installs
[13:40] <patdk-wk> apparmor is standard on ubuntu installs
[13:41] <ComradeHaz`> well, I installed mythbuntu and I have it
[13:41] <ComradeHaz`> and have certainly not added it myself
[13:41] <ComradeHaz`> but as I say, I really don't think the issue lays with that
[13:42] <ComradeHaz`> skip-external-locking
[13:42] <ComradeHaz`> #
[13:42] <ComradeHaz`> # Instead of skip-networking the default is now to listen only on
[13:42] <ComradeHaz`> # localhost which is more compatible and is not less secure.
[13:42] <ComradeHaz`> bind-address            = 10.0.0.6
[13:42] <patdk-wk> oh ya heh, /etc/hosts.allow
[13:42] <ComradeHaz`> That of any interest?
[13:42] <patdk-wk> someone had this issue yesterday, and hosts.allow was blocking it
[13:42] <patdk-wk> mysql on my machine doesn't use hosts.allow :)
[13:43] <ComradeHaz`> Oh?
[13:44] <ComradeHaz`> man hosts_allow
[13:44] <ComradeHaz`> gah
[13:44] <patdk-wk> mysqld: ALL: ALL
[13:44] <patdk-wk> probably
[13:44] <patdk-wk> then restart mysql
[13:45] <ComradeHaz`> Seems not
[13:54] <ComradeHaz`> grr, this is hellish frustrating
[14:03] <patdk-wk> well, worst case
[14:04] <ComradeHaz`> Google is NOT being my friend :/
[14:04] <patdk-wk> run tcpdump -n port 3306
[14:04] <patdk-wk> on your mysql machine
[14:04] <patdk-wk> and see if the frontend every attempts to connect or not
[14:04] <patdk-wk> or look at the frontend logs and see what it says is the error messages
[14:06] <ComradeHaz`> Hmm, looks like Access denied
[14:06] <ComradeHaz`> % mysql -h 10.0.0.6 -u mythtv -p
[14:06] <ComradeHaz`> Enter password:
[14:06] <ComradeHaz`> ERROR 1045 (28000): Access denied for user 'mythtv'@'10.0.0.1' (using password: YES)
[14:06] <patdk-wk> that would be a mysql user error then, a grant issue
[14:07] <ComradeHaz`> Hmm? Meaning what?
[14:07] <patdk-wk> that page you posted
[14:07] <patdk-wk> those grant/flush lines
[14:07] <ComradeHaz`> Yer?
[14:07] <patdk-wk> grant all on mythconverg.* to mythtv@"10.%" identified by "mythtv_user_password"; flush privileges;
[14:11] <ComradeHaz`> still not working.
[14:11] <ComradeHaz`> or do you mean I should specify the password there?
[14:14] <patdk-wk> you should put the password you are using there
[14:18] <ComradeHaz`> If I put in the hosts allow file what you suggested, I get ERROR 1045 (28000): Access denied for user 'mythtv'@'10.0.0.1' (using password: YES)
[14:19] <ComradeHaz`> Incorrect, Sorry.
[14:19] <ComradeHaz`> If I put in the hosts allow file what you suggested, I get: "ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0"
[14:20] <ComradeHaz`> If I put "ALL: 10.0.0.1" (my clients IP) I get "ERROR 1045 (28000): Access denied for user 'mythtv'@'10.0.0.1' (using password: YES)" whatever I specify as the 'identified by' value
[14:21] <ComradeHaz`> So I am inclined to think leaving in hosts.allow "ALL: 10.0.0.1" and concentrate on the value for identified by
[14:26] <ComradeHaz`> OK
[14:26] <ComradeHaz`> All on local machine:
[14:27] <ComradeHaz`> tom@ares:~$ mysql -u mythtv -p WORKS
[14:27] <ComradeHaz`> tom@ares:~$ mysql -h 10.0.0.6 -u mythtv -p DOESN'T WORK
[14:27] <patdk-wk> hosts allow again :)
[14:27] <ComradeHaz`> tom@ares:~$ mysql -h localhost -u mythtv -p WORKS
[14:28] <patdk-wk> ALL: 10.0.0.6
[14:28] <ComradeHaz`> Ah.
[14:29] <ComradeHaz`> Situations still as above.
[14:31] <ComradeHaz`> Meh, I really need to stop playing with this now.
[14:31] <ComradeHaz`> If you have any brilliant ideas let me know!
[14:32] <ComradeHaz`> Thanks for your help so far! :)
[14:33] <patdk-wk> heh
[14:34] <patdk-wk> I dunno, I am so used to doing things manually
[14:34] <patdk-wk> and mysql is one of those things I take out of ubuntu control and into my own