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