[00:02] <croppa> Good morning I was wondering if anyone can steer me in the right direction
[00:03] <croppa> I have just upgraded from Ubuntu 9.04 to 9.10 and mythtv works fine on the backend/frontend machine
[00:05] <croppa> but other front ends cannot connect to it.
[00:05] <croppa> Mythtv scema version has upgraded to 1244
[00:07] <croppa> It seems to be that the outside frontends are havng trouble connecting to the database
[00:08] <croppa> my reading seems that others are having trouble with the database not upgrading properly
[00:10] <croppa> I am not an expert on mysql (infact am probably below newby) but love mythtv and have been using it for years
[00:12] <croppa> The outside frontends report cannot login to database.
[00:13] <klucas> Yes, croppa, I'm rapidly falling in love with mythtv myself.
[00:14] <klucas> if you log on to the front end and fire up a command line
[00:14] <klucas> are you able to log into the database with the CLI mysql client
[00:14] <klucas> hand on I'll look up the command
[00:15] <klucas> *hang
[00:15] <croppa> would this procedure from nerver fixit http://ubuntuforums.org/showthread.php?t=1302135
[00:15] <Zinn> [ubuntuforums.org] [SOLVED] Can't Upgrade Database - Ubuntu Forums
[00:15] <klucas> mysql -u <username> -p -h <host IP>
[00:18] <croppa> Is the password that is asked for the one used by the frontend to connect to the database?
[00:18] <croppa> ie the 8 character one
[00:19] <klucas> croppa: it'll depend on what you entered for the username.
[00:19] <klucas> 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] <croppa> mythtv
[00:20] <klucas> okay is there a user 'mythtv' on the back-end mysql database?
[00:24] <croppa> 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] <klucas> personally I use the webmin mysql module to do database administration but a lot of people use phpmyadmin
[00:32] <klucas> either will show you what users are set up.
[00:32] <klucas> really there are only 2 things that could be wrong
[00:32] <klucas> either the front end can't 'see' the backend
[00:33] <klucas> likely because of firewall config or other network conditions
[00:33] <klucas> or it can see the backend but can't log in
[00:33] <klucas> usually because of user/password issues
[00:35] <croppa> 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] <klucas> 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] <croppa> yes
[00:37] <klucas> okay was it the backend, front end or both that you upgraded?
[00:37] <croppa> and the frontend on the frontend/backend machine works fine
[00:38] <klucas> so you've got a fronend/backend combo on one machine and a master backend on another?
[00:38] <croppa> just that the other frontend machins cannot conect eventhough thay have also been upgraded to 9,10
[00:39] <croppa> no i have onlyt one backend with a frontend and other machins which also conect to it
[00:39] <klucas> ah, okay.
[00:40] <klucas> so you know the username 'mythtv' that the working frontend is connecting to
[00:40] <klucas> if you log on to one of the non-working frontend only machines
[00:40] <klucas> open up a terminal
[00:41] <klucas> and type mysql -u mysql -p -h <ip address of backend machine>
[00:41] <klucas> sorry
[00:41] <klucas> mysql -u mythtv -p -h <ipaddress of backend machine>
[00:42] <klucas> and enter the mythtv user's database password
[00:42] <klucas> when prompted what do you get?
[00:44] <croppa> I have done that and tried every password i can think of and no luck loging in
[00:45] <croppa> I have also tried on the backend machine
[00:45] <croppa> Is there a way to reset the password?
[00:45] <klucas> okay, yes
[00:45] <klucas> if it were me
[00:46] <klucas> I'd load webmin on the backend machine
[00:46] <klucas> if it wasn't installed
[00:46] <klucas> then launch a web browser on it
[00:46] <klucas> and point it to https://localhost:10000
[00:46] <klucas> and log on as root with the root PW
[00:47] <klucas> navigate to the servers section
[00:47] <klucas> then mysql
[00:47] <klucas> and find the mythtv user
[00:47] <klucas> then in there there's an option to reset the password
[00:47] <klucas> 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] <klucas> I'd set it to something that I'd know (clearly) then go back to the front end machine
[00:48] <klucas> in questino
[00:48] <klucas> question
[00:48] <klucas> and run mythtv-setup
[00:48] <klucas> and in the section where it asks about which backend to connect to
[00:48] <klucas> I'd plug in mythtv as the username
[00:48] <klucas> and the password I'd just created
[00:49] <croppa> I have been trying to use that password before but to no avail
[00:51] <croppa> The front end on the frontend/backend has that password in its setup
[00:51] <klucas> I'm sorry, I don't think I follow?
[00:51] <croppa> bummer webmin not in ubuntu repos but not a problem
[00:52] <klucas> There's an installer on the webmin site one sec...
[00:52] <klucas> www.webmin.com
[00:52] <Zinn> [www.webmin.com] Webmin
[00:53] <klucas> the senior guy where I work shits on webmin all the time but I find it useful
[00:56] <croppa> 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] <croppa> I have used webmin befor and found it very usefull
[00:57] <klucas> croppa: okay so that tells us that the mysql server on the frontend/backend machine is just not accepting remote logins
[00:58] <croppa> Am just downloading webmin anyway
[00:58] <klucas> 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] <klucas> cool
[00:59] <croppa> no
[00:59] <klucas> if not try mysql -u mythtv -p -h 127.0.0.1 on the frontend/backend machine
[00:59] <Zinn> [127.0.0.1] MaineFish Productions
[00:59] <klucas> to go at the DB locally
[00:59] <croppa> I am flicking between 2 machines with a KVM switch
[01:00] <klucas> or better yet try mysql -u mythtv -p on the fronend/backend machine
[01:00] <klucas> then plug in the mythtv pw and does it let you in?
[01:00] <croppa> Yes that lets me in
[01:00] <klucas> cool
[01:01] <klucas> so mysql on the backend just isn't listening on the external interface
[01:01] <croppa> yes that sounds possiable
[01:01] <klucas> 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] <klucas> if you tell it to listen on 192.168.174.60 in addition to localhost
[01:02] <klucas> that should solve the issue with the remote frontends.
[01:02] <croppa> ok I will now install webmin
[01:02] <klucas> I believe <sp?>
[01:03] <croppa> Thank you for your help if you are gone befor i get back 8-)
[01:03] <klucas> back shortly (note I didn't use 'brb') :)
[01:03] <klucas> np
[01:13] <klucas> croppa: what video card do you prefer on you frontends?
[01:13] <klucas> I want to upgrade the one on mine (currently using an on-board intel one on an old xcube)
[01:43] <croppa> klucas: I am using a Nvidia and conecting to the LCD tv through the digital output
[01:44] <klucas> croppa: cool, which nvidia?
[01:44] <klucas> I've got this thing connecting to a vga port on my tv at the moment
[01:44] <croppa> 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] <klucas> and I'd like to go dvi/hdmi but I'm limited to low provfile
[01:46] <klucas> okay, so then I'd be looking to allow the mythtv user to connect on the external interface
[01:47] <croppa> the card i am using is an onboard gforce 6 on a ASUS M2NPV-VM motherboard
[01:47] <klucas> and possibly looking to see if the mysql port (can't remember what it is) is allowed through the firewall
[01:47] <klucas> on the backend machine
[01:48] <klucas> once you get it working from the command line the mythtv gui should just fall into place
[01:48] <croppa> Port is 3306
[01:51] <klucas> okay so is the firewall on the backend allowing connections to 3306?
[01:52] <klucas> and check to see that the mythtv user is allowed to connect via remote hosts in webmin
[01:52] <klucas> if so
[01:52] <klucas> then try to connect via the front end
[01:53] <klucas> by going on the front end and doing mysql -u mythtv -p -h 192.168.174.60
[02:03] <klucas> once you get that logon working your front ends(s) will be fine.
[02:06] <croppa> thankyou thankyou thankyou thankyou a change in webmin which i hadnt found has made all the difference
[02:07] <croppa> It was stopping all but 127.0.0.1
[02:07] <Zinn> [127.0.0.1] MaineFish Productions
[02:09] <klucas> 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] <Zinn> [127.0.0.1] MaineFish Productions
[02:09] <croppa> klucas: mysql server configeration > listening address
[02:09] <klucas> croppa: yep, I knew I remember seeing it in there somewhere
[02:09] <klucas> glad it's going for you
[02:09] <klucas> :)
[02:10] <croppa> Thankyou very much again................saved my bacon with management (She who must be obeyed) She likes Mythtv very much
[02:11] <klucas> awesome :) enjoy myth like I said early, falling in love with it more and more day by day
[02:12] <klucas> croppa: I still want to know which nvidia card you're using :)
[02:13] <croppa> can put some tuners back again which were a problem with 9.04
[02:13] <croppa> klucas: the card i am using is an onboard gforce 6 on a ASUS M2NPV-VM motherboard
[02:14] <klucas> croppa: cool thanks
[02:14] <croppa> it is onboard so can still use a small box
[02:15] <croppa> I dont know if the motherboard is available still
[02:16] <klucas> croppa: ya this aopen xcube is a pretty small box and not going to deal with a motherboard swap verry well
[02:17] <klucas> so I'm looking for a pcie card that'll fit in the low profile box
[02:17] <klucas> and have vdpau compatibility
[02:17] <klucas> I was looking on the mythtv wiki earlier and could only find cards that had partial vdpau compatibility
[02:17] <klucas> at my local retailer
[02:18] <klucas> 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] <klucas> croppa: where are you?
[02:37] <klucas> 'night all
[04:26] <zephead> does anybody have experience w/ PVR-150 IR blaster?  If so, I would greatly appreciate some help :)
[04:38] <zephead> does anybody have any experience w/ PVR-150 IR blaster?  If so - I'd /greatly/ appreciate some guidance ;)
[04:39] <zephead> !help
[04:39] <Zinn> !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] <zephead> does anybody have experience w/ PVR-150 IR blaster?  If so, I would greatly appreciate some help :)
[05:58] <darthanubis> !repeat
[05:58] <Zinn> Don't repeatedly ask your question more than 1 time per 2 hours.  It makes the mods mad and you will be kicked.
[13:49] <Zdeno> hello guys anybody alive who is using iptv?
[13:51] <Zdeno> im using gentoo+mythtv ( iptv ) and got problem with load on cpu... does any1 has same problem like me?
[13:52] <Zdeno> btw hw conf: MSI Media Live Barebone with 4400+
[14:27] <rabotnik> 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] <boxer_> 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] <boxer_> aha, found https://launchpad.net/thunar-shares which is prob what I want
[15:43] <Zinn> [launchpad.net] Thunar-Shares in Launchpad
[15:44] <boxer_> Zinn: thanks :) timing
[15:48] <boxer_> (btw great job mythbuntu folks - been running it for a couple of months, v nice integration)
[16:37] <arriflex> test post
[16:38] <arriflex> dunno why, my jobqueue table got screwed up
[16:38] <arriflex> had to do a repair table jobqueue use_frm; to fix it
[20:27] <egghead> 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
[22:43] <dodddummy> 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.
[23:10] <Guest9761> 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] <dodddummy> crap! just as i decided to put the other cards back in i found the solution.  back on my knees!
[23:57] <jarrod1> 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?