API tools faq
paste
Advertisement
trupsalms

phptimeclock asterisk cli

trupsalms
Aug 8th, 2013
299
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.17 KB | None | 0 0
raw download clone embed print report
  1.  
  2. vps10*CLI>
  3. == Using SIP RTP TOS bits 184
  4. == Using SIP RTP CoS mark 5
  5. -- Executing [8463@from-internal:1] NoOp("SIP/703-0000001e", "Running miscapp 3: PHPTimeclock") in new stack
  6. -- Executing [8463@from-internal:2] Macro("SIP/703-0000001e", "user-callerid,") in new stack
  7. -- Executing [s@macro-user-callerid:1] Set("SIP/703-0000001e", "TOUCH_MONITOR=1376005828.96") in new stack
  8. -- Executing [s@macro-user-callerid:2] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
  9. -- Executing [s@macro-user-callerid:3] GotoIf("SIP/703-0000001e", "0?report") in new stack
  10. -- Executing [s@macro-user-callerid:4] ExecIf("SIP/703-0000001e", "1?Set(REALCALLERIDNUM=703)") in new stack
  11. -- Executing [s@macro-user-callerid:5] Set("SIP/703-0000001e", "AMPUSER=703") in new stack
  12. -- Executing [s@macro-user-callerid:6] Set("SIP/703-0000001e", "AMPUSERCIDNAME=703") in new stack
  13. -- Executing [s@macro-user-callerid:7] GotoIf("SIP/703-0000001e", "0?report") in new stack
  14. -- Executing [s@macro-user-callerid:8] Set("SIP/703-0000001e", "AMPUSERCID=703") in new stack
  15. -- Executing [s@macro-user-callerid:9] Set("SIP/703-0000001e", "__DIAL_OPTIONS=") in new stack
  16. -- Executing [s@macro-user-callerid:10] Set("SIP/703-0000001e", "CALLERID(all)="703" <703>") in new stack
  17. -- Executing [s@macro-user-callerid:11] GotoIf("SIP/703-0000001e", "0?limit") in new stack
  18. -- Executing [s@macro-user-callerid:12] ExecIf("SIP/703-0000001e", "0?Set(GROUP(concurrency_limit)=703)") in new stack
  19. -- Executing [s@macro-user-callerid:13] GosubIf("SIP/703-0000001e", "7?sub-ccss,s,1(from-internal,8463)") in new stack
  20. -- Executing [s@sub-ccss:1] ExecIf("SIP/703-0000001e", "0?Return()") in new stack
  21. -- Executing [s@sub-ccss:2] Set("SIP/703-0000001e", "CCSS_SETUP=TRUE") in new stack
  22. -- 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
  23. -- Executing [monitor_default@sub-ccss:1] GotoIf("SIP/703-0000001e", "0?is_exten") in new stack
  24. -- Executing [monitor_default@sub-ccss:2] StackPop("SIP/703-0000001e", "") in new stack
  25. -- Executing [monitor_default@sub-ccss:3] Return("SIP/703-0000001e", "FALSE") in new stack
  26. -- Executing [s@macro-user-callerid:14] GotoIf("SIP/703-0000001e", "0?continue") in new stack
  27. -- Executing [s@macro-user-callerid:15] Set("SIP/703-0000001e", "__TTL=64") in new stack
  28. -- Executing [s@macro-user-callerid:16] GotoIf("SIP/703-0000001e", "1?continue") in new stack
  29. -- Goto (macro-user-callerid,s,27)
  30. -- Executing [s@macro-user-callerid:27] Set("SIP/703-0000001e", "CALLERID(number)=703") in new stack
  31. -- Executing [s@macro-user-callerid:28] Set("SIP/703-0000001e", "CALLERID(name)=703") in new stack
  32. -- Executing [s@macro-user-callerid:29] Set("SIP/703-0000001e", "CDR(cnum)=703") in new stack
  33. -- Executing [s@macro-user-callerid:30] Set("SIP/703-0000001e", "CDR(cnam)=703") in new stack
  34. -- Executing [s@macro-user-callerid:31] Set("SIP/703-0000001e", "CHANNEL(language)=en") in new stack
  35. -- Executing [8463@from-internal:3] Goto("SIP/703-0000001e", "phptimeclock,s,1") in new stack
  36. -- Goto (phptimeclock,s,1)
  37. -- Executing [s@phptimeclock:1] Answer("SIP/703-0000001e", "") in new stack
  38. -- Executing [s@phptimeclock:2] Wait("SIP/703-0000001e", "1") in new stack
  39. > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438
  40. > 0xb7554b28 -- Probation passed - setting RTP source address to 66.87.77.230:63438
  41. -- Executing [s@phptimeclock:3] Read("SIP/703-0000001e", "user,tm_userid,,,3,5") in new stack
  42. -- <SIP/703-0000001e> Playing 'tm_userid.gsm' (language 'en')
  43. -- User entered '1234'
  44. -- Executing [s@phptimeclock:4] NoOp("SIP/703-0000001e", "XXXX") in new stack
  45. -- Executing [s@phptimeclock:5] Wait("SIP/703-0000001e", "2") in new stack
  46. -- Executing [s@phptimeclock:6] Read("SIP/703-0000001e", "pass,tm_pass,,,3,5") in new stack
  47. -- <SIP/703-0000001e> Playing 'tm_pass.gsm' (language 'en')
  48. -- User entered '1234'
  49. -- Executing [s@phptimeclock:7] NoOp("SIP/703-0000001e", "XXXX") in new stack
  50. -- Executing [s@phptimeclock:8] MYSQL("SIP/703-0000001e", "Connect connid 123.123.123.123 phptimeclock phptimeclock phptimeclock") in new stack
  51. -- Executing [s@phptimeclock:9] NoOp("SIP/703-0000001e", "1") in new stack
  52. -- Executing [s@phptimeclock:10] GotoIf("SIP/703-0000001e", "0?error,1") in new stack
  53. -- 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
  54. [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
  55. -- Executing [s@phptimeclock:12] MYSQL("SIP/703-0000001e", "Fetch fetchid tstamp") in new stack
  56. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
  57. -- Executing [s@phptimeclock:13] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  58. [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
  59. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  60. -- Executing [s@phptimeclock:14] NoOp("SIP/703-0000001e", "") in new stack
  61. -- Executing [s@phptimeclock:15] GotoIf("SIP/703-0000001e", "0?fail:next") in new stack
  62. -- Goto (phptimeclock,s,18)
  63. -- Executing [s@phptimeclock:18] NoOp("SIP/703-0000001e", ""moving On"") in new stack
  64. -- Executing [s@phptimeclock:19] NoOp("SIP/703-0000001e", "") in new stack
  65. -- Executing [s@phptimeclock:20] Set("SIP/703-0000001e", "stat="in"") in new stack
  66. -- Executing [s@phptimeclock:21] GotoIf("SIP/703-0000001e", "0?initial") in new stack
  67. -- Executing [s@phptimeclock:22] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ info.inout\ FROM\ info\ WHERE\ fullname=\1234\ AND\ timestamp=\") in new stack
  68. [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
  69. -- Executing [s@phptimeclock:23] MYSQL("SIP/703-0000001e", "Fetch fetchid inout") in new stack
  70. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
  71. -- Executing [s@phptimeclock:24] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  72. [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
  73. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  74. -- Executing [s@phptimeclock:25] NoOp("SIP/703-0000001e", "") in new stack
  75. [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:
  76. = in
  77. ^
  78. [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
  79. [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)
  80. [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'
  81. -- Executing [s@phptimeclock:26] Set("SIP/703-0000001e", "stat=") in new stack
  82. -- Executing [s@phptimeclock:27] NoOp("SIP/703-0000001e", "") in new stack
  83. -- Executing [s@phptimeclock:28] NoOp("SIP/703-0000001e", "initial login") in new stack
  84. -- Executing [s@phptimeclock:29] MYSQL("SIP/703-0000001e", "Query resultid 1 SELECT\ unix_timestamp( utc_timestamp( ) ) ") in new stack
  85. [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
  86. -- Executing [s@phptimeclock:30] MYSQL("SIP/703-0000001e", "Fetch fetchid time") in new stack
  87. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
  88. -- Executing [s@phptimeclock:31] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  89. [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
  90. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  91. -- Executing [s@phptimeclock:32] NoOp("SIP/703-0000001e", "") in new stack
  92. -- Executing [s@phptimeclock:33] NoOp("SIP/703-0000001e", ""CallerID is "703") in new stack
  93. -- Executing [s@phptimeclock:34] MYSQL("SIP/703-0000001e", "Query resultid 1 UPDATE\ employees\ SET\ tstamp=\'\\'\ WHERE \empfullname=\1234") in new stack
  94. [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
  95. -- Executing [s@phptimeclock:35] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  96. [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
  97. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  98. -- 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
  99. [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
  100. -- Executing [s@phptimeclock:37] MYSQL("SIP/703-0000001e", "Fetch fetchid ") in new stack
  101. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:506 aMYSQL_fetch: aMYSQL_fetch: missing some arguments
  102. -- Executing [s@phptimeclock:38] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  103. [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
  104. [2013-08-08 18:50:46] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  105. -- Executing [s@phptimeclock:39] GotoIf("SIP/703-0000001e", "0?in:out") in new stack
  106. -- Goto (phptimeclock,s,42)
  107. -- Executing [s@phptimeclock:42] Playback("SIP/703-0000001e", "tm_clocked_out") in new stack
  108. -- <SIP/703-0000001e> Playing 'tm_clocked_out.gsm' (language 'en')
  109. -- Executing [s@phptimeclock:43] Goto("SIP/703-0000001e", "done") in new stack
  110. -- Goto (phptimeclock,s,44)
  111. -- Executing [s@phptimeclock:44] NoOp("SIP/703-0000001e", ""Connection ID is "1") in new stack
  112. -- Executing [s@phptimeclock:45] NoOp("SIP/703-0000001e", ""Result ID is "") in new stack
  113. -- Executing [s@phptimeclock:46] Wait("SIP/703-0000001e", "1") in new stack
  114. -- Executing [s@phptimeclock:47] MYSQL("SIP/703-0000001e", "Clear ") in new stack
  115. [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
  116. [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  117. -- Executing [s@phptimeclock:48] MYSQL("SIP/703-0000001e", "Disconnect 1") in new stack
  118. -- Auto fallthrough, channel 'SIP/703-0000001e' status is 'UNKNOWN'
  119. -- Executing [h@phptimeclock:1] MYSQL("SIP/703-0000001e", "clear ") in new stack
  120. [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
  121. [2013-08-08 18:50:50] WARNING[24476][C-00000031]: app_mysql.c:520 aMYSQL_clear: Invalid result identifier 0 passed in aMYSQL_clear
  122. -- Executing [h@phptimeclock:2] MYSQL("SIP/703-0000001e", "disconnect 1") in new stack
  123. [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
  124. [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
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!