using external mysql connections in lua for mysql-proxy

[Pavel Dobryakov]

I tried do somethink like this:
test.lua


require "mysql"
function read_query( packet )
if packet:byte() == proxy.COM_QUERY then
local env = assert(mysql())
local con, err = env:connect("t1", "pavel", "123", "localhost")
local query = string.sub(packet, 2)
local result = con:execute("insert into hst values("..query..")")
result:colse()
con:close()
env:close()
end
return proxy.PROXY_IGNORE_RESULT
end


and get this error
2011-08-04 18:02:24: (critical) (lua-error) [/usr/share/mysql-proxy/test.lua]
error loading module 'mysql' from file '/usr/lib/mysql-proxy/lua/mysql.so':
/usr/lib/mysql-proxy/lua/mysql.so: undefined symbol: luaopen_mysql
2011-08-04 18:02:24: (debug) last message repeated 1 times
2011-08-04 18:02:24: (debug) abs wait-for-event::done usec= 0
2011-08-04 18:02:24: (debug) abs lua-exec::done usec= 0