=== dahlSTROM|sleep is now known as dahlSTROM | ||
=== hpeter_ is now known as hpeter | ||
=== hpeter_ is now known as hpeter | ||
stevie_man | hey all, I'm trying to get my backend up and running but I cannot connect to the database. I get the error: "Cannot login". Why I try to login to mysql using the mythtv user I get access denied for user 'mythtv@localhost'. I let myth do the whole automatic table setup thing | 15:49 |
---|---|---|
tgm4883 | stevie_man, is mysql started | 15:56 |
stevie_man | tgm4883: yes, I was looking at the logs and I think mythbackend was using the hosts entry for 127.0.0.1 I had that said zues (name of the server) and not the one that said localhost | 15:57 |
tgm4883 | stevie_man, so 'mysql -u mythtv -p mythconverg' gives you access denied? | 15:58 |
stevie_man | yep | 15:58 |
tgm4883 | odd | 15:59 |
stevie_man | very | 15:59 |
tgm4883 | I'd try resetting it | 15:59 |
tgm4883 | !mysql | 15:59 |
Zinn | If you are having problems connecting to your mysql database, perform the following to reconfigure it: [1] sudo dpkg-reconfigure mysql-server-5.5 (pay attention to the root password you set, you will need it later) [2] sudo dpkg-reconfigure mythtv-database [3] sudo dpkg-reconfigure mythtv-common | 15:59 |
stevie_man | I'm going to wipe everything and try again with the 127.0.0.1 zues entry commented out | 15:59 |
stevie_man | So here is my mythbackend log. http://pastebin.ubuntu.com/6184448/ | 16:05 |
stevie_man | Yes I know I'm using .24 it's for testing only before I switch everythinf over to .27 | 16:05 |
tgm4883 | stevie_man, did you go though mythtv-setup? | 16:11 |
tgm4883 | stevie_man, that is so old, i'm not even sure I remember all of the oddities of it | 16:11 |
stevie_man | yah, that's what is generated when I do the mythtv-setup | 16:15 |
stevie_man | what is this? Using configuration directory = /var/lib/mythtv/.mythtv | 16:27 |
stevie_man | when I try to cd into it I'm told it is not a directory and when I try to edit it it's not a file | 16:27 |
tgm4883 | it looks like it thinks that is the home directory for the mythtv user | 16:28 |
tgm4883 | what did you do? | 16:28 |
stevie_man | Nothing that I know of | 16:28 |
tgm4883 | what version of ubuntu is this? | 16:28 |
stevie_man | I'm on Debian Squeeze | 16:29 |
tgm4883 | ok, where did you install the packages from? | 16:29 |
stevie_man | from www.deb-multimedia.org | 16:32 |
tgm4883 | hmm | 16:33 |
tgm4883 | stevie_man, so for some reason, their packages are looking in that directory for the config files | 16:33 |
* tgm4883 shrugs | 16:33 | |
stevie_man | even better the setup didn't create the mysql users this time around | 16:34 |
stevie_man | oh that one was my fault | 16:34 |
tgm4883 | stevie_man, this is why I tend to recommend mythbuntu | 16:35 |
stevie_man | yah, this is only a test, a prove of concept before I replace my working mediaportal frontends with mythbuntu | 16:35 |
stevie_man | so even before I run the ,ythtv-setup the user cannot connect to the database | 16:38 |
tgm4883 | is the user even setup in the database? | 16:41 |
stevie_man | tgm4883: The user was setup in the database twice. One @localhost and once @% | 18:20 |
stevie_man | What does the mythbuntu-repos.deb file do? (located at http://www.mythbuntu.org/files/mythbuntu-repos.deb) | 18:42 |
tgm4883 | stevie_man, it adds the repos tab to MCC for versions prior to 12.04 | 18:43 |
stevie_man | ah, can I use this to install .25 then? (11.04?) | 18:44 |
tgm4883 | yea I think it's still available | 18:46 |
tgm4883 | yea it's still available | 18:46 |
=== dahlSTROM is now known as dahlSTROM|sleep | ||
stevie_man | tgm4883: how do I use the mythbuntu repo installer package once it is installed? | 20:02 |
tgm4883 | stevie_man, you need mythbuntu-control-centre | 20:03 |
stevie_man | oh so I need to be in mythbuntu to use the repo-installer? | 20:05 |
tgm4883 | stevie_man, no, mythbuntu-control-centre is another package. the repo installer is a plugin for i | 20:05 |
stevie_man | ah, I guess there isn't a control centre for Debian | 20:11 |
=== dahlSTROM|sleep is now known as dahlSTROM | ||
=== dahlSTROM is now known as dahlSTROM|sleep |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!