Lua5.1 Sqlite3 and libluasqlite3 installation problem

["Voratima Orawannukul" <voratima@...>]

Hello,

I must have done something wrong when I try to install libluasqlite3. I 
downloaded the package from 
http://www.nessie.de/mroth/lua-sqlite3/lua-sqlite3-0.4.1.tar.gz.

I first ran ./configure and got 1 warning below, but I thought it?s not big 
deal.

checking if we need -llua... nm: invalid argument -D
Usage: nm [-agnoprumxjlfAP[s segname sectname] [-] [-t format] [[-arch 
<arch_flag>] ...] [file ...]
yes
checking if we need -llualib... no
configure: creating ./config.status
config.status: creating Makefile


Then, I ran ?make? and got several warning and error.
gcc -c -g -O2 -o libluasqlite3.o libluasqlite3.c
libluasqlite3.c: In function 'push_column':
libluasqlite3.c:570: warning: pointer targets in passing argument 2 of 
'lua_pushlstring' differ in signedness
libluasqlite3.c: In function 'l_sqlite3_value_text':
libluasqlite3.c:1233: warning: pointer targets in passing argument 2 of 
'lua_pushlstring' differ in signedness
libluasqlite3.c: In function 'l_sqlite3_value':
libluasqlite3.c:1255: warning: pointer targets in passing argument 2 of 
'lua_pushlstring' differ in signedness
gcc -shared   -o libluasqlite3.so libluasqlite3.o -lsqlite3 -llua -lm
powerpc-apple-darwin8-gcc-4.0.0: unrecognized option `-shared'
/usr/bin/ld: Undefined symbols:
_main
collect2: ld returned 1 exit status
make: *** [libluasqlite3.so] Error 1

I google the error and found out the Unix don?t support ??shared? and that I 
should change to ??dynamiclib? instead. After the change, ?make? went 
successfully. But when I tried ?make check?, I got this messages:
/usr/local/bin/lua: ./libluasqlite3-loader.lua:47: file is not a bundle
stack traceback:
       [C]: in function 'assert'
       ./libluasqlite3-loader.lua:47: in function 'load_libluasqlite3'
       ./sqlite3.lua:49: in main chunk
       [C]: in function 'require'
       ./tests-sqlite3.lua:30: in main chunk
       [C]: in function 'require'
       tests.lua:32: in main chunk
       [C]: ?
make: *** [check] Error 1

Though the ?make check? fail, I can installed it but I got the same result 
when ran ?lua test.lua?. I?ve been doing this for more than 2 weeks now and 
I read pretty much every message boards out there including 
http://lua-users.org/lists/lua-l/2005-02/msg00202.html. It was helpful but 
doesn?t help solve my problem. Just to warn you I?m pretty new to both Unix 
and Lua.

Any help is deeply appreciated.

Here is information about my system:
OS: Mac OS X 10.4.7
Sqlite3: version 3.3.6
Lua: version5.1.1


--Voratima