Hi, We use MSSQL and in our channels table currently its not update channe-state status. Though in my logs I could see the below messages 2013-02-18 17:04:02.767161 [DEBUG] sofia.c:6282 Channel sofia/internal/100@fsfailover.uk01.com entering state [terminated][487] 2013-02-18 17:04:02.767161 [DEBUG] switch_channel.c:2950 (sofia/internal/100@fsfailover.uk01.com) Callstate Change EARLY -> HANGUP Not sure where these states are being saved. I need to invoke my lua script during HANGUP case currently lua script works till call gets established, after that I don't see its hitting any lua scripts written by us. Please suggest what can we do now? Many thanks. Regards, Archana From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Eliot Gable Sent: 18 February 2013 14:37 To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Multicast in freeswitch On Mon, Feb 18, 2013 at 4:17 AM, Archana Venugopan <a.venugopan@mundio.com<mailto:a.venugopan@mundio.com>> wrote: Hi, LUA script is written by us. Ya its being lauched from dialplan. The script establishes call to mobile and our deskphone. So far it dint update the DB, it just checks the DB and establishes call. This is probably what you want: http://wiki.freeswitch.org/wiki/Mod_lua#session:setHangupHook As for updating the database, if you have a PostgreSQL database, you can enable the core pgsql support and use native pgsql calls from lua to access the database. Also, keep in mind that FS keeps a channels table in the database and if you just want to read the state of sessions up in FS, if you use core ODBC or core PGSQL support, you can just read the channels table for the current call state information.