http://www.chriscalender.com/?p=126
I was able to get this working, so let me post my steps, and perhaps that will help you (note that I did encounter the same error you did at one point).
1. Downloaded LuaSocket 2.0.1 (contains lua/ and lib/ directories)
2. Copied contents of 'lua/' into the following directory:
C:\Program Files\MySQL\mysql-proxy-0.8.0\lib\mysql-proxy\lua
3. Copied contents of 'lib/' into the following directory:
C:\Program Files\MySQL\mysql-proxy-0.8.0\bin
4. In step #3, you should have copied a 'socket/' and 'mime/' directories into bin/. Rename the directory named "socket" to "lua-socket". This will get you past one set of errors.
5. Next, in the C:\Program Files\MySQL\mysql-proxy-0.8.0\bin, there is a file named lua51.dll. If you try to run it now, you'll get an error saying "lua5.1.dll was not found". So I made a copy of "lua51.dll" and renamed it "lua5.1.dll", in the same directory.
Now when I start my script, it works, and can access the socket functions.
For instance, my proxy basedir is, which is also where my script is located:
C:\Program Files\MySQL\mysql-proxy-0.8.0\
I invoked my script as follows:
C:\Program Files\MySQL\mysql-proxy-0.8.0\bin>mysql-proxy.exe --proxy-lua-script=show-vars.lua --lua-cpath=!\\lua-?.dll --lua-path=!\\..\\lib\\mysql-proxy\\lua\\?.lua;!\\..\\lib\\mysql-proxy\\lua\\socket\\?.lua
show-vars.lua is the name of my lua script.
In it, I have the following 2 lines:
socket = require("socket")
print(socket._VERSION)
And when I start up the script, and connect to my instance, it outputs the following:
LuaSocket 2.0.1
Hope this helps.
Edited 1 time(s). Last edit at 08/21/2010 12:00PM by Edwin DeSouza.