[OpenSIPS-Users] problem with db_mysql module load

[Bogdan-Andrei Iancu]

Hi,

you need to install the libmysqlclient-dev lib (or mysqlclient-devel on 
redhat).

Regards,
Bogdan

Gres + wrote:
> i do the make install step but
> in fact i get some errors relating to db_mysql during compile opensips 
> , this is part of it:
>
> make[1]: Entering directory 
> `/root/download/opensips-1.5.1-tls/modules/db_mysql'
> make[1]: Leaving directory 
> `/root/download/opensips-1.5.1-tls/modules/db_mysql'
> make[1]: Entering directory 
> `/root/download/opensips-1.5.1-tls/modules/db_mysql'
> Compiling dbase.c
> 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
> *dbase.c:37:25: error: mysql/mysql.h: No such file or directory
> dbase.c:38:26: error: mysql/errmsg.h: No such file or directory
> dbase.c:39:32: error: mysql/mysqld_error.h: No such file or directory
> dbase.c:40:33: error: mysql/mysql_version.h: No such file or directory*
> In file included from dbase.c:45:
> *val.h:44: error: expected declaration specifiers or ‘...’ before 
> ‘MYSQL_BIND’
> In file included from dbase.c:46:
> my_con.h:38: error: expected specifier-qualifier-list before ‘my_bool’
> my_con.h:44: error: expected specifier-qualifier-list before ‘my_bool’
> my_con.h:50: error: expected specifier-qualifier-list before 
> ‘MYSQL_STMT’
> my_con.h:61: error: expected specifier-qualifier-list before 
> ‘MYSQL_BIND’
> my_con.h:77: error: expected specifier-qualifier-list before 
> ‘MYSQL_RES’
> dbase.c: In function ‘reset_all_statements’:
> dbase.c:61: error: ‘struct my_con’ has no member named ‘ps_list’
> dbase.c:61: error: ‘struct prep_stmt’ has no member named ‘next’
> dbase.c:62: error: ‘struct my_stmt_ctx’ has no member named ‘next’
> dbase.c:63: error: ‘struct my_stmt_ctx’ has no member named ‘stmt’
> dbase.c:63: error: ‘struct my_stmt_ctx’ has no member named 
> ‘table’*
> .
> .
> .
> .
> *make[1]: *** [dbase.o] Error 1
> make[1]: Leaving directory 
> `/root/download/opensips-1.5.1-tls/modules/db_mysql'
> make: *** [modules] Error 2*
>
> /*Girgis Rasmy */
>
>
>
>
> > Date: Mon, 25 May 2009 12:35:03 +0300
> > From: bogdan at voice-system.ro
> > To: franz-edler at aon.at
> > CC: gergis.rasmy at gmail.com; users at lists.opensips.org
> > Subject: Re: [OpenSIPS-Users] problem with db_mysql module load
> >
> > Hi Franz,
> >
> > Actually, looking at the previous email from Girgis (same topic), I
> > suspect he is just compiling the db_mysql module, but not installing it.
> >
> > Regards,
> > Bogdan
> >
> > Franz Edler wrote:
> > > Hi Girgis,
> > >
> > >
> > >> May 22 14:44:14 [3637] ERROR:core:yyparse: module 'db_mysql.so' 
> not found
> > >> in '/usr/local/lib/opensips/modules/'
> > >>
> > >
> > > I guess you had a problem during compilation of db_mysql.
> > > Do it again and look at the log.
> > >
> > > -franz
> > >
> > >
> > > _______________________________________________
> > > Users mailing list
> > > Users at lists.opensips.org
> > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> > >
> > >
> >
>
> ------------------------------------------------------------------------
> Hotmail® has ever-growing storage! Don’t worry about storage limits. 
> Check it out. 
> <http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009>