Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- vps10*CLI>
- == Using SIP RTP TOS bits 184
- == Using SIP RTP CoS mark 5
- -- Executing [8463@from-internal:1] NoOp("SIP/703-0000001e", "Running miscapp 3: PHPTimeclock") in new stack
- -- Executing [8463@from-internal:2] Macro("SIP/703-0000001e", "user-callerid,") in new stack
- -- Executing [s@macro-user-callerid:1] Set("SIP/703-0000001e", "TOUCH_MONITOR=1376005828.96") in new stack
- -- Executing [s@macro-user-callerid:2] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
- -- Executing [s@macro-user-callerid:3] GotoIf("SIP/703-0000001e", "0?report") in new stack
- -- Executing [s@macro-user-callerid:4] ExecIf("SIP/703-0000001e", "1?Set(REALCALLERIDNUM=703)") in new stack
- -- Executing [s@macro-user-callerid:5] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
- -- Executing [s@macro-user-callerid:6] Set("SIP/703-0000001e", "AMPUSERCIDNAME=703") in new stack
- -- Executing [s@macro-user-callerid:7] GotoIf("SIP/703-0000001e", "0?report") in new stack
- -- Executing [s@macro-user-callerid:8] Set("SIP/703-0000001e", "AMPUSERCID=703") in new stack
- -- Executing [s@macro-user-callerid:9] Set("SIP/703-0000001e", "__DIAL_OPTIONS=") in new stack
- -- Executing [s@macro-user-callerid:10] Set("SIP/703-0000001e", "CALLERID(all)="703" <703>") in new stack
- -- Executing [s@macro-user-callerid:11] GotoIf("SIP/703-0000001e", "0?limit") in new stack
- -- Executing [s@macro-user-callerid:12] ExecIf("SIP/703-0000001e", "0?Set(GROUP(concurrency_limit)=703)") in new stack
- -- Executing [s@macro-user-callerid:13] GosubIf("SIP/703-0000001e", "7?sub-ccss,s,1(from-internal,8463)") in new stack
- -- Executing [s@sub-ccss:1] ExecIf("SIP/703-0000001e", "0?Return()") in new stack
- -- Executing [s@sub-ccss:2] Set("SIP/703-0000001e", "CCSS_SETUP=TRUE") in new stack
- -- Executing [s@sub-ccss:3] GosubIf("SIP/703-0000001e", "0?monitor_config,1(from-internal,8463):monitor_default,1(from-internal,8463)") in new stack
- -- Executing [monitor_default@sub-ccss:1] GotoIf("SIP/703-0000001e", "0?is_exten") in new stack
- -- Executing [monitor_default@sub-ccss:2] StackPop("SIP/703-0000001e", "") in new stack
- -- Executing [monitor_default@sub-ccss:3] Return("SIP/703-0000001e", "FALSE") in new stack
- -- Executing [s@macro-user-callerid:14] GotoIf("SIP/703-0000001e", "0?continue") in new stack
- -- Executing [s@macro-user-callerid:15] Set("SIP/703-0000001e", "__TTL=64") in new stack
- -- Executing [s@macro-user-callerid:16] GotoIf("SIP/703-0000001e", "1?continue") in new stack
- -- Goto (macro-user-callerid,s,27)
- -- Executing [s@macro-user-callerid:27] Set("SIP/703-0000001e", "CALLERID(number)=703") in new stack
- -- Executing [s@macro-user-callerid:28] Set("SIP/703-0000001e", "CALLERID(name)=703") in new stack
- -- Executing [s@macro-user-callerid:29] Set("SIP/703-0000001e", "CDR(cnum)=703") in new stack
- -- Executing [s@macro-user-callerid:30] Set("SIP/703-0000001e", "CDR(cnam)=703") in new stack
- -- Executing [s@macro-user-callerid:31] Set("SIP/703-0000001e", "CHANNEL(language)=en") in new stack
- -- Executing [8463@from-internal:3] Goto("SIP/703-0000001e", "phptimeclock,s,1") in new stack
- -- Goto (phptimeclock,s,1)
- -- Executing [s@phptimeclock:1] Answer("SIP/703-0000001e", "") in new stack
- -- Executing [s@phptimeclock:2] Wait("SIP/703-0000001e", "1") in new stack
- > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438
- > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438
- -- Executing [s@phptimeclock:3] Read("SIP/703-0000001e", "user,tm_userid,,,3,5") in new stack
- -- <SIP/703-0000001e> Playing 'tm_userid.gsm' (language 'en')
- -- User entered '1234'
- -- Executing [s@phptimeclock:4] NoOp("SIP/703-0000001e", "XXXX") in new stack
- -- Executing [s@phptimeclock:5] Wait("SIP/703-0000001e", "2") in new stack
- -- Executing [s@phptimeclock:6] Read("SIP/703-0000001e", "pass,tm_pass,,,3,5") in new stack
- -- <SIP/703-0000001e> Playing 'tm_pass.gsm' (language 'en')
- -- User entered '1234'
- -- Executing [s@phptimeclock:7] NoOp("SIP/703-0000001e", "XXXX") in new stack
- -- Executing [s@phptimeclock:8] MYSQL("SIP/703-0000001e", "Connect connid 123.123.123.123 phptimeclock phptimeclock phptimeclock") in new stack
- -- Executing [s@phptimeclock:9] NoOp("SIP/703-0000001e", "1") in new stack
- -- Executing [s@phptimeclock:10] GotoIf("SIP/703-0000001e", "0?error,1") in new stack
- -- Executing [s@phptimeclock:11] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ tstamp\ FROM\ employees\ WHERE\ empfullname=\1234\ AND\ employee_passwd\ =\ encrypt(\"1234\"\,\"xy\")") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ tstamp\ FROM\ employees\ WHERE\ empfullname=\1234\ AND\ employee_passwd\ =\ en' at line 1
- -- Executing [s@phptimeclock:12] MYSQL("SIP/703-0000001e", "Fetch fetchid tstamp") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
- -- Executing [s@phptimeclock:13] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:14] NoOp("SIP/703-0000001e", "") in new stack
- -- Executing [s@phptimeclock:15] GotoIf("SIP/703-0000001e", "0?fail:next") in new stack
- -- Goto (phptimeclock,s,18)
- -- Executing [s@phptimeclock:18] NoOp("SIP/703-0000001e", ""moving On"") in new stack
- -- Executing [s@phptimeclock:19] NoOp("SIP/703-0000001e", "") in new stack
- -- Executing [s@phptimeclock:20] Set("SIP/703-0000001e", "stat="in"") in new stack
- -- Executing [s@phptimeclock:21] GotoIf("SIP/703-0000001e", "0?initial") in new stack
- -- Executing [s@phptimeclock:22] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ info.inout\ FROM\ info\ WHERE\ fullname=\1234\ AND\ timestamp=\") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ info.inout\ FROM\ info\ WHERE\ fullname=\1234\ AND\ timestamp=\' at line 1
- -- Executing [s@phptimeclock:23] MYSQL("SIP/703-0000001e", "Fetch fetchid inout") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
- -- Executing [s@phptimeclock:24] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:25] NoOp("SIP/703-0000001e", "") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: ast_expr2.fl:470 ast_yyerror: ast_yyerror(): syntax error: syntax error, unexpected '=', expecting $end; Input:
- = in
- ^
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: ast_expr2.fl:474 ast_yyerror: If you have questions, please refer to https://wiki.asterisk.org/wiki/display/AST/Channel+Variables
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: func_logic.c:192 acf_if: Syntax IF(<expr>?[<true>][:<false>]) (expr must be non-null, and either <true> or <false> must be non-null)
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: func_logic.c:193 acf_if: In this case, <expr>='', <true>='out', and <false>='in'
- -- Executing [s@phptimeclock:26] Set("SIP/703-0000001e", "stat=") in new stack
- -- Executing [s@phptimeclock:27] NoOp("SIP/703-0000001e", "") in new stack
- -- Executing [s@phptimeclock:28] NoOp("SIP/703-0000001e", "initial login") in new stack
- -- Executing [s@phptimeclock:29] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ unix_timestamp( utc_timestamp( ) ) ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ unix_timestamp( utc_timestamp( ) )' at line 1
- -- Executing [s@phptimeclock:30] MYSQL("SIP/703-0000001e", "Fetch fetchid time") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
- -- Executing [s@phptimeclock:31] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:32] NoOp("SIP/703-0000001e", "") in new stack
- -- Executing [s@phptimeclock:33] NoOp("SIP/703-0000001e", ""CallerID is "703") in new stack
- -- Executing [s@phptimeclock:34] MYSQL("SIP/703-0000001e", "Query resultid 1 UPDATE\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\1234") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\1234' at line 1
- -- Executing [s@phptimeclock:35] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:36] MYSQL("SIP/703-0000001e", "Query resultid 1 INSERT\ INTO\ info\ SET\ fullname=\'\1234\'\, info.inout=\'\\'\, timestamp=\'\\'\, ipaddress=\'\703\'\") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:405 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\ INTO\ info\ SET\ fullname=\'\1234\'\, info.inout=\'\\'\, timestamp=\'\\'\, ipa' at line 1
- -- Executing [s@phptimeclock:37] MYSQL("SIP/703-0000001e", "Fetch fetchid ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
- -- Executing [s@phptimeclock:38] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:39] GotoIf("SIP/703-0000001e", "0?in:out") in new stack
- -- Goto (phptimeclock,s,42)
- -- Executing [s@phptimeclock:42] Playback("SIP/703-0000001e", "tm_clocked_out") in new stack
- -- <SIP/703-0000001e> Playing 'tm_clocked_out.gsm' (language 'en')
- -- Executing [s@phptimeclock:43] Goto("SIP/703-0000001e", "done") in new stack
- -- Goto (phptimeclock,s,44)
- -- Executing [s@phptimeclock:44] NoOp("SIP/703-0000001e", ""Connection ID is "1") in new stack
- -- Executing [s@phptimeclock:45] NoOp("SIP/703-0000001e", ""Result ID is "") in new stack
- -- Executing [s@phptimeclock:46] Wait("SIP/703-0000001e", "1") in new stack
- -- Executing [s@phptimeclock:47] MYSQL("SIP/703-0000001e", "Clear ") in new stack
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [s@phptimeclock:48] MYSQL("SIP/703-0000001e", "Disconnect 1") in new stack
- -- Auto fallthrough, channel 'SIP/703-0000001e' status is 'UNKNOWN'
- -- Executing [h@phptimeclock:1] MYSQL("SIP/703-0000001e", "clear ") in new stack
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 0, identifier_type 2 not found in identifier list
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
- -- Executing [h@phptimeclock:2] MYSQL("SIP/703-0000001e", "disconnect 1") in new stack
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:194 find_identifier: Identifier 1, identifier_type 1 not found in identifier list
- [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:537 aMYSQL_disconnect: Invalid connection identifier 1 passed in aMYSQL_disconnect
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement