<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All,<BR>
While [ gmake prefix="/usr/local/kamailio-3.0" all ] I got the error below regarding the db_mysql, however I have already installed the mysql server in the path /usr/local/mysql and all the .h and lib files are there.<BR>
<BR>
Please suggest what's wrong here and how to fix the issue.<BR>
<BR>
=========<BR>
<BR>
Makefile.defs defs skipped<BR>gmake[1]: Entering directory `/usr/local/src/kamailio-3.0.0/kamailio/modules/db_mysql'<BR>gcc -fPIC -DPIC -g -O9 -funroll-loops -m64 -mcpu=ultrasparc -mtune=ultrasparc -Wall -DNAME='"kamailio"' -DVERSION='"3.0.2"' -DARCH='"sparc64"' -DOS='solaris_' -DOS_QUOTED='"solaris"' -DCOMPILER='"gcc 3.4.6"' -D__CPU_sparc64 -D__OS_solaris -DSER_VER=3000002 -DCFG_DIR='"/usr/local/kamailio-3.0/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DF_MALLOC -DUSE_TLS -DTLS_HOOKS -DSTATISTICS -DMALLOC_STATS -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DSPARC64_MODE -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -DHAVE_ALLOCA_H -DUSE_SIGACTION -DHAVE_DEVPOLL -DHAVE_SELECT -DHAVE_FILIO_H -DSER_MOD_INTERFACE -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/include/mysql -DMOD_NAME='"db_mysql"' -c km_dbase.c -o km_dbase.o -MMD -MP<BR>km_dbase.c:38:25: warning: mysql/mysql.h: No such file or directory<BR>km_dbase.c:39:26: warning: mysql/errmsg.h: No such file or directory<BR>km_dbase.c:40:33: warning: mysql/mysql_version.h: No such file or directory<BR>In file included from km_dbase.c:47:<BR>km_my_con.h:47: error: syntax error before "MYSQL_RES"<BR>km_my_con.h:47: warning: no semicolon at end of struct or union<BR>km_my_con.h:48: warning: type defaults to `int' in declaration of `con'<BR>km_my_con.h:48: warning: data definition has no type or storage class<BR>km_my_con.h:49: error: syntax error before "row"<BR>km_my_con.h:49: warning: type defaults to `int' in declaration of `row'<BR>km_my_con.h:49: warning: data definition has no type or storage class<BR>km_my_con.h:51: error: syntax error before '}' token<BR>km_dbase.c: In function `db_mysql_submit_query':<BR>km_dbase.c:81: error: dereferencing pointer to incomplete type<BR>km_dbase.c:82: warning: implicit declaration of function `mysql_ping'<BR>km_dbase.c:82: error: dereferencing pointer to incomplete type<BR>km_dbase.c:83: warning: implicit declaration of function `mysql_error'<BR>km_dbase.c:83: error: dereferencing pointer to incomplete type<BR>km_dbase.c:83: warning: format argument is not a pointer (arg 7)<BR>km_dbase.c:83: error: dereferencing pointer to incomplete type<BR>km_dbase.c:83: error: dereferencing pointer to incomplete type<BR>km_dbase.c:83: warning: format argument is not a pointer (arg 6)<BR>km_dbase.c:83: error: dereferencing pointer to incomplete type<BR>km_dbase.c:83: error: dereferencing pointer to incomplete type<BR>km_dbase.c:91: error: dereferencing pointer to incomplete type<BR>km_dbase.c:109: warning: implicit declaration of function `mysql_real_query'<BR>km_dbase.c:109: error: dereferencing pointer to incomplete type<BR>km_dbase.c:112: warning: implicit declaration of function `mysql_errno'<BR>km_dbase.c:112: error: dereferencing pointer to incomplete type<BR>km_dbase.c:113: error: `CR_SERVER_GONE_ERROR' undeclared (first use in this function)<BR>km_dbase.c:113: error: (Each undeclared identifier is reported only once<BR>km_dbase.c:113: error: for each function it appears in.)<BR>km_dbase.c:113: error: `CR_SERVER_LOST' undeclared (first use in this function)<BR>km_dbase.c:117: error: dereferencing pointer to incomplete type<BR>km_dbase.c:117: warning: format argument is not a pointer (arg 7)<BR>km_dbase.c:117: error: dereferencing pointer to incomplete type<BR>km_dbase.c:117: error: dereferencing pointer to incomplete type<BR>km_dbase.c:117: warning: format argument is not a pointer (arg 6)<BR>km_dbase.c:117: error: dereferencing pointer to incomplete type<BR>km_dbase.c:117: error: dereferencing pointer to incomplete type<BR>km_dbase.c: In function `db_mysql_store_result':<BR>km_dbase.c:166: error: dereferencing pointer to incomplete type<BR>km_dbase.c:166: warning: implicit declaration of function `mysql_store_result'<BR>km_dbase.c:166: error: dereferencing pointer to incomplete type<BR>km_dbase.c:167: error: dereferencing pointer to incomplete type<BR>km_dbase.c:168: warning: implicit declaration of function `mysql_field_count'<BR>km_dbase.c:168: error: dereferencing pointer to incomplete type<BR>km_dbase.c:173: error: dereferencing pointer to incomplete type<BR>km_dbase.c:173: warning: format argument is not a pointer (arg 7)<BR>km_dbase.c:173: error: dereferencing pointer to incomplete type<BR>km_dbase.c:173: error: dereferencing pointer to incomplete type<BR>km_dbase.c:173: warning: format argument is not a pointer (arg 6)<BR>km_dbase.c:173: error: dereferencing pointer to incomplete type<BR>km_dbase.c:173: error: dereferencing pointer to incomplete type<BR>km_dbase.c:188: warning: implicit declaration of function `mysql_free_result'<BR>km_dbase.c:188: error: dereferencing pointer to incomplete type<BR>km_dbase.c:195: error: dereferencing pointer to incomplete type<BR>km_dbase.c: In function `db_mysql_free_result':<BR>km_dbase.c:228: error: dereferencing pointer to incomplete type<BR>km_dbase.c:229: error: dereferencing pointer to incomplete type<BR>km_dbase.c: In function `db_mysql_fetch_result':<BR>km_dbase.c:294: error: dereferencing pointer to incomplete type<BR>km_dbase.c:294: error: dereferencing pointer to incomplete type<BR>km_dbase.c:295: error: dereferencing pointer to incomplete type<BR>km_dbase.c:296: error: dereferencing pointer to incomplete type<BR>km_dbase.c:301: error: dereferencing pointer to incomplete type<BR>km_dbase.c:301: warning: format argument is not a pointer (arg 7)<BR>km_dbase.c:301: error: dereferencing pointer to incomplete type<BR>km_dbase.c:301: error: dereferencing pointer to incomplete type<BR>km_dbase.c:301: warning: format argument is not a pointer (arg 6)<BR>km_dbase.c:301: error: dereferencing pointer to incomplete type<BR>km_dbase.c:301: error: dereferencing pointer to incomplete type<BR>km_dbase.c:312: warning: implicit declaration of function `mysql_num_rows'<BR>km_dbase.c:312: error: dereferencing pointer to incomplete type<BR>km_dbase.c:351: error: dereferencing pointer to incomplete type<BR>km_dbase.c:351: warning: implicit declaration of function `mysql_fetch_row'<BR>km_dbase.c:351: error: dereferencing pointer to incomplete type<BR>km_dbase.c:352: error: dereferencing pointer to incomplete type<BR>km_dbase.c:353: error: dereferencing pointer to incomplete type<BR>km_dbase.c:353: warning: format argument is not a pointer (arg 7)<BR>km_dbase.c:353: error: dereferencing pointer to incomplete type<BR>km_dbase.c:353: error: dereferencing pointer to incomplete type<BR>km_dbase.c:353: warning: format argument is not a pointer (arg 6)<BR>km_dbase.c:353: error: dereferencing pointer to incomplete type<BR>km_dbase.c:353: error: dereferencing pointer to incomplete type<BR>km_dbase.c: In function `db_last_inserted_id':<BR>km_dbase.c:465: warning: implicit declaration of function `mysql_insert_id'<BR>km_dbase.c:465: error: dereferencing pointer to incomplete type<BR>gmake[1]: *** [km_dbase.o] Error 1<BR>gmake[1]: Leaving directory `/usr/local/src/kamailio-3.0.0/kamailio/modules/db_mysql'<BR>gmake: *** [modules] Error 1<BR>AppSer01:root@/usr/local/src/kamailio-3.0.0/kamailio$ <BR>
<BR>
AppSer01:root@/usr/local$ ls -l<BR>total 48<BR>drwxr-xr-x 4 bin bin 4608 Jun 1 02:58 bin<BR>drwxr-xr-x 46 bin bin 1024 Jun 1 02:58 doc<BR>drwxr-xr-x 4 bin bin 512 Apr 15 04:32 etc<BR>drwxr-xr-x 12 bin bin 1024 Jun 1 02:58 include<BR>drwxr-xr-x 2 bin bin 1024 Apr 15 04:32 info<BR>drwxr-xr-x 11 bin bin 4608 Jun 1 02:58 lib<BR>drwxr-xr-x 4 bin bin 512 Apr 15 04:31 libexec<BR>drwxr-xr-x 8 bin bin 512 Apr 15 04:32 man<BR>lrwxrwxrwx 1 root root 35 Jun 1 06:04 mysql -> mysql-5.1.47-solaris10-sparc-64bit/<BR>drwxr-xr-x 13 root mysql 512 Jun 1 06:29 mysql-5.1.47-solaris10-sparc-64bit<BR>drwxr-xr-x 10 bin bin 512 Apr 15 04:31 samba<BR>drwxr-xr-x 2 bin bin 512 Apr 15 04:32 sbin<BR>drwxr-xr-x 12 bin bin 512 Apr 15 04:32 share<BR>drwxr-xr-x 3 root root 512 May 31 03:10 src<BR>drwxr-xr-x 9 bin bin 512 Apr 15 04:31 ssl<BR>drwxr-xr-x 3 bin bin 512 Apr 15 04:30 var<BR>AppSer01:root@/usr/local$ cd mysql<BR>/usr/local/mysql<BR>AppSer01:root@/usr/local/mysql$ ls include/<BR>decimal.h m_string.h my_dbug.h my_list.h my_sys.h mysql_time.h mysqld_error.h sslopt-case.h<BR>errmsg.h my_alloc.h my_dir.h my_net.h my_xml.h mysql_version.h plugin.h sslopt-longopts.h<BR>keycache.h my_attribute.h my_getopt.h my_no_pthread.h mysql_com.h mysql.h sql_common.h sslopt-vars.h<BR>m_ctype.h my_config.h my_global.h my_pthread.h mysql_embed.h mysqld_ername.h sql_state.h typelib.h<BR>AppSer01:root@/usr/local/mysql$ ls lib/<BR>libdbug.a libmysqlclient_r.la libmysqlclient.la libmystrings.a plugin<BR>libheap.a libmysqlclient_r.so libmysqlclient.so libmysys.a<BR>libmyisam.a libmysqlclient_r.so.16 libmysqlclient.so.16 libvio.a<BR>libmyisammrg.a libmysqlclient_r.so.16.0.0 libmysqlclient.so.16.0.0 libz.a<BR>libmysqlclient_r.a libmysqlclient.a libmysqld.a libz.la<BR>AppSer01:root@/usr/local/mysql$ <BR>
===<BR>
<BR>
Thanks,<BR>
Kevin Jin<BR>
<BR> <br /><hr />使用新一代 Windows Live Messenger 轻松交流和共享！ <a href='http://www.windowslive.cn/messenger/' target='_new'>立刻下载！</a></body>
</html>