Re: [mythtv-users] Upgraded Mandriva to 2006 - problems with mysql and myth
David Watkins wrote: Well the problem appears to be here. Have you set an IP address on the backend? Database connection looks OK to me, unless you're connecting to the wrong database? Thanks for the help. It's fixed now, and here's what I think happened - 1. After the upgrade, the ethernet connection didn't work. 2. I set up a new connection, BUT I accidentally set up the firewire network connection (and I used the old address that my machine used to have) 3. When I discovered my mistake, I setup the ethernet card, but because the old address was in use, I used the next available address. 4. Mythbackend didn't like this. 5. I used Webmin to see if mysql was running (it was) 6. I reset the mythtv user password in mysql, to mythtv, or so I thought, but must have got it wrong. 7. So, I reset the machine's ip to the original address (and told firewire it would have to depend on dhcp :-)) 7. I tried to log into mysql at a console prompt as mythtv, and got the access denied error 8. Then I logged into mysql as root, and did a 'GRANT ALL ON mythconverg.* TO [EMAIL PROTECTED] IDENTIFIED BY "*mythtv*"; ' 9. Now it all works!!! So, don't know if the ip change somehow upset the backend (even though I had it configured to localhost or 127.0.0.1), but the rest was my fault. I have related it all here in case it helps somebody else sometime during an upgrade :-) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Upgraded Mandriva to 2006 - problems with mysql and myth
On 26/10/05, ffrr <[EMAIL PROTECTED]> wrote: > The upgrade from 2005LE to 2006 was fairly smooth, and nearly everything > works - except mythtv > > The problem seems to be something to do with mysql permissions and/or > host names. The back end dies as follows... > > 2005-10-26 17:59:40.637 New DB connection, total: 2 > 2005-10-26 17:59:41.079 mythbackend: MythBackend started as master server > 2005-10-26 17:59:41.334 DVB#0 DVB SI Table Parser Started > 2005-10-26 17:59:41.822 DVB#0 Using DVB card 0, with frontend DST DVB-T. > 2005-10-26 17:59:41.953 New DB connection, total: 3 > 2005-10-26 17:59:43.574 DVB#0 DVB signal 6200 | snr 5000 | ber 811e058 | unc > b7811134 > 2005-10-26 17:59:43.578 DVB#0 Status: LOCK. > 2005-10-26 17:59:43.579 DVB#0 Multiplex Locked > 2005-10-26 17:59:44.331 DVB#0 Successfully tuned to channel 1601. > 2005-10-26 17:59:44.604 New DB scheduler connection > 2005-10-26 17:59:45.557 mythbackend version: 0.18.20050523-1 www.mythtv.org > 2005-10-26 17:59:45.850 Enabled verbose msgs : important general > 2005-10-26 17:59:45.999 AutoExpire: Found 1 recorders w/max rate of 138 > MiB/min > 2005-10-26 17:59:46.040 AutoExpire: space: 2.0 GB w/freq: 10 min > 2005-10-26 17:59:47.561 Reschedule requested for id -1. > 2005-10-26 17:59:47.706 Scheduled 15 items in 0.1 = 0.07 match + 0.07 place > 2005-10-26 17:59:47.712 scheduler: Scheduled items > 2005-10-26 17:59:47.719 Seem to be woken up by USER > 2005-10-26 17:59:55.560 mythbackend: Running housekeeping thread > 2005-10-26 18:07:01.336 New DB connection, total: 1 > No setting found for this machine's BackendServerIP. > Please run setup on this machine and modify the first page > of the general settings. Well the problem appears to be here. Have you set an IP address on the backend? Database connection looks OK to me, unless you're connecting to the wrong database? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Upgraded Mandriva to 2006 - problems with mysql and myth
The upgrade from 2005LE to 2006 was fairly smooth, and nearly everything works - except mythtv The problem seems to be something to do with mysql permissions and/or host names. The back end dies as follows... 2005-10-26 17:59:40.637 New DB connection, total: 2 2005-10-26 17:59:41.079 mythbackend: MythBackend started as master server 2005-10-26 17:59:41.334 DVB#0 DVB SI Table Parser Started 2005-10-26 17:59:41.822 DVB#0 Using DVB card 0, with frontend DST DVB-T. 2005-10-26 17:59:41.953 New DB connection, total: 3 2005-10-26 17:59:43.574 DVB#0 DVB signal 6200 | snr 5000 | ber 811e058 | unc b7811134 2005-10-26 17:59:43.578 DVB#0 Status: LOCK. 2005-10-26 17:59:43.579 DVB#0 Multiplex Locked 2005-10-26 17:59:44.331 DVB#0 Successfully tuned to channel 1601. 2005-10-26 17:59:44.604 New DB scheduler connection 2005-10-26 17:59:45.557 mythbackend version: 0.18.20050523-1 www.mythtv.org 2005-10-26 17:59:45.850 Enabled verbose msgs : important general 2005-10-26 17:59:45.999 AutoExpire: Found 1 recorders w/max rate of 138 MiB/min 2005-10-26 17:59:46.040 AutoExpire: space: 2.0 GB w/freq: 10 min 2005-10-26 17:59:47.561 Reschedule requested for id -1. 2005-10-26 17:59:47.706 Scheduled 15 items in 0.1 = 0.07 match + 0.07 place 2005-10-26 17:59:47.712 scheduler: Scheduled items 2005-10-26 17:59:47.719 Seem to be woken up by USER 2005-10-26 17:59:55.560 mythbackend: Running housekeeping thread 2005-10-26 18:07:01.336 New DB connection, total: 1 No setting found for this machine's BackendServerIP. Please run setup on this machine and modify the first page of the general settings. and mythtv-setup saysthis many times at the prompt... 2005-10-26 18:30:41.910 Unable to connect to database! 2005-10-26 18:30:41.910 Driver error was [1/1045]: QMYSQL3: Unable to connect Database error was: Access denied for user 'mythtv'@'localhost' (using password: YES) Mysql is running, and I can see all the data in the mythconverg database from Webmin. I have tried resetting the password for the user mythtv (it's supposed to be mythtv isn't it?) Any ideas? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users