On 8/21/06, <b class="gmail_sendername"><a href="mailto:mstrimel@comcast.net">mstrimel@comcast.net</a></b> <<a href="mailto:mstrimel@comcast.net">mstrimel@comcast.net</a>> wrote:<div><span class="gmail_quote"></span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>Just installed 0.19 using apt on SuSE 10.0, only to learn that this myth version is incompatible with MySQL 5. Oops. So I guess I need to do this over with
0.19-fixes. Before I start:</blockquote><div><br>Does YaST not have an RPM package for SuSE? I thought that apt was strictly a Debian or Debian-derived distribution tool. If you installed myth from an RPM, it should have cross-referenced the dependencies and told you which version of MySQL was required. Also, as far as I know, MySQL 5 is backwards compatible with other MySQL versions (in terms of SQL language support, anyway).
<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">1. Other than uninstalling the previous version of mythtv using apt-get, anything else I must *undo* before I compile
0.19-fixes?</blockquote><div><br>I'd do a quick search using find or locate to see if there are any myth files hanging around. Delete any .myth dirs in home directories. All other files should be removed by your package manager as they typically aren't touched by the user.
<br> </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">2. Is it OK to leave the mythtv user intact before I proceed? (I"ve read that RPM installs hang if user mythtv already exists)
</blockquote><div><br>Sure, why not? If you have a user named 'mythtv', it's just a user. An RPM shouldn't depend on a certain user name... and if it does, it shouldn't hang if that user already exists. In fact, it should use the existing UID/GID.
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">3. Before starting, should I delete the mythconverg database somehow? (database backup is not needed) If so, how? The "drop" database command suggested elsewhere on this board did *not* work for me (no output, and the db was still there.)
</blockquote><div><br>If you want a clean slate, then yes... I would recommend deleting the database. As for the command, first log into your mysql server (using the 'mysql' command). Make sure you login as a user that has DROP privileges for the mysqlconverg database. Most MySQL servers typically have a root user... use that one. Then, the command is simple... immediately after logging in, do a 'DROP DATABASE mythconverg' and you're done.
<br> </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">4. Is there a way to purge the listings database? Something seems wrong with my listings (see below), so I'd rather start over, but "mythfilldatabase --update-all" (paraphrasing here) doesn't seem to really get rid of everything if I'm reading the output correctly.
</blockquote><div><br>The safest was is probably through mythtv-setup. Run that and delete your listing source by deleting and recreating your video sources. This should empty the entire program table from the database. Alternatively, you can try manually clearing the program table (I have no idea what this will do). Use a SQL command like 'DELETE FROM
mythconverg.program WHERE chanid>0'.<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">5. My install of 0.19 had my channels off by one (
I.e., the listings would show a program on channel 4 when it was really on channel 5, and so on.) The channels were also out of order: after "10" was "101", etc. -- not handling the 3-digit channels properly. I have a PVR-250 hooked into a DirecTV box that worked fine with mythtv .17. I've researched this off-by-one problem and it looks complicated to solve, so I need a little guidance on the easy bits:
</blockquote><div><br>I don't have DirecTV, so I can't really speak to that. As for having the channels off by one, that happened to me once. All I did was run 'mythtv-setup' again. I deleted my listings using the method described above and re-created it. That fixed everything.
<br></div><br></div>- Joe<br>