Back to Home / #mythtv / 2008 / 03 / Prev Day | Next Day
#mythtv IRC Logs for 2008-03-21

---Logopened Fri Mar 21 00:00:24 2008
00:22-!-superm1 [n=superm1@ubuntu/member/superm1] has joined #mythtv
00:27-!-gnome42 [] has quit [Remote closed the connection]
00:35-!-purserj [] has quit [Read error: 113 (No route to host)]
00:39-!-purserj [] has joined #mythtv
00:56-!-dramman [] has joined #mythtv
00:56-!-mzb_d800 [] has quit ["Time to quit"]
00:56-!-dramman [] has left #mythtv []
00:59-!-purserj [] has quit [Remote closed the connection]
00:59-!-purserj [] has joined #mythtv
01:20-!-purserj [] has quit [Remote closed the connection]
01:20-!-purserj [] has joined #mythtv
01:21-!-cattelan [] has joined #mythtv
01:23-!-BathoryQuorthon [] has left #mythtv ["Great Hall Awaits a Fallen Brother"]
01:34-!-purserj [] has quit [Read error: 113 (No route to host)]
01:59-!-carvajal [n=carvajal@] has joined #mythtv
02:00-!-cattelan [] has quit [Read error: 104 (Connection reset by peer)]
02:28<Chutt>no HDHR replacement until next thursday :(
02:30<GreyFoxx>Was the QT4 merge gonna happen tomorrow?
02:30<Chutt>not until there's a way to fix the utf8 issue
02:31<GreyFoxx>ahhh opk
03:51<xris>Chutt: I have a spare. :)
03:51<xris>granted, the guy from LFNW finally emailed today asking for raffle donations...
04:09-!-xris [] has quit []
04:32-!-joobie [] has quit ["Leaving"]
04:43-!-feiner [] has quit [Read error: 104 (Connection reset by peer)]
04:55-!-mykeul [n=mykeul@] has joined #mythtv
05:00-!-feiner [] has joined #mythtv
05:05-!-beavis_ [] has joined #mythtv
06:56-!-purserj [] has joined #mythtv
07:16-!-TelnetManta [] has quit ["Ex-Chat"]
08:04-!-_gunni_ [] has joined #mythtv
08:23-!-|gunni| [] has joined #mythtv
08:39-!-_gunni_ [] has quit [Read error: 110 (Connection timed out)]
08:40-!-purserj [] has quit [Read error: 113 (No route to host)]
08:50-!-purserj [] has joined #mythtv
09:02-!-purserj [] has quit [Connection reset by peer]
09:17-!-purserj [] has joined #mythtv
09:30-!-gardz [] has quit []
09:36-!-mykeul [n=mykeul@] has quit ["Leaving."]
09:42-!-fizban99 [] has joined #mythtv
09:47-!-fizban99 [] has left #mythtv ["Konversation terminated!"]
09:51-!-purserj [] has quit [Remote closed the connection]
09:52-!-purserj [] has joined #mythtv
10:14-!-bofh80 [n=bofh80@] has joined #mythtv
10:16-!-nordle [n=nordle@] has joined #mythtv
10:16-!-nordle [n=nordle@] has left #mythtv []
10:16-!-nordle [n=nordle@] has joined #mythtv
10:17-!-nordle [n=nordle@] has left #mythtv []
10:40-!-JoeyBorn [] has quit [Read error: 110 (Connection timed out)]
10:41-!-gnome42 [] has joined #mythtv
11:33-!-onyxsoft_ [] has joined #mythtv
11:33-!-onyxsoft [] has quit [Read error: 104 (Connection reset by peer)]
11:49-!-onyxsoft_ [] has quit ["Ex-Chat"]
11:49-!-onyxsoft_ [] has joined #mythtv
11:49-!-onyxsoft_ [] has quit [Read error: 104 (Connection reset by peer)]
11:49-!-onyxsoft [] has joined #mythtv
11:49-!-bofh80 [n=bofh80@] has quit [Remote closed the connection]
11:59-!-JoeBorn [] has joined #mythtv
12:54-!-xris [] has joined #mythtv
12:54-!-xris [] has quit [Read error: 104 (Connection reset by peer)]
12:55-!-xris [] has joined #mythtv
13:48-!-gbee [] has quit ["Gone"]
13:57-!-jgarvey [] has joined #mythtv
13:58-!-xris [] has quit []
14:04-!-xris [] has joined #mythtv
14:07-!-xri1 [n=xris@] has joined #mythtv
14:11-!-xri1_ [] has joined #mythtv
14:11-!-xris [] has quit [Read error: 104 (Connection reset by peer)]
14:14-!-gbee [] has joined #mythtv
14:28-!-xri1 [n=xris@] has quit [Read error: 110 (Connection timed out)]
14:35-!-ahbritto [] has joined #mythtv
14:42<gbee>QObject::connect: Cannot queue arguments of type 'bool&'(Make sure 'bool&' is registered using qRegisterMetaType().)
14:43<gbee>not sure where that comes from, since QT fails to give adequate info
14:43<gbee>there is an instance in the preview generator of a signal/slot using a bool
14:54<MrGandalf>trade it out for an int
14:54<janneg>I saw the same message with SignalMonitorValue which is understandable
14:55<janneg>but according to it should aleready know bool
14:55<Chutt>a reference to a bool, though?
14:56<janneg>ah, probably not
15:00<janneg>I'm writing atm an awk script to generate the db update for fixing utf8 with qt4
15:01<Chutt>janneg, cool =)
15:01<janneg>I think I'll settle in converting to BINARY and BLOB
15:02<janneg>if someone has a huge preference for utf8 he might convince me to add that
15:03<janneg>but easiest way to convert existing databases to utf8 needs the BINARY conversion too
15:06<Chutt>might ask on the dev list to see if anyone has any other opinion
15:06<Chutt>unless you don't care =)
15:11<janneg>I was thinking of it but discarded it in the fear of a endless discussion
15:13<janneg>but I'll ask and commit that I think is best after a day or so
15:22-!-iamlindoro__ [] has quit []
15:22<jams>GreyFoxx- you about?
15:26-!-nwahmaet [n=pjudge@] has joined #mythtv
15:29-!-iamlindoro_ [] has joined #mythtv
15:36<MrGandalf>Isn't there a performance hit on utf8 tables?
15:39-!-aeha [] has left #mythtv []
15:41<janneg>MrGandalf: I don't know. if you can find a source with more information please repply to ny post
15:41<MrGandalf>janneg: I just remember from experience
15:43<MrGandalf>what's the min. supported mysql version now days?
15:47<janneg>are there telnet clients with readline support?
15:48<laga>janneg: rlwrap?
15:52-!-nwahmaet [n=pjudge@] has left #mythtv []
15:54<janneg>editing recordings over the network control is ...
15:58-!-BathoryQuorthon [] has joined #mythtv
15:59<sphery>janneg: If we need to go from latin1->binary->utf8, to go to utf8, anyway, going latin1->binary now works, then if a reason for utf8 is found, we can "finish" later, right?
16:03<janneg>sphery: that's at least the easiest way to convert the data I know
16:04<sphery>so, that approach makes the most sense to me--there's really no reason that the utf8 conversion has to happen now.
16:04<sphery>(if ever)
16:17<MrGandalf>and why doesn't latin1 work?
16:17<MrGandalf>(sorry, I know it's been discussed here)
16:20<janneg>latin1 would work only for latin1 chars
16:21<sphery>MrGandalf: And, what we've been doing--storing utf8 in latin1 fields in the DB-won't work with changes to the QT MySQL driver in QT4.
16:24<MrGandalf>I see.. I didn't know Myth did that.
16:33-!-kormoc [n=kormoc@unaffiliated/kormoc] has joined #mythtv
16:38<Anduin>The switch to binary fields is going to break anywhere we depend on automatic case conversion (LIKE) and DB sorting will be nonsense.
16:43<MrGandalf>from what I've read, mysql versions > 4.1 handle utf8 correctly and is now the standard.
16:47<sphery>Anduin: And all the users who "know" how to use MySQL directly will wonder why their queries no longer work like they used to. :)
16:48<Anduin>sphery: Yeah, I personally don't care, I'll have to rewrite a few custom searches, and in fairness it isn't as if current DB sorting works for everyone.
16:49<Anduin>It looks like we should require 5.0.19 though (they seem to have sorted out padding/stripping issues by then)
16:53<sphery>Currently the DBMS version check in dbcheck.cpp is only comparing to version 5. If we change MINIMUM_DBMS_VERSION to 5.0.19, the check should still work (but we'd want to change the log message that's output for failure to remove the ".0" after MINIMUM_DBMS_VERSION.
16:53<janneg>I don't care about db sorting but missing case conversion is imho blocker for BINARY
16:53-!-xomp [] has joined #mythtv
16:53<Chutt>i'd agree on that
16:53<janneg>the first stable 5.0 release was iirc 5.0.18
16:54<xomp>just installed mythtv and when I try to run it; it tells me "Cannot login to database?" then just goes into this never ending cycle of setup. Any suggestons?
16:54<Anduin>xomp: #mythtv-users
16:55<xomp>ah, thanks
16:55-!-xomp [] has left #mythtv ["Leaving"]
16:56<sphery>The DBUtil::CompareDBMSVersion() should work relatively well even for major/minor/point comparison, but if users are running MySQL versions that don't use a relatively "sane" server version string (which can be changed), they'll end up needing to use DBMSVersionOverride .
16:57<sphery>sane means that the first string of contiguous digits is the major, second is minor, third is point. I.e. "CoolDBMS2-5.0.19" would parse to version 2.5.0.
16:58<sphery>I'm guessing it won't be a problem for most, but mentioning it in case we do require a specific point release.
17:03-!-BathoryQuorthon_ [] has joined #mythtv
17:09-!-BathoryQuorthon [] has quit [Nick collision from services.]
17:10-!-BathoryQuorthon_ is now known as BathoryQuorthon
17:11-!-mo0dbo0m [] has quit [Client Quit]
17:16-!-frankr [] has joined #mythtv
17:17<frankr>Hello.. I just setup mythtv on a debian box, it has a radeon 7000 card with 64mb, glxgears runs very smoothly but when I run mythtv in opengl mode the fades go suuuuper slow
17:18<sphery>We can do DB sorting with something like "SELECT CONVERT(binary_col USING utf8) FROM tbl_name" and if we specify a collation of utf8_general_ci we'll still be able to do case-insensitive stuff. It may be better for searching, etc. to do the conversions beforehand, though.
17:18<sphery>frankr: #mythtv-users
17:25-!-frankr [] has quit ["Lost terminal"]
17:25-!-jgarvey [] has quit ["Leaving"]
17:29<gbee>why are so many people running mysql without innodb?
17:30-!-purserj [] has quit [Read error: 104 (Connection reset by peer)]
17:32-!-purserj [] has joined #mythtv
17:32-!-reynaldo_ is now known as reynaldo
17:41<hads>gbee: This is a comment in the default Debian my.cnf "# You might want to disable InnoDB to shrink the mysqld process by circa 100MB."
17:42<gbee>huh? doesn't use anything like that on my machines
17:43<sphery>And the line after it says, "# If you do, eventually gbee will fix the MythWeather foreign-key constraints requirement"
17:43<gbee>at least don't think it does, mysql is way less memory hungry than mythbackend ...
17:44*gbee says as he notices that his backend is leaking
17:44<hads>gbee: I don't know of the actual effects but I just remembered seeing it.
17:44<gbee>I'll get around to fixing mythweather sometime before 0.23, though maybe someone will just submit a patch and save me a tedious job
17:45<sphery>gbee: Or, we can go to MySQL embedded, then we can switch everyone to InnoDB, then we can use foreign keys, etc. everywhere.
17:46<sphery>As you said, QT4 claims to make embedded MySQL a breeze... :)
17:46<gbee>it's not nice to tease ...
17:46<gbee>shame there is more to switching to an embedded database than just that
17:47<hads>gbee: I just checked with top. Restarted mysql with innodb enabled, 124M VIRT, restarted again with it disabled and 44676 VIRT
17:47<gbee>so I was wrong :)
17:47<hads>Just thought it would be interesting to see if the comment was right :)
17:47<sphery>gbee: To encourage someone to write a patch (or at least to prevent someone who might otherwise write it from being discouraged), you might want to add a comment to that ticket explaining why running without InnoDB may not be a good idea.
17:48<sphery>hads: I'm running at 125MiB virt (almost 120 writable/private) with InnoDB.
17:48<gbee>sphery: already did (before the latest comment)
17:48<sphery>Yeah, but last word always wins...
17:49<sphery>Now that someone said, "It works if you just take out the innodb word..." (or whatever).
17:49<gbee>meh, maybe tomorrow, I just want to watch TV for the first time this week
18:11-!-czth_ [n=dbrobins@nat/microsoft/x-ced885007256d1f5] has joined #mythtv
18:27-!-czth__ [n=dbrobins@nat/microsoft/x-fd5a8fdb73b9e33b] has quit [Read error: 110 (Connection timed out)]
18:40-!-purserj [] has quit [Read error: 104 (Connection reset by peer)]
19:04<janneg>ugh, I'm creting 500 lines db update just for the main mythtv tables
19:08<janneg>should I set the charset of the columns explicitly to utf8 or should I just change the default charset and expect a unmodified db schema
19:19-!-beavis_ [] has quit ["Verlassend"]
19:30<sphery>I think after fixing the columns, you'll want to do an ALTER TABLE tbl_name DEFAULT CHARACTER SET utf8; so that any new (character-based) columns added to the table will be utf8. Also, might want an ALTER DATABASE mythconverg CHARACTER SET = utf8 COLLATE = utf8_general_ci; to ensure new tables use the right charset and that new connections use the case-insensive collation. Neither does any conversions.
19:30<sphery>But I'm not sure if that's what you were asking...
19:34<janneg>not sure either, but don't think I want to set all columns explicitly to utf8
19:35<janneg>so I have to change the default database charset to utf8 before converting the columns back to char
19:36<janneg>make install
19:44<sphery>The ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8; (instead of "DEFAULT CHARACTER SET utf8") normally tells MySQL to convert each (character-based) column in the entire table to utf8, but to tell it to convert each column in the table to utf8, maintaining the appropriate size, but if you first convert to binary, the columns are no longer character-based, so they won't be converted.
19:45<sphery>d/ but to tell it to convert each column in the table to utf8,/
19:45<sphery>copy/paste issue
19:47<sphery>So I would expect you'll have to explicitly convert each column from binary to utf8. AIUI, the database default is only used when creating new tables and to specify a value for new connections to use.
19:51<janneg>the actual data is already utf8. so no explicit conversions seems necessary
19:54<sphery>Oh. Nevermind. I missed the part about converting each column back to char type. It sounds like it should use the default charset. You may need to set the default for the table (as above) first, though (as it would override the database default).
19:59-!-ahbritto [] has quit [Client Quit]
20:37-!-_gunni_ [] has joined #mythtv
20:43-!-superm1 [n=superm1@ubuntu/member/superm1] has quit [Read error: 104 (Connection reset by peer)]
20:52-!-|gunni| [] has quit [Read error: 113 (No route to host)]
21:02-!-jonathan_poon [] has joined #mythtv
21:02<jonathan_poon>hey guys..
21:02-!-jonathan_poon [] has left #mythtv ["Leaving"]
21:02-!-superm1 [n=superm1@ubuntu/member/superm1] has joined #mythtv
21:06-!-xri1_ is now known as xris
21:09-!-reynaldo_ [] has joined #mythtv
21:29-!-reynaldo [] has quit [Read error: 110 (Connection timed out)]
21:31-!-reynaldo [] has joined #mythtv
21:32<sphery>I wonder if someone should update the 0.21-fixes checkout instructions on to match (or perhaps just refer to)
21:34-!-_gunni_ [] has quit ["KVIrc 3.2.4 Anomalies"]
21:43-!-dasunt [n=dasunt@unaffiliated/dasunt] has joined #mythtv
21:43-!-dasunt [n=dasunt@unaffiliated/dasunt] has left #mythtv []
21:44-!-reynaldo_ [] has quit [Read error: 110 (Connection timed out)]
23:33-!-kormoc [n=kormoc@unaffiliated/kormoc] has quit []
23:56-!-scott23 [] has joined #mythtv
23:56-!-scott23 [] has left #mythtv []
---Logclosed Sat Mar 22 00:00:50 2008