Re: Smsd Bug ?

[Jan Derfinak]

On Tue, 18 Jun 2002, Raphael Bellec wrote:

Hi.

> libmysql client version is the last version in "stable" debian, which is 
> 3.22.30-4
> mysql itself is not on this computer.
> the error msg is 
> 
> Erreur dlopen : /usr/local/stow/gnokii//share/smsd/libmysql.so: undefined 
> symbol: mysql_real_escape_string
> Cannot load database module mysql in directory 
> /usr/local/stow/gnokii//share/smsd

I use mysql 3.23.49. The function mysql_real_escape_string() is defined:
-----------------
8.4.3.176 mysql_real_escape_string()

unsigned int mysql_real_escape_string(MYSQL *mysql, char *to,
const char *from, unsigned int length) 

8.4.3.177 Description

This function is used to create a legal SQL string that you can use in a SQL
statement. See section 6.1.1.1 Strings. 

-----------------

I think that problem is in old mysql version. I don't know if your mysql has
this function. Please can you verify this?

If not you can upgrade mysql or replace mysql_real_escape_string with my
function strEscape (See file pq.c for usage).


                                        jano

-- 
The future's uncertain, and the end is always near
                        The Doors-Roadhouse Blues