I have a lua script that creates mysql insert statements, is there any way to create a mysql connection with lua? It would be nice to do bulk uploads from lua itself.
I just dicovered os.execute() this my do what I want.
Perhaps this may help get you in the right direction?
I saw this one before, and tried to hack around with it but I dont think there are any drivers available on my system for lua to talk to MYSQL. There are a few beta drivers out there but nothing I would trust on a production level box.
I don't know how to talk to a MySQL database from plain LUA, but recent versions of NAS and NSA have been linked with MySQL connector for C, enabling lua scripts that are executed in NAS or NSA context to talk to mysql databases over nimdb.
MySQL is enabled on Windows and Linux systems.
I'll attach a sample lua script that can run on a NAS from NMS 5.0 for example.
Thanks! I will keep this around for 5.0...
Retrieving data ...