*CLI> module load pbx_lua.so
Unable to load module pbx_lua.so
Command 'module load pbx_lua.so' failed.
*CLI> [Nov 25 09:34:50] ERROR[31399]: pbx_lua.c:1440 load_or_reload_lua_stuff: Error loading extensions.lua: error loading module 'luasql.mysql' from file '/usr/local/lib/lua/5.1/luasql/mysql.so':
/usr/local/lib/lua/5.1/luasql/mysql.so: undefined symbol: lua_getfield

explorer pbx # nm pbx_lua.so | grep lua_getfield
U lua_getfield
explorer pbx #
man nm, "U" The symbol is undefined.

require "luasql.mysql"

env = assert(luasql.mysql())

function mysql_connect()
local my_con = assert(env:connect("astpbx","asterisk","password"))
return my_con
end

function lookup_exten(number)
con = mysq_connect()
res = assert(con:execute(string.format("SELECT id FROM account WHERE code='%s'", channel.accountcode)))
row = res:fetch({}, a)
print(row.id)
end

explorer luasql-2.1.1 # make
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -c -o src/luasql.o src/luasql.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -c -o src/ls_mysql.o src/ls_mysql.c
In file included from src/ls_mysql.c:19:
/usr/include/mysql/mysql.h:129: warning: ISO C90 does not support ‘long long’
export MACOSX_DEPLOYMENT_TARGET="10.3"; gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -o src/mysql.so -shared -llua src/luasql.o src/ls_mysql.o -L/usr/lib/mysql/ -lmysqlclient -lz
/usr/lib/gcc/x86_64-pc-linux-gnu/4.1.2/../../../../x86_64-pc-linux-gnu/bin/ld: src/luasql.o: relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC
src/luasql.o: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [src/mysql.so] Error 1

explorer luasql-2.1.1 # make
gcc -fPIC -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -c -o src/luasql.o src/luasql.c
gcc -fPIC -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -c -o src/ls_mysql.o src/ls_mysql.c
In file included from src/ls_mysql.c:19:
/usr/include/mysql/mysql.h:129: warning: ISO C90 does not support ‘long long’
export MACOSX_DEPLOYMENT_TARGET="10.3"; gcc -fPIC -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -I../compat/src -I/usr/include/mysql -I/usr/local/include -o src/mysql.so -shared -llua src/luasql.o src/ls_mysql.o -L/usr/lib/mysql/ -lmysqlclient -lz
explorer luasql-2.1.1 # make install
mkdir -p /usr/local/lib/lua/5.1/luasql
cp src/mysql.so /usr/local/lib/lua/5.1/luasql
explorer luasql-2.1.1 #

explorer tmp # diff -u luasql-2.1.1/config config
--- luasql-2.1.1/config 2007-10-28 02:55:27.000000000 +0400
+++ config 2009-11-25 13:13:14.000000000 +0300
@@ -1,10 +1,10 @@
# Driver (leave uncommented ONLY the line with the name of the driver)
-#T= mysql
+T= mysql
#T= oci8
#T= odbc
#T= postgres
#T= sqlite
-T=sqlite3
+#T=sqlite3

# Installation directories

@@ -24,7 +24,7 @@
LUA_VERSION_NUM= 501

# OS dependent
-LIB_OPTION= -shared #for Linux
+LIB_OPTION= -shared -llua #for Linux
#LIB_OPTION= -bundle -undefined dynamic_lookup #for MacOS X

LIBNAME= $T.so
@@ -33,8 +33,8 @@
# Compilation parameters
# Driver specific
######## MySQL
-#DRIVER_LIBS= -L/usr/local/mysql/lib -lmysqlclient -lz
-#DRIVER_INCS= -I/usr/local/mysql/include
+DRIVER_LIBS= -L/usr/lib/mysql/ -lmysqlclient -lz
+DRIVER_INCS= -I/usr/include/mysql
######## Oracle OCI8
#DRIVER_LIBS= -L/home/oracle/OraHome1/lib -lz -lclntsh
#DRIVER_INCS= -I/home/oracle/OraHome1/rdbms/demo -I/home/oracle/OraHome1/rdbms/public
@@ -45,15 +45,15 @@
#DRIVER_LIBS= -lsqlite
#DRIVER_INCS=
######## SQLite3
-DRIVER_LIBS= -L/opt/local/lib -lsqlite3
-DRIVER_INCS= -I/opt/local/include
+#DRIVER_LIBS= -L/opt/local/lib -lsqlite3
+#DRIVER_INCS= -I/opt/local/include
######## ODBC
#DRIVER_LIBS= -L/usr/local/lib -lodbc
#DRIVER_INCS= -DUNIXODBC -I/usr/local/include

WARN= -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic
INCS= -I$(LUA_INC)
-CFLAGS= -O2 $(WARN) -I$(COMPAT_DIR) $(DRIVER_INCS) $(INCS) $(DEFS)
+CFLAGS= -fPIC -O2 $(WARN) -I$(COMPAT_DIR) $(DRIVER_INCS) $(INCS) $(DEFS)
CC= gcc

# $Id: config,v 1.8 2007/10/27 22:55:27 carregal Exp $