Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Marco van de Voort
On Wed, Mar 03, 2010 at 11:52:40AM +, Henry Vermaak wrote: > >> should link to mysqlclient.so (using the symlink, the unix way). > > > > I agree completely, and there is already a way to check the client > > library version in the mysql api. > > But what if they're dynamically loaded? Most us

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Luiz Americo Pereira Camara
Joost van der Sluis escreveu: Bottom-line: don't use MySQL. And do not upgrade your MySQL-client library version. Currently i don't use client server RDMS at all. For client server i would prefer Firebird given other experiences. But the problem is that most web host companies only offer

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Joost van der Sluis
On Tue, 2010-03-02 at 20:11 +0100, Marco van de Voort wrote: > On Tue, Mar 02, 2010 at 02:59:12PM +, Henry Vermaak wrote: > > > seems to have fallen from the air, connecting to nothing ? > > > > I presume it comes from here (in mysql.inc): > > > > const > > mysqllib = 'libmysqlclient.'+

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Henry Vermaak
On 3 March 2010 10:30, Sven Barth wrote: > > As far as I see it, it tries to load two libaries dynamically: > libmysqlclient.so.15 at first and libmysqlclient.so as fallback. On my system > (ArchLinux) libmysqlclient.so is a symlink to the current version (.16), so > the application is able to

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Henry Vermaak
On 3 March 2010 09:18, Henry Vermaak wrote: > On 2 March 2010 19:11, Marco van de Voort wrote: >> >> mysql version is a disaster (and one of the reasons why I avoid mysql when I >> can). IMHO FPC should never hardcode the number in the first place, but >> should link to mysqlclient.so (using the

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Vincent Snijders
2010/3/2 Marco van de Voort : > > Anyway, long story short, FPC has a provision for such mistakes, -XLA > > Try passing -XLAlibmysqlclient.so.15=libsqlclient.so.16 and pray. Isn't this only useful for dynamic linking at compile time, not for dynamic loading at run time? Vincent -- __

[Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Sven Barth
Hi again! > Henry Vermaak wrote: > > This is good to know, but the issue was that the compiler was trying > to link against a version of a library that didn't exist on the > system. As far as I see it, it tries to load two libaries dynamically: libmysqlclient.so.15 at first and libmysqlclient.so

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Henry Vermaak
On 3 March 2010 08:44, Sven Barth wrote: > > The problem is not mysqlvlib as also mysqllib is checked for. The problem is > the version string returned by the API. This is checked for in > fcl-db/src/sqldb/mysql/mysqlconn.inc/TConnectionName.DoInternalConnect. > This is good to know, but the is

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Henry Vermaak
On 2 March 2010 19:11, Marco van de Voort wrote: > > mysql version is a disaster (and one of the reasons why I avoid mysql when I > can). IMHO FPC should never hardcode the number in the first place, but > should link to mysqlclient.so (using the symlink, the unix way). I agree completely, and th

[Lazarus] Lazarus & MySQL 5.1

2010-03-03 Thread Sven Barth
Hi together! I'm using MySQL 5.1 without problems on my Linux machine. >I presume it comes from here (in mysql.inc): > > const >mysqllib = 'libmysqlclient.'+sharedsuffix; > {$IF DEFINED(mysql50)} >mysqlvlib = mysqllib+'.15'; > {$ELSEIF DEFINED(mysql41)} >mysqlvlib = mysqllib+'.14';

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Mattias Gaertner
On Tue, 02 Mar 2010 17:37:46 -0600 "Terry A. Haimann" wrote: > How do I do this in Lazarus? Project / Project Options / Compiler / Other >[...] > > Try passing -XLAlibmysqlclient.so.15=libsqlclient.so.16 and pray. Mattias -- ___ Lazarus mailing lis

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread waldo kitty
On 3/2/2010 18:34, Terry A. Haimann wrote: I have tried this and it doesn't work. in what way "it doesn't work"?? do you get an error or a complete failure with nothing indicating what went wrong? FWIW: "it doesn't work" is pretty poor for an analysis to work from :P ;) waldo kitty wrote:

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Terry A. Haimann
How do I do this in Lazarus? Marco van de Voort wrote: On Tue, Mar 02, 2010 at 02:59:12PM +, Henry Vermaak wrote: seems to have fallen from the air, connecting to nothing ? I presume it comes from here (in mysql.inc): const mysqllib = 'libmysqlclient.'+sharedsuffix; {$IF

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Terry A. Haimann
I have tried this and it doesn't work. waldo kitty wrote: On 3/1/2010 23:18, Terry A. Haimann wrote: I upgraded my laptop to Fedora Core 12, which has MySQL 5.1.42 installed. I have installed the latest Lazarus RPM, which is 0.9.28.2 and FPC 2.2.4. My Lazarus App won't connect to the server. I

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Marco van de Voort
On Tue, Mar 02, 2010 at 02:59:12PM +, Henry Vermaak wrote: > > seems to have fallen from the air, connecting to nothing ? > > I presume it comes from here (in mysql.inc): > > const > mysqllib = 'libmysqlclient.'+sharedsuffix; > {$IF DEFINED(mysql50)} > mysqlvlib = mysqllib+'.15';

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Henry Vermaak
On 2 March 2010 14:48, Marco van de Voort wrote: > On Mon, Mar 01, 2010 at 10:18:48PM -0600, Terry A. Haimann wrote: >> I upgraded my laptop to Fedora Core 12, which has MySQL 5.1.42 >> installed.  I have installed the latest Lazarus RPM, which is 0.9.28.2 >> and FPC 2.2.4.  My Lazarus App won't c

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-02 Thread Marco van de Voort
On Mon, Mar 01, 2010 at 10:18:48PM -0600, Terry A. Haimann wrote: > I upgraded my laptop to Fedora Core 12, which has MySQL 5.1.42 > installed. I have installed the latest Lazarus RPM, which is 0.9.28.2 > and FPC 2.2.4. My Lazarus App won't connect to the server. I have the > libmysqlclient.s

Re: [Lazarus] Lazarus & MySQL 5.1

2010-03-01 Thread waldo kitty
On 3/1/2010 23:18, Terry A. Haimann wrote: I upgraded my laptop to Fedora Core 12, which has MySQL 5.1.42 installed. I have installed the latest Lazarus RPM, which is 0.9.28.2 and FPC 2.2.4. My Lazarus App won't connect to the server. I have the libmysqlclient.so.16.0.0 installed. I am not sure

[Lazarus] Lazarus & MySQL 5.1

2010-03-01 Thread Terry A. Haimann
I upgraded my laptop to Fedora Core 12, which has MySQL 5.1.42 installed. I have installed the latest Lazarus RPM, which is 0.9.28.2 and FPC 2.2.4. My Lazarus App won't connect to the server. I have the libmysqlclient.so.16.0.0 installed. I am not sure where to get the libmysqlclient.so.15.