API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 9th, 2017
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.95 KB | None | 0 0
raw download clone embed print report
  1. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ grep 4689382 2017-11-09--10
  2. [2017-11-09 10:11:47] [16458] INFO: Retrieving Customer ID 4689382
  3. [2017-11-09 10:11:47] [16458] TRACE: Queueing refresh for key customer/backend/customer_id=4689382 (97d35214-8cda-4adc-9211-7f6292db630f)
  4. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (positive) for customer/backend/customer_id=4689382
  5. [2017-11-09 10:11:47] [16458] DEBUG: Customer ID 4689382 mapping Gradwell -> Gradwell::Customer::Repository::Gradwell
  6. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::cust_id_db/4689382 - TTL 600/600
  7. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14156: SELECT * FROM `customers` WHERE `cust_id` = '4689382'
  8. [2017-11-09 10:11:47] [16458] TRACE: Lookup in database for customer 4689382, success, $VAR1 = {
  9. [2017-11-09 10:11:47] [16458] TRACE: 'cust_email' => '4689382-1cbeea26597258f2dd88d2fe7b7ad1ae',
  10. [2017-11-09 10:11:47] [16458] TRACE: 'cust_id' => '4689382',
  11. [2017-11-09 10:11:47] [16458] INFO: inclusive_seconds: ================= (447799148398, 10800, 4689382, 1510222307) ==============
  12. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14159: SELECT * FROM `cp_inc_sec_left` WHERE `cust_id` = '4689382'
  13. [2017-11-09 10:11:47] [16458] INFO: inclusive_seconds: will look for inclusive minutes for 447799148398/10800/4689382
  14. [2017-11-09 10:11:47] [16458] TRACE: FROM customer_packages cp INNER JOIN package p ON cp.package_id = p.id WHERE cp.cust_id = 4689382 AND
  15. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::customer_hold/4689382 - TTL 600/600
  16. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=hosting;hostname=voipdb.gradwell.net (RO): Query #878: SELECT `status` FROM `statement_cache` WHERE `cust_id` = '4689382'
  17. [2017-11-09 10:11:47] [16458] TRACE: onHold(4689382): 0, returning and storing to cache
  18. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Metadata::Repository::Default::metadata/4689382 - TTL 600/600
  19. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=gw_shared;hostname=voipdb.gradwell.net (RO): Query #251: SELECT `customer_id`,`tier_id`,`is_trusted`,`password`,`pin` FROM `customer_metadata` WHERE `customer_id` = '4689382'
  20. [2017-11-09 10:11:47] [16458] INFO: Considering customer 4689382 as trusted because they have no tier
  21. [2017-11-09 10:11:47] [16458] INFO: Restrictions on customer_id 4689382: none (is trusted)
  22. [2017-11-09 10:11:47] [16458] TRACE: 4689382, 900
  23. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Billing::VoIP::Prepay::remaining_amount/4689382 - TTL 600/600
  24. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14161: SELECT SUM(remaining_amount) as remaining_amount FROM prepay_topup WHERE customer_id = 4689382
  25. [2017-11-09 10:11:47] [16458] INFO: Customer 4689382 has no Tier: it will use legacy credit logic
  26. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::ub-sms/4689382 - TTL 600/600
  27. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14162: SELECT COUNT(1) `c` FROM `sms_log` WHERE `cust_id` = '4689382' AND `sms_billed` = '0'
  28. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::ub-data/4689382 - TTL 600/600
  29. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14163: SELECT SUM(cost) AS cost FROM mobile_data_usage WHERE invoiced = 0 AND cust_id = 4689382
  30. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14164: SELECT SUM(ws_cost) AS ws_cost FROM mobile_data_usage WHERE ws_cust_id > 0 AND ws_invoiced = 0 AND cust_id = 4689382
  31. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::VoIP::Billing::CDR::unbilled_cdr_cache_2/4689382 - TTL 600/600
  32. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14165: SELECT * FROM `cdr_unbilled_cache` WHERE `cust_id` = '4689382'
  33. [2017-11-09 10:11:47] [16458] DEBUG: [Credit:4689382] got cost=0 ws_cost=0 agent_cost=0 from cache
  34. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::queuedinvoices/4689382 - TTL 600/600
  35. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=hosting;hostname=voipdb.gradwell.net (RO): Query #879: SELECT SUM(price) AS price FROM netsuite_invoice ni, netsuite_invoice_item nii WHERE nii.saved = 0 AND nii.invoice_id = ni.id AND cust_id = 4689382
  36. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::recurbill/4689382 - TTL 600/600
  37. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=hosting;hostname=voipdb.gradwell.net (RO): Query #880: SELECT item_vat_code, SUM(unit_price * quantity) AS price, prod_code, unit_price, quantity FROM recur_bill WHERE prod_code LIKE 'voip-calls%' AND cust_id = 4689382 GROUP BY item_vat_code
  38. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::Gradwell::balanceAndCreditLimit/4689382 - TTL 600/600
  39. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=hosting;hostname=voipdb.gradwell.net (RO): Query #881: SELECT `creditLimit`,`balance` FROM `customer_cache` WHERE `cust_id` = '4689382' AND `parent_ns_id` IS NULL
  40. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net: Query #1312: SELECT SUM(pence)/100 AS p FROM prepay_tickdown WHERE cust_id = 4689382 AND cancelled = 0 AND billed = 0
  41. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net: Query #1313: SELECT SUM(ws_pence)/100 AS p FROM prepay_tickdown WHERE ws_cust_id = 4689382 AND cancelled = 0 AND billed = 0
  42. [2017-11-09 10:11:47] [16458] DEBUG: [Credit:4689382] active calls 0 + ws 0
  43. [2017-11-09 10:11:47] [16458] INFO: [Credit:4689382] active calls now at 0 (added VAT)
  44. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] Have got unbilled sms 0, unbilled calls 0, unbilled agent calls 0, unbilled data 0, balance 0, active calls 0
  45. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] Credit balance is 0 (credit_limit 0 - balance 0)
  46. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] result is 0 = bal 0 - (ub 0 + rb 0 + qi 0 + ac 0)
  47. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] reseller 'gradwell' for 4689382 not found or not a premier partner
  48. [2017-11-09 10:11:47] [16458] DEBUG: [Credit:4689382] credit cache update: cust_id=4689382 credit=0 credit_full=0
  49. [2017-11-09 10:11:47] [16458] DEBUG: Customer 4689382 has 0 of credit
  50. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::Customer::Repository::cdr_today/4689382 - TTL 600/600
  51. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14166: SELECT SUM(cost) / 10 AS cost FROM cdr_bill_2017_11 WHERE calldate >= '2017-11-09 00:00:00' AND cust_id = 4689382
  52. [2017-11-09 10:11:47] [16458] DEBUG: CACHE HIT: getActiveCalls(4689382) = 0
  53. [2017-11-09 10:11:47] [16458] DEBUG: enduser 4689382 has 3 bundles
  54. [2017-11-09 10:11:47] [16458] TRACE: Cache miss for Gradwell::VoIP::Billing::TelcoCostPolicy::4689382 - TTL 600/600
  55. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14170: SELECT `blocked` FROM `telco_cost_policy` WHERE `cust_id` = '4689382'
  56. [2017-11-09 10:11:47] [16458] DEBUG: Gradwell::VoIP::Billing::TelcoCostPolicy; customer 4689382 is NOT blocked via telco_cost_policy table lookup
  57. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (negative) for Gradwell::Billing::VoIP::Prepay::remaining_amount/4689382
  58. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (negative) for Gradwell::Customer::Repository::Gradwell::ub-sms/4689382
  59. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (negative) for Gradwell::Customer::Repository::Gradwell::ub-data/4689382
  60. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (positive) for Gradwell::VoIP::Billing::CDR::unbilled_cdr_cache_2/4689382
  61. [2017-11-09 10:11:47] [16458] DEBUG: [Credit:4689382] got cost=0 ws_cost=0 agent_cost=0 from cache
  62. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (negative) for Gradwell::Customer::Repository::Gradwell::queuedinvoices/4689382
  63. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (negative) for Gradwell::Customer::Repository::Gradwell::recurbill/4689382
  64. [2017-11-09 10:11:47] [16458] TRACE: Cache hit (positive) for Gradwell::Customer::Repository::Gradwell::balanceAndCreditLimit/4689382
  65. [2017-11-09 10:11:47] [16458] DEBUG: CACHE HIT: getActiveCalls(4689382) = 0
  66. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] Have got unbilled sms 0, unbilled calls 0, unbilled agent calls 0, unbilled data 0, balance 0, active calls 0
  67. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] Credit balance is 0 (credit_limit 0 - balance 0)
  68. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] result is 0 = bal 0 - (ub 0 + rb 0 + qi 0 + ac 0)
  69. [2017-11-09 10:11:47] [16458] TRACE: [Credit:4689382] reseller 'gradwell' for 4689382 not found or not a premier partner
  70. [2017-11-09 10:11:47] [16458] DEBUG: [Credit:4689382] credit cache update: cust_id=4689382 credit=0 credit_full=0
  71. [2017-11-09 10:11:47] [16458] INFO: SENDING NO CREDIT NOTICE TO ENDUSER 4689382/gradwell, WHO HAS 0 CREDIT
  72. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14175: SELECT * FROM credit_warning WHERE cust_id = 4689382 AND cw_type = 'No Credit'
  73. [2017-11-09 10:11:47] [16458] INFO: dbi:mysql:database=voip;hostname=voipdb.gradwell.net: Query #1314: INSERT INTO credit_warning (`cust_id`, `cw_credit`, `cw_date`, `cw_dst`, `cw_pending`, `cw_src`, `cw_type`) VALUES ('4689382', NULL, '2017-11-09 10:11:47', '07799148398', '1', '2348671', 'No Credit')
  74. [2017-11-09 10:11:47] [16458] TRACE: dbi:mysql:database=voip;hostname=voipdb.gradwell.net (RO): Query #14176: SELECT * FROM play_credit_announce WHERE cust_id = '4689382'
  75. [2017-11-09 10:11:47] [16458] INFO: dbi:mysql:database=voip;hostname=voipdb.gradwell.net: Query #1315: INSERT INTO blocked_call (`cust_id`, `dest_num`, `int_id`, `ip`, `reason`, `src_num`, `ts`) VALUES ('4689382', '447799148398', '456942', '109.224.240.148', 'credit', '02071838498', '2017-11-09 10:11:47')
  76. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ grep 16458 2017-11-09 | 10:11:47
  77. -bash: 10:11:47: command not found
  78. grep: 2017-11-09: No such file or directory
  79. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ zgrep 16458 2017-11-09 | 10:11:47
  80. -bash: 10:11:47: command not found
  81. gzip: 2017-11-09.gz: No such file or directory
  82. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ grep 16458 2017-11-09 | 10:11:47
  83. -bash: 10:11:47: command not found
  84. grep: 2017-11-09: No such file or directory
  85. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ grep 16458 2017-11-09
  86. grep: 2017-11-09: No such file or directory
  87. ben.morris@prepay-1:/var/log/gradwell/VoIPPrepayServer$ grep 16458 2017-11-09
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!