lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

Am 13.10.2015 um 13:44 schröbte David Muscut:
I want to script a query to a SphinxQL server (via the MySQL 4.1 transport
protocol). I can query the server properly via the command line mysql
client, but am unable to via luasql. Can someone point me to a working
example of how to use luasql to query a sphinxql server?

The following works:
$ mysql -P9306 --protocol=tcp --prompt='sphinxQL> '

The following does not:
$ lua5.1
Lua 5.1.5  Copyright (C) 1994-2012, PUC-Rio
mysql = require "luasql.mysql"
env  = mysql.mysql()
= env:connect('localhost','9306')
nil    LuaSQL: error connecting to database. MySQL: Access denied for user
'9306'@'localhost' (using password: NO)
return  env:connect('user','pass','localhost','9306')
nil    LuaSQL: error connecting to database. MySQL: Can't connect to MySQL
server on '9306' (22)

The luasql documentation[1] says that the first argument (after `self`) has to be the `sourcename` (I think that's the database name):