Thank you for your reply.
Okay, I have tried the following.
ls /usr/include/mysql/
and mysql.h was in there.

As root:
LDFLAGS=-L/usr/lib/mysql CPPFLAGS=-I/usr/include/mysql

Removed the pure-ftpd-1.0.29 folder, re-extracted the .tar.bz2 and ran:
./configure --with-mysql

but still the same error.
I am glad people are still coming up with ideas

Hi,

Just tuning bathory's reply: LDFLAGS=-L/usr/lib/mysql CPPFLAGS=-I/usr/include/mysql ./configure --with-mysql ... (removed the 64 bit part).

You should run all in one command, as written in my previous post:
Don't split it in 2 parts

Hi druuna. I am running out of ideas too! I also thought bathory's idea could be a winner, especially when I saw he is a Slackware user.

Yes, still exactly the same error. I have tried to use the --with-mysql switch some years back and had no problems although at the time I knew nothing about sql. I am wishing to start using it now as I am using MySQL for some other web application databases, so it makes sense to use it for Pure-FTPd also.

I can not remove the old puredb just yet as they are currently in use. For the same reason I have not tried a reboot yet. Could the problem really be that the server is currently in use? I would hope not. If so, feel free to call me names ;-)

Have a look at bathory's reply (#18)

Oh right. My bad!
However, just tried it and nope, still not working, still the same error message. It is like we have changed nothing.

And did you also try "my" version (post #17)?

Sure did.

@druuna
I'm running pure-ftp 64bit, without mysql support on my Slackware64 with no problems.

@OP
Just for testing, I've installed mysql-5.1.46-x86_64 Slackware package and recompiled pure-ftp with mysql and it was compiled just fine. So I guess it's something with Fedora mysql libraries (or it's SELinux?)

Another thing to try is to add /usr/lib64/mysql (don't mix 32 and 64 bit libraries) in /etc/ld.so.conf, run ldconfig and retry.

So, I have removed any 32-bit MySQL bits, checked that /usr/lib64/mysql exists in /etc/ld.so.conf.d/mysql-x86_64.conf, re-run /sbin/ldconfig and tried again. Still the same error. I have SELinux set to permissive at the moment as it interferes with another service I run. It will be reactivated later but for now it is 'switched off'. It is starting to look like a Fedora thing.

Thank you all for the suggestions, I really appreciate it.

Doh, I'm also buffled!
As a last resort, you can download the mysql-5.1.50-linux-x86_64-glibc23 binary from www.mysql.com, extract it in some place like /opt and rename the directory /opt/mysql-5.1.50-linux-x86_64-glibc23 to /opt/mysql
Then use /opt/mysql/lib in /etc/ld.so.conf and LDFLAGS and /opt/mysql/include in CPPFLAGS and try again. I've also tested here (after removing the mysql Slackware package) and it also compiled fine.

I am not desperate for it to work so I don't think I will download from mysql.com and do a manual install. When my users have finished using the ftp I will try a reboot and some other things. I am sure in 6 months time or so it will be fixed by someone out there.

Thanks again for all your help

Fair enough.

Anyway I've done a little more research on this, because it looks very strange, and I've find out that the pure-ftpd configure script looks for mysql_config, so make sure it exists and it's in your PATH:
Regards

Hi,
Understandable. Do make sure you remove mysql first (both 32 and 64 bits versions)and also remove the links you created (see posts #10/11) before you start installing mysql from source.

A manual install does have another possible advantage: You can decide which switches/options to use (just as you want with pure-ftpd).

Well, we did try, too bad we could not come up with a solution.....

Morning guys,

I have tried exporting the path to mysql_config (after checking that it did exist and where it existed on here) but again it didn't work.

Thanks for reminding me about the symlinks I made in post 10.

Back when I was a Slackware user I did install MySQL from source. I suspect one day I will try it and see what happens.

I really appreciate the help as this the most help people have given me on a Linux forum before :-)