[OpenSIPS-Users] RE problem with db_mysql module load

[Brett Nemeroff]

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.-Brett


On Mon, May 25, 2009 at 11:54 PM, gmail <gergis.rasmy at gmail.com> 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>
> ------------------------------
> Windows Live™: Keep your life in sync. Check it out.<http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090526/ae88cae4/attachment-0001.htm