API tools faq
paste
trupsalms

phptimeclock asterisk cli4

trupsalms
Aug 10th, 2013
298
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 11.31 KB | None | 0 0
raw download clone embed print report
  1. vps10*CLI>
  2.   == Using SIP RTP TOS bits 184
  3.   == Using SIP RTP CoS mark 5
  4.     -- Executing [8463@from-internal:1] NoOp("SIP/703-00000006", "Running miscapp 3: PHPTimeclock") in new stack
  5.     -- Executing [8463@from-internal:2] Macro("SIP/703-00000006", "user-callerid,") in new stack
  6.     -- Executing [s@macro-user-callerid:1] Set("SIP/703-00000006", "TOUCH_MONITOR=1376144833.11") in new stack
  7.     -- Executing [s@macro-user-callerid:2] Set("SIP/703-00000006", "AMPUSER=703") in new stack
  8.     -- Executing [s@macro-user-callerid:3] GotoIf("SIP/703-00000006", "0?report") in new stack
  9.     -- Executing [s@macro-user-callerid:4] ExecIf("SIP/703-00000006", "1?Set(REALCALLERIDNUM=703)") in new stack
  10.     -- Executing [s@macro-user-callerid:5] Set("SIP/703-00000006", "AMPUSER=703") in new stack
  11.     -- Executing [s@macro-user-callerid:6] Set("SIP/703-00000006", "AMPUSERCIDNAME=703") in new stack
  12.     -- Executing [s@macro-user-callerid:7] GotoIf("SIP/703-00000006", "0?report") in new stack
  13.     -- Executing [s@macro-user-callerid:8] Set("SIP/703-00000006", "AMPUSERCID=703") in new stack
  14.     -- Executing [s@macro-user-callerid:9] Set("SIP/703-00000006", "__DIAL_OPTIONS=") in new stack
  15.     -- Executing [s@macro-user-callerid:10] Set("SIP/703-00000006", "CALLERID(all)="703" <703>") in new stack
  16.     -- Executing [s@macro-user-callerid:11] GotoIf("SIP/703-00000006", "0?limit") in new stack
  17.     -- Executing [s@macro-user-callerid:12] ExecIf("SIP/703-00000006", "0?Set(GROUP(concurrency_limit)=703)") in new stack
  18.     -- Executing [s@macro-user-callerid:13] GosubIf("SIP/703-00000006", "7?sub-ccss,s,1(from-internal,8463)") in new stack
  19.     -- Executing [s@sub-ccss:1] ExecIf("SIP/703-00000006", "0?Return()") in new stack
  20.     -- Executing [s@sub-ccss:2] Set("SIP/703-00000006", "CCSS_SETUP=TRUE") in new stack
  21.     -- Executing [s@sub-ccss:3] GosubIf("SIP/703-00000006", "0?monitor_config,1(from-internal,8463):monitor_default,1(from-internal,8463)") in new stack
  22.     -- Executing [monitor_default@sub-ccss:1] GotoIf("SIP/703-00000006", "0?is_exten") in new stack
  23.     -- Executing [monitor_default@sub-ccss:2] StackPop("SIP/703-00000006", "") in new stack
  24.     -- Executing [monitor_default@sub-ccss:3] Return("SIP/703-00000006", "FALSE") in new stack
  25.     -- Executing [s@macro-user-callerid:14] GotoIf("SIP/703-00000006", "0?continue") in new stack
  26.     -- Executing [s@macro-user-callerid:15] Set("SIP/703-00000006", "__TTL=64") in new stack
  27.     -- Executing [s@macro-user-callerid:16] GotoIf("SIP/703-00000006", "1?continue") in new stack
  28.     -- Goto (macro-user-callerid,s,27)
  29.     -- Executing [s@macro-user-callerid:27] Set("SIP/703-00000006", "CALLERID(number)=703") in new stack
  30.     -- Executing [s@macro-user-callerid:28] Set("SIP/703-00000006", "CALLERID(name)=703") in new stack
  31.     -- Executing [s@macro-user-callerid:29] Set("SIP/703-00000006", "CDR(cnum)=703") in new stack
  32.     -- Executing [s@macro-user-callerid:30] Set("SIP/703-00000006", "CDR(cnam)=703") in new stack
  33.     -- Executing [s@macro-user-callerid:31] Set("SIP/703-00000006", "CHANNEL(language)=en") in new stack
  34.     -- Executing [8463@from-internal:3] Goto("SIP/703-00000006", "phptimeclock,s,1") in new stack
  35.     -- Goto (phptimeclock,s,1)
  36.     -- Executing [s@phptimeclock:1] Answer("SIP/703-00000006", "") in new stack
  37.     -- <SIP/705-00000002> Playing 'spy-sip.ulaw' (language 'en')
  38.     -- Executing [s@phptimeclock:2] Wait("SIP/703-00000006", "1") in new stack
  39.     -- <SIP/705-00000002> Playing 'digits/7.ulaw' (language 'en')
  40.     -- <SIP/705-00000002> Playing 'digits/0.ulaw' (language 'en')
  41.     -- Executing [s@phptimeclock:3] Read("SIP/703-00000006", "user,tm_userid,,,3,5") in new stack
  42.     -- <SIP/703-00000006> Playing 'tm_userid.gsm' (language 'en')
  43.        > 0xb7537e78 -- Probation passed - setting RTP source address to 184.78.109.95:1498
  44.        > 0xb7537e78 -- Probation passed - setting RTP source address to 184.78.109.95:1498
  45.     -- <SIP/705-00000002> Playing 'digits/3.ulaw' (language 'en')
  46.   == Spying on channel SIP/703-00000006
  47. [2013-08-10 09:27:16] NOTICE[27640][C-00000002]: app_chanspy.c:487 start_spying: Attaching SIP/705-00000002 to SIP/703-00000006
  48.     -- User entered '1234'
  49.     -- Executing [s@phptimeclock:4] NoOp("SIP/703-00000006", "1234") in new stack
  50.     -- Executing [s@phptimeclock:5] Wait("SIP/703-00000006", "2") in new stack
  51.     -- Executing [s@phptimeclock:6] Read("SIP/703-00000006", "pass,tm_pass,,,3,5") in new stack
  52.     -- <SIP/703-00000006> Playing 'tm_pass.gsm' (language 'en')
  53.     -- User entered '1234'
  54.     -- Executing [s@phptimeclock:7] NoOp("SIP/703-00000006", "1234") in new stack
  55.     -- Executing [s@phptimeclock:8] MYSQL("SIP/703-00000006", "Connect connid 174.127.126.96 phptimeclock phptimeclock phptimeclock") in new stack
  56.     -- Executing [s@phptimeclock:9] NoOp("SIP/703-00000006", "1") in new stack
  57.     -- Executing [s@phptimeclock:10] GotoIf("SIP/703-00000006", "0?error,1") in new stack
  58.     -- Executing [s@phptimeclock:11] MYSQL("SIP/703-00000006", "Query resultid 1 SELECT tstamp FROM employees WHERE empfullname=1234 AND employee_passwd= encrypt("1234","xy")") in new stack
  59.     -- Executing [s@phptimeclock:12] MYSQL("SIP/703-00000006", "Fetch fetchid 2 tstamp") in new stack
  60.     -- Executing [s@phptimeclock:13] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  61.     -- Executing [s@phptimeclock:14] NoOp("SIP/703-00000006", "1") in new stack
  62.     -- Executing [s@phptimeclock:15] GotoIf("SIP/703-00000006", "0?fail:next") in new stack
  63.     -- Goto (phptimeclock,s,18)
  64.     -- Executing [s@phptimeclock:18] NoOp("SIP/703-00000006", ""moving On"") in new stack
  65.     -- Executing [s@phptimeclock:19] NoOp("SIP/703-00000006", "1376161169") in new stack
  66.     -- Executing [s@phptimeclock:20] Set("SIP/703-00000006", "stat="in"") in new stack
  67.     -- Executing [s@phptimeclock:21] GotoIf("SIP/703-00000006", "0?initial") in new stack
  68.     -- Executing [s@phptimeclock:22] MYSQL("SIP/703-00000006", "Query resultid 1 SELECT info.inout FROM info WHERE fullname=1234 AND timestamp=1376161169") in new stack
  69.     -- Executing [s@phptimeclock:23] MYSQL("SIP/703-00000006", "Fetch fetchid 2 inout") in new stack
  70.     -- Executing [s@phptimeclock:24] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  71.     -- Executing [s@phptimeclock:25] NoOp("SIP/703-00000006", "") in new stack
  72. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: ast_expr2.fl:470 ast_yyerror: ast_yyerror():  syntax error: syntax error, unexpected '=', expecting $end; Input:
  73.   = in
  74.   ^
  75. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: ast_expr2.fl:474 ast_yyerror: If you have questions, please refer to https://wiki.asterisk.org/wiki/display/AST/Channel+Variables
  76. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: 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)
  77. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: func_logic.c:193 acf_if:       In this case, <expr>='', <true>='out', and <false>='in'
  78.     -- Executing [s@phptimeclock:26] Set("SIP/703-00000006", "stat=") in new stack
  79.     -- Executing [s@phptimeclock:27] NoOp("SIP/703-00000006", "") in new stack
  80.     -- Executing [s@phptimeclock:28] NoOp("SIP/703-00000006", "initial login") in new stack
  81.     -- Executing [s@phptimeclock:29] MYSQL("SIP/703-00000006", "Query resultid 1 SELECT unix_timestamp( utc_timestamp( ) ) ") in new stack
  82.     -- Executing [s@phptimeclock:30] MYSQL("SIP/703-00000006", "Fetch fetchid 2 time") in new stack
  83.     -- Executing [s@phptimeclock:31] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  84.     -- Executing [s@phptimeclock:32] NoOp("SIP/703-00000006", "1376162852") in new stack
  85.     -- Executing [s@phptimeclock:33] NoOp("SIP/703-00000006", ""CallerID is "703") in new stack
  86.     -- Executing [s@phptimeclock:34] MYSQL("SIP/703-00000006", "Query resultid 1 UPDATE employees SET tstamp='1376162852' WHERE empfullname=1234") in new stack
  87.     -- Executing [s@phptimeclock:35] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  88. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
  89. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear
  90.     -- Executing [s@phptimeclock:36] MYSQL("SIP/703-00000006", "Query resultid 1 INSERT INTO info SET fullname=1234, info.inout=, timestamp=1376162852, ipaddress=703") in new stack
  91. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: 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 ' timestamp=1376162852, ipaddress=703' at line 1
  92.     -- Executing [s@phptimeclock:37] MYSQL("SIP/703-00000006", "Fetch fetchid 2") in new stack
  93. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
  94. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:503 aMYSQL_fetch: aMYSQL_fetch: Invalid result identifier 2 passed
  95.     -- Executing [s@phptimeclock:38] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  96. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
  97. [2013-08-10 09:27:32] WARNING[29811][C-00000008]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear
  98.     -- Executing [s@phptimeclock:39] GotoIf("SIP/703-00000006", "0?in:out") in new stack
  99.     -- Goto (phptimeclock,s,42)
  100.     -- Executing [s@phptimeclock:42] Playback("SIP/703-00000006", "tm_clocked_out") in new stack
  101.     -- <SIP/703-00000006> Playing 'tm_clocked_out.gsm' (language 'en')
  102.     -- Executing [s@phptimeclock:43] Goto("SIP/703-00000006", "done") in new stack
  103.     -- Goto (phptimeclock,s,44)
  104.     -- Executing [s@phptimeclock:44] NoOp("SIP/703-00000006", ""Connection ID is "1") in new stack
  105.     -- Executing [s@phptimeclock:45] NoOp("SIP/703-00000006", ""Result ID is "2") in new stack
  106.     -- Executing [s@phptimeclock:46] Wait("SIP/703-00000006", "1") in new stack
  107.     -- Executing [s@phptimeclock:47] MYSQL("SIP/703-00000006", "Clear 2") in new stack
  108. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
  109. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear
  110.     -- Executing [s@phptimeclock:48] MYSQL("SIP/703-00000006", "Disconnect 1") in new stack
  111.     -- Auto fallthrough, channel 'SIP/703-00000006' status is 'UNKNOWN'
  112.     -- Executing [h@phptimeclock:1] MYSQL("SIP/703-00000006", "clear 2") in new stack
  113. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
  114. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear
  115.     -- Executing [h@phptimeclock:2] MYSQL("SIP/703-00000006", "disconnect 1") in new stack
  116. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:194 find_identifier: Identifier 1, identifier_type 1 not found in identifier list
  117. [2013-08-10 09:27:36] WARNING[29811][C-00000008]: app_mysql.c:537 aMYSQL_disconnect: Invalid connection identifier 1 passed in aMYSQL_disconnect
  118.   == Done Spying on channel SIP/703-00000006
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!