Hi I can run this query on linux cli: mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " but the same query inside lua script with os.execute does not work. Itried: -os.execute(' mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " '); -os.execute([[ mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " ]]); ... Please help. Regards M.Shirazi
As far as I know, these are forked system calls. Freeswitch doesn't wait for a response. Can you use an odbc handle for a Lua db query? (I worked around it by having the results written to a file and using an api to read that file.) On Mon, Oct 4, 2021, 5:27 PM Mehdi Shirazi <m.shirazi@gmail.com> wrote:
Hi I can run this query on linux cli: mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " but the same query inside lua script with os.execute does not work. Itried: -os.execute(' mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " '); -os.execute([[ mssql-cli -S 192.168.69.60 -d IVR_SH -U IVRSH1 -P IVRSH -Q "SELECT * FROM "dbo"."IVR_REQEST" " ]]); ... Please help. Regards M.Shirazi
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
participants (2)
-
Avi Marcus
-
Mehdi Shirazi