<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=GB2312" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
On 6/3/10 3:37 AM, JinKevin wrote:
<blockquote cite="mid:SNT110-W1D7663A7B806AD5AE991AE6D10@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>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</blockquote>
is this installing the mysql client devel library, as well?<br>
<br>
You can look into Makefile of modules/db_mysql/ for tuning the path to
the files of mysql client devel library.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote cite="mid:SNT110-W1D7663A7B806AD5AE991AE6D10@phx.gbl"
type="cite"> 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>
<a class="moz-txt-link-abbreviated" href="mailto:AppSer01:root@/usr/local/src/kamailio-3.0.0/kamailio$">AppSer01:root@/usr/local/src/kamailio-3.0.0/kamailio$</a> <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 moz-do-not-send="true"
href="http://www.windowslive.cn/messenger/" target="_new">立刻下载！</a>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
Kamailio (OpenSER) Advanced Training
Miami, Fl, USA - June 21-23, 2010
<a class="moz-txt-link-freetext" href="http://www.asipto.com/index.php/kamailio-advanced-training/">http://www.asipto.com/index.php/kamailio-advanced-training/</a>
</pre>
</body>
</html>