Have resolved the issue by make link of the /usr/local/mysql/lib to /usr/local/lib/mysql and /usr/local/mysql/include to /usr/local/include/mysql. Thanks, Kevin Date: Thu, 3 Jun 2010 10:35:30 +0200 From: miconda(a)gmail.com To: kevin.jzh(a)hotmail.com CC: sr-users(a)lists.sip-router.org Subject: Re: [SR-Users] Failed to make module db_mysql on Solaris 10 Sparc 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 serveris 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 轻松交流和共享！ 立刻下载！ _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)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/ _________________________________________________________________ 想知道明天天气如何？必应告诉你！ http://cn.bing.com/search?q=%E5%A4%A9%E6%B0%94%E9%A2%84%E6%8A%A5&form=M…