Bug 99379 - requires MySQL 4.x, but seems to work on 3.23.x
Summary: requires MySQL 4.x, but seems to work on 3.23.x
Status: RESOLVED NOT A BUG
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 1.3.5
Platform: RedHat Enterprise Linux Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
: 106576 (view as bug list)
Depends on:
Blocks:
 
Reported: 2005-02-14 17:34 UTC by Aurelien Bompard
Modified: 2006-06-11 12:32 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
patch to configure to detect mysql < 4.0 (345 bytes, patch)
2005-02-14 17:35 UTC, Aurelien Bompard 		Details
allow of of mysql3 too (1.64 KB, patch)
2005-10-25 17:41 UTC, Rex Dieter 		Details
Show Obsolete (1) View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.