API tools faq
paste
Advertisement
trupsalms

phptimeclock asterisk cli

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