Re: [Tracker] mysql bug

[Jamie McCracken <jamiemcc blueyonder co uk>]

Gergan Penkov wrote:
> Hi all,
> I'm very busy atm so I could not help much with testing, but I've
> routinely update and use the tracker:)
> So I have found a bug in mysql - so just to let the fellow gentoo users
> or whoever uses mysql-5.0.24a (this version on gentoo is flagged as
> 5.0.24-r1).
> The tracker will not start with this version of mysql - it (in fact
> mysql) will spit out errors about the number of messages in errmsg.sys
> not being correct, but will proceed starting and will
> try to connect to the running server (or something like this - at
> least something, which is dependent on the global configuration), which
> of course will fail as it does not have the permissions to, so the next
> fatal error will be something like 
> [Warning] Can't create test file /var/lib/mysql/myhost.lower-test
> and this will be the end of it :(
> Now I resolved this with just copying the errmsg.sys
> from /usr/share/mysql/english to /usr/share/tracker/english and all is
> working now.
> These problems are somewhat similar to what I had in the beginning
> with having tracker trying to connect to my mysql server, so there is
> definitively a bug in mysql- trying to do, what it is doing after the
> first error, but is there any possibility to automagically use
> errmsg.sys from mysql and not install a copy of it as this seems to
> be very mysql-version-dependent?

it is but theres no real way round this other than to depend on the 
mysql server (which is out of the question).

tracker will always break whenever mysql changes the errmsg file and 
thats why I want to move towards sqlite (I aslo dont like their attitude 
to fixing bugs in the embedded version which seem to be very low 
priority - especially the ssl crap)

If we stick with mysql I will probably inline a cut down version of the 
mysql source in tracker and always use that for statically linking 
libmysqld.a

--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/