[08:08] <Hawke> Hii all. im really really new to linux, im trying to get mythbuntu up and running. i have it all installed, when i log on it launches to setup, i select my language then it goes to database config and whatever i do it cant connect to the database. i have made sure my username is in mythtv group, and i have checked the password is correct but im so new i dont really know what else to try. any help for me to try would be great. than
[18:12] <Hawke84> hi im having real problems installing mythbuntu, i cant get past the configure database, it wont connect to the mysql. im really new to linux. any suggestions?
[19:39] <qwebirc68730>  hey is anyone there?
[19:53] <superm1> qwebirc68730: yeah
[19:54] <superm1> what's up?
[20:57] <sabhain> Is it better to upgrade a backend server, or do a complete re-install?  Currently on 10-10 or 10-04.
[20:57] <sabhain> Some version of LTS I think
[20:58] <sabhain> Generally things are stable, but I'm getting longer and longer freezes at the top and bottom of the hour
[20:58] <sabhain> Also, I need to add a slave backend to the system, and that's a new system
[21:01] <superm1> sabhain: if it's LTS it's 10.04 probably then
[21:02] <superm1> depends on how your data is organized for which i would say is better
[21:02] <superm1> if you are putting recordings on a separate partition/drive, it's probably easier to just backup your mythconverg database, reinstall, reload database
[21:03] <superm1> if recordings are on same drive, you just need to be careful that they don't get lost in the reinstall
[21:03] <sabhain> superm1: they're on separate drives, but within the same system.
[21:03] <superm1> ok.  the other question is what other stuff have you done different than the standard install?
[21:04] <superm1> if you installed a lot of apps or configured a lot of services specially, that's just extra work to redo later so an upgrade might be more convenient
[21:04] <sabhain> I think it's pretty vanilla, really, outside of customizing LIRC settings.  The big thing I'm going to lose in the upgrade will be diskless
[21:04] <sabhain> I've been running diskless on 3 front-ends .. and it's been pretty awesome.  But with the cost of a small SSD what it is, I'm prepared to just do separate installs again.
[21:05] <superm1> yeah it's too bad we don't have a good way to do diskless anymore
[21:05] <superm1> i wish it would be revived
[21:05] <sabhain> It's really been the most stable server I've ever had.
[21:05] <superm1> if you're getting freezes, i'd be wary to think it's actually the software though
[21:06] <superm1> like the HW is frozen?
[21:06] <sabhain> I'd love to jump in and figure it out .. but just too much happening.  I understand from another user (wyhzzrd??) that it works, it's just the ltsp arguments that need to be tweaked
[21:06] <superm1> or like a long mysql query is pegging the system?
[21:07] <sabhain> whenever you're watching anything (live, recorded, or video) .. and the system is recording and switches programs (at the top or bottom of the hour generally), I get a 5-10 second *hesitation* .. and then playback resumes as if norma.
[21:07] <sabhain> normal
[21:07] <sabhain> hardly ever get any real hangs or freezes that require a restart
[21:08] <sabhain> maybe 3-4 times a year?
[21:11] <superm1> ohh
[21:11] <superm1> yeah that's mysql queries
[21:11] <superm1> i've read posts on mailing list about people with major problems on that
[21:11] <sabhain> I was wondering if there was some sort of log that I should clear out
[21:11] <superm1> it's lessened with newer versions of mythtv, but some other stuff you can do:
[21:11] <superm1> 1) optimize the mysql database
[21:12] <superm1> 2) move mysql to a different drive
[21:13] <superm1> check and see which mysql optimizations you have enabled
[21:13] <superm1> http://www.mythtv.org/wiki/Optimizing_Performance
[21:13] <superm1> there's more on there
[21:17] <superm1> http://code.mythtv.org/trac/ticket/2335 also fixes a problem like that, but it's from versions that came out before ubuntu 10.04
[21:21] <sabhain> superm1: how do you do (2)?  You relocate the database from / ?
[21:22] <Jay2k1> stop mysql, move the directory somewhere else, then symlink the directory back
[21:23] <sabhain> and would there be a performance improvement if the recordings themselves were on a different system than the backend processes?  Say a JBOD on the LAN?
[21:23] <sabhain> or a streamlined NFS server?
[21:29] <superm1> sabhain: well the key is database on a separate drive from recordings
[21:29] <superm1> not sure your mounting structure though, are they on the same drive?
[21:30] <superm1> i don't think putting recordings on a JBOD on a LAN would help, you'll just saturate your LAN link and make your frontend performance dip
[21:39] <sabhain> superm1: what's the default location of mysql?
[21:40] <superm1> sabhain:  /var/lib/mysql i thinks
[21:41] <sabhain> they're on different physical drives.  the mythconverg is on the / drive with the system files, but all recordings are on different drives
[21:58] <superm1> yeah then that shouldn't change things for you
[21:59] <superm1> try those mysql database optimizations
[23:52] <possum007> What does "Error opening jump program file" mean?