Hello, On 6/3/10 3:37 AM, JinKevin wrote: > Hi All, > 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 is this installing the mysql client devel library, as well?
You can look into Makefile of modules/db_mysql/ for tuning the path to the files of mysql client devel library. Cheers, Daniel > in the path /usr/local/mysql and all the .h and lib files are there. > > Please suggest what's wrong here and how to fix the issue. > > ========= > > Makefile.defs defs skipped > gmake[1]: Entering directory > `/usr/local/src/kamailio-3.0.0/kamailio/modules/db_mysql' > 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 > km_dbase.c:38:25: warning: mysql/mysql.h: No such file or directory > km_dbase.c:39:26: warning: mysql/errmsg.h: No such file or directory > km_dbase.c:40:33: warning: mysql/mysql_version.h: No such file or > directory > In file included from km_dbase.c:47: > km_my_con.h:47: error: syntax error before "MYSQL_RES" > km_my_con.h:47: warning: no semicolon at end of struct or union > km_my_con.h:48: warning: type defaults to `int' in declaration of `con' > km_my_con.h:48: warning: data definition has no type or storage class > km_my_con.h:49: error: syntax error before "row" > km_my_con.h:49: warning: type defaults to `int' in declaration of `row' > km_my_con.h:49: warning: data definition has no type or storage class > km_my_con.h:51: error: syntax error before '}' token > km_dbase.c: In function `db_mysql_submit_query': > km_dbase.c:81: error: dereferencing pointer to incomplete type > km_dbase.c:82: warning: implicit declaration of function `mysql_ping' > km_dbase.c:82: error: dereferencing pointer to incomplete type > km_dbase.c:83: warning: implicit declaration of function `mysql_error' > km_dbase.c:83: error: dereferencing pointer to incomplete type > km_dbase.c:83: warning: format argument is not a pointer (arg 7) > km_dbase.c:83: error: dereferencing pointer to incomplete type > km_dbase.c:83: error: dereferencing pointer to incomplete type > km_dbase.c:83: warning: format argument is not a pointer (arg 6) > km_dbase.c:83: error: dereferencing pointer to incomplete type > km_dbase.c:83: error: dereferencing pointer to incomplete type > km_dbase.c:91: error: dereferencing pointer to incomplete type > km_dbase.c:109: warning: implicit declaration of function > `mysql_real_query' > km_dbase.c:109: error: dereferencing pointer to incomplete type > km_dbase.c:112: warning: implicit declaration of function `mysql_errno' > km_dbase.c:112: error: dereferencing pointer to incomplete type > km_dbase.c:113: error: `CR_SERVER_GONE_ERROR' undeclared (first use in > this function) > km_dbase.c:113: error: (Each undeclared identifier is reported only once > km_dbase.c:113: error: for each function it appears in.) > km_dbase.c:113: error: `CR_SERVER_LOST' undeclared (first use in this > function) > km_dbase.c:117: error: dereferencing pointer to incomplete type > km_dbase.c:117: warning: format argument is not a pointer (arg 7) > km_dbase.c:117: error: dereferencing pointer to incomplete type > km_dbase.c:117: error: dereferencing pointer to incomplete type > km_dbase.c:117: warning: format argument is not a pointer (arg 6) > km_dbase.c:117: error: dereferencing pointer to incomplete type > km_dbase.c:117: error: dereferencing pointer to incomplete type > km_dbase.c: In function `db_mysql_store_result': > km_dbase.c:166: error: dereferencing pointer to incomplete type > km_dbase.c:166: warning: implicit declaration of function > `mysql_store_result' > km_dbase.c:166: error: dereferencing pointer to incomplete type > km_dbase.c:167: error: dereferencing pointer to incomplete type > km_dbase.c:168: warning: implicit declaration of function > `mysql_field_count' > km_dbase.c:168: error: dereferencing pointer to incomplete type > km_dbase.c:173: error: dereferencing pointer to incomplete type > km_dbase.c:173: warning: format argument is not a pointer (arg 7) > km_dbase.c:173: error: dereferencing pointer to incomplete type > km_dbase.c:173: error: dereferencing pointer to incomplete type > km_dbase.c:173: warning: format argument is not a pointer (arg 6) > km_dbase.c:173: error: dereferencing pointer to incomplete type > km_dbase.c:173: error: dereferencing pointer to incomplete type > km_dbase.c:188: warning: implicit declaration of function > `mysql_free_result' > km_dbase.c:188: error: dereferencing pointer to incomplete type > km_dbase.c:195: error: dereferencing pointer to incomplete type > km_dbase.c: In function `db_mysql_free_result': > km_dbase.c:228: error: dereferencing pointer to incomplete type > km_dbase.c:229: error: dereferencing pointer to incomplete type > km_dbase.c: In function `db_mysql_fetch_result': > km_dbase.c:294: error: dereferencing pointer to incomplete type > km_dbase.c:294: error: dereferencing pointer to incomplete type > km_dbase.c:295: error: dereferencing pointer to incomplete type > km_dbase.c:296: error: dereferencing pointer to incomplete type > km_dbase.c:301: error: dereferencing pointer to incomplete type > km_dbase.c:301: warning: format argument is not a pointer (arg 7) > km_dbase.c:301: error: dereferencing pointer to incomplete type > km_dbase.c:301: error: dereferencing pointer to incomplete type > km_dbase.c:301: warning: format argument is not a pointer (arg 6) > km_dbase.c:301: error: dereferencing pointer to incomplete type > km_dbase.c:301: error: dereferencing pointer to incomplete type > km_dbase.c:312: warning: implicit declaration of function `mysql_num_rows' > km_dbase.c:312: error: dereferencing pointer to incomplete type > km_dbase.c:351: error: dereferencing pointer to incomplete type > km_dbase.c:351: warning: implicit declaration of function > `mysql_fetch_row' > km_dbase.c:351: error: dereferencing pointer to incomplete type > km_dbase.c:352: error: dereferencing pointer to incomplete type > km_dbase.c:353: error: dereferencing pointer to incomplete type > km_dbase.c:353: warning: format argument is not a pointer (arg 7) > km_dbase.c:353: error: dereferencing pointer to incomplete type > km_dbase.c:353: error: dereferencing pointer to incomplete type > km_dbase.c:353: warning: format argument is not a pointer (arg 6) > km_dbase.c:353: error: dereferencing pointer to incomplete type > km_dbase.c:353: error: dereferencing pointer to incomplete type > km_dbase.c: In function `db_last_inserted_id': > km_dbase.c:465: warning: implicit declaration of function > `mysql_insert_id' > km_dbase.c:465: error: dereferencing pointer to incomplete type > gmake[1]: *** [km_dbase.o] Error 1 > gmake[1]: Leaving directory > `/usr/local/src/kamailio-3.0.0/kamailio/modules/db_mysql' > gmake: *** [modules] Error 1 > AppSer01:root@/usr/local/src/kamailio-3.0.0/kamailio$ > > AppSer01:root@/usr/local$ ls -l > total 48 > drwxr-xr-x 4 bin bin 4608 Jun 1 02:58 bin > drwxr-xr-x 46 bin bin 1024 Jun 1 02:58 doc > drwxr-xr-x 4 bin bin 512 Apr 15 04:32 etc > drwxr-xr-x 12 bin bin 1024 Jun 1 02:58 include > drwxr-xr-x 2 bin bin 1024 Apr 15 04:32 info > drwxr-xr-x 11 bin bin 4608 Jun 1 02:58 lib > drwxr-xr-x 4 bin bin 512 Apr 15 04:31 libexec > drwxr-xr-x 8 bin bin 512 Apr 15 04:32 man > lrwxrwxrwx 1 root root 35 Jun 1 06:04 mysql -> > mysql-5.1.47-solaris10-sparc-64bit/ > drwxr-xr-x 13 root mysql 512 Jun 1 06:29 > mysql-5.1.47-solaris10-sparc-64bit > drwxr-xr-x 10 bin bin 512 Apr 15 04:31 samba > drwxr-xr-x 2 bin bin 512 Apr 15 04:32 sbin > drwxr-xr-x 12 bin bin 512 Apr 15 04:32 share > drwxr-xr-x 3 root root 512 May 31 03:10 src > drwxr-xr-x 9 bin bin 512 Apr 15 04:31 ssl > drwxr-xr-x 3 bin bin 512 Apr 15 04:30 var > AppSer01:root@/usr/local$ cd mysql > /usr/local/mysql > AppSer01:root@/usr/local/mysql$ ls include/ > decimal.h m_string.h my_dbug.h my_list.h my_sys.h mysql_time.h > mysqld_error.h sslopt-case.h > errmsg.h my_alloc.h my_dir.h my_net.h my_xml.h mysql_version.h > plugin.h sslopt-longopts.h > keycache.h my_attribute.h my_getopt.h my_no_pthread.h mysql_com.h > mysql.h sql_common.h sslopt-vars.h > m_ctype.h my_config.h my_global.h my_pthread.h mysql_embed.h > mysqld_ername.h sql_state.h typelib.h > AppSer01:root@/usr/local/mysql$ ls lib/ > libdbug.a libmysqlclient_r.la libmysqlclient.la libmystrings.a plugin > libheap.a libmysqlclient_r.so libmysqlclient.so libmysys.a > libmyisam.a libmysqlclient_r.so.16 libmysqlclient.so.16 libvio.a > libmyisammrg.a libmysqlclient_r.so.16.0.0 libmysqlclient.so.16.0.0 libz.a > libmysqlclient_r.a libmysqlclient.a libmysqld.a libz.la > AppSer01:root@/usr/local/mysql$ > === > > Thanks, > Kevin Jin > > > ------------------------------------------------------------------------ > 使用新一代 Windows Live Messenger 轻松交流和共享! 立刻下载! > <http://www.windowslive.cn/messenger/> > > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > -- Daniel-Constantin Mierla Kamailio (OpenSER) Advanced Training Miami, Fl, USA - June 21-23, 2010 http://www.asipto.com/index.php/kamailio-advanced-training/
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users