| croppa | Good morning I was wondering if anyone can steer me in the right direction | 00:02 |
|---|---|---|
| croppa | I have just upgraded from Ubuntu 9.04 to 9.10 and mythtv works fine on the backend/frontend machine | 00:03 |
| croppa | but other front ends cannot connect to it. | 00:05 |
| croppa | Mythtv scema version has upgraded to 1244 | 00:05 |
| croppa | It seems to be that the outside frontends are havng trouble connecting to the database | 00:07 |
| croppa | my reading seems that others are having trouble with the database not upgrading properly | 00:08 |
| croppa | I am not an expert on mysql (infact am probably below newby) but love mythtv and have been using it for years | 00:10 |
| croppa | The outside frontends report cannot login to database. | 00:12 |
| klucas | Yes, croppa, I'm rapidly falling in love with mythtv myself. | 00:13 |
| 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:14 |
| 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:15 |
| 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:18 |
| 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:19 |
| klucas | okay is there a user 'mythtv' on the back-end mysql database? | 00:20 |
| 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:24 |
| 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:32 |
| 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:33 |
| 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:35 |
| 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:36 |
| 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:37 |
| 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:38 |
| croppa | no i have onlyt one backend with a frontend and other machins which also conect to it | 00:39 |
| klucas | ah, okay. | 00:39 |
| 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:40 |
| 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:41 |
| klucas | and enter the mythtv user's database password | 00:42 |
| klucas | when prompted what do you get? | 00:42 |
| croppa | I have done that and tried every password i can think of and no luck loging in | 00:44 |
| 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:45 |
| 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:46 |
| 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:47 |
| 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:48 |
| croppa | I have been trying to use that password before but to no avail | 00:49 |
| 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:51 |
| 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:52 |
| klucas | the senior guy where I work shits on webmin all the time but I find it useful | 00:53 |
| 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:56 |
| klucas | croppa: okay so that tells us that the mysql server on the frontend/backend machine is just not accepting remote logins | 00:57 |
| 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:58 |
| 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 | 00:59 |
| 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:00 |
| 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:01 |
| 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:02 |
| 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:03 |
| 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:13 |
| croppa | klucas: I am using a Nvidia and conecting to the LCD tv through the digital output | 01:43 |
| 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:44 |
| klucas | and I'd like to go dvi/hdmi but I'm limited to low provfile | 01:45 |
| klucas | okay, so then I'd be looking to allow the mythtv user to connect on the external interface | 01:46 |
| 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:47 |
| 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:48 |
| klucas | okay so is the firewall on the backend allowing connections to 3306? | 01:51 |
| 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:52 |
| klucas | by going on the front end and doing mysql -u mythtv -p -h 192.168.174.60 | 01:53 |
| klucas | once you get that logon working your front ends(s) will be fine. | 02:03 |
| croppa | thankyou thankyou thankyou thankyou a change in webmin which i hadnt found has made all the difference | 02:06 |
| croppa | It was stopping all but 127.0.0.1 | 02:07 |
| Zinn | [127.0.0.1] MaineFish Productions | 02:07 |
| 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:09 |
| croppa | Thankyou very much again................saved my bacon with management (She who must be obeyed) She likes Mythtv very much | 02:10 |
| klucas | awesome :) enjoy myth like I said early, falling in love with it more and more day by day | 02:11 |
| klucas | croppa: I still want to know which nvidia card you're using :) | 02:12 |
| 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:13 |
| klucas | croppa: cool thanks | 02:14 |
| croppa | it is onboard so can still use a small box | 02:14 |
| croppa | I dont know if the motherboard is available still | 02:15 |
| klucas | croppa: ya this aopen xcube is a pretty small box and not going to deal with a motherboard swap verry well | 02:16 |
| 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:17 |
| 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:18 |
| klucas | croppa: where are you? | 02:19 |
| klucas | 'night all | 02:37 |
| === jakent_ is now known as jakent | ||
| zephead | does anybody have experience w/ PVR-150 IR blaster? If so, I would greatly appreciate some help :) | 04:26 |
| zephead | does anybody have any experience w/ PVR-150 IR blaster? If so - I'd /greatly/ appreciate some guidance ;) | 04:38 |
| 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:39 |
| zephead | does anybody have experience w/ PVR-150 IR blaster? If so, I would greatly appreciate some help :) | 04:49 |
| 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. | 05:58 |
| === Guest98536 is now known as jussi01 | ||
| Zdeno | hello guys anybody alive who is using iptv? | 13:49 |
| Zdeno | im using gentoo+mythtv ( iptv ) and got problem with load on cpu... does any1 has same problem like me? | 13:51 |
| Zdeno | btw hw conf: MSI Media Live Barebone with 4400+ | 13:52 |
| 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. | 14:27 |
| 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:37 |
| boxer_ | aha, found https://launchpad.net/thunar-shares which is prob what I want | 15:43 |
| Zinn | [launchpad.net] Thunar-Shares in Launchpad | 15:43 |
| boxer_ | Zinn: thanks :) timing | 15:44 |
| boxer_ | (btw great job mythbuntu folks - been running it for a couple of months, v nice integration) | 15:48 |
| arriflex | test post | 16:37 |
| arriflex | dunno why, my jobqueue table got screwed up | 16:38 |
| arriflex | had to do a repair table jobqueue use_frm; to fix it | 16:38 |
| 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 | 20:27 |
| === Guest32953 is now known as Seeker` | ||
| 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. | 22:43 |
| === john is now known as Guest9761 | ||
| 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:10 |
| dodddummy | crap! just as i decided to put the other cards back in i found the solution. back on my knees! | 23:17 |
| 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? | 23:57 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!