将CGI（C编程）与Mysql链接时出错

 // save user 
void saveUser(char *name, char *pwd,char *role)
{

    char  query[500];
    memset(query,0,500);
    conn = mysql_init(NULL);

    /* Connect to database */
    if (!mysql_real_connect(conn, server,
    user, password, database, 0, NULL, 0)) {
        fprintf(stderr, \"%s\\n\", mysql_error(conn));
        exit(1);
   }

    /* send SQL query */
    sprintf(query,\"insert into userTbl(name,password,role) values (\\\'%s\\\',\\\'%s\\\',\\\'%s\\\'); \",name,pwd,role);
    if (mysql_query(conn, query)) 
    {
        fprintf(stderr, \"%s\\n\", mysql_error(conn));
        exit(2);
   }

    /* close connection */
    mysql_close(conn);
}

// get users
void getAll()
{

    char  query[500];
    char result[1024];
    memset(result,0,1024);
    memset(query,0,500);
    conn = mysql_init(NULL);

    /* Connect to database */
    if (!mysql_real_connect(conn, server,
    user, password, database, 0, NULL, 0)) {
        fprintf(stderr, \"%s\\n\", mysql_error(conn));
        exit(1);
   }

    /* send SQL query */
    sprintf(query,\"select * from userTbl\");
    if (mysql_query(conn, query)) 
    {
        fprintf(stderr, \"%s\\n\", mysql_error(conn));
        exit(2);
   }
    res = mysql_use_result(conn);

    /* output table name */
    system(\"clear\");
    sprintf(result,\"ID\\t Name\\t Password\\t Role\\n\");
        while ((row = mysql_fetch_row(res)) != NULL)
    {
         //printf(\"%s \\n\", row[0]);
        //strcpy(id,row[0]);
        sprintf(query,\"%s\\t %s\\t %s\\t\\t %s\\n\",row[0], row[1], row[2], row[3]);
        strcat(result,query);
    }
    /* close connection */
    mysql_free_result(res);
    mysql_close(conn);
    printf(result); 
}

    ROOT=.
     CURDIR=$(shell /bin/pwd)
     JITCOMM_INSTALL=$(ROOT)/install

     include $(ROOT)/Makefile.basic

     #set root directory
     SUB_DIRS = cgi_src
     SUB_DIRS += check_update
     SUB_DIRS += loadconfig
SUB_DIRS += keepalive
SUB_DIRS += script
SUB_DIRS += server
SUB_DIRS += startproxy
SUB_DIRS += net_stats
#SUB_DIRS += ../sniffer_gui
#SUB_DIRS += java 

all:
ifneq ($(SUB_DIRS), )
        @for i in $(SUB_DIRS) ; do if [ ! -d $(CURDIR)/$${i} ]; then continue; fi; \\
        cd $(CURDIR)/$${i}; make || exit; cd $(CURDIR); done
endif

clean:
        @rm -f $(ROOT)/lib/*
        @rm -rf $(JITCOMM_INSTALL)
ifneq ($(SUB_DIRS), )
        @for i in $(SUB_DIRS) ; do if [ ! -d $(CURDIR)/$${i} ]; then continue; fi; \\
        cd $(CURDIR)/$${i}; make clean || exit; cd $(CURDIR); done
endif


install: all
        @rm -rf $(JITCOMM_INSTALL)
        @mkdir $(JITCOMM_INSTALL)
        @mkdir $(JITCOMM_INSTALL)/etc
        @mkdir $(JITCOMM_INSTALL)/etc/acpro
        @mkdir $(JITCOMM_INSTALL)/etc/syslog-ng
        @mkdir $(JITCOMM_INSTALL)/etc/apache2
        @mkdir $(JITCOMM_INSTALL)/etc/apache2/sites-available
        @mkdir $(JITCOMM_INSTALL)/var
        @mkdir $(JITCOMM_INSTALL)/var/www
        @mkdir $(JITCOMM_INSTALL)/var/www/cgi-bin

ROOT=../
CURDIR=$(shell /bin/pwd)

include $(ROOT)/Makefile.basic

#set root directory
SUB_DIRS = util
SUB_DIRS += cgi_util
SUB_DIRS += cgi_module

#Must be last
SUB_DIRS += cgi_main

all:
ifneq ($(SUB_DIRS), )
        @for i in $(SUB_DIRS) ; do if [ ! -d $(CURDIR)/$${i} ]; then continue; fi; \\
        cd $(CURDIR)/$${i}; make || exit; cd $(CURDIR); done
endif

clean:
ifneq ($(SUB_DIRS), )
        @for i in $(SUB_DIRS) ; do if [ ! -d $(CURDIR)/$${i} ]; then continue; fi; \\
        cd $(CURDIR)/$${i}; make clean || exit; cd $(CURDIR); done
endif


install:

ifneq ($(SUB_DIRS), )
        @for i in $(SUB_DIRS) ; do if [ ! -d $(CURDIR)/$${i} ]; then continue; fi; \\
        cd $(CURDIR)/$${i}; make install || exit; cd $(CURDIR); done
endif

CC=/usr/bin/gcc
#CC=powerpc-linux-gcc
CP=/usr/bin/cp
CFLAGS=-g -Wall $(shell mysql_config --cflags) $(shell mysql_config --libs)

www=/var/www
htdocs=/htdocs
cgi_bin=/cgi-bin
config=/etc/apache2/sites-available/default


INSTALL_DIR=$(pwd)/.install

 /usr/bin/gcc -c -g -Wall -I/usr/include/mysql  -DBIG_JOINS=1 -fPIC fno-strict- aliasing -Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient -I../include -o cgi_func.o cgi_func.c
 /usr/bin/gcc -c -g -Wall -I/usr/include/mysql  -DBIG_JOINS=1 -fPIC -fno-strict-aliasing -Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient -I../include -o cgic.o cgic.c
 /usr/bin/gcc -g -Wall -I/usr/include/mysql  -DBIG_JOINS=1 -fPIC -fno-strict-aliasing -Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient -static -o cgi_main  cgi_func.o  cgic.o -lcgi_util -lcgi_module -lutil -L../../lib -lm
 ../../lib/libcgi_module.a(users.o):(.data.rel.local+0x8): multiple definition of `password\'
 ../../lib/libcgi_module.a(password.o):/home/jitcomm/intern_GUI/jit24_test_v2/cgi_src/cgi_module/password.c:292: first defined here
 /usr/bin/ld: Warning: size of symbol `password\' changed from 193 in ../../lib     /libcgi_module.a(password.o) to 4 in ../../lib/libcgi_module.a(users.o)
 /usr/bin/ld: Warning: type of symbol `password\' changed from 2 to 1 in ../../lib/libcgi_module.a(users.o)
 ../../lib/libcgi_module.a(users.o): In function `save\':
 /home/jitcomm/intern_GUI/jit24_test_v2/cgi_src/cgi_module/users.c:17: multiple definition of `save\'
 ../../lib/libcgi_module.a(mode.o):/home/jitcomm/intern_GUI/jit24_test_v2/cgi_src/cgi_module/mode.c:56: first defined here
 ../../lib/libcgi_module.a(users.o): In function `saveUser\':
 users.c:(.text+0x1cb): undefined reference to `mysql_init\'
 users.c:(.text+0x22d): undefined reference to `mysql_real_connect\'
 users.c:(.text+0x241): undefined reference to `mysql_error\'
 users.c:(.text+0x2bd): undefined reference to `mysql_query\'
 users.c:(.text+0x2d1): undefined reference to `mysql_error\'
 users.c:(.text+0x30d): undefined reference to `mysql_close\'