proftpd mysql module

[edie209]

I am trying to set up proftp using sql for authentication using a a little web interface called Proftpd Administrator I am doing this on my home server which is a clarkconnect
server CentOS (based) clarckconnect does not come with proftpd with the mysql module install so I have tried compiling the package only for it to fail on the make part of the compile some referance to mod_sql_mysql

[root@Webserver proftpd-1.3.0a]# make
cd lib/ && make lib
make[1]: Entering directory `/home/shared/proftpd-1.3.0a/lib'
make[1]: Nothing to be done for `lib'.
make[1]: Leaving directory `/home/shared/proftpd-1.3.0a/lib'
cd src/ && make src
make[1]: Entering directory `/home/shared/proftpd-1.3.0a/src'
make[1]: Nothing to be done for `src'.
make[1]: Leaving directory `/home/shared/proftpd-1.3.0a/src'
cd modules/ && make static
make[1]: Entering directory `/home/shared/proftpd-1.3.0a/modules'
gcc -DHAVE_CONFIG_H  -DLINUX  -I.. -I../include -I/usr/local/include/mysql/ -O2 -Wall -c mod_sql_mysql.c
mod_sql_mysql.c:135:19: mysql.h: No such file or directory
mod_sql_mysql.c:162: error: syntax error before "MYSQL"
mod_sql_mysql.c:162: warning: no semicolon at end of struct or union
mod_sql_mysql.c: In function `_build_error':
mod_sql_mysql.c:301: warning: implicit declaration of function `mysql_errno'
mod_sql_mysql.c:301: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:303: warning: implicit declaration of function `mysql_error'
mod_sql_mysql.c:303: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `_build_data':
mod_sql_mysql.c:314: error: `MYSQL' undeclared (first use in this function)
mod_sql_mysql.c:314: error: (Each undeclared identifier is reported only once
mod_sql_mysql.c:314: error: for each function it appears in.)
mod_sql_mysql.c:314: error: `mysql' undeclared (first use in this function)
mod_sql_mysql.c:315: error: `MYSQL_RES' undeclared (first use in this function)
mod_sql_mysql.c:315: error: `result' undeclared (first use in this function)
mod_sql_mysql.c:316: error: `MYSQL_ROW' undeclared (first use in this function)
mod_sql_mysql.c:316: error: syntax error before "row"
mod_sql_mysql.c:325: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:331: warning: implicit declaration of function `mysql_store_result'
mod_sql_mysql.c:337: warning: implicit declaration of function `mysql_num_rows'
mod_sql_mysql.c:338: warning: implicit declaration of function `mysql_num_fields'
mod_sql_mysql.c:343: error: `row' undeclared (first use in this function)
mod_sql_mysql.c:343: warning: implicit declaration of function `mysql_fetch_row'
mod_sql_mysql.c:353: warning: implicit declaration of function `mysql_free_result'
mod_sql_mysql.c: In function `cmd_open':
mod_sql_mysql.c:406: warning: implicit declaration of function `mysql_ping'
mod_sql_mysql.c:406: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:418: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:418: warning: implicit declaration of function `mysql_init'
mod_sql_mysql.c:420: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:431: warning: implicit declaration of function `mysql_options'
mod_sql_mysql.c:431: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:431: error: `MYSQL_READ_DEFAULT_GROUP' undeclared (first use in this function)
mod_sql_mysql.c:433: warning: implicit declaration of function `mysql_real_connect'
mod_sql_mysql.c:433: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:433: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:433: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:433: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:434: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:434: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:435: error: `CLIENT_INTERACTIVE' undeclared (first use in this function)
mod_sql_mysql.c: In function `cmd_close':
mod_sql_mysql.c:527: warning: implicit declaration of function `mysql_close'
mod_sql_mysql.c:527: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:528: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_defineconnection':
mod_sql_mysql.c:594: error: invalid application of `sizeof' to incomplete type `mod_sql_mysql.c'
mod_sql_mysql.c:597: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:598: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:629: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:630: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:631: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:649: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:650: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:651: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:652: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_select':
mod_sql_mysql.c:801: warning: implicit declaration of function `mysql_real_query'
mod_sql_mysql.c:801: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_insert':
mod_sql_mysql.c:914: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_update':
mod_sql_mysql.c:1012: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_query':
mod_sql_mysql.c:1127: error: dereferencing pointer to incomplete type
mod_sql_mysql.c:1142: warning: implicit declaration of function `mysql_field_count'
mod_sql_mysql.c:1142: error: dereferencing pointer to incomplete type
mod_sql_mysql.c: In function `cmd_escapestring':
mod_sql_mysql.c:1221: warning: implicit declaration of function `mysql_escape_string'
mod_sql_mysql.c: In function `cmd_checkauth':
mod_sql_mysql.c:1287: warning: implicit declaration of function `make_scrambled_password'
make[1]: *** [mod_sql_mysql.o] Error 1
make[1]: Leaving directory `/home/shared/proftpd-1.3.0a/modules'
make: *** [modules] Error 2

firstly can I get this package premade or how do I go forward with this error

[monkeyx]

This article explains how to add repos and yum to clarkconnect.

http://ruckman.net/tech/2007/05/25/h...-clarkconnect/

[edie209]

Thanks monkeyx that has worked a charm