Re: Mysql proxy 0.70 issues

[Giovanni Scopel]

Hi,
thanks for answer. I tried to use the simpliest lua script. Everythink works fine, without errors or warning.

But with other lua scripts, the same errors.

This is the /etc/default/mysql-proxy:

--------------------
ENABLED="true"
OPTIONS="
--log-file=/var/log/mysql/mysql-proxy.log
--log-level=debug
--proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua
--proxy-backend-addresses=xx.xx.xx.xx:3306
--proxy-backend-addresses=yy.yy.yy.yy:3306"
--------------------


Portion of log file:
------------------------------------------
2009-05-19 07:25:25: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-19 07:25:25: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-19 07:25:25: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-19 07:25:25: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-19 07:25:25: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2009-05-19 07:25:25: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-19 07:25:25: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-19 07:25:25: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-19 07:25:25: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-19 07:25:25: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2009-05-19 07:25:26: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:76: attempt to get length of field 'backends' (a nil value)
2009-05-19 07:25:26: (critical) (read_query) [string "/usr/share/mysql-proxy/rw-splitting.lua"]:218: bad argument #1 to 'ipairs' (table expected, got userdata)
2009-05-19 07:25:26: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2009-05-19 07:25:26: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2009-05-19 07:25:26: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
-----------------------------------------


mysql-proxy configuration:
----------------------------
mysql-proxy -V
mysql-proxy 0.7.0
glib2: 2.16.6
libevent: 1.3e
admin: 0.7.0
proxy: 0.7.0
----------------------------


Before I start, I must set the LD_LIBRARY_PATH

---------------------------
export LD_LIBRARY_PATH=/usr/local/lib/
---------------------------


Maybe the problem is the Lua intepreter?

Regards,
JS