This usually happens when you don't have the mysql development libraries installed. The package name will be something like mysql-devel or mysql-dev depending on your distribution.<div>-Brett</div><div><br><br><div class="gmail_quote">
On Mon, May 25, 2009 at 11:54 PM, gmail <span dir="ltr"><<a href="mailto:gergis.rasmy@gmail.com">gergis.rasmy@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#ffffff">
<div><font face="Arial"></font> </div>
<div style="font:10pt arial"> </div><br><br><br>
i do the make install step but<br>in fact i get some errors relating to db_mysql
during compile opensips , this is part of it:<br><br>make[1]: Entering directory
`/root/download/opensips-1.5.1-tls/modules/db_mysql'<br>make[1]: Leaving
directory `/root/download/opensips-1.5.1-tls/modules/db_mysql'<br>make[1]:
Entering directory
`/root/download/opensips-1.5.1-tls/modules/db_mysql'<br>Compiling dbase.c<br>gcc
-fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -Wall -minline-all-stringops
-falign-loops -ftree-vectorize -mtune=prescott -Wold-style-definition
-Wmissing-field-initializers -Wredundant-decls
-DMOD_NAME='"db_mysql"' -DNAME='"opensips"'
-DVERSION='"1.5.1-notls"' -DARCH='"i386"' -DOS='"linux"' -DCOMPILER='"gcc
4.1.2"' -D__CPU_i386 -D__OS_linux -D__SMP_yes
-DCFG_DIR='"/usr/local/etc/opensips/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP
-DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DSTATISTICS
-DCHANGEABLE_DEBUG_LEVEL -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT
-DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN
-DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H
-DHAVE_TIMEGM -DHAVE_EPOLL -DHAVE_SIGIO_RT -DHAVE_SELECT -I/usr/include -c
dbase.c -o dbase.o<br><font color="#0070c0"><b><font size="+0">dbase.c:37:25: error:
mysql/mysql.h: No such file or directory</font><br>dbase.c:38:26: error:
mysql/errmsg.h: No such file or directory<br>dbase.c:39:32: error:
mysql/mysqld_error.h: No such file or directory<br>dbase.c:40:33: error:
mysql/mysql_version.h: No such file or directory</b></font><font color="#0070c0"><br></font><font color="#0070c0">In file included from
dbase.c:45:</font><br><font color="#0070c0"><b>val.h:44: error: expected
declaration specifiers or ‘...’ before ‘MYSQL_BIND’<br>In file included
from dbase.c:46:<br>my_con.h:38: error: expected specifier-qualifier-list before
‘my_bool’<br>my_con.h:44: error: expected specifier-qualifier-list before
‘my_bool’<br>my_con.h:50: error: expected specifier-qualifier-list before
‘MYSQL_STMT’<br>my_con.h:61: error: expected specifier-qualifier-list before
‘MYSQL_BIND’<br>my_con.h:77: error: expected specifier-qualifier-list before
‘MYSQL_RES’<br>dbase.c: In function
‘reset_all_statements’:<br>dbase.c:61: error: ‘struct my_con’ has no
member named ‘ps_list’<br>dbase.c:61: error: ‘struct prep_stmt’ has no
member named ‘next’<br>dbase.c:62: error: ‘struct my_stmt_ctx’ has no
member named ‘next’<br>dbase.c:63: error: ‘struct my_stmt_ctx’ has no
member named ‘stmt’<br>dbase.c:63: error: ‘struct my_stmt_ctx’ has no
member named ‘table’</b></font><br>.<br>.<br>.<br>.<br><b><font color="#0070c0">make[1]: *** [dbase.o] Error 1</font><font color="#0070c0"><br></font><font color="#0070c0">make[1]: Leaving directory
`/root/download/opensips-1.5.1-tls/modules/db_mysql'</font><font color="#0070c0"><br></font><font color="#0070c0">make: *** [modules] Error
2</font></b><br><br>
<div><font face="Lucida Handwriting, Cursive" color="#333366" size="2"><em><strong>Girgis Rasmy
</strong></em></font><br></div><br><br><br><br>> Date: Mon, 25 May 2009
12:35:03 +0300<br>> From: <a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a><br>> To:
<a href="mailto:franz-edler@aon.at" target="_blank">franz-edler@aon.at</a><br>> CC: <a href="mailto:gergis.rasmy@gmail.com" target="_blank">gergis.rasmy@gmail.com</a>;
<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a><br>> Subject: Re: [OpenSIPS-Users] problem with
db_mysql module load<br>> <br>> Hi Franz,<br>> <br>> Actually,
looking at the previous email from Girgis (same topic), I <br>> suspect he is
just compiling the db_mysql module, but not installing it.<br>> <br>>
Regards,<br>> Bogdan<br>> <br>> Franz Edler wrote:<br>> > Hi
Girgis,<br>> ><br>> > <br>> >> May 22 14:44:14 [3637]
ERROR:core:yyparse: module 'db_mysql.so' not found<br>> >> in
'/usr/local/lib/opensips/modules/'<br>> >> <br>> ><br>> > I
guess you had a problem during compilation of db_mysql.<br>> > Do it again
and look at the log.<br>> ><br>> > -franz<br>> ><br>>
><br>> > _______________________________________________<br>> >
Users mailing list<br>> > <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>> >
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>> ><br>>
> <br>> <br><br>
<hr>
Hotmail® has ever-growing storage! Don’t worry about storage limits. <a href="http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009" target="_blank">Check
it out.</a><br>
<hr>
Windows Live™: Keep your life in sync. <a href="http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009" target="_blank">Check it out.</a> </div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>