| Tuesday, December 24th, 2013, 00:02 UTC | ||
| [00:02:37] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has quit (Remote host closed the connection) | |
| [00:30:39] | TimeWolf_ (TimeWolf_!~TimeWolf_@216.112.253.9) has joined #mythtv-users | |
| [00:36:30] | xris (xris!~xris@mythtv/developer/xris) has quit (Ping timeout: 252 seconds) | |
| [00:41:15] | xris (xris!~xris@50.245.128.9) has joined #mythtv-users | |
| [00:41:15] | xris (xris!~xris@50.245.128.9) has quit (Changing host) | |
| [00:41:16] | xris (xris!~xris@mythtv/developer/xris) has joined #mythtv-users | |
| [00:41:16] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v xris | |
| [00:52:39] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [01:02:04] | sailerboy (sailerboy!~sailerboy@2605:6400:2:fed5:22:3e62:d2e8:e4e1) has joined #mythtv-users | |
| [01:02:21] | sailerboy (sailerboy!~sailerboy@2605:6400:2:fed5:22:3e62:d2e8:e4e1) has quit (Remote host closed the connection) | |
| [01:03:34] | sailerboy (sailerboy!~sailerboy@2605:6400:2:fed5:22:3e62:d2e8:e4e1) has joined #mythtv-users | |
| [01:04:54] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [01:13:55] | SmallwoodDR82 (SmallwoodDR82!~Smallwood@unaffiliated/smallwooddr82) has joined #mythtv-users | |
| [01:14:27] | wsuetholz (wsuetholz!~Thunderbi@ip87.centonline.com) has quit (Ping timeout: 260 seconds) | |
| [01:26:25] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [01:26:36] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Remote host closed the connection) | |
| [01:30:59] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [01:32:12] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has quit (Read error: Connection reset by peer) | |
| [01:32:36] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has joined #mythtv-users | |
| [01:32:37] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v knightr | |
| [01:37:44] | Korny: | To bad that chuck guy isn't here anymore I could have told him an easy solution to his issue |
| [01:41:13] | Korny: | emit + mythlink == easy :/ |
| [01:48:16] | sjuk (sjuk!~sjuk@adsl-dyn-88-208-148-222.heliweb.de) has quit (Remote host closed the connection) | |
| [01:52:11] | Dave123_ (Dave123_!~Dave123@cpe-74-74-202-129.rochester.res.rr.com) has joined #mythtv-users | |
| [02:18:48] | BillK (BillK!~BillK-Fre@58-7-99-229.dyn.iinet.net.au) has quit (Ping timeout: 252 seconds) | |
| [02:23:50] | BillK (BillK!~BillK-Fre@124.149.111.175) has joined #mythtv-users | |
| [02:28:35] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@unaffiliated/j-e-f-f-a) has quit (Quit: Oh No!!!! ;-)) | |
| [02:29:48] | DavidBrooke: | wagnerrp: I have messed up something by using...grant all on mythconverg.* to mythtv@"abc" identified by "mythtv"; |
| [02:30:17] | DavidBrooke: | I'm getting the revolving language/database screens on my good setup now |
| [02:30:39] | wagnerrp: | if you're only granting new permissions, you can't screw up existing ones |
| [02:31:08] | DavidBrooke: | is that what I doing? I don't know |
| [02:31:22] | wagnerrp: | yes, that is what that command does |
| [02:32:09] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@unaffiliated/j-e-f-f-a) has joined #mythtv-users | |
| [02:33:19] | DavidBrooke: | I don't understand what is going on then |
| [02:33:27] | DavidBrooke: | very confused |
| [02:33:59] | DavidBrooke: | I have two setups on host abc |
| [02:34:21] | DavidBrooke: | one worked the other had the revolving language / database screens |
| [02:34:36] | DavidBrooke: | now they both have the same probleb |
| [02:34:42] | DavidBrooke: | problem |
| [02:34:56] | DavidBrooke: | after I issued the mysql command |
| [02:35:07] | wagnerrp: | two setups? |
| [02:35:14] | wagnerrp: | are you attempting to do dualhead or something? |
| [02:36:00] | DavidBrooke: | I have several partitons....one partition is my main use..."working"....the other are tests only |
| [02:37:43] | DavidBrooke: | today was the first time changing anything concernng mythtv... |
| [02:38:36] | buu: | DavidBrooke: Can you login using the mysql client? |
| [02:39:25] | DavidBrooke: | login....meaning ....mysql -u -p -h? |
| [02:42:25] | DavidBrooke: | using the above...no I can't login,,,access denied |
| [02:43:38] | wagnerrp: | try using the fqdn instead of just the hostname |
| [02:43:41] | wagnerrp: | try using the ip address |
| [02:44:16] | DavidBrooke: | this command again....grant all on mythconverg.* to mythtv@"abc" identified by "mythtv"; |
| [02:44:25] | wagnerrp: | yes |
| [02:44:33] | DavidBrooke: | but 192.168.x.x instead of abc? |
| [02:44:47] | wagnerrp: | assuming your config.xml is configured to use the mythtv account name and password |
| [02:44:53] | wagnerrp: | make sure to quote all text |
| [02:46:12] | buu: | DavidBrooke: Make sure to grant login permissions @abc to mythtv |
| [02:46:18] | buu: | not just table permissions |
| [02:46:33] | wagnerrp: | the command i gave him does it all in one shot |
| [02:46:43] | wagnerrp: | no need for separate login permissions |
| [02:47:55] | buu: | If he can't log in.. |
| [02:51:13] | DavidBrooke: | here is the command issued by root...grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'mythtv'; |
| [02:51:30] | DavidBrooke: | 1. does this cover the password? |
| [02:52:22] | DavidBrooke: | 2. is this all I need to do at the root mysql prompt |
| [02:52:44] | wagnerrp: | yes |
| [02:54:01] | arescorpio (arescorpio!~arescorpi@212-56-245-190.fibertel.com.ar) has joined #mythtv-users | |
| [02:55:28] | DavidBrooke: | is the second 'mythtv' the password? |
| [02:55:36] | wagnerrp: | identified by, yes |
| [02:57:16] | DavidBrooke: | so if I go over to the abc computer and type...mysql -u mythtv -p -h 192.168.z.z (mysql sever ip), if I can login...everything should be ok? |
| [02:57:28] | wagnerrp: | it should be |
| [02:57:56] | DavidBrooke: | do I need to reboot/login the abc computer? |
| [02:58:03] | wagnerrp: | no |
| [02:58:29] | DavidBrooke: | well...the abc computer still isn't getting access |
| [03:00:07] | wagnerrp: | did you grant permissions to the fqdn and ip address? |
| [03:00:22] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [03:00:30] | wagnerrp: | mysql can get confused |
| [03:01:37] | DavidBrooke: | what is fqdn? |
| [03:02:09] | wagnerrp: | fully qualified domain name |
| [03:02:17] | wagnerrp: | 'abc' is a hostname |
| [03:02:26] | wagnerrp: | 'abc.davidbrooke.com' is a fqdn |
| [03:03:00] | DavidBrooke: | I did two things.....1. grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'apassword' |
| [03:03:19] | DavidBrooke: | 2. mysql -u mythtv -p -h 192.168.z.z |
| [03:03:20] | neo_ (neo_!ae5e4952@gateway/web/freenode/ip.174.94.73.82) has joined #mythtv-users | |
| [03:03:52] | DavidBrooke: | and entered "apassword" |
| [03:05:45] | DavidBrooke: | using your example....'abc.davidbrooke.com' is a fqdn...should mine be...abc.192.168.x.x? |
| [03:06:09] | wagnerrp: | an ip address is not a domain name |
| [03:06:38] | wagnerrp: | when you set your hostname, do you have a DNS server, or did you otherwise configure your hosts file to match? |
| [03:08:05] | DavidBrooke: | I made up the compuert host name with no consideration for a dns server |
| [03:08:25] | neo_ (neo_!ae5e4952@gateway/web/freenode/ip.174.94.73.82) has quit (Ping timeout: 272 seconds) | |
| [03:08:35] | wagnerrp: | with no DNS server or hosts file, mysql has no way to reverse the IP address into a hostname |
| [03:08:49] | wagnerrp: | granting permission to a hostname would thus be meaningless |
| [03:08:53] | wagnerrp: | you must use an IP address |
| [03:09:43] | DavidBrooke: | did I not do that>1. grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'apassword' |
| [03:10:04] | wagnerrp: | assuming 'x.x' were the actual IP address, that should have worked |
| [03:10:10] | DavidBrooke: | where 192168.x.x is the ip address of the abc computer |
| [03:11:59] | DavidBrooke: | just to be clear....the computer where the mysql server is located and where I have issued this prior command...1. grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'apassword'....do I need to do anything else and issuing that command? |
| [03:12:28] | wagnerrp: | maybe 'flush privileges;' |
| [03:12:40] | DavidBrooke: | what does that do? |
| [03:12:57] | wagnerrp: | force authentication to refresh and accept the new grants |
| [03:16:30] | DavidBrooke: | I did this...grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'apassword' |
| [03:16:58] | DavidBrooke: | and this...mysql -u mythtv -p -h 192.168.z.z (apassword) |
| [03:17:05] | DavidBrooke: | access denied still |
| [03:17:24] | DavidBrooke: | sorry and used this...flush privileges; |
| [03:18:10] | DavidBrooke: | this info is the config.xml...mysql -u mythtv -p -h 192.168.z.z (apassword) |
| [03:27:55] | DavidBrooke: | is there any way I can see what is in the musql database ...so I can verify what the user name, password, etc...? |
| [03:30:13] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has quit (Quit: Leaving) | |
| [03:31:48] | wagnerrp: | passwords are not stored in a recoverable manner in mysql |
| [03:37:02] | rsiebert_ (rsiebert_!~quassel@e179170076.adsl.alicedsl.de) has joined #mythtv-users | |
| [03:37:10] | rsiebert (rsiebert!~quassel@g225105162.adsl.alicedsl.de) has quit (Read error: Operation timed out) | |
| [03:38:27] | bill6502 (bill6502!~bill@205.178.26.43) has joined #mythtv-users | |
| [03:38:54] | DavidBrooke: | if I erase the current abc computer and re-install linux and mythtv...will this fix the problem? |
| [03:39:22] | wagnerrp: | doubtful |
| [03:39:58] | DavidBrooke: | is there any option to fix the access denied issue? |
| [03:40:25] | wagnerrp: | i don't know enough mysql to know |
| [03:41:06] | andyman53 (andyman53!6c2ee2fb@gateway/web/freenode/ip.108.46.226.251) has joined #mythtv-users | |
| [03:41:16] | andyman53: | Hey all |
| [03:41:40] | DavidBrooke: | in trying to better understand.....what is it that mythtv frontend needs to work correctly? |
| [03:41:45] | andyman53: | Can't seem to get mythtv to record. It was working until I did some yum updates. Now i get "you should've gotten a channel lock by now" |
| [03:41:57] | andyman53: | and PauseRecorder() called with no recorder |
| [03:42:22] | bill6502: | DavidBrooke: 2 steps to "see" your password: SELECT PASSWORD('yourPasswordHere'); and then: SELECT Host,User,Password FROM user; You'll only see he encrypted version, but they must match. |
| [03:42:23] | andyman53: | it works fine if i do a manual capture with the ceton python script and vlc |
| [03:43:39] | DavidBrooke: | bill6502: 1. where am I inputing the info...on the frontend or the mysql server? |
| [03:44:04] | wagnerrp: | what type of tuner? |
| [03:44:46] | bill6502: | DavidBrooke: Where you doing the GRANTs |
| [03:45:18] | _nyloc_ (_nyloc_!~quassel@p57B4F5E1.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [03:45:22] | DavidBrooke: | bill6502: this is the command from the mysql server...grant all on mythconverg.* to 'mythtv'@'192.168.x.x' identified by 'apassword' |
| [03:45:58] | nyloc (nyloc!~quassel@p5B26F447.dip0.t-ipconnect.de) has quit (Ping timeout: 246 seconds) | |
| [03:51:10] | bill6502: | you asked: '...so I can verify what the user name, password, etc...?'. as wagnerrp said, you can recover the passwords, but you can compare the encrypted values with the 2 SELECTs I suggested. |
| [03:51:52] | wagnerrp: | s/can/cannot/ |
| [03:52:33] | DavidBrooke: | bill6502: I understand.....what I don't clearly understand is how to take your info and input it.... |
| [03:53:32] | DavidBrooke: | where do I input this inf...SELECT PASSWORD('yourPasswordHere');? |
| [03:53:37] | bill6502: | Ah, at the mysql prompt |
| [03:53:55] | DavidBrooke: | k |
| [03:54:13] | DavidBrooke: | I need more info...I'm a noobie |
| [03:54:55] | DavidBrooke: | do this get inputed on the frontend or mysql server? |
| [03:55:00] | DavidBrooke: | SELECT PASSWORD('yourPasswordHere'); |
| [03:55:07] | wagnerrp: | shouldn't matter |
| [03:55:58] | DavidBrooke: | k...so I can enter this...SELECT PASSWORD('apassword'); |
| [03:56:48] | andyman53: | wagnerrp: ceton infinitv 4 |
| [03:58:14] | bill6502: | DavidBrooke: yes, at the mysql prompt, which is: mysql> |
| [03:59:07] | DavidBrooke: | bill6502: then type this info where....SELECT Host,User,Password FROM user;? |
| [03:59:21] | DavidBrooke: | frontend or mysql server? |
| [04:00:22] | bill6502: | same place as you typed the 1st SELECT |
| [04:00:23] | wagnerrp: | the root user |
| [04:00:35] | wagnerrp: | if you have remote access for the root user, it shouldn't matter |
| [04:00:52] | wagnerrp: | of course having remote access for the root user is a bad thing |
| [04:04:22] | DavidBrooke: | bill6502: I typed the following into the mysql server computer: |
| [04:04:42] | DavidBrooke: | SELECT PASSWORD('apassword'); |
| [04:04:43] | DavidBrooke: | SELECT Host,User,Password FROM user; |
| [04:05:13] | DavidBrooke: | feedback was no database selected |
| [04:05:37] | bill6502: | type: USE mysql; |
| [04:07:58] | DavidBrooke: | bill6502: feddback ...unknown database |
| [04:08:13] | wagnerrp: | sounds like you're not using the root user |
| [04:10:29] | bill6502: | type: \s and look for the line:"Current user: " , what does it say? |
| [04:10:36] | DavidBrooke: | wagnerrp: using the same -u root as earlier |
| [04:11:02] | wagnerrp: | bill6502: is it possible he's using mariadb, and they've moved things around since splitting? |
| [04:11:45] | DavidBrooke: | \s....current user = root@localhost |
| [04:13:21] | bill6502: | wagnerrp: good idea, but i don't know how to verify that |
| [04:14:23] | bill6502: | DavidBrooke: that looks good (at least it matches mine) |
| [04:14:40] | DavidBrooke: | bill6502: are you sure that inputing this...SELECT Host,User,Password FROM user; is exactly what I need to do....Host doesn't need to be the the actual host name of the computer? |
| [04:15:33] | wagnerrp: | you're pulling those data columns out of the database |
| [04:15:34] | wagnerrp: | Host is the name of the column |
| [04:15:53] | bill6502: | DavidBrooke: it's correct, type: SHOW databases; |
| [04:19:58] | DavidBrooke: | there are 5 databases: information_schema, mysql, mythconverg, performance_schema and test |
| [04:21:52] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [04:22:24] | bill6502: | that's also good, try typing the following line again: |
| [04:22:28] | bill6502: | USE mysql; |
| [04:24:03] | DavidBrooke: | feedback...reading table information....then says database changed |
| [04:25:46] | ubIx_ (ubIx_!~ulf@p5DD1935C.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [04:25:49] | bill6502: | much better, now do the 2 selects and compare the encrypted passwords (you can use the up arrow to scroll back to previous commands |
| [04:27:49] | wagnerrp: | mysql doesn't salt? |
| [04:28:57] | ubIx (ubIx!~ulf@p5DD18CA2.dip0.t-ipconnect.de) has quit (Ping timeout: 252 seconds) | |
| [04:29:58] | DavidBrooke: | bill6502: i have a 3 column table: host user password....also I have the apassword and the encrypted version.... |
| [04:30:21] | bill6502: | all i know is that the output of the 2 will always match, so I'd say no it doesn't salt |
| [04:30:53] | DavidBrooke: | there are several possible entries for the frontend |
| [04:31:27] | DavidBrooke: | 2 of which match the encrypted apassword |
| [04:31:49] | wagnerrp: | bah... i've been dicking around with portage for two hours, and here i had forgotten to mount /proc |
| [04:31:55] | wagnerrp: | apparently portage does not like that |
| [04:32:46] | wagnerrp: | that's what i get for trying to work outside my auto-update routines |
| [04:33:18] | DavidBrooke: | bill6502: it seems you have given me a way to see the password and host names |
| [04:36:42] | bill6502: | exactly, how about putting the output of the following command in a pastebin (it only prints the 1st 10 characters of the encrypted password:) |
| [04:36:50] | bill6502: | SELECT Host,User,LEFT(Password,10) FROM user; |
| [04:45:59] | DavidBrooke: | bill6502: http://pastebin.com/1Kby2LG9 |
| [04:48:09] | bill6502: | line 13 (% | mythtv | *AE40320EB) tells me that any host and user mythtv will work |
| [04:51:21] | bill6502: | so, let's drop back an hour. from the same host you've been doing SQL does this work: |
| [04:51:25] | bill6502: | mysql -umythtv -p mythconverg |
| [04:51:41] | bill6502: | typed from a command prompt, not mysql |
| [04:53:52] | paulobear (paulobear!617a735e@gateway/web/freenode/ip.97.122.115.94) has quit (Quit: Page closed) | |
| [04:54:05] | DavidBrooke: | bill6502: which computer? frontend or mysql server? |
| [04:54:33] | bill6502: | mysql server for starters |
| [04:54:49] | Lexridge (Lexridge!~lexridge@cdm-75-109-8-5.asbnva.dh.suddenlink.net) has joined #mythtv-users | |
| [04:54:57] | wagnerrp: | technically, that command will only work from the mysql server |
| [04:55:00] | arescorpio (arescorpio!~arescorpi@212-56-245-190.fibertel.com.ar) has quit (Excess Flood) | |
| [04:58:31] | DavidBrooke: | the mysql server is at the mysql prompt after executing ...mysql -umythtv -p mythconverg |
| [04:59:17] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has quit (Ping timeout: 252 seconds) | |
| [05:00:35] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has joined #mythtv-users | |
| [05:01:38] | bill6502: | you must type: mysql -umythtv -p mythconverg from a shell prompt, not a mysql prompt. either exit mysql or (better) open a new terminal window |
| [05:02:46] | DavidBrooke: | I typed ...mysql -umythtv -p mythconverg ...from the prompt in termial and it came up to the mysql prompt |
| [05:04:37] | andyman53: | i'm trying to watch livetv or record, i know the video source is good, I can capture with the ceton client and mplayer |
| [05:04:47] | andyman53: | but I can't seem to get it to work again after yum updates |
| [05:04:59] | andyman53: | i get PauseRecorder() called with no recorder and "should've gotten a lock by now" |
| [05:05:09] | andyman53: | audited the SElinux logs, nothing out of the ordinary |
| [05:05:35] | andyman53: | the above error was the only thing in the backend log, didn't see anything in /var/log/messages either |
| [05:06:20] | DavidBrooke: | bill6502: if the result is incorrect please state the correct result |
| [05:08:06] | bill6502: | i'm just reading the IRC backlog. you said: 'login....meaning ....mysql -u -p -h?' and 'using the above...no I can't login,,,access denied', but the command you just typed says all is A-OK. |
| [05:10:50] | bill6502: | do you have a host named: 'c2d'? |
| [05:10:53] | DavidBrooke: | bill6502: honestly....I have done so much up till this point...let's go off the current results and move forward |
| [05:11:17] | DavidBrooke: | bill6502: yes but it is in upper case C2D |
| [05:11:34] | DavidBrooke: | C2D is the frontend in question |
| [05:12:34] | bill6502: | note that on line 14 of your pastebin, a different encrypted password was used (c2d | mythtv | *CC8F35F58) |
| [05:12:53] | DavidBrooke: | bill6502: correct |
| [05:13:51] | DavidBrooke: | bill6502: due to the lack of understanding during troubleshooting....the wrong password was executed |
| [05:14:11] | DavidBrooke: | earlier mythtv was a password |
| [05:14:42] | DavidBrooke: | then I changed to the config.xml password |
| [05:16:37] | BillK (BillK!~BillK-Fre@124.149.111.175) has quit (Ping timeout: 246 seconds) | |
| [05:16:59] | DavidBrooke: | my memory is slowly coming back.... |
| [05:17:50] | DavidBrooke: | the mysql -u -p -h...was....executed on the frontend where as mysql -umythtv -p mythconverg was executed on the mysql server |
| [05:17:53] | andyman53: | can someone poin me in the the right direction? |
| [05:17:59] | andyman53: | i'm not sure why this is happening |
| [05:19:14] | Lexridge (Lexridge!~lexridge@cdm-75-109-8-5.asbnva.dh.suddenlink.net) has quit (Quit: Leaving) | |
| [05:19:20] | DavidBrooke: | bill6502: mysql -u -p -h was executed mysql -u mythtv -p -h 192.168.z.z (mysql server ip address)....this resulted in access denied which it still does currently |
| [05:20:10] | DavidBrooke: | the frontend is the problem |
| [05:21:01] | DavidBrooke: | bill6502: mysql -u mythtv -p -h 192.168.z.z data is taken from config.xml |
| [05:21:48] | DavidBrooke: | which is the same config.xml on all other frontends |
| [05:23:53] | bill6502: | i'd prefer deleting lines 14 and 15, but don't know the proper command to do it. so fix line 14 for now. i believe the following command will do that: |
| [05:24:29] | bill6502: | grant all on mythconverg.* to 'mythtv'@'c2d' identified by 'apassword' |
| [05:25:01] | DavidBrooke: | apassword = config.xml password? |
| [05:25:13] | andyman53 (andyman53!6c2ee2fb@gateway/web/freenode/ip.108.46.226.251) has quit (Ping timeout: 272 seconds) | |
| [05:27:00] | bill6502: | the same password that encrypts as: *AE40320EB ..... that you've been using. I assume that is what is in all your config.xml files and is NOT mythtv (*CC8F35F58.....) |
| [05:31:04] | DavidBrooke: | k done |
| [05:32:20] | bill6502: | we could verify it, but why not just try starting the remote frontend again |
| [05:33:13] | DavidBrooke: | I just tested the frontend ...access denied mythtv@C2D.....C2D is important here it seems |
| [05:33:43] | DavidBrooke: | this is what I just used...mysql -u mythtv -p -h 192.168.z.z |
| [05:37:10] | DavidBrooke: | wait 1 min.... |
| [05:38:17] | DavidBrooke: | your command didn't have a ";" at the end....so I added it to the second...here is the output: |
| [05:38:54] | DavidBrooke: | mysql> grant all on mythconverg.* to 'mythtv'@'c2d' identified by 'apassword' |
| [05:38:55] | DavidBrooke: | -> grant all on mythconverg.* to 'mythtv'@'c2d' identified by 'apassword'; |
| [05:38:55] | DavidBrooke: | ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grant all on mythconverg.* to 'mythtv'@'c2d' identified by 'k2iP7ALd'' at line 2 |
| [05:39:20] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has quit (Read error: Connection reset by peer) | |
| [05:39:36] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has joined #mythtv-users | |
| [05:39:37] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [05:39:37] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has joined #mythtv-users | |
| [05:39:37] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v knightr | |
| [05:41:47] | bill6502: | enter it again from the mysql prompt (mysql> ): grant all on mythconverg.* to 'mythtv'@'c2d' identified by 'k2iP7ALd'; |
| [05:47:27] | DavidBrooke: | it was accepted |
| [05:47:41] | DavidBrooke: | and the frontend connected to mysql |
| [05:47:59] | DavidBrooke: | mythfrontend looks to be working |
| [05:51:11] | DavidBrooke: | bill6502: so the capitalization doesn't matter? |
| [05:51:24] | bill6502: | it would appear that the explicit entry for c2d was matching (and failing) over the wild-card entry (%@mythtv) |
| [05:51:40] | bill6502: | correct, case doesn't matter |
| [05:53:31] | bill6502: | If you want to clean things up, I'd do the following (but what you have is OK.) Honestly, I've not done this, so take it for what it's worth: |
| [05:53:33] | bill6502: | DROP USER 'mythtv'@'c2d','mythtv'@'192.168.97.102'; |
| [05:54:43] | bill6502: | The wild card *should* care for your configuration (it's what I use.) |
| [05:55:41] | DavidBrooke: | bill6502: k...ty very much for youe time and help |
| [05:55:57] | bill6502: | np, gn |
| [05:56:05] | bill6502 (bill6502!~bill@205.178.26.43) has left #mythtv-users () | |
| [06:12:00] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [06:21:24] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [06:26:27] | SmallwoodDR82 (SmallwoodDR82!~Smallwood@unaffiliated/smallwooddr82) has quit (Quit: and I'm out...) | |
| [07:14:42] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has quit (Quit: Leaving) | |
| [07:22:34] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has joined #mythtv-users | |
| [07:22:34] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has joined #mythtv-users | |
| [07:22:34] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [07:22:34] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v knightr | |
| [07:24:58] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [07:43:39] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [08:20:29] | Tobbe5178 (Tobbe5178!~asdf@h104n2-sv-a13.ias.bredband.telia.com) has joined #mythtv-users | |
| [08:21:31] | rdark (rdark!~rdark@77.75.111.121) has joined #mythtv-users | |
| [08:28:07] | BillK (BillK!~BillK-Fre@124.149.111.175) has joined #mythtv-users | |
| [08:46:11] | Gumby (Gumby!~gumby@unaffiliated/gumby) has joined #mythtv-users | |
| [08:51:01] | croppa (croppa!~stuart@14.14.233.220.static.exetel.com.au) has joined #mythtv-users | |
| [08:54:26] | justdave (justdave!~dave@unaffiliated/justdave) has quit (Ping timeout: 252 seconds) | |
| [08:54:44] | justdave (justdave!~dave@unaffiliated/justdave) has joined #mythtv-users | |
| [08:56:38] | hR13 (hR13!~hR13@81-235-12-37-no94.bredband.skanova.com) has quit (Quit: Leaving) | |
| [09:05:47] | justdave (justdave!~dave@unaffiliated/justdave) has quit (Remote host closed the connection) | |
| [09:06:04] | justdave (justdave!~dave@unaffiliated/justdave) has joined #mythtv-users | |
| [09:39:09] | amizraa (amizraa!~amizraa@gateway/tor-sasl/amizraa) has quit (Ping timeout: 240 seconds) | |
| [09:59:27] | Gumby (Gumby!~gumby@unaffiliated/gumby) has quit (Ping timeout: 260 seconds) | |
| [10:15:47] | stuartm: | heh, BBC advertising that they'll be showing "The Indiana Jones trilogy and that other one" this Christmas |
| [11:02:03] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 272 seconds) | |
| [11:13:20] | croppa (croppa!~stuart@14.14.233.220.static.exetel.com.au) has quit () | |
| [11:14:03] | knightr_ (knightr_!~Nicolas@69-165-170-178.dsl.teksavvy.com) has joined #mythtv-users | |
| [11:15:45] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv-users | |
| [12:01:34] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has joined #mythtv-users | |
| [12:15:50] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has quit (Remote host closed the connection) | |
| [12:34:41] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has joined #mythtv-users | |
| [12:34:46] | MartinT_ (MartinT_!~smuxi@46-18-104-220.static.vivaciti.org) has joined #mythtv-users | |
| [12:35:31] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has quit (Remote host closed the connection) | |
| [12:41:32] | MartinT_ is now known as MartinT | |
| [12:59:01] | louisdk (louisdk!~louis@static-5-103-130-65.seas-nve.net) has joined #mythtv-users | |
| [13:04:31] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [13:26:58] | StevenR (StevenR!~foo@cpc14-sgyl28-2-0-cust18.18-2.cable.virginm.net) has joined #mythtv-users | |
| [13:49:32] | dkeith___ (dkeith___!~dkeith@173.48.203.40) has joined #mythtv-users | |
| [13:57:36] | knightr_ (knightr_!~Nicolas@69-165-170-178.dsl.teksavvy.com) has quit (Read error: Connection reset by peer) | |
| [13:57:45] | imhouse1 (imhouse1!~matthew.h@d118-75-124-4.try.wideopenwest.com) has joined #mythtv-users | |
| [13:57:56] | mengoshmink (mengoshmink!~mengoshmi@188-223-42-51.zone14.bethere.co.uk) has quit (Ping timeout: 240 seconds) | |
| [13:59:05] | ServerSage (ServerSage!~ServerSag@c-67-161-33-172.hsd1.ca.comcast.net) has joined #mythtv-users | |
| [14:02:25] | mengoshmink (mengoshmink!~mengoshmi@188-223-42-51.zone14.bethere.co.uk) has joined #mythtv-users | |
| [14:06:02] | baggy (baggy!~baggy@baggywrinkle.demon.co.uk) has quit (*.net *.split) | |
| [14:06:02] | dkeith__ (dkeith__!~dkeith@173.48.203.40) has quit (*.net *.split) | |
| [14:06:02] | ServerSa` (ServerSa`!~ServerSag@c-67-161-33-172.hsd1.ca.comcast.net) has quit (*.net *.split) | |
| [14:06:02] | ikevin (ikevin!~kevin@lisa.illux.org) has quit (*.net *.split) | |
| [14:06:02] | Cougar (Cougar!~cougar@2a03:5880:104:10:7902:7e8:9c7e:aac8) has quit (*.net *.split) | |
| [14:06:02] | toddc (toddc!~toddc@ip72-201-193-24.ph.ph.cox.net) has quit (*.net *.split) | |
| [14:06:02] | Floppe (Floppe!~Floppe@2001:14b8:1d3::100) has quit (*.net *.split) | |
| [14:06:02] | tris (tris!tristan@camel.ethereal.net) has quit (*.net *.split) | |
| [14:09:01] | tris (tris!tristan@camel.ethereal.net) has joined #mythtv-users | |
| [14:09:15] | toddc (toddc!~toddc@ip72-201-193-24.ph.ph.cox.net) has joined #mythtv-users | |
| [14:10:55] | ikevin (ikevin!~kevin@lisa.illux.org) has joined #mythtv-users | |
| [14:10:55] | Cougar (Cougar!~cougar@2a03:5880:104:10:7902:7e8:9c7e:aac8) has joined #mythtv-users | |
| [14:10:55] | Floppe (Floppe!~Floppe@2001:14b8:1d3::100) has joined #mythtv-users | |
| [14:11:02] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has joined #mythtv-users | |
| [14:11:02] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has joined #mythtv-users | |
| [14:11:02] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [14:11:02] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v knightr | |
| [14:21:29] | amizraa (amizraa!~amizraa@gateway/tor-sasl/amizraa) has joined #mythtv-users | |
| [14:25:35] | rdark (rdark!~rdark@77.75.111.121) has quit (Quit: leaving) | |
| [14:27:13] | Bhaal (Bhaal!~bhaal@freenode/staff-emeritus/bhaal) has quit (Read error: Connection reset by peer) | |
| [14:28:20] | Bhaal (Bhaal!~bhaal@freenode/staff-emeritus/bhaal) has joined #mythtv-users | |
| [14:32:15] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has joined #mythtv-users | |
| [14:32:16] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [14:32:16] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has quit (Changing host) | |
| [14:33:19] | louisdk (louisdk!~louis@static-5-103-130-65.seas-nve.net) has quit (Ping timeout: 272 seconds) | |
| [14:35:13] | BillK (BillK!~BillK-Fre@124.149.111.175) has quit (Ping timeout: 272 seconds) | |
| [14:51:06] | louisdk (louisdk!~louis@static-5-103-130-65.seas-nve.net) has joined #mythtv-users | |
| [15:02:18] | GreyFoxx (GreyFoxx!~greg@out.of.phaze.org) has joined #mythtv-users | |
| [15:02:40] | GreyFoxx (GreyFoxx!~greg@out.of.phaze.org) has quit (Changing host) | |
| [15:02:40] | GreyFoxx (GreyFoxx!~greg@mythtv/developer/GreyFoxx) has joined #mythtv-users | |
| [15:02:40] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v GreyFoxx | |
| [15:15:57] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has joined #mythtv-users | |
| [15:26:15] | rhpot1991 (rhpot1991!~rhpot1991@2001:4968:202:3:101a:1f29:2296:bad4) has joined #mythtv-users | |
| [15:26:15] | rhpot1991 (rhpot1991!~rhpot1991@ubuntu/member/rhpot1991) has joined #mythtv-users | |
| [15:26:15] | rhpot1991 (rhpot1991!~rhpot1991@2001:4968:202:3:101a:1f29:2296:bad4) has quit (Changing host) | |
| [15:30:13] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has joined #mythtv-users | |
| [15:30:32] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [15:37:05] | Cubber (Cubber!~ronny@mail.ronnybull.com) has joined #mythtv-users | |
| [15:38:13] | ikevin (ikevin!~kevin@lisa.illux.org) has quit (Ping timeout: 246 seconds) | |
| [15:45:27] | Bhaal (Bhaal!~bhaal@freenode/staff-emeritus/bhaal) has quit (Ping timeout: 240 seconds) | |
| [15:45:51] | Bhaal (Bhaal!~bhaal@freenode/staff-emeritus/bhaal) has joined #mythtv-users | |
| [16:01:57] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [16:06:09] | amizraa (amizraa!~amizraa@gateway/tor-sasl/amizraa) has quit (Ping timeout: 240 seconds) | |
| [16:09:29] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has joined #mythtv-users | |
| [16:09:30] | knightr (knightr!~Nicolas@69-165-170-178.dsl.teksavvy.com) has quit (Changing host) | |
| [16:09:30] | knightr (knightr!~Nicolas@mythtv/developer/knightr) has joined #mythtv-users | |
| [16:09:30] | Mode for #mythtv-users by ChanServ!ChanServ@services. : +v knightr | |
| [16:11:02] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Read error: Operation timed out) | |
| [16:11:58] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [16:15:50] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has quit (Quit: Leaving) | |
| [16:17:32] | wsuetholz (wsuetholz!~Thunderbi@ip87.centonline.com) has joined #mythtv-users | |
| [16:18:47] | amizraa (amizraa!~amizraa@gateway/tor-sasl/amizraa) has joined #mythtv-users | |
| [16:22:32] | Gumby (Gumby!~gumby@50.66.40.198) has joined #mythtv-users | |
| [16:22:32] | Gumby (Gumby!~gumby@unaffiliated/gumby) has joined #mythtv-users | |
| [16:22:32] | Gumby (Gumby!~gumby@50.66.40.198) has quit (Changing host) | |
| [16:26:48] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has joined #mythtv-users | |
| [16:38:25] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [16:55:29] | Dave123 (Dave123!~Dave123@cpe-74-74-202-129.rochester.res.rr.com) has quit (Remote host closed the connection) | |
| [17:02:08] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has quit (Quit: Leaving) | |
| [17:03:02] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Remote host closed the connection) | |
| [17:04:21] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [17:19:16] | BillK (BillK!~BillK-Fre@124.149.111.175) has joined #mythtv-users | |
| [17:28:49] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has quit (Quit: devinheitmueller) | |
| [17:31:35] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has joined #mythtv-users | |
| [17:33:40] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [17:35:23] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has joined #mythtv-users | |
| [17:45:47] | baggy (baggy!~baggy@baggywrinkle.demon.co.uk) has joined #mythtv-users | |
| [17:46:00] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [18:12:49] | JimBaxter (JimBaxter!~jbaxter@jimbax.plus.com) has joined #mythtv-users | |
| [18:13:09] | JimBaxter (JimBaxter!~jbaxter@jimbax.plus.com) has quit (Client Quit) | |
| [18:17:24] | BillK (BillK!~BillK-Fre@124.149.111.175) has quit (Ping timeout: 260 seconds) | |
| [18:32:50] | [R]: | wtf @ the spam to -users |
| [18:35:18] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has quit (Quit: devinheitmueller) | |
| [18:47:52] | dashs (dashs!~dave@dashs.denver.co.us) has joined #mythtv-users | |
| [18:51:06] | imhouse1 (imhouse1!~matthew.h@d118-75-124-4.try.wideopenwest.com) has left #mythtv-users () | |
| [18:56:36] | SteveGoodey (SteveGoodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has quit (Read error: Operation timed out) | |
| [18:57:02] | SteveGoodey (SteveGoodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has joined #mythtv-users | |
| [19:07:35] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has quit (Quit: Leaving) | |
| [19:12:13] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has joined #mythtv-users | |
| [19:14:03] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [19:23:56] | stuartm: | not sure whether it's spam, or just an incoherent angry rant sent to every address in Mr. Brown's contact list |
| [19:25:59] | [R]: | lol |
| [19:26:52] | stuartm: | if it's spam for the purposes of making money or even just phishing, I can't see the angle – it was unsolicited though and off-topic, so that user has been unsubscribed from the list |
| [19:27:29] | [R]: | well are the google sites real? |
| [19:28:26] | stuartm: | yes, although not particularly professional looking |
| [19:35:22] | stuartm: | the whole thing reads as a very personal and undignified argument between two academics (website reads like a research paper, properly citing it's sources etc) |
| [19:35:46] | [R]: | lol |
| [19:36:41] | stuartm: | interjected with personal opinion, and unverifiable facts – "the fake paper didn't convey any meaning (not even 0.0000001%) as a whole" |
| [19:37:06] | wagnerrp: | sounds like the same troll that did the "chow en ming" crap |
| [19:37:07] | stuartm: | yes folks, that's 'meaning' expressed as a percentage |
| [19:38:18] | stuartm: | so not a very intelligent individual – but that's hardly a rare thing in Academia |
| [19:39:01] | stuartm: | wagnerrp: can't really say what it is, but it's a lot of work for no apparent purpose |
| [19:40:21] | wagnerrp: | the stuff i'm referring to was listing all sorts of arguments as to why someone was poisoning him, and was looking for international help |
| [19:40:47] | [R]: | oh yeah, i remmbered that one |
| [19:40:54] | [R]: | that was hilarious |
| [19:40:59] | wagnerrp: | and then years later, asked for actual mythtv help |
| [19:41:06] | stuartm: | actually, what makes most sense to me would be a disgruntled student, that would fit with the poor language skills and first/second year of university "if I cite lots of sources, it looks like I really did the research and know what I'm talking about" feel to it |
| [19:43:10] | afpup (afpup!~andrew@bas6-barrie18-3096512010.dsl.bell.ca) has joined #mythtv-users | |
| [19:53:07] | jnylen: | stuartm: merry christmaseru |
| [19:56:28] | [R]: | Alert: This website may shutdown at anytime due to lawsuits from the fake conference organizers. Copy the content of this website and its attachments (see at the end of this website) quickly and read them at your convenience even if this website is shutdown. |
| [19:56:28] | [R]: | HAHA |
| [20:00:01] | stuartm: | all 115 pdfs |
| [20:01:24] | joki (joki!~joki@p548621BB.dip0.t-ipconnect.de) has quit (Ping timeout: 252 seconds) | |
| [20:04:16] | stuartm: | jnylen: to you as well |
| [20:04:28] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [20:08:58] | joki (joki!~joki@p548626DA.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [20:10:51] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Ping timeout: 262 seconds) | |
| [20:12:04] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has quit (Quit: devinheitmueller) | |
| [20:28:11] | Steve-Goodey (Steve-Goodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has joined #mythtv-users | |
| [20:28:31] | SteveGoodey (SteveGoodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has quit (Ping timeout: 259 seconds) | |
| [20:37:48] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [20:41:41] | Steve_Goodey (Steve_Goodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has joined #mythtv-users | |
| [20:42:14] | Steve-Goodey (Steve-Goodey!~steve@host86-143-180-227.range86-143.btcentralplus.com) has quit (Ping timeout: 264 seconds) | |
| [20:43:22] | [R] ([R]!~rbox@unaffiliated/rbox) has quit (Quit: Leaving) | |
| [20:46:24] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [20:57:09] | DavidBrooke: | I'm trying out a debian distro siduction....the current version seems to work well with mythtv...they have a new rc1 version that will start using systemd....mythtv frontend is having problems starting....stuck at the language/database screens.....I can pastebin some cli info |
| [21:01:04] | joki (joki!~joki@p548626DA.dip0.t-ipconnect.de) has quit (Ping timeout: 240 seconds) | |
| [21:02:05] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [21:03:38] | stuartm: | database connection |
| [21:04:27] | joki (joki!~joki@p548626DA.dip0.t-ipconnect.de) has joined #mythtv-users | |
| [21:11:41] | ctmjr: | any distro based on debian sid (unstable) is going to give you major headaches fix one thing today something else breaks tommorow |
| [21:12:15] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has joined #mythtv-users | |
| [21:12:15] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [21:12:15] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has quit (Changing host) | |
| [21:18:43] | dashs (dashs!~dave@dashs.denver.co.us) has quit (Quit: Leaving) | |
| [21:20:12] | afpup: | I run debian as my base distro, but compile myth from source for that very reason |
| [21:26:28] | DavidBrooke: | stuartm: the config.xml data will connect to mysql via mysql -u mythtv -p -h computerhost name or ip address |
| [21:28:10] | DavidBrooke: | this is the first debian base distro not to work right off with mythtv in my trials so far |
| [21:31:02] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Ping timeout: 240 seconds) | |
| [21:31:04] | DavidBrooke: | stuartm: sorry mis-typed mysql via mysql -u mythtv -p -h masterbackendhostname or ip address |
| [21:31:25] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
| [21:33:40] | stuartm: | I can't tell you why it's not working, only that the language/database screens _only_ get shown if it can't connect to the database |
| [21:34:15] | stuartm: | try running "mythfrontend -v database" and pastebin the resulting output to the console |
| [21:34:58] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has joined #mythtv-users | |
| [21:37:03] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [21:37:05] | DavidBrooke: | going to change over to that frontend...brb |
| [21:37:19] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [21:39:27] | wsuetholz (wsuetholz!~Thunderbi@ip87.centonline.com) has quit (Ping timeout: 260 seconds) | |
| [21:40:52] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [21:42:53] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has quit (Remote host closed the connection) | |
| [21:43:53] | DavidBrooke: | stuartm: http://pastebin.com/0Vrz2TNd |
| [21:44:19] | dougl (dougl!~doug@S0106744401495b56.wp.shawcable.net) has joined #mythtv-users | |
| [21:47:05] | buu: | jesus christ |
| [21:47:08] | buu: | pastebin needs go fucking die |
| [21:48:10] | buu: | DavidBrooke: The mysqld is running on localhost? |
| [21:48:12] | afpup: | trying to connect to localhost? |
| [21:48:40] | afpup: | DavidBrooke: you have more then one config.xml on that system? |
| [21:50:13] | DavidBrooke: | afpup: there is only one config.xml at ~/.mythtv |
| [21:51:14] | DavidBrooke: | buu: I have no idea |
| [21:51:44] | buu: | DavidBrooke: How many computers are involved here? |
| [21:52:20] | DavidBrooke: | buu: why are you asking how many computers? |
| [21:52:49] | buu: | So I know where your damn mysql server is |
| [21:53:04] | DavidBrooke: | buu: I have an issue with the current computer that I'm trying to run mythtv frontend on |
| [21:53:24] | afpup: | looks like it does connect to 192.*.*.100, but then it doesn't seem to stay open... never seen this |
| [21:53:44] | DavidBrooke: | buu: the mysql server is on the masterbackend....I'm on a remote frontend |
| [21:55:06] | Kwisher (Kwisher!~kevin@c-98-212-119-100.hsd1.in.comcast.net) has quit (Quit: Leaving) | |
| [21:57:11] | buu: | DavidBrooke: Is the masterbackend 192.168.97.100? |
| [21:57:23] | DavidBrooke: | y |
| [21:58:42] | buu: | DavidBrooke: can you run mysql -h 192.168.97.100 and manually connect to mythconverg? |
| [21:59:55] | DavidBrooke: | I posted earlier.....mysql -u mythtv -p -h ip address or hostname....it connects using that command |
| [22:00:27] | buu: | DavidBrooke: And it stays connected and you can run sql commands? |
| [22:01:59] | stuartm: | DavidBrooke: any firewall on that machine? One that maybe blocking pings? |
| [22:02:28] | stuartm: | can you "ping -c3 192.168.97.100" from the mythfrontend machine? |
| [22:02:30] | DavidBrooke: | buu: just connected again...got mysql prompt and issued SHOW databases; and it worked and still connected |
| [22:03:17] | DavidBrooke: | stuartm: no firewall that I know of |
| [22:04:19] | buu: | DavidBrooke: Can you wait a couple of minutes and try running ping or select 1 or something? |
| [22:04:20] | DavidBrooke: | stuartm: ping -c3 192.168.97.100 |
| [22:04:37] | DavidBrooke: | stuartm: $ ping -c3 192.168.97.100 |
| [22:04:37] | DavidBrooke: | ping: icmp open socket: Operation not permitted |
| [22:06:07] | DavidBrooke: | buu: why wait? select 1 or something? |
| [22:09:00] | stuartm: | there's your problem, MythTV attempts to ping the database server before it tries to connect, if the ping fails ... |
| [22:09:24] | stuartm: | there is a setting to disable the ping before connect, but you might want to figure out why that's failing |
| [22:09:25] | BillK (BillK!~BillK-Fre@124.149.111.175) has joined #mythtv-users | |
| [22:09:39] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has quit (Quit: Leaving) | |
| [22:10:33] | stuartm: | DavidBrooke: when the database configuration screen appears, uncheck 'Ping test server?' |
| [22:14:39] | DavidBrooke: | stuartm: your assessment is correct |
| [22:15:04] | DavidBrooke: | I unchecked the ping test and mythfrontend works |
| [22:15:34] | DavidBrooke: | I need to better understand your ping test..... |
| [22:16:56] | DavidBrooke: | so that I can continue the troubleshooting |
| [22:21:01] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has joined #mythtv-users | |
| [22:23:56] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has quit (Remote host closed the connection) | |
| [22:24:17] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has joined #mythtv-users | |
| [22:24:35] | stuartm: | DavidBrooke: it just calls `ping`, which in your case is returning "ping: icmp open socket: Operation not permitted" |
| [22:24:55] | stuartm: | selinux? |
| [22:25:49] | DavidBrooke: | selinux? |
| [22:28:57] | DavidBrooke: | stuartm: I don't understand the resulting statement...."ping: icmp open socket: Operation not permitted" |
| [22:31:42] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has joined #mythtv-users | |
| [22:31:42] | zombor (zombor!~zombor__@kohana/developer/zombor) has joined #mythtv-users | |
| [22:31:42] | zombor (zombor!~zombor__@CPE-24-211-23-167.wi.res.rr.com) has quit (Changing host) | |
| [22:32:06] | afpup: | I don't think any Debian distro has selinux enabled, or even installed by default. However, something is preventing ping from accessing the port... does it work as root? |
| [22:32:33] | [R]: | is ping set setuid? |
| [22:39:10] | DavidBrooke: | afpup: :~$ sudo ping -c3 192.168.97.100 |
| [22:39:10] | DavidBrooke: | [sudo] password for william: |
| [22:39:10] | DavidBrooke: | PING 192.168.97.100 (192.168.97.100) 56(84) bytes of data. |
| [22:39:10] | DavidBrooke: | 64 bytes from 192.168.97.100: icmp_seq=1 ttl=64 time=1.03 ms |
| [22:39:10] | DavidBrooke: | 64 bytes from 192.168.97.100: icmp_seq=2 ttl=64 time=1.01 ms |
| [22:39:11] | DavidBrooke: | 64 bytes from 192.168.97.100: icmp_seq=3 ttl=64 time=1.02 ms |
| [22:39:13] | DavidBrooke: | --- 192.168.97.100 ping statistics --- |
| [22:39:15] | DavidBrooke: | 3 packets transmitted, 3 received, 0% packet loss, time 2002ms |
| [22:39:17] | DavidBrooke: | rtt min/avg/max/mdev = 1.019/1.025/1.034/0.037 ms |
| [22:40:15] | DavidBrooke: | [R]: is ping set setuid? not sure what this means? |
| [22:40:25] | [R]: | ls -l $(which ping) |
| [22:41:27] | justinh: | oh man, I have to rescan. My Film4 recordings are all borked |
| [22:42:03] | justinh: | stopped mythbackend.. and according to scan there are two Film4 channels now. GRRR |
| [22:42:45] | justinh: | unless I did a >> instead of just > pipe. Hmm |
| [22:43:15] | stuartm: | when did you last re-scan, surely they aren't moving channels on Christmas Eve? |
| [22:43:58] | justinh: | I last rescanned yonks ago. I'm tired of rescanning because they had a reshuffle |
| [22:44:41] | justinh: | they change things around when some no-mark puts a new placeholder up. It's beyond annoying |
| [22:45:06] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has quit (Quit: Leaving) | |
| [22:45:15] | DavidBrooke: | [R]: still confused.....ls -l $(which ping) |
| [22:45:23] | [R]: | type that in... |
| [22:46:09] | justinh: | oh crap. the mux it's on has changed |
| [22:46:14] | justinh: | full rescan ahoy :-\ |
| [22:48:34] | justinh: | found 11 off-air channels. Hmm. |
| [22:49:05] | DavidBrooke: | [R]: ~$ ls -l $(which ping) |
| [22:49:05] | DavidBrooke: | -rwxr-xr-x 1 root root 44080 Dec 13 08:01 /bin/ping |
| [22:49:14] | [R]: | yeah, you screwd up your ping |
| [22:49:20] | [R]: | sudo chmod +s /bin/ping |
| [22:50:46] | DavidBrooke: | [R]: that allowed ping to work as user |
| [22:51:49] | justinh: | gah. it didn't find film4 |
| [22:52:24] | justinh: | ah. I should've deleted all the channels. Of course. |
| [22:52:33] | DavidBrooke: | [R]: re-checked ping test in mythtv...restarted mythtv and it works as expected |
| [22:53:28] | DavidBrooke: | [R]: ty for your help |
| [22:53:35] | DavidBrooke: | stuartm: ty for your help |
| [22:53:46] | DavidBrooke: | buu: ty for your help |
| [22:54:02] | justinh: | cos if channels exist, and you only update em when you scan – I'm not sure 0.25 copes with a channel appearing on a different mux |
| [22:55:45] | justinh: | Fire Hit TV.. WTH?! |
| [22:55:48] | justinh: | DELETED |
| [22:56:13] | stuartm: | it should, though perhaps not as gracefully as we'd like, it will delete the old, add the new – at least it does in 0.26/0.27, but I didn't think that code had changed since 0.25 |
| [22:59:18] | justinh: | ah nuts. now I have to reinsert xmltvids |
| [22:59:27] | justinh: | I *HATE* rescanning |
| [22:59:56] | justinh: | not as much as I can't stand all the so-called 'channels' they offer on 'free' TV platforms though :-) |
| [23:00:33] | stuartm: | that's why I don't delete channels :) Although I do create a backup of the table first so I can copy over visibility preferences |
| [23:01:06] | justinh: | I deleted all the crufty ones in mythtv-setup since their 'content' still shows up in the finder |
| [23:01:14] | stuartm: | stuarta and I really do want to give the scanner some attention, but it probably won't be in this cycle |
| [23:01:20] | justinh: | never did get around to sending in that patch |
| [23:01:28] | justinh: | prolly won't apply now |
| [23:01:35] | justinh: | or for a long, long time lol |
| [23:02:04] | justinh: | meh. I think I'll ditch xmltv for now |
| [23:02:20] | stuartm: | programs from !visible channels show up in the finder? I'll have to check if that's still the case |
| [23:03:25] | justinh: | oh yeah – or search results.. |
| [23:03:44] | justinh: | or was it just search results? hmm. |
| [23:05:29] | justinh: | sorry stuartm – there was definitely one area I use a lot where hidden channels programs showed up |
| [23:06:00] | justinh: | the misclassification of shows doesn't help. I mean how is 'Made in Essex' or whatever a *documentary* ? ;-) |
| [23:06:56] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has joined #mythtv-users | |
| [23:08:59] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has quit (Remote host closed the connection) | |
| [23:09:12] | justinh: | I really need to make time to give my mythtv system a bit of TLC soon. I was never this far behind in updating it |
| [23:11:08] | DavidBrooke (DavidBrooke!~DavidBroo@c-69-180-207-35.hsd1.tn.comcast.net) has joined #mythtv-users | |
| [23:13:35] | justinh: | when we finally move we won't have a frontend anymore. The backend is always on, so we may aswell make use of it |
| [23:13:45] | justinh: | less to update :-) |
| [23:14:41] | SmallwoodDR82 (SmallwoodDR82!~Smallwood@unaffiliated/smallwooddr82) has joined #mythtv-users | |
| [23:15:39] | justinh: | now then.. is this xmltv install from a package or from somewhere else? |
| [23:16:50] | justinh: | opens synaptic.. it's not from a package. whew |
| [23:17:58] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has quit (Quit: devinheitmueller) | |
| [23:22:49] | justinh: | wow. there's a tv_grab_uk_guardian now eh? |
| [23:25:29] | aarcane (aarcane!~aarcane@99-42-64-118.lightspeed.irvnca.sbcglobal.net) has quit (Quit: Leaving) | |
| [23:26:58] | justinh: | well, at least I can go back to xmltv should I feel the need now |
| [23:36:16] | devinheitmueller (devinheitmueller!~devinheit@cpe-67-244-6-56.nyc.res.rr.com) has joined #mythtv-users | |
| [23:41:29] | amizraa (amizraa!~amizraa@gateway/tor-sasl/amizraa) has quit (Ping timeout: 240 seconds) | |
| [23:42:40] | HaSH (HaSH!~zero@unaffiliated/hash) has quit (Ping timeout: 257 seconds) | |
| [23:43:05] | HaSH (HaSH!~zero@162.219.179.10) has joined #mythtv-users | |
| [23:44:21] | justinh: | right I think that's me all set for my very first Christmas at home. Little point tidying up the livingroom – the kids will have it a tip by 7am :D |
| [23:46:10] | afpup: | 7am? your kids sleep in :-) |
| [23:46:28] | justinh: | hahaha. 7am is wishful thinking |
| [23:46:50] | justinh: | but it's the first christmas the oldest will be aware of so erm.. heh |
| [23:47:47] | afpup: | just a side note: I see you're thinking of combining your fe & be and you have kids... I found my system was somewhat more um, robust, with a MBE that the kids couldn't play with, of course, YMMV |
| [23:48:25] | justinh: | oh the MBE/FE will still be tucked away in a cupboard. I'm not as stupid as I am grey looking |
| [23:48:34] | afpup: | lol :-) |
| [23:48:49] | justinh: | and my son – the oldest of the 2... he's all over everything tech. God help me |
| [23:49:18] | justinh: | want your desktop reconfigured in all kinds of ways you never thought possible? Call in a 3 year old |
| [23:50:07] | justinh: | and on that note, I'm off to bed. Night all. And MERRY CHRISTMAS :-) |
| [23:50:12] | afpup: | yep, used to have all kinds of macro's programmed into my desktop keyboard... then my, at the time 4 year old, got ahold of it. |
| [23:50:25] | afpup: | night Justinh, merry christmas |
| [23:53:13] | Tobbe5178 (Tobbe5178!~asdf@h104n2-sv-a13.ias.bredband.telia.com) has quit (Read error: Connection reset by peer) | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.