[OpenSIPS-Devel] [ opensips-Bugs-2085158 ] db_mysql doesn't compile with MySQL 4.1.22 on RHEL 4

[SourceForge.net]

Bugs item #2085158, was opened at 2008-08-31 17:06
Message generated for change (Comment added) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2085158&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.4.x
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Andrew Pogrebennyk (apogrebennyk)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: db_mysql doesn't compile with MySQL 4.1.22 on RHEL 4

Initial Comment:
Hi,

I have the MySQL-devel package installed among other on my RHEL 4 system:
MySQL-client-4.1.22-0.glibc23
MySQL-bench-4.1.22-0.glibc23
MySQL-devel-4.1.22-0.glibc23
MySQL-server-4.1.22-0.glibc23
MySQL-embedded-4.1.22-0.glibc23
MySQL-shared-4.1.22-0.glibc23

/usr/include/mysql/mysql_version.h contains the following definitions:
#define PROTOCOL_VERSION                10
#define MYSQL_SERVER_VERSION            "4.1.22"
#define MYSQL_BASE_VERSION              "mysqld-4.1"
#define MYSQL_SERVER_SUFFIX_DEF         "-standard"
#define FRM_VER                         6
#define MYSQL_VERSION_ID                40122
#define MYSQL_PORT                      3306
#define MYSQL_UNIX_ADDR                 "/var/lib/mysql/mysql.sock"
#define MYSQL_CONFIG_NAME               "my"
#define MYSQL_COMPILATION_COMMENT       "MySQL Community Edition - Standard (GPL)"

Compilation of db_mysql module in 1.4.1 fails with this error:
Compiling res.c
gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -Wall -minline-all-stringops -falign-loops -mtune=pentium4 -DMOD_NAME='"db_mysql"'    -DNAME='"opensips"' -DVERSION='"1.4.1-notls"' -DARCH='"i386"' -DOS='"linux"' -DCOMPILER='"gcc 3.4.6"' -D__CPU_i386 -D__OS_linux -D__SMP_yes -DCFG_DIR='"/usr/local/etc/opensips/"' -DPKG_MALLOC -DSHM_MEM  -DSHM_MMAP -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DSTATISTICS -DCHANGEABLE_DEBUG_LEVEL -DF_MALLOC  -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024  -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_EPOLL -DHAVE_SIGIO_RT -DHAVE_SELECT -I/usr/include -c res.c -o res.o
res.c: In function `db_mysql_get_columns':
res.c:88: error: `MYSQL_TYPE_NEWDECIMAL' undeclared (first use in this function)
res.c:88: error: (Each undeclared identifier is reported only once
res.c:88: error: for each function it appears in.)
make[1]: *** [res.o] Error 1
make[1]: Leaving directory `/root/opensips-1.4.1-notls/modules/db_mysql'
make: *** [modules] Error 2

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

>Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2008-09-01 21:13

Message:
Logged In: YES 
user_id=1275325
Originator: NO

Hi,

A fix is available on trunk and 1.4 branch - please upgrade and test.

Thanks and regards,
Bogdan

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

Comment By: Andrew Pogrebennyk (apogrebennyk)
Date: 2008-08-31 18:48

Message:
Logged In: YES 
user_id=2064595
Originator: YES

Thanks, I have already solved this by commenting out that line in res.c. I
thought the developers would fix this permanently by wrapping the line in
some preprocessor directives.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2008-08-31 18:35

Message:
Logged In: NO 

It appears that the type NEWDECIMAL was introduced in mysql in major
version release 5.  If you installed from packages then a yum update or
whatever manager you are using should fix the problem.  If you installed
from source, just upgrade to at least version 5.0 for mysql.

I haven't been able to find this in a changelog yet but the mysql api
doesn't list this data type on the mysql documentation library.

http://dev.mysql.com/doc/refman/4.1/en/c-api-datatypes.html





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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2085158&group_id=232389