Bug 99379

Summary:	requires MySQL 4.x, but seems to work on 3.23.x
Product:	[Applications] amarok	Reporter:	Aurelien Bompard <gauret>
Component:	general	Assignee:	Amarok Developers <amarok-bugs-dist>
Status:	RESOLVED NOT A BUG
Severity:	normal	CC:	kde-bugzilla, rdieter
Priority:	NOR
Version:	1.3.5
Target Milestone:	---
Platform:	RedHat Enterprise Linux
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	patch to configure to detect mysql < 4.0 allow of of mysql3 too

Description Aurelien Bompard 2005-02-14 17:34:30 UTC

Version:           1.2 (using KDE KDE 3.3.1)
Installed from:    RedHat RPMs
Compiler:          gcc-3.4.2 
OS:                Linux

In the configure script, the include flags for mysql are found by running mysql_config --include. This switch is only available for mysql > 4.0. There is an equivalent switch which works for all versions: --cflags.
There are still a few distributions which ship mysql 3.x.x due to the change in licensing (resolved recently).
I'll attach a patch to make it work with an old mysql

Comment 1 Aurelien Bompard 2005-02-14 17:35:36 UTC

Created attachment 9623 [details]
patch to configure to detect mysql < 4.0

Comment 2 Christian Muehlhaeuser 2005-02-14 21:31:38 UTC

sorry, we depend on mysql >=4.x. dont remember the exact reason, but there were some problems with temporary tables, iirc.

regards,
muesli

Comment 3 gneeki 2005-03-07 20:57:30 UTC

I have amarok 1.2.1 working fine with mysql 3.23.58, as far as I can
tell - I think the only problem with temporary tables is that the
GRANT sql command for writing to them doesn't exist <4, so the wiki
page for mysql throws an error. You just need to leave out the grant
on temporary tables - I'm told anyone can create them in v3, and it
seems to work fine.

Course, something might break. But I see no sign yet.

Comment 4 Alexandre Oliveira 2005-03-07 21:05:12 UTC

Due to last comment, I reopened the bug.
Any other known problem with mysql 3.X?

Comment 5 Thiago Macieira 2005-03-08 03:08:43 UTC

Changing the summary to reflect the new purpose.

Comment 6 gneeki 2005-05-25 18:00:23 UTC

Why hasn't this been incorporated? Amarok works fine with MySQL version 3, and it just needs a check for this in configure, with the patch above. I have to make this change in the tarball everytime I compile a new version. Can it be implemented please?

To repeat, all that MySQL version 3 needs is to change "mysql_config --include" to "mysql_config --cflags". A quick check in configure will do this.

Comment 7 Alexandre Oliveira 2005-06-01 00:20:43 UTC

*** Bug 106576 has been marked as a duplicate of this bug. ***

Comment 8 Rex Dieter 2005-10-25 17:35:52 UTC

Confirmed against 1.3.5 too.

Comment 9 Rex Dieter 2005-10-25 17:41:28 UTC

Created attachment 13151 [details]
allow of of mysql3 too

mysql_config --cflags only if it works
mysql_config --include only if it works

Comment 10 Greg Meyer 2006-03-01 03:15:14 UTC

Is this fixed now?

Comment 11 Rex Dieter 2006-03-01 03:53:34 UTC

Not fixed yet, not until someone applies patch (at least the configure.in.in bits) from comment #9.

I could do it, provided it's approved by an amarok developer.

Comment 12 Jeff Mitchell 2006-05-26 22:25:54 UTC

I'm guessing a dev hasn't applied it cause none of us are using mysql 3 anymore and don't want to downgrade :-)

Comment 13 Mark Kretschmann 2006-05-31 12:15:59 UTC

Sorry, we won't support 3.x any more. We simply can't maintain it. It's two major versions outdated by now.