<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
please disregard previous message . It needed patch -p1 instead of -p0.<br><br>Will check soon...<br><br>Yianni.<br><br><br><br><hr id="stopSpelling">From: yiannividalis@hotmail.com<br>To: mythtv-users@mythtv.org<br>Date: Thu, 29 Jul 2010 16:54:27 +0300<br>Subject: Re: [mythtv-users] problem with Greek characters in storage group paths<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
<br>Date: Tue, 27 Jul 2010 18:29:58 -0400<br>From: mtdean@thirdcontact.com<br>To: mythtv-users@mythtv.org<br>Subject: Re: [mythtv-users] problem with Greek characters in storage group paths<br><br>
On 07/27/2010 03:57 PM, Yianni Vidalis wrote:
<blockquote cite="mid:COL121-W27977DEB71DAD20F2B6E4FBBA70@phx.gbl">
<style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
Well, I've spent the last two days trying to isolate the problem.<br>
<br>
It turns out there were more than one:<br>
<br>
I think the conversion of the non-ascii storage group path relates
to #8530, but it only creates problem if the top storage group
folder includes non-ascii characters. Subfolders are scanned ok.<br>
</blockquote>
<br>
So we /do/ have a user trying to use non-ASCII characters in a SG
path. :)<br>
<br>
Can you apply and test the attached patch, please? I don't have a
setup that would allow me to test it, but I'm pretty sure it should
fix all the issues related to the utf8_bin collation.<br>
<br>
If you can give it a thorough testing, I'll commit it. By "thorough
testing," I mean adding a non-ASCII directory using the Storage
Directories section in mythtv-setup, and verifying that the editor
still shows the directory path properly when you exit and re-enter;
making sure that the storage group path is correct in the backend
status page ( <a class="ecxmoz-txt-link-freetext" href="http://" target="_blank">http://</a><hostname>:6544/ )--note that it may not
display correctly due to HTML encoding issues, but if you look at
the source of the HTML, it should probably have the proper
characters; and testing the access to the storage directories<br>
<br>
<blockquote cite="mid:COL121-W27977DEB71DAD20F2B6E4FBBA70@phx.gbl"><br>
the command:<br>
<br>
mysql -umythtv -p mythconverg -e 'status;' <br>
<br>
on my old database was giving me:<br>
<br>
Server characterset: latin1<br>
Db characterset: latin1<br>
Client characterset: utf8<br>
Conn. characterset: utf8<br>
<br>
whilst the newly created in opensuse 11.2 <br>
<br>
Server characterset: utf8<br>
Db characterset: utf8<br>
Client characterset: utf8<br>
Conn. characterset: utf8<br>
<br>
I included in my /etc/my.cnf under [mysqld]<br>
default-character-set=latin1<br>
character_set_server=latin1<br>
<br>
and fixed that part (of course, I recreated the database)<br>
</blockquote>
<br>
Yeah, please make sure you have a known-good database schema when
you test. If you have done any schema changes at all, it will break
things. If you have data that you need to recover from an old
database (recording information or history), please let me know and
I'll give you more information on how to recover that information
into a good database. If you're just getting started, just creating
a new database would work.<br>
<br>
<blockquote cite="mid:COL121-W27977DEB71DAD20F2B6E4FBBA70@phx.gbl">Now, the main problem that I am still facing, and for
which I would appreciate any help, is that the backend cannot scan
video folders that include non-ascii subfolders or files but only
when it is started by the /etc/init.d/mythbackend script.<br>
<br>
If I start mythbackend as the mythtv user or root, and start
mythfrontend on another terminal, everything is perfectly ok and
the database gets updated with the videos.<br>
<br>
I scanned some old tickets (including one of mine) and came
accross #7487. I think it is very similar to that.<br>
<br>
Here is a very small part of the log (mythfrontend -v all) that
shows what the frontend reads in the folders. It actually creates
incremental paths with tens of '/' until it stops and starts on
the next file. It's almost fun to watch!<br>
</blockquote>
<br>
<a class="ecxmoz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/dev/439348#439348" target="_blank">http://www.gossamer-threads.com/lists/mythtv/dev/439348#439348</a><br>
<br>
Thanks for the reminder to fix storagegroup.dirname access (and for
the testing :).<br>
<br>
Mike<br>
<br>
<br>Thank you for the patch, unfortunately it fails against 25427M<br><br>patching file mythtv/libs/libmythdb/storagegroup.cpp<br>Hunk #1 FAILED at 359.<br>Hunk #2 FAILED at 472.<br>Hunk #3 FAILED at 656.<br>Hunk #4 FAILED at 738.<br>4 out of 4 hunks FAILED -- saving rejects to file mythtv/libs/libmythdb/storagegroup.cpp.rej<br>patching file mythtv/libs/libmyth/storagegroupeditor.cpp<br>Hunk #1 FAILED at 199.<br>1 out of 1 hunk FAILED -- saving rejects to file mythtv/libs/libmyth/storagegroupeditor.cpp.rej<br>patching file mythtv/programs/mythbackend/mainserver.cpp<br>Hunk #1 FAILED at 3964.<br>1 out of 1 hunk FAILED -- saving rejects to file mythtv/programs/mythbackend/mainserver.cpp.rej<br>patching file mythtv/programs/mythtv-setup/checksetup.cpp<br>Hunk #1 FAILED at 97.<br><br>Yianni.<br>                                           
<br>_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users                                            </body>
</html>