[Serusers] Fwd: Adding authentication through mySQL

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(a)googlemail.com> Date: Tue, Apr 8, 2008 at 12:13 PM Subject: Adding authentication through mySQL To: serusers(a)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_modu… 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