[00:02] Good morning I was wondering if anyone can steer me in the right direction [00:03] I have just upgraded from Ubuntu 9.04 to 9.10 and mythtv works fine on the backend/frontend machine [00:05] but other front ends cannot connect to it. [00:05] Mythtv scema version has upgraded to 1244 [00:07] It seems to be that the outside frontends are havng trouble connecting to the database [00:08] my reading seems that others are having trouble with the database not upgrading properly [00:10] I am not an expert on mysql (infact am probably below newby) but love mythtv and have been using it for years [00:12] The outside frontends report cannot login to database. [00:13] Yes, croppa, I'm rapidly falling in love with mythtv myself. [00:14] if you log on to the front end and fire up a command line [00:14] are you able to log into the database with the CLI mysql client [00:14] hand on I'll look up the command [00:15] *hang [00:15] would this procedure from nerver fixit http://ubuntuforums.org/showthread.php?t=1302135 [00:15] [ubuntuforums.org] [SOLVED] Can't Upgrade Database - Ubuntu Forums [00:15] mysql -u -p -h [00:18] Is the password that is asked for the one used by the frontend to connect to the database? [00:18] ie the 8 character one [00:19] croppa: it'll depend on what you entered for the username. [00:19] There has to be a username/password on the backend database that the front end can use to log into your mysql database [00:19] mythtv [00:20] okay is there a user 'mythtv' on the back-end mysql database? [00:24] how am i able to check for users on the database?....I did a normal install of 9.04 setting up ontop of ubuntu and it was working fine untill i uprgaded [00:32] personally I use the webmin mysql module to do database administration but a lot of people use phpmyadmin [00:32] either will show you what users are set up. [00:32] really there are only 2 things that could be wrong [00:32] either the front end can't 'see' the backend [00:33] likely because of firewall config or other network conditions [00:33] or it can see the backend but can't log in [00:33] usually because of user/password issues [00:35] as the problem has started with the upgrade and effects all the previously workin front ends would you suspect something like the firewall? [00:36] forgive me, I'm a bit late to the game here but are you saying that every thing was fine until you did an upgrade? [00:36] yes [00:37] okay was it the backend, front end or both that you upgraded? [00:37] and the frontend on the frontend/backend machine works fine [00:38] so you've got a fronend/backend combo on one machine and a master backend on another? [00:38] just that the other frontend machins cannot conect eventhough thay have also been upgraded to 9,10 [00:39] no i have onlyt one backend with a frontend and other machins which also conect to it [00:39] ah, okay. [00:40] so you know the username 'mythtv' that the working frontend is connecting to [00:40] if you log on to one of the non-working frontend only machines [00:40] open up a terminal [00:41] and type mysql -u mysql -p -h [00:41] sorry [00:41] mysql -u mythtv -p -h [00:42] and enter the mythtv user's database password [00:42] when prompted what do you get? [00:44] I have done that and tried every password i can think of and no luck loging in [00:45] I have also tried on the backend machine [00:45] Is there a way to reset the password? [00:45] okay, yes [00:45] if it were me [00:46] I'd load webmin on the backend machine [00:46] if it wasn't installed [00:46] then launch a web browser on it [00:46] and point it to https://localhost:10000 [00:46] and log on as root with the root PW [00:47] navigate to the servers section [00:47] then mysql [00:47] and find the mythtv user [00:47] then in there there's an option to reset the password [00:47] there's probably a way to do it with either the command line mysql client or phpmyadmin but I don't know them off the top of my head [00:48] I'd set it to something that I'd know (clearly) then go back to the front end machine [00:48] in questino [00:48] question [00:48] and run mythtv-setup [00:48] and in the section where it asks about which backend to connect to [00:48] I'd plug in mythtv as the username [00:48] and the password I'd just created [00:49] I have been trying to use that password before but to no avail [00:51] The front end on the frontend/backend has that password in its setup [00:51] I'm sorry, I don't think I follow? [00:51] bummer webmin not in ubuntu repos but not a problem [00:52] There's an installer on the webmin site one sec... [00:52] www.webmin.com [00:52] [www.webmin.com] Webmin [00:53] the senior guy where I work shits on webmin all the time but I find it useful [00:56] the password that is in the frontend setup on the frontend/backend machine (which works) is the same as the other frontends and is also one which i tried with stuart@stuart-ubuntu:~$ mysql -u mythtv -p -h 192.168.174.60 [00:56] I have used webmin befor and found it very usefull [00:57] croppa: okay so that tells us that the mysql server on the frontend/backend machine is just not accepting remote logins [00:58] Am just downloading webmin anyway [00:58] if you log on to the fronend/backend machine and do mysql -u mythtv -p -h 192.168.174.60 then plug in the PW does it let you log on? [00:58] cool [00:59] no [00:59] if not try mysql -u mythtv -p -h 127.0.0.1 on the frontend/backend machine [00:59] [127.0.0.1] MaineFish Productions [00:59] to go at the DB locally [00:59] I am flicking between 2 machines with a KVM switch [01:00] or better yet try mysql -u mythtv -p on the fronend/backend machine [01:00] then plug in the mythtv pw and does it let you in? [01:00] Yes that lets me in [01:00] cool [01:01] so mysql on the backend just isn't listening on the external interface [01:01] yes that sounds possiable [01:01] If I'm not mistaken there's options in the mysql module of webmin that'll tell mysql which interfaces to allow logons for for a selected user [01:02] if you tell it to listen on 192.168.174.60 in addition to localhost [01:02] that should solve the issue with the remote frontends. [01:02] ok I will now install webmin [01:02] I believe [01:03] Thank you for your help if you are gone befor i get back 8-) [01:03] back shortly (note I didn't use 'brb') :) [01:03] np [01:13] croppa: what video card do you prefer on you frontends? [01:13] I want to upgrade the one on mine (currently using an on-board intel one on an old xcube) [01:43] klucas: I am using a Nvidia and conecting to the LCD tv through the digital output [01:44] croppa: cool, which nvidia? [01:44] I've got this thing connecting to a vga port on my tv at the moment [01:44] I have not been able to connect to the data base through mysql -u mythtv -p -h 192.168.174.60 and have tried a lot of changes in webmin [01:45] and I'd like to go dvi/hdmi but I'm limited to low provfile [01:46] okay, so then I'd be looking to allow the mythtv user to connect on the external interface [01:47] the card i am using is an onboard gforce 6 on a ASUS M2NPV-VM motherboard [01:47] and possibly looking to see if the mysql port (can't remember what it is) is allowed through the firewall [01:47] on the backend machine [01:48] once you get it working from the command line the mythtv gui should just fall into place [01:48] Port is 3306 [01:51] okay so is the firewall on the backend allowing connections to 3306? [01:52] and check to see that the mythtv user is allowed to connect via remote hosts in webmin [01:52] if so [01:52] then try to connect via the front end [01:53] by going on the front end and doing mysql -u mythtv -p -h 192.168.174.60 [02:03] once you get that logon working your front ends(s) will be fine. [02:06] thankyou thankyou thankyou thankyou a change in webmin which i hadnt found has made all the difference [02:07] It was stopping all but 127.0.0.1 [02:07] [127.0.0.1] MaineFish Productions [02:09] ya if it's only allowing 127.0.0.1 then that's all that'll be allowed to log in and your frontends are fucked [02:09] [127.0.0.1] MaineFish Productions [02:09] klucas: mysql server configeration > listening address [02:09] croppa: yep, I knew I remember seeing it in there somewhere [02:09] glad it's going for you [02:09] :) [02:10] Thankyou very much again................saved my bacon with management (She who must be obeyed) She likes Mythtv very much [02:11] awesome :) enjoy myth like I said early, falling in love with it more and more day by day [02:12] croppa: I still want to know which nvidia card you're using :) [02:13] can put some tuners back again which were a problem with 9.04 [02:13] klucas: the card i am using is an onboard gforce 6 on a ASUS M2NPV-VM motherboard [02:14] croppa: cool thanks [02:14] it is onboard so can still use a small box [02:15] I dont know if the motherboard is available still [02:16] croppa: ya this aopen xcube is a pretty small box and not going to deal with a motherboard swap verry well [02:17] so I'm looking for a pcie card that'll fit in the low profile box [02:17] and have vdpau compatibility [02:17] I was looking on the mythtv wiki earlier and could only find cards that had partial vdpau compatibility [02:17] at my local retailer [02:18] thanks for the tip though I'll find out what chipset it's running and see if I can find something similar for the kinda money I'm looking to spend [02:19] croppa: where are you? [02:37] 'night all === jakent_ is now known as jakent [04:26] does anybody have experience w/ PVR-150 IR blaster? If so, I would greatly appreciate some help :) [04:38] does anybody have any experience w/ PVR-150 IR blaster? If so - I'd /greatly/ appreciate some guidance ;) [04:39] !help [04:39] !help For a complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi Other available commands: !status, !about, !bug [bug_number]. [04:49] does anybody have experience w/ PVR-150 IR blaster? If so, I would greatly appreciate some help :) [05:58] !repeat [05:58] Don't repeatedly ask your question more than 1 time per 2 hours. It makes the mods mad and you will be kicked. === Guest98536 is now known as jussi01 [13:49] hello guys anybody alive who is using iptv? [13:51] im using gentoo+mythtv ( iptv ) and got problem with load on cpu... does any1 has same problem like me? [13:52] btw hw conf: MSI Media Live Barebone with 4400+ [14:27] Mythfilldatabase runs perfectly if I run it manually, but the backend never seems to run it by itself even though I specified it to run daily. I've searched for a solution but can't see what I'm doing wrong. [15:37] hi folks - my mythbuntu9.10 is doing samba-sharing of myth stuff perfectly; but how do I add an arbitrary folder as a separate share? [15:43] aha, found https://launchpad.net/thunar-shares which is prob what I want [15:43] [launchpad.net] Thunar-Shares in Launchpad [15:44] Zinn: thanks :) timing [15:48] (btw great job mythbuntu folks - been running it for a couple of months, v nice integration) [16:37] test post [16:38] dunno why, my jobqueue table got screwed up [16:38] had to do a repair table jobqueue use_frm; to fix it [20:27] anyone know how to assign multiple key strokes to one remote button press in lirc. trying to editing my ~/.lirc/mythtv config file to send a key macro === Guest32953 is now known as Seeker` [22:43] i bought a hauppauge hvr-1600. decided to take my old cards out and put just put it in. but my graphics card goes into low res mode when i do that. === john is now known as Guest9761 [23:10] i get the following error when trying to reconfigure my backend on 9:10 Failed to create or modify database (incorrect admin username/password?) [23:17] crap! just as i decided to put the other cards back in i found the solution. back on my knees! [23:57] Hi. I've got mythbuntu karmic on a laptop, and a UIR-compatible receiver working through a USB serial adapter. when it suspends to ram then wakes up, the device name always changes from /dev/ttyACM0 to ttyACM1. so the remote stops working. it only changes if lircd has locked it before the suspend.. any way to fix this?