[Serusers] Fwd: Adding authentication through mySQL

[frq ser]

oops... I forgot to add the error log:


[... ser]# make modules=modules/mysql modules

make[1]: Entering directory `.../ser/modules/mysql'
gcc -fPIC -DPIC -g -O9 -funroll-loops  -Wcast-align  -Wall
-minline-all-stringops -malign-double -falign-loops -ftree-vectorize
-mtune=athlon64      -DNAME='"ser"' -DVERSION='"0.9.7-pre1"' -DARCH='"i386"'
-DOS='"linux"' -DCOMPILER='"gcc 4.1.1"' -D__CPU_i386 -D__OS_linux
-DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM  -DSHM_MMAP
-DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -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
-I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include
-I/usr/include/mysql -c dbase.c -o dbase.o
dbase.c:34:25: error: mysql/mysql.h: No such file or directory
dbase.c:35:26: error: mysql/errmsg.h: No such file or directory
In file included from dbase.c:39:
val.h:44: error: expected ')' before '*' token
In file included from dbase.c:40:
my_con.h:39: error: expected specifier-qualifier-list before 'MYSQL_RES'
dbase.c: In function 'submit_query':
dbase.c:67: error: 'struct my_con' has no member named 'timestamp'
dbase.c:68: warning: implicit declaration of function 'mysql_ping'
dbase.c:68: error: 'struct my_con' has no member named 'con'
dbase.c:72: error: 'struct my_con' has no member named 'timestamp'
dbase.c:90: warning: implicit declaration of function 'mysql_query'
dbase.c:90: error: 'struct my_con' has no member named 'con'
dbase.c:93: warning: implicit declaration of function 'mysql_errno'
dbase.c:93: error: 'struct my_con' has no member named 'con'
dbase.c:94: error: 'CR_SERVER_GONE_ERROR' undeclared (first use in this
function)
dbase.c:94: error: (Each undeclared identifier is reported only once
dbase.c:94: error: for each function it appears in.)
dbase.c:94: error: 'CR_SERVER_LOST' undeclared (first use in this function)
dbase.c:98: warning: implicit declaration of function 'mysql_error'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:98: error: 'struct my_con' has no member named 'con'
dbase.c:98: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c: At top level:
dbase.c:138: error: expected ')' before '*' token
dbase.c:166: error: expected ')' before '*' token
dbase.c:207: error: expected ')' before '*' token
dbase.c: In function 'store_result':
dbase.c:304: error: 'struct my_con' has no member named 'res'
dbase.c:304: warning: implicit declaration of function 'mysql_store_result'
dbase.c:304: error: 'struct my_con' has no member named 'con'
dbase.c:305: error: 'struct my_con' has no member named 'res'
dbase.c:306: warning: implicit declaration of function 'mysql_field_count'
dbase.c:306: error: 'struct my_con' has no member named 'con'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c:311: error: 'struct my_con' has no member named 'con'
dbase.c:311: warning: format '%s' expects type 'char *', but argument 3 has
type 'int'
dbase.c: In function 'db_free_result':
dbase.c:348: warning: implicit declaration of function 'mysql_free_result'
dbase.c:348: error: 'struct my_con' has no member named 'res'
dbase.c:349: error: 'struct my_con' has no member named 'res'
dbase.c: In function 'db_query':
dbase.c:398: warning: implicit declaration of function 'print_where'
dbase.c:398: error: 'struct my_con' has no member named 'con'
dbase.c: In function 'db_insert':
dbase.c:471: warning: implicit declaration of function 'print_values'
dbase.c:471: error: 'struct my_con' has no member named 'con'
dbase.c: In function 'db_delete':
dbase.c:516: error: 'struct my_con' has no member named 'con'
dbase.c: In function 'db_update':
dbase.c:559: warning: implicit declaration of function 'print_set'
dbase.c:559: error: 'struct my_con' has no member named 'con'
dbase.c:568: error: 'struct my_con' has no member named 'con'
make[1]: *** [dbase.o] Error 1
make[1]: Leaving directory `.../ser/modules/mysql'


---------- Forwarded message ----------
From: frq ser <frq.ser at googlemail.com>
Date: Tue, Apr 8, 2008 at 12:13 PM
Subject: Adding authentication through mySQL
To: serusers at iptel.org


Hi,

I am trying to add user authentication through mySQL database to my SER
(0.9.7-pre1). When I tried to run SER with the modifed ser.cfg file, it gave
the error that it could not locate the 'mysql.so' module. Then I tried to
'make' the mysql module following the instructions given here:
http://www.iptel.org/faq/why_does_ser_fail_to_start_with_an_error_load_module_could_not_open_module_usr_local_lib_ser_modules_mysql_so

When I typed 'make modules=modules/mysql modules' at the SER source
directory, it gives me the error message saying that it could not locate
'mysql.h' and 'errmsg.h' (complete log given at the end of this email). I've
tried to locate these files on my computer but couldn't find them. Note that
mySQL is working fine on its own. I need your suggestions as to how I should
proceed.

Thanks in advance for any help.

Frq
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080408/1fa0624b/attachment.htm>