| ComradeHaz` | Hi guys, how do I set my mythbackend database to accept connections from other frontends? | 11:47 |
|---|---|---|
| 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:01 |
| ComradeHaz` | http://pastebin.com/LHK15UJF | 12:15 |
| Zinn | [pastebin.com] tom@ares:~$ sudo mythbuntu-control-centre [sudo] | 12:15 |
| ComradeHaz` | I first tried running as 'me' and then as root, same thing happens. | 12:16 |
| 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:30 |
| patdk-wk | ComradeHaz`, note second paragraph from the bottom | 13:32 |
| ComradeHaz` | patdk-wk: noted. Done. | 13:33 |
| patdk-wk | netstat -atnp | grep mysql, shows what? | 13:33 |
| 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:34 |
| 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:35 |
| patdk-wk | sudo iptables -L -nv, is blank? | 13:36 |
| ComradeHaz` | Not blank, but looks uninteresting. | 13:36 |
| 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:37 |
| ComradeHaz` | indeed, 'tis most odd. | 13:38 |
| ComradeHaz` | The my.cnf config file mentions machines running apparmor may need to mess with another file | 13:39 |
| 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:40 |
| 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:41 |
| 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:42 |
| ComradeHaz` | Oh? | 13:43 |
| 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:44 |
| ComradeHaz` | Seems not | 13:45 |
| ComradeHaz` | grr, this is hellish frustrating | 13:54 |
| patdk-wk | well, worst case | 14:03 |
| 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:04 |
| 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:06 |
| 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:07 |
| ComradeHaz` | still not working. | 14:11 |
| ComradeHaz` | or do you mean I should specify the password there? | 14:11 |
| patdk-wk | you should put the password you are using there | 14:14 |
| 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:18 |
| 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:19 |
| 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:20 |
| 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:21 |
| ComradeHaz` | OK | 14:26 |
| ComradeHaz` | All on local machine: | 14:26 |
| 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:27 |
| patdk-wk | ALL: 10.0.0.6 | 14:28 |
| ComradeHaz` | Ah. | 14:28 |
| ComradeHaz` | Situations still as above. | 14:29 |
| ComradeHaz` | Meh, I really need to stop playing with this now. | 14:31 |
| ComradeHaz` | If you have any brilliant ideas let me know! | 14:31 |
| ComradeHaz` | Thanks for your help so far! :) | 14:32 |
| patdk-wk | heh | 14:33 |
| 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 | 14:34 |
| === hpeter_ is now known as hpeter | ||
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!