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@gmail.com
To: kevin.jzh@hotmail.com
CC: sr-users@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 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 轻松交流和共享! 立刻下载!
_______________________________________________ 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/


搜索本应是彩色的,快来体验新一代搜索引擎-必应,精美图片每天换哦! 立即试用!