Mysql 8.x will not compile with latest Kannel
Hillel Bilman <[email protected]> Fri, 2 Aug 2019 16:29:48 +0200
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <CAMuHb=eHxABxTZ99EBkTs=rH_7uZNoat719poYif2AemgAFCPg@mail.gmail.com> |
--0000000000005f431a058f23310b
Content-Type: text/plain; charset="UTF-8"
Hi Alex,
The server I'm using has:
Mysql 8.0.17
Centos 7.x
Kannel svn-r5278M (latest version from svn)
Latest Kannel SVN will not compile with Mysql 8.0.17.
This error with Mysql 8.x was reported in redmine 08/18/2018
https://redmine.kannel.org/issues/782
But there does not seem to be any reported solution.
Any help is appreciated to be able to compile Kannel.
Steps using to compile Kannel:
svn co https://svn.kannel.org/gateway/trunk/ gateway
cd gateway
./bootstrap.sh
./configure --with-defaults=speed --with-mysql --enable-start-stop-daemon
--enable-ssl --disable-localtime --enable-cookies
make;make install
Configuring for Kannel gateway version svn-r5278M ...
..
Showing the database section with the two WARNINGs:
Configuring DB support ...
checking whether to compile with MySQL support... searching
checking for mysql_config... /bin/mysql_config
checking mysql version... 8.0.17
checking mysql reentrant libs... -L/usr/lib64/mysql -lmysqlclient -lpthread
-lm -lrt -lssl -lcrypto -ldl
checking for mysql_init in -lmysqlclient_r... no
checking mysql libs... -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt
-lssl -lcrypto -ldl
checking for mysql_init in -lmysqlclient... yes
checking mysql includes... -I/usr/include/mysql
checking mysql/mysql.h usability... yes
checking mysql/mysql.h presence... no
configure: WARNING: mysql/mysql.h: accepted by the compiler, rejected by
the preprocessor!
configure: WARNING: mysql/mysql.h: proceeding with the compiler's result
checking for mysql/mysql.h... yes
checking mysql/mysql_version.h usability... yes
checking mysql/mysql_version.h presence... yes
checking for mysql/mysql_version.h... yes
checking for mysql_stmt_init in -lmysqlclient_r... no
checking for mysql_stmt_init in -lmysqlclient... yes
checking whether to compile with MySQL support... yes
checking whether to compile with LibSDB support... disabled
checking whether to compile with SQLite2 support... disabled
checking whether to compile with SQLite3 support... disabled
checking whether to compile with Oracle support... disabled
checking whether to compile with PostgresSQL support... disabled
checking whether to compile with Redis support... disabled
checking whether to compile with FreeTDS Ct-Lib support... disabled
checking whether to compile with Cassandra support... disabled
root@eco007-truservcomm-jhb1-001 /home/kannel/gateway $ make
make all-recursive
make[1]: Entering directory `/home/kannel/gateway'
Making all in gwlib
make[2]: Entering directory `/home/kannel/gateway/gwlib'
/bin/sh ../libtool --tag=CC --mode=compile gcc -std=gnu99
-DHAVE_CONFIG_H -I. -I.. -g -O2 -D_XOPEN_SOURCE=600 -D_BSD_SOURCE
-D_DEFAULT_SOURCE -D_LARGE_FILES= -I/usr/include/libxml2
-I/usr/include/openssl -I/usr/include/mysql -MT dbpool.lo -MD -MP -MF
.deps/dbpool.Tpo -c -o dbpool.lo dbpool.c
libtool: compile: gcc -std=gnu99 -DHAVE_CONFIG_H -I. -I.. -g -O2
-D_XOPEN_SOURCE=600 -D_BSD_SOURCE -D_DEFAULT_SOURCE -D_LARGE_FILES=
-I/usr/include/libxml2 -I/usr/include/openssl -I/usr/include/mysql -MT
dbpool.lo -MD -MP -MF .deps/dbpool.Tpo -c dbpool.c -fPIC -DPIC -o
.libs/dbpool.o
In file included from gwlib.h:83:0,
from dbpool.c:70:
dbpool_mysql.c: In function 'mysql_select':
dbpool_mysql.c:248:48: error: 'my_bool' undeclared (first use in this
function)
bind[i].is_null = gw_malloc(sizeof(my_bool));
^
gwmem.h:122:43: note: in definition of macro 'gw_malloc'
#define gw_malloc(size) (gw_native_malloc(size))
^
dbpool_mysql.c:248:48: note: each undeclared identifier is reported only
once for each function it appears in
bind[i].is_null = gw_malloc(sizeof(my_bool));
^
gwmem.h:122:43: note: in definition of macro 'gw_malloc'
#define gw_malloc(size) (gw_native_malloc(size))
^
make[2]: *** [dbpool.lo] Error 1
make[2]: Leaving directory `/home/kannel/gateway/gwlib'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/kannel/gateway'
make: *** [all] Error 2
root@eco007-truservcomm-jhb1-001 /home/kannel/gateway $ rpm -qa|grep mysql
mysql-community-common-8.0.17-1.el7.x86_64
mysql-community-server-8.0.17-1.el7.x86_64
mysql-community-libs-8.0.17-1.el7.x86_64
mysql-community-libs-compat-8.0.17-1.el7.x86_64
mysql80-community-release-el7-3.noarch
mysql-community-client-8.0.17-1.el7.x86_64
mysql-community-devel-8.0.17-1.el7.x86_64
--0000000000005f431a058f23310b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Hi Alex,<div><br></div><div>The server I'm using has:<=
/div><div>Mysql 8.0.17<br></div><div>Centos 7.x</div><div>Kannel=C2=A0=C2=
=A0svn-r5278M (latest version from svn)</div><div><br></div><div>Latest Kan=
nel SVN will not compile with Mysql 8.0.17.</div><div>This error with Mysql=
8.x was reported in redmine=C2=A008/18/2018=C2=A0=C2=A0<a href=3D"https://=
redmine.kannel.org/issues/782">https://redmine.kannel.org/issues/782</a></d=
iv><div>But there does not seem to be any reported solution.</div><div><br>=
</div><div>Any help is appreciated to be able to compile Kannel.</div><div>=
<br></div><div>Steps using to compile Kannel:</div><div><span id=3D"gmail-d=
ocs-internal-guid-c7a2f41d-7fff-082a-2f5d-55050d97b44a"><p dir=3D"ltr" styl=
e=3D"line-height:1.656;margin-top:0pt;margin-bottom:0pt"><span style=3D"fon=
t-size:12pt;font-family:"Times New Roman";color:rgb(58,58,58);bac=
kground-color:transparent;font-variant-numeric:normal;font-variant-east-asi=
an:normal;vertical-align:baseline;white-space:pre-wrap">svn co <a href=3D"h=
ttps://svn.kannel.org/gateway/trunk/">https://svn.kannel.org/gateway/trunk/=
</a>=C2=A0 gateway</span></p><p dir=3D"ltr" style=3D"line-height:1.656;marg=
in-top:0pt;margin-bottom:0pt">cd gateway<br>./bootstrap.sh<br>./configure -=
-with-defaults=3Dspeed --with-mysql =C2=A0--enable-start-stop-daemon --enab=
le-ssl =C2=A0--disable-localtime =C2=A0--enable-cookies <br>make;make insta=
ll<br></p></span><div><br></div><div>Configuring for Kannel gateway version=
svn-r5278M ...=C2=A0</div><div>=C2=A0..<br></div><div>Showing the database=
section with the two WARNINGs:</div><div>Configuring DB support ...<br>che=
cking whether to compile with MySQL support... searching<br>checking for my=
sql_config... /bin/mysql_config<br>checking mysql version... 8.0.17<br>chec=
king mysql reentrant libs... -L/usr/lib64/mysql -lmysqlclient -lpthread -lm=
-lrt -lssl -lcrypto -ldl<br>checking for mysql_init in -lmysqlclient_r... =
no<br>checking mysql libs... -L/usr/lib64/mysql -lmysqlclient -lpthread -lm=
-lrt -lssl -lcrypto -ldl<br>checking for mysql_init in -lmysqlclient... ye=
s<br>checking mysql includes... -I/usr/include/mysql<br>checking mysql/mysq=
l.h usability... yes<br>checking mysql/mysql.h presence... no<br>configure:=
WARNING: mysql/mysql.h: accepted by the compiler, rejected by the preproce=
ssor!<br>configure: WARNING: mysql/mysql.h: proceeding with the compiler=
9;s result<br>checking for mysql/mysql.h... yes<br>checking mysql/mysql_ver=
sion.h usability... yes<br>checking mysql/mysql_version.h presence... yes<b=
r>checking for mysql/mysql_version.h... yes<br>checking for mysql_stmt_init=
in -lmysqlclient_r... no<br>checking for mysql_stmt_init in -lmysqlclient.=
.. yes<br>checking whether to compile with MySQL support... yes<br>checking=
whether to compile with LibSDB support... disabled<br>checking whether to =
compile with SQLite2 support... disabled<br>checking whether to compile wit=
h SQLite3 support... disabled<br>checking whether to compile with Oracle su=
pport... disabled<br>checking whether to compile with PostgresSQL support..=
. disabled<br>checking whether to compile with Redis support... disabled<br=
>checking whether to compile with FreeTDS Ct-Lib support... disabled<br>che=
cking whether to compile with Cassandra support... disabled<br></div><div><=
br></div><div>root@eco007-truservcomm-jhb1-001 /home/kannel/gateway $ make<=
br>make =C2=A0all-recursive<br>make[1]: Entering directory `/home/kannel/ga=
teway'<br>Making all in gwlib<br>make[2]: Entering directory `/home/kan=
nel/gateway/gwlib'<br>/bin/sh ../libtool =C2=A0--tag=3DCC =C2=A0 --mode=
=3Dcompile gcc -std=3Dgnu99 -DHAVE_CONFIG_H -I. -I.. =C2=A0 =C2=A0 -g -O2 -=
D_XOPEN_SOURCE=3D600 -D_BSD_SOURCE -D_DEFAULT_SOURCE -D_LARGE_FILES=3D -I/u=
sr/include/libxml2 -I/usr/include/openssl -I/usr/include/mysql -MT dbpool.l=
o -MD -MP -MF .deps/dbpool.Tpo -c -o dbpool.lo dbpool.c<br>libtool: compile=
: =C2=A0gcc -std=3Dgnu99 -DHAVE_CONFIG_H -I. -I.. -g -O2 -D_XOPEN_SOURCE=3D=
600 -D_BSD_SOURCE -D_DEFAULT_SOURCE -D_LARGE_FILES=3D -I/usr/include/libxml=
2 -I/usr/include/openssl -I/usr/include/mysql -MT dbpool.lo -MD -MP -MF .de=
ps/dbpool.Tpo -c dbpool.c =C2=A0-fPIC -DPIC -o .libs/dbpool.o<br>In file in=
cluded from gwlib.h:83:0,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0from dbpool.c:70:<br>dbpool_mysql.c: In function 'mysq=
l_select':<br>dbpool_mysql.c:248:48: error: 'my_bool' undeclare=
d (first use in this function)<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0bind[i].is_null =3D gw_malloc(sizeof(my_bool));<br>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ^<br>gwmem.h:122:43: note: in definition of macro 'gw_malloc'<b=
r>=C2=A0#define gw_malloc(size) (gw_native_malloc(size))<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>dbpo=
ol_mysql.c:248:48: note: each undeclared identifier is reported only once f=
or each function it appears in<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0bind[i].is_null =3D gw_malloc(sizeof(my_bool));<br>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ^<br>gwmem.h:122:43: note: in definition of macro 'gw_malloc'<b=
r>=C2=A0#define gw_malloc(size) (gw_native_malloc(size))<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>make=
[2]: *** [dbpool.lo] Error 1<br>make[2]: Leaving directory `/home/kannel/ga=
teway/gwlib'<br>make[1]: *** [all-recursive] Error 1<br>make[1]: Leavin=
g directory `/home/kannel/gateway'<br>make: *** [all] Error 2<br></div>=
<div><br></div><div>root@eco007-truservcomm-jhb1-001 /home/kannel/gateway $=
rpm -qa|grep mysql<br>mysql-community-common-8.0.17-1.el7.x86_64<br>mysql-=
community-server-8.0.17-1.el7.x86_64<br>mysql-community-libs-8.0.17-1.el7.x=
86_64<br>mysql-community-libs-compat-8.0.17-1.el7.x86_64<br>mysql80-communi=
ty-release-el7-3.noarch<br>mysql-community-client-8.0.17-1.el7.x86_64<br>my=
sql-community-devel-8.0.17-1.el7.x86_64<br></div><div><br></div></div></div=
>
--0000000000005f431a058f23310b--