说明:
mysql头文件库和luasql不是必需的,这里是为了使用cumulus admin项目,让mona通过lua访问数据库。
1.mysql头文件库
#apt-get install libmysqlclient-dev
2.需要gcc/g++ 4.8.2及以上版本,gcc安装/升级见linux区
3.Lua
#cd /usr/local/
#wget http://www.lua.org/ftp/lua-5.1.5.tar.gz
#tar zxvf lua-5.1.5.tar.gz
#cd lua-5.1.5/
#make & make install
4.Luajit
#cd /usr/local/
#wget http://luajit.org/download/LuaJIT-2.0.4.tar.gz
#tar zxvf LuaJIT-2.0.4.tar.gz
编辑src/Makefile,注释DLUAJIT_ENABLE_LUA52COMPAT所在的行
#make & make install
5.Luasql
#cd /usr/local/
#wget http://files.luaforge.net/releases/luasql/luasql/LuaSQL2.1.1/luasql-2.1.1.tar.gz
#tar zxvf luasql-2.1.1.tar.gz
修改luasql-2.1.1/config:
取消注释T= mysql,注释T=sqlite3;
修改mysql路径:
DRIVER_LIBS= -L/usr/lib/mysql -lmysqlclient -lz //plugin
DRIVER_INCS= -I/usr/include/mysql //头文件库
修改编译参数:
WARN= -Wall -Wmissing-prototypes -Wmissing-declarations -ansi -pedantic -Wno-long-long -fPIC
#make & make install
ps: 若出现如下错误
stdin:1: module ‘luasql.mysql’ not found:
no field package.preload['luasql.mysql']
no file ‘./luasql/mysql.lua’
no file ‘/usr/share/lua/5.1/luasql/mysql.lua’
no file ‘/usr/share/lua/5.1/luasql/mysql/init.lua’
no file ‘/usr/lib/lua/5.1/luasql/mysql.lua’
no file ‘/usr/lib/lua/5.1/luasql/mysql/init.lua’
no file ‘./luasql/mysql.so’
no file ‘/usr/lib/lua/5.1/luasql/mysql.so’
no file ‘/usr/lib/lua/5.1/loadall.so’
no file ‘./luasql.so’
no file ‘/usr/lib/lua/5.1/luasql.so’
no file ‘/usr/lib/lua/5.1/loadall.so’
进入目录’/usr/lib/lua/5.1,建立文件夹luasql,并将mysql.so拷贝进来即可。