Need help with getting started with luasql

["Pete Kay" <petedao@...>]

Hi,

I managed to get lua to install now, but then I am not able to compile the luasql under Debian env.  I tried both make and make install but they all give error about some files that don't exist.

ser:/usr/src/luasql-2.1.1# make
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/opt/local/include -I/usr/local/include    -c -o src/ls_sqlite3.o src/ls_sqlite3.c
src/ls_sqlite3.c:14:21: error: sqlite3.h: No such file or directory
src/ls_sqlite3.c:41: error: expected specifier-qualifier-list before 'sqlite3'
src/ls_sqlite3.c:51: error: expected specifier-qualifier-list before 'sqlite3_stmt'
src/ls_sqlite3.c: In function 'finalize':
src/ls_sqlite3.c:95: warning: implicit declaration of function 'sqlite3_finalize'
src/ls_sqlite3.c:95: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c:95: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c:95: error: (Each undeclared identifier is reported only once
src/ls_sqlite3.c:95: error: for each function it appears in.)
src/ls_sqlite3.c:97: warning: implicit declaration of function 'sqlite3_errmsg'
src/ls_sqlite3.c:97: warning: implicit declaration of function 'sqlite3_db_handle'
src/ls_sqlite3.c:97: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c:97: warning: assignment makes pointer from integer without a cast
src/ls_sqlite3.c:98: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c:105: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c: In function 'cur_fetch':
src/ls_sqlite3.c:116: error: 'sqlite3_stmt' undeclared (first use in this function)
src/ls_sqlite3.c:116: error: 'vm' undeclared (first use in this function)
src/ls_sqlite3.c:116: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c:117: warning: ISO C90 forbids mixed declarations and code
src/ls_sqlite3.c:122: warning: implicit declaration of function 'sqlite3_step'
src/ls_sqlite3.c:125: error: 'SQLITE_DONE' undeclared (first use in this function)
src/ls_sqlite3.c:128: error: 'SQLITE_ROW' undeclared (first use in this function)
src/ls_sqlite3.c:141: warning: implicit declaration of function 'sqlite3_column_text'
src/ls_sqlite3.c: In function 'cur_close':
src/ls_sqlite3.c:187: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c: At top level:
src/ls_sqlite3.c:230: error: expected declaration specifiers or '...' before 'sqlite3_stmt'
src/ls_sqlite3.c: In function 'create_cursor':
src/ls_sqlite3.c:245: error: 'cur_data' has no member named 'sql_vm'
src/ls_sqlite3.c:245: error: 'sql_vm' undeclared (first use in this function)
src/ls_sqlite3.c:254: warning: implicit declaration of function 'sqlite3_column_name'
src/ls_sqlite3.c:254: warning: passing argument 2 of 'lua_pushstring' makes pointer from integer without a cast
src/ls_sqlite3.c:263: warning: implicit declaration of function 'sqlite3_column_decltype'
src/ls_sqlite3.c:263: warning: passing argument 2 of 'lua_pushstring' makes pointer from integer without a cast
src/ls_sqlite3.c: In function 'conn_close':
src/ls_sqlite3.c:291: warning: implicit declaration of function 'sqlite3_close'
src/ls_sqlite3.c:291: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c: In function 'conn_escape':
src/ls_sqlite3.c:299: warning: implicit declaration of function 'sqlite3_mprintf'
src/ls_sqlite3.c:299: warning: initialization makes pointer from integer without a cast
src/ls_sqlite3.c:307: warning: implicit declaration of function 'sqlite3_free'
src/ls_sqlite3.c: In function 'conn_execute':
src/ls_sqlite3.c:322: error: 'sqlite3_stmt' undeclared (first use in this function)
src/ls_sqlite3.c:322: error: 'vm' undeclared (first use in this function)
src/ls_sqlite3.c:323: warning: ISO C90 forbids mixed declarations and code
src/ls_sqlite3.c:327: warning: implicit declaration of function 'sqlite3_prepare'
src/ls_sqlite3.c:327: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:328: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c:330: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:330: warning: assignment makes pointer from integer without a cast
src/ls_sqlite3.c:340: warning: implicit declaration of function 'sqlite3_column_count'
src/ls_sqlite3.c:343: error: 'SQLITE_ROW' undeclared (first use in this function)
src/ls_sqlite3.c:343: error: 'SQLITE_DONE' undeclared (first use in this function)
src/ls_sqlite3.c:345: warning: implicit declaration of function 'sqlite3_reset'
src/ls_sqlite3.c:346: error: too many arguments to function 'create_cursor'
src/ls_sqlite3.c:353: warning: implicit declaration of function 'sqlite3_changes'
src/ls_sqlite3.c:353: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:358: warning: assignment makes pointer from integer without a cast
src/ls_sqlite3.c: In function 'conn_commit':
src/ls_sqlite3.c:380: warning: implicit declaration of function 'sqlite3_exec'
src/ls_sqlite3.c:380: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:382: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c: In function 'conn_rollback':
src/ls_sqlite3.c:408: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:409: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c: In function 'conn_getlastautoid':
src/ls_sqlite3.c:425: warning: implicit declaration of function 'sqlite3_last_insert_rowid'
src/ls_sqlite3.c:425: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c: In function 'conn_setautocommit':
src/ls_sqlite3.c:442: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:449: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:450: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c: At top level:
src/ls_sqlite3.c:467: error: expected declaration specifiers or '...' before 'sqlite3'
src/ls_sqlite3.c: In function 'create_connection':
src/ls_sqlite3.c:476: error: 'conn_data' has no member named 'sql_conn'
src/ls_sqlite3.c:476: error: 'sql_conn' undeclared (first use in this function)
src/ls_sqlite3.c: In function 'env_connect':
src/ls_sqlite3.c:490: error: 'sqlite3' undeclared (first use in this function)
src/ls_sqlite3.c:490: error: 'conn' undeclared (first use in this function)
src/ls_sqlite3.c:491: warning: ISO C90 forbids mixed declarations and code
src/ls_sqlite3.c:495: warning: implicit declaration of function 'sqlite3_open'
src/ls_sqlite3.c:496: error: 'SQLITE_OK' undeclared (first use in this function)
src/ls_sqlite3.c:498: warning: assignment makes pointer from integer without a cast
src/ls_sqlite3.c:506: error: too many arguments to function 'create_connection'
make: *** [src/ls_sqlite3.o] Error 1
ser:/usr/src/luasql-2.1.1# make install
mkdir -p /usr/local/lib/lua/5.1/luasql
cp src/sqlite3.so /usr/local/lib/lua/5.1/luasql
cp: cannot stat `src/sqlite3.so': No such file or directory
make: *** [install] Error 1
ser:/usr/src/luasql-2.1.1# 


Can someone please tell me how to fix this problem?

Thanks,
Pete