Sunday, July 22nd, 2018, 01:19 UTC | ||
[01:19:19] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has quit (Remote host closed the connection) | |
[01:43:27] | croppa (croppa!~stuart@26.84.233.220.static.exetel.com.au) has quit (Ping timeout: 240 seconds) | |
[01:43:37] | croppa (croppa!~stuart@26.84.233.220.static.exetel.com.au) has joined #mythtv-users | |
[01:48:41] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:5c07:c60b:8036:b8bb) has joined #mythtv-users | |
[01:51:34] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:e839:f6d7:38c7:cbd0) has quit (Ping timeout: 260 seconds) | |
[05:11:05] | bumblebeebat (bumblebeebat!~sean@fctnnbsc38w-47-55-90-178.dhcp-dynamic.fibreop.nb.bellaliant.net) has quit (Ping timeout: 240 seconds) | |
[05:13:19] | cspack (cspack!cspack@gateway/vpn/privateinternetaccess/cspack) has quit (Quit: WeeChat 2.2) | |
[05:18:14] | nephyrin (nephyrin!~neph@67.183.153.159) has quit (Ping timeout: 260 seconds) | |
[05:18:56] | nephyrin (nephyrin!~neph@67.183.153.159) has joined #mythtv-users | |
[05:20:27] | bumblebeebat (bumblebeebat!~sean@fctnnbsc38w-47-55-90-178.dhcp-dynamic.fibreop.nb.bellaliant.net) has joined #mythtv-users | |
[05:21:05] | cspack (cspack!cspack@gateway/vpn/privateinternetaccess/cspack) has joined #mythtv-users | |
[05:28:26] | bumblebeebat (bumblebeebat!~sean@fctnnbsc38w-47-55-90-178.dhcp-dynamic.fibreop.nb.bellaliant.net) has quit (Ping timeout: 276 seconds) | |
[05:54:52] | bumblebeebat (bumblebeebat!~sean@fctnnbsc38w-47-55-90-178.dhcp-dynamic.fibreop.nb.bellaliant.net) has joined #mythtv-users | |
[08:20:54] | Steve-Goodey (Steve-Goodey!~steve@host86-149-199-165.range86-149.btcentralplus.com) has joined #mythtv-users | |
[08:49:05] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:35b9:fa5f:d3de:d776) has joined #mythtv-users | |
[08:52:30] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:5c07:c60b:8036:b8bb) has quit (Ping timeout: 260 seconds) | |
[09:27:23] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has joined #mythtv-users | |
[09:53:33] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:2192:a39d:71d3:47f4) has joined #mythtv-users | |
[09:56:54] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:35b9:fa5f:d3de:d776) has quit (Ping timeout: 260 seconds) | |
[10:05:14] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has quit (Ping timeout: 268 seconds) | |
[10:27:20] | SteveGoodey (SteveGoodey!~steve@2a00:23c5:7da3:4501:7a24:afff:fe9d:c233) has joined #mythtv-users | |
[10:46:52] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has joined #mythtv-users | |
[11:14:32] | SteveGoodey (SteveGoodey!~steve@2a00:23c5:7da3:4501:7a24:afff:fe9d:c233) has quit (Quit: Konversation terminated!) | |
[11:15:02] | Steve-Goodey (Steve-Goodey!~steve@host86-149-199-165.range86-149.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
[11:31:01] | ShapeShifter499 (ShapeShifter499!~ShapeShif@unaffiliated/shapeshifter499) has joined #mythtv-users | |
[12:03:22] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:dccb:22b5:dcca:d715) has joined #mythtv-users | |
[12:06:10] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:2192:a39d:71d3:47f4) has quit (Ping timeout: 260 seconds) | |
[12:06:20] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has quit (Remote host closed the connection) | |
[12:22:29] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has quit (Ping timeout: 276 seconds) | |
[12:37:25] | squidly (squidly!squidly@HoodLUG/member/squidly) has quit (Quit: leaving) | |
[12:37:43] | squidly (squidly!squidly@HoodLUG/member/squidly) has joined #mythtv-users | |
[12:46:17] | louisdk (louisdk!~louisdk@212.178.176.210) has joined #mythtv-users | |
[13:13:20] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has joined #mythtv-users | |
[13:28:26] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has quit (Remote host closed the connection) | |
[13:29:26] | louisdk (louisdk!~louisdk@212.178.176.210) has quit (Remote host closed the connection) | |
[14:16:35] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:11ad:ba23:c9ae:e3d9) has joined #mythtv-users | |
[14:20:07] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:dccb:22b5:dcca:d715) has quit (Ping timeout: 265 seconds) | |
[14:29:53] | jpabq (jpabq!~quassel@67-0-207-216.albq.qwest.net) has joined #mythtv-users | |
[14:29:54] | jpabq_ (jpabq_!~quassel@67-0-207-216.albq.qwest.net) has quit (Ping timeout: 276 seconds) | |
[14:55:26] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:458f:772c:6345:7de4) has joined #mythtv-users | |
[14:58:18] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:11ad:ba23:c9ae:e3d9) has quit (Ping timeout: 265 seconds) | |
[15:00:19] | ShapeShifter499 (ShapeShifter499!~ShapeShif@unaffiliated/shapeshifter499) has quit (Quit: Leaving) | |
[16:22:10] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7da3:4501:9200:4eff:feb3:e38b) has joined #mythtv-users | |
[16:34:00] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:51eb:d24e:c5ce:e387:91e2:977f) has quit (Ping timeout: 265 seconds) | |
[16:39:10] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:503e:2c9:af0c:d7fd) has joined #mythtv-users | |
[16:41:58] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:458f:772c:6345:7de4) has quit (Ping timeout: 260 seconds) | |
[16:43:57] | brfransen (brfransen!~brfransen@47.42.27.251) has quit (Ping timeout: 240 seconds) | |
[16:45:27] | Tobbe5178 (Tobbe5178!~asdf@2001:2002:51eb:d24e:8435:3d3f:6de9:f8a1) has joined #mythtv-users | |
[16:53:32] | brfransen (brfransen!~brfransen@47.42.27.251) has joined #mythtv-users | |
[17:29:04] | bumblebeebat: | Life seems a lot harder without mythbuntu lol |
[17:29:26] | bumblebeebat: | Just installed a new server with xbuntu and the mythbuntu repos |
[17:29:41] | bumblebeebat: | noticed that the backend does not seem to be working |
[17:30:10] | bumblebeebat: | Can anyone point me to a tutorial to get thing up and running |
[17:30:41] | bumblebeebat: | I am using 18.04 |
[17:30:51] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:a82c:dbe2:2ce0:6ca9) has joined #mythtv-users | |
[17:33:44] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:503e:2c9:af0c:d7fd) has quit (Ping timeout: 256 seconds) | |
[17:38:00] | bumblebeebat: | Ok, hunted it down a little, the users table inside mythconverg does not have a mythtv user |
[17:38:21] | bumblebeebat: | just an admin, is that correct |
[17:59:45] | bill6502 (bill6502!~bill@205.178.24.168) has joined #mythtv-users | |
[18:00:51] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:4c43:ea87:d6d5:ae8a) has joined #mythtv-users | |
[18:01:23] | bill6502: | bumblebeebat: ^^^ yes, that's normal (used for things like Services API and Webserver.) |
[18:04:34] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:a82c:dbe2:2ce0:6ca9) has quit (Ping timeout: 260 seconds) | |
[18:05:09] | bumblebeebat: | bill6502, ok, so all I have to do is add my mythtv user |
[18:06:35] | bill6502: | no, not to that table, if you don't have one for mysql or MariaDB, then yes |
[18:08:49] | bill6502: | you did say users in mythconverg, which isn't the same as user in the mysql database |
[18:09:14] | bumblebeebat: | got it |
[18:12:11] | bill6502 (bill6502!~bill@205.178.24.168) has left #mythtv-users () | |
[18:29:58] | bumblebeebat: | I am getting the following error: ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES) |
[18:30:59] | bumblebeebat: | when I try to run mythtv-setup without sudo |
[18:45:11] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:70eb:4163:599b:82ef) has joined #mythtv-users | |
[18:45:53] | cspack: | bumblebeebat: is this a new install? |
[18:48:22] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:4c43:ea87:d6d5:ae8a) has quit (Ping timeout: 265 seconds) | |
[18:49:13] | bumblebeebat: | it is a new install |
[18:49:43] | bumblebeebat: | just got mythtv-setup working by accessing it via localhost |
[18:50:09] | cspack: | did you run mc.sql script? It sets the db permissions |
[18:50:29] | cspack: | https://www.mythtv.org/wiki/Database_Setup |
[18:50:36] | bumblebeebat: | hummm, I thought i made changes to mysql so other systems could access it |
[18:52:54] | cspack: | yeah for remote you have to manually grant mysql permissions |
[18:53:39] | bumblebeebat: | when it says enter password does that mean to enter the password I want |
[18:54:59] | cspack: | for which command does it prompt you? |
[19:04:31] | bumblebeebat: | enter password: |
[19:04:50] | bumblebeebat: | I assume that is the mythtv user password |
[19:06:33] | cspack: | I don't know what command you are running |
[19:06:41] | bumblebeebat: | oh sorry |
[19:08:28] | brfransen (brfransen!~brfransen@47.42.27.251) has quit (Ping timeout: 244 seconds) | |
[19:08:38] | bumblebeebat: | when I ran the mc.sql script it asks me for a password |
[19:09:04] | bumblebeebat: | I think the prompt was "enter password:" |
[19:10:01] | cspack: | if you ran mysql -uroot -p then it's asking for the root password. If you didn't set a root password then remove the -p |
[19:10:26] | bumblebeebat: | ok |
[19:10:32] | bumblebeebat: | let me try that |
[19:10:36] | brfransen (brfransen!~brfransen@47.42.27.251) has joined #mythtv-users | |
[19:15:07] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:581c:fea:e311:8725) has joined #mythtv-users | |
[19:17:56] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:70eb:4163:599b:82ef) has quit (Ping timeout: 276 seconds) | |
[19:42:39] | bumblebeebat: | yes, you are right, that password prompt is gone |
[19:45:33] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:48cc:ffd0:49d1:1ce4) has joined #mythtv-users | |
[19:47:49] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:581c:fea:e311:8725) has quit (Ping timeout: 265 seconds) | |
[19:52:50] | bumblebeebat: | I am following the myth mysql wiki page and when I entered "UPDATE user SET Password=PASSWORD('mynewpassword') WHERE user='mythtv';" |
[19:53:24] | bumblebeebat: | I get the error "ERROR 1054 (42S22): Unknown column 'Password' in 'field list'" |
[20:03:10] | tonsofpcs: | hi all |
[20:04:06] | tonsofpcs: | bumblebeebat: what mysql version? |
[20:04:07] | cspack: | bumblebeebat: try mysql.user for the table name (i.e. UPDATE mysql.user SET...) |
[20:04:36] | tonsofpcs: | newer versions use ALTER USER |
[20:05:42] | tonsofpcs: | anyway, if mythtv-setup worked, that means your password in your config file is correct... |
[20:05:47] | tonsofpcs: | it's stored in plaintext. |
[20:11:58] | [R] ([R]!~rbox@unaffiliated/rbox) has joined #mythtv-users | |
[20:13:31] | cspack: | tonsofpcs: you are probably right, he's on ubuntu 18.04 so likely mysql 5.7 |
[20:22:50] | bumblebeebat: | I am on 18.04 |
[20:23:25] | bumblebeebat: | I will will look up the mysql changes |
[20:23:55] | tonsofpcs: | oh, yea, definitely ALTER |
[20:24:00] | tonsofpcs: | https://dev.mysql.com/doc/refman/8.0/en/reset . . . issions.html |
[20:24:08] | tonsofpcs: | obviously not for 'root' but same idea |
[20:28:11] | Moscherkobold (Moscherkobold!quassel@2a01:4f8:173:1ed5::3) has quit (Read error: Connection reset by peer) | |
[20:28:30] | Moscherkobold (Moscherkobold!moscherkob@2a01:4f8:173:1ed5::3) has joined #mythtv-users | |
[20:30:38] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7da3:4501:9200:4eff:feb3:e38b) has quit (Quit: Konversation terminated!) | |
[20:54:12] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has joined #mythtv-users | |
[21:11:45] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has quit (Read error: Connection reset by peer) | |
[21:13:26] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:41b3:e53:25d9:f5de) has joined #mythtv-users | |
[21:17:32] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:48cc:ffd0:49d1:1ce4) has quit (Ping timeout: 276 seconds) | |
[21:23:40] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has joined #mythtv-users | |
[21:24:33] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has joined #mythtv-users | |
[21:33:02] | user798645 (user798645!~User@user-10mt7in.cable.mindspring.com) has quit (Ping timeout: 276 seconds) | |
[21:48:19] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv-users | |
[22:10:42] | dragonian (dragonian!~dragonian@2604:6000:100e:8165:6544:93ca:c177:a289) has joined #mythtv-users | |
[22:13:32] | dragonia_ (dragonia_!~dragonian@2604:6000:100e:8165:41b3:e53:25d9:f5de) has quit (Ping timeout: 245 seconds) | |
[22:45:39] | Roklobster (Roklobster!~Dirkka@119-18-15-76.cust.aussiebb.net) has quit (Remote host closed the connection) | |
[23:25:18] | gregl (gregl!~greg@cpe-24-194-253-7.nycap.res.rr.com) has joined #mythtv-users | |
[23:52:27] | xris- (xris-!~xris@97-113-149-135.tukw.qwest.net) has quit (Quit: Goodbye.) | |
[23:54:29] | oozer (oozer!~oozer@user-10mt7in.cable.mindspring.com) has joined #mythtv-users |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.