finnras Posted September 5, 2008 Share Posted September 5, 2008 I try to test the SQL plugin. I use a Access database. When I use the simulator its work fine BUT when I call via SIP the SQL plugin return a wrong result. Please take a look at the logfile. Would you please help me geting out of this problem. 18:42:35 Ringing on Line Simulator detected. Waiting until ring number 2. 18:42:35 Simulator 5555555555 [Answered] 18:42:35 Answered line [1000 "Simulator Line"] call number [216] cid [5555555555] did[simulator] drn[0 (0ms)] 18:42:35 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav 18:42:42 Caller pressed key [1] 18:42:43 Caller pressed key [1] 18:42:44 Caller pressed key [1] 18:42:45 Caller pressed key [1] 18:42:46 Caller pressed key [1] 18:42:47 Caller pressed key [1] 18:42:48 Caller pressed key [1] 18:42:49 Caller pressed key [1] 18:42:50 Caller pressed key [#] 18:42:50 Variable number = 11111111 18:42:50 Command - Go 18:42:50 Open OGM: start 18:42:50 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'" 18:42:50 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav 18:42:51 Plugin returned: Rowcount=-1&Result=Okay&id=1&kode=11111111©right=NCH Swift Sound 18:42:53 Command - Go 18:42:53 Open OGM: valg1Okay 18:42:53 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Okay.wav 18:42:53 followed by read number: number 18:42:56 Call disconnected 18:42:58 Call disconnected ------------------------------------------------------------------------------------------------------------------------- 18:43:34 Incoming SIP call 18:43:36 Ringing on Line 88917091 detected. Waiting until ring number 2. 18:43:36 viptel 46730888 [Answered] 18:43:36 Answering call... 18:43:37 Answered line [1 "viptel"] call number [217] cid [46730888] did[88917091] drn[0 (0ms)] 18:43:37 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav 18:43:44 Caller pressed key [1] 18:43:45 Caller pressed key [1] 18:43:47 Caller pressed key [1] 18:43:48 Caller pressed key [1] 18:43:49 Caller pressed key [1] 18:43:50 Caller pressed key [1] 18:43:51 Caller pressed key [1] 18:43:52 Caller pressed key [1] 18:43:54 Caller pressed key [#] 18:43:54 Variable number = 11111111 18:43:54 Command - Go 18:43:54 Open OGM: start 18:43:54 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'" 18:43:54 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav 18:43:54 Plugin returned: Result=Error©right=NCH Swift Sound 18:43:55 Command - Go 18:43:55 Open OGM: valg1Error 18:43:55 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Error.wav 18:43:55 Command - Polite Hangup 18:43:55 Play system prompt: GoodBye 18:43:59 Call has disconnected 18:43:59 Call disconnected Link to comment Share on other sites More sharing options...
mayankmodi Posted December 3, 2008 Share Posted December 3, 2008 Hi , I am facing the same problem with SQL plugin. It's working fine in case of simulator but when I tried using Incoming SIP call, getting same error message. Did you get any solution? Thanks in Advance. Here is the log: 10:39:39 Default OGM selected: 'Test Step' 10:40:09 Ringing on Line Simulator detected. Waiting until ring number 3. 10:40:09 Simulator 5555555555 [Answered] 10:40:09 Answered line [1000 "Simulator Line"] call number [33] cid [5555555555] did[simulator] drn[0 (0ms)] 10:40:09 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\SQLLink.exe" DHIS "select * from users where userid = 22" "root" "" 10:40:09 Play file: C:\Documents and Settings\All Users\Application Data\NCH Swift Sound\IVM\OGMs\Test Step.wav 10:40:10 Plugin returned: Rowcount=1&Result=Okay&userid=22&username=dpc_gand&password=92c5d5855cf4309c21bfb109c96495da©right=NCH Swift Sound 10:40:12 Command - Go 10:40:12 Open OGM: Test Step1 10:40:12 Text-to-Speech Synthesis: Welcome dpc_gand 10:40:19 Command - Go 10:40:19 Open OGM: Test Step 2 10:40:19 Text-to-Speech Synthesis: Welcome 10:40:24 Command - Polite Hangup 10:40:24 Play system prompt: GoodBye 10:40:25 Call disconnected 10:40:26 Call disconnected ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 10:41:06 Ringing on Line HSP56 MicroModem detected. Waiting until ring number 3. 10:41:11 HSP56 MicroModem Unknown [Answered] 10:41:16 Answered line [1 "HSP56 MicroModem"] call number [34] cid [unknown] did[HSP56 MicroModem] drn[1 (5125ms)] 10:41:16 Run plugin: "C:\Program Files\NCH Swift Sound\IVM\SQLLink.exe" DHIS "select * from users where userid = 22" "root" "" 10:41:16 Play file: C:\Documents and Settings\All Users\Application Data\NCH Swift Sound\IVM\OGMs\Test Step.wav 10:41:16 Plugin returned: Result=Error©right=NCH Swift Sound 10:41:19 Command - Go 10:41:19 Open OGM: Test Step1 10:41:19 Text-to-Speech Synthesis: Welcome 10:41:24 Command - Go 10:41:24 Open OGM: Test Step 2 10:41:25 Text-to-Speech Synthesis: Welcome 10:41:30 Command - Polite Hangup 10:41:30 Play system prompt: GoodBye 10:41:31 Call disconnected I try to test the SQL plugin. I use a Access database. When I use the simulator its work fine BUT when I call via SIP the SQL plugin return a wrong result. Please take a look at the logfile. Would you please help me geting out of this problem. 18:42:35 Ringing on Line Simulator detected. Waiting until ring number 2. 18:42:35 Simulator 5555555555 [Answered] 18:42:35 Answered line [1000 "Simulator Line"] call number [216] cid [5555555555] did[simulator] drn[0 (0ms)] 18:42:35 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav 18:42:42 Caller pressed key [1] 18:42:43 Caller pressed key [1] 18:42:44 Caller pressed key [1] 18:42:45 Caller pressed key [1] 18:42:46 Caller pressed key [1] 18:42:47 Caller pressed key [1] 18:42:48 Caller pressed key [1] 18:42:49 Caller pressed key [1] 18:42:50 Caller pressed key [#] 18:42:50 Variable number = 11111111 18:42:50 Command - Go 18:42:50 Open OGM: start 18:42:50 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'" 18:42:50 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav 18:42:51 Plugin returned: Rowcount=-1&Result=Okay&id=1&kode=11111111©right=NCH Swift Sound 18:42:53 Command - Go 18:42:53 Open OGM: valg1Okay 18:42:53 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Okay.wav 18:42:53 followed by read number: number 18:42:56 Call disconnected 18:42:58 Call disconnected ------------------------------------------------------------------------------------------------------------------------- 18:43:34 Incoming SIP call 18:43:36 Ringing on Line 88917091 detected. Waiting until ring number 2. 18:43:36 viptel 46730888 [Answered] 18:43:36 Answering call... 18:43:37 Answered line [1 "viptel"] call number [217] cid [46730888] did[88917091] drn[0 (0ms)] 18:43:37 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\ny start.wav 18:43:44 Caller pressed key [1] 18:43:45 Caller pressed key [1] 18:43:47 Caller pressed key [1] 18:43:48 Caller pressed key [1] 18:43:49 Caller pressed key [1] 18:43:50 Caller pressed key [1] 18:43:51 Caller pressed key [1] 18:43:52 Caller pressed key [1] 18:43:54 Caller pressed key [#] 18:43:54 Variable number = 11111111 18:43:54 Command - Go 18:43:54 Open OGM: start 18:43:54 Run plugin: "C:\ProgramData\NCH Swift Sound\IVM\SQLLink.exe" "telefon" "SELECT * FROM tlf WHERE kode='11111111'" 18:43:54 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\start.wav 18:43:54 Plugin returned: Result=Error©right=NCH Swift Sound 18:43:55 Command - Go 18:43:55 Open OGM: valg1Error 18:43:55 Play file: C:\ProgramData\NCH Swift Sound\IVM\OGMs\valg1Error.wav 18:43:55 Command - Polite Hangup 18:43:55 Play system prompt: GoodBye 18:43:59 Call has disconnected 18:43:59 Call disconnected Link to comment Share on other sites More sharing options...
polenta Posted July 10, 2009 Share Posted July 10, 2009 The "user DSN" will only work for the Simulator. You have to create a "system DSN" to allow other extensions or outside calls to interact with DB. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now