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