|
Am 13.10.2015 um 15:50 schröbte David Muscut:
On Tue, Oct 13, 2015 at 4:34 PM, Philipp Janda <siffiejoe@gmx.net> wrote:The luasql documentation[1] says that the first argument (after `self`) has to be the `sourcename` (I think that's the database name): env:connect(sourcename[,username[,password[,hostname[,port]]]])Hi Philip, I tried that as well, however when I use the index name lua can't connect to the sphinxql server.
What is the index name?
The other strange bit is that there is no authentication to the sphinxql server, while there is to mysql, however I get an access denied when I don't include the mysql credentials even though the connection request specifies the sphinxql server on port 9306.
All arguments except the `sourcename` are optional, so you could pass `nil` for those (port should be 9306 of course). You can try passing the empty string `""` as sourcename. Unfortunately, there is no way to force TCP as transport protocol, but hopefully specifying a port (and maybe "127.0.0.1" as hostname) will be sufficient.
Anyway, passing "localhost" (or "user") as sourcename won't do any good.
- D
Good luck! Philipp