Jump to content

DOES IT WORK


finnras

Recommended Posts

:unsure: I try to test the SQL plugin. I use a Access database. When I use the simulator its work fine :o 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. :rolleyes:

 

 

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&copyright=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

:blink: -------------------------------------------------------------------------------------------------------------------------

 

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&copyright=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

  • 2 months later...

Hi :rolleyes: , 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&copyright=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&copyright=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

 

:unsure: I try to test the SQL plugin. I use a Access database. When I use the simulator its work fine :o 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. :rolleyes:

 

 

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&copyright=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

:blink: -------------------------------------------------------------------------------------------------------------------------

 

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&copyright=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

  • 7 months later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...