API tools faq
paste
Guest User

Untitled

a guest
Apr 9th, 2018
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 35.70 KB | None | 0 0
raw download clone embed print report
  1.  
  2. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  3. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten = '442080990359' AND context = 'mor_local' AND priority = '1'
  4. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  5. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten LIKE '\\_%' AND context = 'mor_local' AND priority = '1' ORDER BY exten
  6. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  7. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten = '442080990359' AND context = 'mor_local' AND priority = '1'
  8. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  9. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten LIKE '\\_%' AND context = 'mor_local' AND priority = '1' ORDER BY exten
  10. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  11. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten = '442080990359' AND context = 'mor_local' AND priority = '1'
  12. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  13. [2011-11-22 11:14:27] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten LIKE '\\_%' AND context = 'mor_local' AND priority = '1' ORDER BY exten
  14. [2011-11-22 11:14:27] DEBUG[17897] app_mor_various.c: Loop count: 0
  15. [2011-11-22 11:14:27] NOTICE[17897] app_mor.c: Core version: 11.pre.95, Server ID: 1, Dial out settings: , active calls enabled: 1, active calls count: 29, weekday: WD (2011-11-22), use lcr partials: 1, check_banned_clis: 1, use_speed_dials: 1, play_hgc_audio: 0, use_flat_rates: 1, server ip: 127.0.0.1
  16. [2011-11-22 11:14:27] NOTICE[17897] app_mor_various.c: Tell balance: 0, tell time: 0, tell time mod.: 1.000000, tell r.time when left: 0 s, tell r.time every: 60 s, card_id: 0, callback: 0, call_leg1: 0
  17. [2011-11-22 11:14:27] NOTICE[17897] app_mor_authentication.c: Date: 2011-11-22, time: 11:14:27
  18. [2011-11-22 11:14:27] NOTICE[17897] app_mor_various.c: SQL: (SELECT IF((SELECT daytype FROM days WHERE date = '2011-11-22') IS NULL, (SELECT IF(WEEKDAY('2011-11-22') = 5 OR WEEKDAY('2011-11-22') = 6, 'FD', 'WD')), (SELECT daytype FROM days WHERE date = '2011-11-22')));
  19. [2011-11-22 11:14:27] NOTICE[17897] app_mor_various.c: Weekday: WD for date: 2011-11-22
  20. [2011-11-22 11:14:27] NOTICE[17897] app_mor_authentication.c: CLID: 11071, Src: 11071, Dst: 442080990359, Acc/dev_id: 1382, CallerID: 11071, uniqueid: 1321956867.664978
  21. [2011-11-22 11:14:27] NOTICE[17897] app_mor_activecalls.c: SQL: INSERT INTO activecalls (server_id, uniqueid, start_time, src, dst, src_device_id) VALUES ('1', '1321956867.664978', '2011-11-22 11:14:27', '11071', '442080990359', '1382');
  22. [2011-11-22 11:14:27] NOTICE[17897] app_mor_authentication.c: SQL: SELECT devices.user_id, users.lcr_id, balance, frozen_balance, credit, blocked, lcrs.order, users.tariff_id, postpaid, 1, 1, 1, currencies.exchange_rate, devices.ani, providers.ani, devices.tell_balance, devices.tell_time, devices.tell_rtime_when_left, devices.repeat_rtime_every, tariffs.currency, (SELECT currencies.name FROM currencies WHERE id = 1), tariffs.purpose, users.allow_loss_calls, devices.cid_from_dids, (SELECT IF((SELECT dids.did FROM dids WHERE dids.device_id = 1382 AND dids.did = '11071') IS NULL, (SELECT dids.did FROM dids WHERE dids.device_id = 1382 LIMIT 1), '11071')), devices.record, users.owner_id, devices.process_sipchaninfo, devices.allow_duplicate_calls, users.call_limit, devices.call_limit, D.activecalls, E.activecalls, 1, 1, devices.istrunk, users.vat_percent, devices.ipaddr, devices.canreinvite, devices.record_forced, users.recording_forced_enabled, devices.fake_ring, devices.save_call_log, users.warning_email_active, users.warning_email_balance, users.warning_balance_call, users.warning_balance_sound_file_id, devices.grace_time, devices.language, lcrs.first_provider_percent_limit, devices.change_failed_code_to, devices.max_timeout, (SELECT dids.did FROM dids JOIN devices ON (dids.id = devices.forward_did_id AND devices.id = '1382')), (SELECT currencies.name FROM currencies WHERE currencies.id = users.currency_id) FROM devices LEFT JOIN users ON (users.id = devices.user_id) LEFT JOIN lcrs ON (users.lcr_id = lcrs.id) LEFT JOIN tariffs ON (tariffs.id = users.tariff_id) LEFT JOIN currencies ON (currencies.name = tariffs.currency) LEFT JOIN providers ON (providers.device_id = devices.id) LEFT JOIN (SELECT COUNT(id) AS 'activecalls', src_device_id FROM activecalls GROUP BY src_device_id) AS D ON (devices.id = D.src_device_id) LEFT JOIN (SELECT COUNT(id) AS 'activecalls', user_id FROM activecalls GROUP BY user_id) AS E ON (users.id = E.user_id) WHERE devices.id = '1382' LIMIT 1;
  23. [2011-11-22 11:14:27] NOTICE[17897] app_mor_authentication.c: User's data retrieved: id: 1043, lcr_id: 187, balance: 0.000000, frozen_balance: 0.000000, credit: 0.000000, blocked: 0, lcr_order: price, tariff_id: 553, postpaid: 0, day type: WD, exchange rate: 0.868800, ani: 0, tell balance: 0, time: 0, when left: 60s, every: 60s, user currency: GBP, def.curr: EUR, tariff type: user, allow loss calls: 0, cid from dids: 0, cid from did: , record: 0, owner: 1027, sipchaninfo: 0, allow duplicate calls: 0, user call limit: 0, device call limit: 0, device active calls: 1, user active calls: 0, is_trunk: 0, vat_percent: 0.000000, originator_ip: 213.197.141.162, canreinvite: 0, record_forced: 0, recording_forced_enabled: 0, fake_ring: 0, save_call_log: 0, warning balance(wb) active: 0, wb value: 0.000000, wb call: 0, wb file id: 0, grace time: 0, reseller_allow_loss_calls: 0, lang: en, lcr_first_prov_perc: 0.000000, change_failed_code_to: 0, device_max_timeout: 0, forward_did: , user tell currency: GBP
  24. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: SQL: SELECT A.cut, A.add FROM devices JOIN locations ON (locations.id = devices.location_id AND locations.user_id = '1027') LEFT JOIN (SELECT * FROM locationrules WHERE enabled = 1 AND lr_type = 'src' AND LENGTH('11071') BETWEEN minlen AND maxlen AND (SUBSTRING('11071',1,LENGTH(cut)) = cut OR LENGTH(cut) = 0 OR ISNULL(cut) ) ORDER BY location_id DESC, LENGTH(cut) DESC) AS A ON (A.location_id = locations.id ) WHERE devices.id = '1382' LIMIT 1;
  25. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: Localized CallerID: 11071 (cut: , add: )
  26. [2011-11-22 11:14:27] DEBUG[17897] app_mor_callerid.c: Current CALLERID(all): "" <11071>
  27. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: Changed CallerID to: 11071
  28. [2011-11-22 11:14:27] DEBUG[17897] app_mor_callerid.c: Current CALLERID(all): "" <11071>
  29. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: SQL: SELECT callerids.cli, ivrs.start_block_id, (SELECT value FROM conflines WHERE name = 'Banned_CLIs_default_IVR_id' AND owner_id = 0) FROM callerids LEFT JOIN ivrs ON (ivrs.id = callerids.ivr_id) WHERE callerids.cli = '11071' AND banned = 1;
  30. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callingdata.c: SQL: SELECT balance, frozen_balance, credit, blocked, postpaid, users.tariff_id, tariffs.purpose, currencies.exchange_rate, allow_loss_calls, users.call_limit, D.activecalls, own_providers FROM users JOIN tariffs ON (tariffs.id = users.tariff_id) JOIN currencies ON (currencies.name = tariffs.currency) LEFT JOIN (SELECT COUNT(id) AS 'activecalls', owner_id FROM activecalls GROUP BY owner_id) AS D ON (users.id = D.owner_id) WHERE users.id = '1027';
  31. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callingdata.c: Reseller's data retrieved: id: 1027, balance: 6.166662, frozen_balance: 0.000000, credit: -1.000000, blocked: 0, postpaid: 0, tariff_id: 781, purpose: user_wholesale, exchange rate: 1.000000, allow_loss_calls: 0, call_limit: 0, active calls: 3, own_providers: 1
  32. [2011-11-22 11:14:27] NOTICE[17897] app_mor.c: Caller type: Local
  33. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: Checking Phonebooks for CallerID Name change...
  34. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callerid.c: SQL: SELECT users.id, A.name, B.name FROM users LEFT JOIN (SELECT name, user_id, number FROM phonebooks WHERE user_id = '1043' and number = '11071') AS A ON (A.user_id = users.id) LEFT JOIN (SELECT name, user_id, number FROM phonebooks WHERE user_id = '0' and number = '11071') AS B ON (A.number = B.number) WHERE users.id = 1043;
  35. [2011-11-22 11:14:27] NOTICE[17897] app_mor_destinations.c: SQL: SELECT devices.id, A.cut, A.add, A.tariff_id, A.lcr_id, dids.did, A.device_id FROM devices JOIN locations ON (locations.id = devices.location_id AND locations.user_id = '1027') LEFT JOIN (SELECT * FROM locationrules WHERE enabled = 1 AND lr_type = 'dst' AND LENGTH('442080990359') BETWEEN minlen AND maxlen AND (SUBSTRING('442080990359',1,LENGTH(cut)) = cut OR LENGTH(cut) = 0 OR ISNULL(cut) ) ORDER BY location_id DESC, LENGTH(cut) DESC) AS A ON (A.location_id = locations.id ) LEFT JOIN dids ON (dids.id = A.did_id) WHERE devices.id = '1382' LIMIT 1;
  36. [2011-11-22 11:14:27] NOTICE[17897] app_mor_destinations.c: Localization info: cut: , add: , new_did: , new_device_id: 0
  37. [2011-11-22 11:14:27] NOTICE[17897] app_mor_destinations.c: Localized destination: 442080990359
  38. [2011-11-22 11:14:27] NOTICE[17897] app_mor_dids.c: Checking DID (442080990359) ...
  39. [2011-11-22 11:14:27] NOTICE[17897] app_mor_dids.c: SQL: SELECT dids.status, didrates.rate, didrates.connection_fee, didrates.increment_s, didrates.min_time, devices.device_type, devices.extension, devices.istrunk, dids.provider_id, devices.name, didrates.rate_type, dids.user_id, users.postpaid, users.balance, users.frozen_balance, users.credit, devices.id, dids.language, dids.dialplan_id, dialplans.dptype, dialplans.data1, dialplans.data2, dialplans.data3, dialplans.data4, dialplans.data5, dialplans.data6, dialplans.data7, dialplans.data8, COUNT(callflows.id) as 'cf_count', devices.record, dids.id, D.activecalls, dids.call_limit, devices.ipaddr, devices.record_forced, users.recording_forced_enabled, devices.fake_ring, devices.save_call_log, devices.server_id, servers.id, dids.sound_file_id, dialplans.sound_file_id, devices.promiscredir, dids.grace_time, dids.t_digit, dids.t_response, dialplans.data9, dialplans.data10, dialplans.data11, dialplans.data12, pbxfunctions.pf_type, dids.cid_name_prefix FROM dids LEFT JOIN didrates ON (dids.id = didrates.did_id) LEFT JOIN devices ON (dids.device_id = devices.id) LEFT JOIN users ON (users.id = dids.user_id) LEFT JOIN dialplans ON (dids.dialplan_id = dialplans.id) LEFT JOIN callflows ON (callflows.device_id = devices.id AND callflows.action != 'empty') LEFT JOIN (SELECT COUNT(id) AS 'activecalls', did_id FROM activecalls GROUP BY did_id) AS D ON (dids.id = D.did_id) LEFT JOIN servers ON (servers.server_id = devices.server_id) LEFT JOIN pbxfunctions ON (pbxfunctions.id = dialplans.data1) WHERE did = '442080990359' GROUP BY didrates.rate_type;
  40. [2011-11-22 11:14:27] NOTICE[17897] app_mor_dids.c: DID: 442080990359, id: 353, status: active, Provider rate 0.000000, con. fee: 0.000000, inc: 1, min time: 0, prov.id: 175, Inc. rate 0.000000, con. fee: 0.000000, inc: 1, min time: 0, Owner. rate 0.000000, con. fee: 0.000000, inc: 1, min time: 0, language: , dialplan id: 126, call limit: 0, active calls: 0, owner id: 0, postpaid: 0, balance: -1.988764, frz_balance: 0.000000, credit: -1.000000, sound_file_id: 0, did_grace_time: 0, timeout digit: 10, timeout response: 20, cid_name_prefix:
  41. [2011-11-22 11:14:27] NOTICE[17897] app_mor_dids.c: DID Dial Plan id: 126, type = callingcard, data1: 10, data2: 6, data3: 1, data4: 1, data5: 5, data6: 10, data7: 1, data8: 0, data9: , data10: , data11: , data12: , sound file id: 0
  42. [2011-11-22 11:14:27] NOTICE[17897] app_mor_callingcards.c: Number length: 10, PIN length: 6, Try_times_for_PIN: 5, Ask PIN only: 1, Try_times_for_dst: 10, card_used: 0, card_id: 0, previous_dst: , pinless: 0, pinless_reset: 0, channel language: en
  43. [2011-11-22 11:14:27] NOTICE[17897] app_mor_various.c: Answering channel! Time: 1321956867
  44. [2011-11-22 11:14:27] WARNING[17897] rtp.c: RTP Read too short
  45. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: Searching card by PIN: 009876
  46. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: SQL: SELECT cards.id, cards.balance, cardgroups.tariff_id, cardgroups.lcr_id, cardgroups.setup_fee, cardgroups.ghost_min_perc, cards.first_use, cards.daily_charge_paid_till, DATEDIFF(CURRENT_DATE, cards.daily_charge_paid_till), cardgroups.daily_charge, cardgroups.vat_percent, lcrs.order, currencies.exchange_rate, 1, (SELECT currencies.name FROM currencies WHERE id = 1), tariffs.purpose, cards.frozen_balance, cards.number, cards.sold, cards.owner_id, ((NOW() >= cardgroups.valid_from) AND (NOW() <= cardgroups.valid_till)), (ISNULL(first_use) OR (valid_after_first_use = 0) OR (DATE_ADD(first_use, INTERVAL valid_after_first_use DAY) >= NOW())), cards.pin, cardgroups.ghost_balance_perc, cardgroups.id, cardgroups.use_external_function, cardgroups.allow_loss_calls, cardgroups.tell_cents, cardgroups.tell_balance_in_currency, cards.language, cardgroups.solo_pinless, cards.callerid FROM cards JOIN cardgroups ON (cards.cardgroup_id = cardgroups.id) LEFT JOIN lcrs ON (cardgroups.lcr_id = lcrs.id) LEFT JOIN tariffs ON (tariffs.id = cardgroups.tariff_id) LEFT JOIN currencies ON (currencies.name = tariffs.currency) WHERE cards.pin = '009876';
  47. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: Card's id: 423263, balance: 0.237049, vat_percent: 0.000000, setup fee: 0.000000, g.min%: 100, first_use: 2011-07-26 16:29:00, daily_charge_paid_till: 2012-10-20 00:00:00, dc_diff: 0, daily_charge: 0.000000, vat_percent: 0.000000, lcr order: price, day type: WD, exch.rate: 0.868800, default curr: EUR
  48. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: Card's tariff type: user, frozen balance: 0.000000, number: 1110000001, sold: 1, owner_id: 1027, user call limit: 1, device_call_limit: 1, valid1: 1, valid2: 1, pin: 009876, ghost_balance_perc: 100.000000, tariff_id: 709, card group id: 106, use external function: 0, allow loss calls: 0, tell cents: 1, tell currency: GBP, language: en, solo pinless: 0, callerid:
  49. [2011-11-22 11:14:41] DEBUG[17897] app_mor_various.c: Checking for duplicate Voucher
  50. [2011-11-22 11:14:41] NOTICE[17897] app_mor_various.c: SQL: SELECT (SELECT disable_voucher FROM cardgroups WHERE cardgroups.id = 106), (SELECT id FROM vouchers WHERE number = '1110000001');
  51. [2011-11-22 11:14:41] DEBUG[17897] app_mor_various.c: No need to block duplicate Voucher
  52. [2011-11-22 11:14:41] NOTICE[17897] app_mor_activecalls.c: SQL: SELECT COUNT(id) FROM activecalls WHERE card_id = '423263';
  53. [2011-11-22 11:14:41] NOTICE[17897] app_mor_activecalls.c: Active call count for Card: 0 call(s)
  54. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: got_card: 1, retries: 0
  55. [2011-11-22 11:14:41] NOTICE[17897] app_mor_activecalls.c: SQL: UPDATE activecalls SET card_id = '423263' WHERE uniqueid = '1321956867.664978';
  56. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: SQL: SELECT taxes.id, compound_tax, tax2_enabled, tax3_enabled, tax4_enabled, tax1_value, tax2_value, tax3_value, tax4_value FROM taxes JOIN cardgroups ON (taxes.id = cardgroups.tax_id) JOIN cards ON (cards.cardgroup_id = cardgroups.id) WHERE cards.id = 423263;
  57. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: Compound tax: 1, Enabled? tax2: 0, tax3: 0, tax4: 0, Values: tax1: 0.000000, tax2: 0.000000, tax3: 0.000000, tax4: 0.000000
  58. [2011-11-22 11:14:41] NOTICE[17897] app_mor_callingcards.c: Balance with TAX: 0.237049
  59. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: Original balance: 0.237049, ghost_balance_perc: 100.000000, final_balance: 0.000000, tell cents: 1, tell_currency: GBP
  60. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: SQL: SELECT (SELECT exchange_rate FROM `currencies` WHERE name = 'EUR'), (SELECT exchange_rate FROM `currencies` WHERE name = 'GBP');
  61. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: Converted 0.237049 EUR (1.000000) to 0.205949 GBP (0.868800)
  62. [2011-11-22 11:14:41] NOTICE[17897] app_mor_tells.c: Tell balance: 0.21
  63. [2011-11-22 11:14:45] NOTICE[17897] app_mor_destinations.c: Will ask for destination 10 time(s)
  64. [2011-11-22 11:15:15] DEBUG[17897] app_mor_destinations.c: Entered destination (before cleaning): 923009548214
  65. [2011-11-22 11:15:15] NOTICE[17897] app_mor_destinations.c: Entered destination: 923009548214
  66. [2011-11-22 11:15:15] NOTICE[17897] app_mor_destinations.c: got_dst: 1, retries: 1
  67. [2011-11-22 11:15:15] NOTICE[17897] app_mor_destinations.c: SQL: SELECT cards.id, A.cut, A.add, A.tariff_id, A.lcr_id, dids.did, A.device_id FROM cards JOIN cardgroups ON (cards.cardgroup_id = cardgroups.id) JOIN locations ON (locations.id = cardgroups.location_id AND cardgroups.owner_id = locations.user_id) LEFT JOIN (SELECT * FROM locationrules WHERE enabled = 1 AND lr_type = 'dst' AND LENGTH('923009548214') BETWEEN minlen AND maxlen AND (SUBSTRING('923009548214',1,LENGTH(cut)) = cut OR LENGTH(cut) = 0 OR ISNULL(cut) ) ORDER BY location_id DESC, LENGTH(cut) DESC) AS A ON (A.location_id = locations.id ) LEFT JOIN dids ON (dids.id = A.did_id) WHERE cards.id = '423263' AND cards.sold = '1' LIMIT 1;
  68. [2011-11-22 11:15:15] NOTICE[17897] app_mor_destinations.c: Localization info: cut: , add: , new_did: , new_device_id: 0
  69. [2011-11-22 11:15:15] NOTICE[17897] app_mor_destinations.c: Localized destination: 923009548214
  70. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingcards.c: SQL: SELECT percent FROM cc_gmps WHERE cardgroup_id = 106 AND prefix=SUBSTRING('923009548214', 1, LENGTH(prefix)) ORDER BY LENGTH(prefix) DESC LIMIT 1;
  71. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingcards.c: Custom Ghost Min Percent not found, using default one: 100
  72. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingcards.c: Destination: 923009548214
  73. [2011-11-22 11:15:15] NOTICE[17897] app_mor_various.c: Reseting CDR! Previously answered billsec: 48
  74. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: SQL: SELECT balance, frozen_balance, credit, blocked, postpaid, users.tariff_id, tariffs.purpose, currencies.exchange_rate, allow_loss_calls, users.call_limit, D.activecalls, own_providers FROM users JOIN tariffs ON (tariffs.id = users.tariff_id) JOIN currencies ON (currencies.name = tariffs.currency) LEFT JOIN (SELECT COUNT(id) AS 'activecalls', owner_id FROM activecalls GROUP BY owner_id) AS D ON (users.id = D.owner_id) WHERE users.id = '1027';
  75. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: Reseller's data retrieved: id: 1027, balance: 6.166662, frozen_balance: 0.000000, credit: -1.000000, blocked: 0, postpaid: 0, tariff_id: 781, purpose: user_wholesale, exchange rate: 1.000000, allow_loss_calls: 0, call_limit: 0, active calls: 2, own_providers: 1
  76. [2011-11-22 11:15:15] NOTICE[17897] app_mor_dids.c: SQL: SELECT id, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12 FROM dialplans WHERE dptype = 'pbxfunction' AND data2 = '923009548214';
  77. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: SQL: SELECT A.prefix, ratedetails.rate, ratedetails.increment_s, ratedetails.min_time, ratedetails.connection_fee as 'cf' FROM rates JOIN ratedetails ON (ratedetails.rate_id = rates.id AND (ratedetails.daytype = 'WD' OR ratedetails.daytype = '' ) AND '11:14:27' BETWEEN ratedetails.start_time AND ratedetails.end_time) JOIN (SELECT destinations.* FROM destinations WHERE destinations.prefix IN ('9','92','923','9230','92300','923009','9230095','92300954','923009548','9230095482','92300954821','923009548214')) as A ON (A.id = rates.destination_id) WHERE rates.tariff_id = 781 ORDER BY LENGTH(A.prefix) DESC LIMIT 1;
  78. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: reseller wholesale rate: 0.017270, incr.: 1, min_time: 0, conn_fee: 0.000000
  79. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: SQL: SELECT B.prefix, aid, afrom, adur, atype, around, aprice, acid, acfrom, acdur, actype, acround, acprice FROM (SELECT A.prefix, aratedetails.id as 'aid', aratedetails.from as 'afrom', aratedetails.duration as 'adur', aratedetails.artype as 'atype', aratedetails.round as 'around', aratedetails.price as 'aprice', acustratedetails.id as 'acid', acustratedetails.from as 'acfrom', acustratedetails.duration as 'acdur', acustratedetails.artype as 'actype', acustratedetails.round as 'acround', acustratedetails.price as 'acprice', SUM(acustratedetails.id) as 'sacid' FROM rates LEFT JOIN aratedetails ON (aratedetails.rate_id = rates.id AND '11:14:27' BETWEEN aratedetails.start_time AND aratedetails.end_time AND (aratedetails.daytype = 'WD' OR aratedetails.daytype = '')) JOIN destinationgroups ON (destinationgroups.id = rates.destinationgroup_id) JOIN (SELECT destinations.* FROM destinations WHERE destinations.destinationgroup_id != 0 AND destinations.prefix IN ('9','92','923','9230','92300','923009','9230095','92300954','923009548','9230095482','92300954821','923009548214') ORDER BY LENGTH(destinations.prefix) DESC LIMIT 1) as A ON (A.destinationgroup_id = destinationgroups.id) LEFT JOIN customrates ON (customrates.destinationgroup_id = destinationgroups.id AND customrates.user_id = 1043) LEFT JOIN acustratedetails ON (acustratedetails.customrate_id = customrates.id AND '11:14:27' BETWEEN acustratedetails.start_time AND acustratedetails.end_time AND (acustratedetails.daytype = 'WD' OR acustratedetails.daytype = '')) WHERE rates.tariff_id = 709 GROUP BY aratedetails.id, acustratedetails.id ) AS B GROUP BY IF(B.sacid > 0,B.acid,B.aid) ORDER BY acfrom ASC, actype ASC, afrom ASC, atype ASC
  80. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: Adv.rates for user: prefix|from|duration|type|round|price
  81. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: 92300|1|0|2|90|0.050000
  82. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: 92300|1|10|1|10|0.000000
  83. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: 92300|11|600|1|60|0.030000
  84. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: 92300|611|-1|1|1|0.010000
  85. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: Retrieved 4 adv.rates, max adv.rate: 0.030000, total event price: 0.050000
  86. [2011-11-22 11:15:15] NOTICE[17897] app_mor_routing.c: SQL: SELECT lcr_partials.prefix, lcrs.id, lcrs.order FROM lcr_partials JOIN lcrs ON (lcrs.id = lcr_partials.lcr_id)WHERE main_lcr_id = '188' AND prefix=SUBSTRING('923009548214',1,LENGTH(prefix)) ORDER BY LENGTH(prefix) DESC LIMIT 1;
  87. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: SQL: SELECT * FROM (SELECT providers.id as 'providers_id', tech, channel, login, password, server_ip, A.prefix, ratedetails.rate, ratedetails.increment_s, ratedetails.min_time, providers.name as 'provname', devices.name as 'devname', ratedetails.connection_fee as 'cf', providers.cut_a, providers.add_a, currencies.exchange_rate AS 'e_rate', C.cut, C.add, providers.timeout, providers.interpret_noanswer_as_failed, providers.interpret_busy_as_failed, lcrproviders.priority as 'lcr_priority', providers.call_limit, D.activecalls, devices.latency, devices.grace_time, lcrproviders.percent, devices.fake_ring, devices.id, devices.save_call_log, providers.use_p_asserted_identity, devices.promiscredir, providers.common_use, providers.user_id FROM providers JOIN lcrproviders ON (lcrproviders.active = 1 AND providers.id = lcrproviders.provider_id AND lcrproviders.lcr_id = '188' ) JOIN tariffs ON (providers.tariff_id = tariffs.id) JOIN rates ON (rates.tariff_id = tariffs.id) JOIN ratedetails ON (ratedetails.rate_id = rates.id AND (ratedetails.daytype = 'WD' OR ratedetails.daytype = '' ) AND '11:14:27' BETWEEN ratedetails.start_time AND ratedetails.end_time) JOIN (SELECT id, prefix FROM destinations WHERE destinations.prefix IN ('9','92','923','9230','92300','923009','9230095','92300954','923009548','9230095482','92300954821','923009548214') ORDER BY LENGTH(destinations.prefix) DESC) as A ON (A.id = rates.destination_id) LEFT JOIN devices ON (devices.id = providers.device_id) LEFT JOIN currencies ON (currencies.name = tariffs.currency) LEFT JOIN (SELECT * FROM providerrules WHERE enabled = 1 AND pr_type = 'dst' AND LENGTH('923009548214') BETWEEN minlen AND maxlen AND (SUBSTRING('923009548214',1,LENGTH(cut)) = cut OR LENGTH(cut) = 0 OR ISNULL(cut) OR (cut = '-') ) ORDER BY LENGTH(cut) DESC) AS C ON (C.provider_id = providers.id) LEFT JOIN (SELECT COUNT(id) AS 'activecalls', provider_id FROM activecalls GROUP BY provider_id) AS D ON (providers.id = D.provider_id) ORDER BY LENGTH(A.prefix) DESC, LENGTH(C.cut) DESC) AS B GROUP BY B.providers_id ORDER BY B.rate / B.e_rate ASC
  88. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: LCR table:
  89. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: prov_id: 255, SIP/ mapesbury @ sip.voicetrading.com, device_id: 1387, prefix: 9230, rate: 0.0145, increment: 1, min_time: 0, conn_fee: 0.000000, exchange rate: 1.345800, cut: , add: 00001, timeout: 60, interpret as failed: no answer: 0, busy: 0, priority: 2, call limit: 0, active calls: 1, latency: 0.000000, grace_time: 0, percent: 0, fake_ring: 0, save_call_log: 0, use pai: 0, 302 support: 0, common use: 0, owner_id: 1027
  90. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: prov_id: 266, SIP/ mapesbury @ sip.voicetrading.com, device_id: 1413, prefix: 9230, rate: 0.0225, increment: 1, min_time: 0, conn_fee: 0.000000, exchange rate: 1.345800, cut: , add: 00, timeout: 60, interpret as failed: no answer: 0, busy: 0, priority: 3, call limit: 0, active calls: 1, latency: 0.000000, grace_time: 0, percent: 0, fake_ring: 0, save_call_log: 0, use pai: 0, 302 support: 0, common use: 0, owner_id: 1027
  91. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: prov_id: 267, SIP/ mapesbury @ sip.voicetrading.com, device_id: 1414, prefix: 9230, rate: 0.0263, increment: 1, min_time: 0, conn_fee: 0.000000, exchange rate: 1.345800, cut: , add: 00000, timeout: 60, interpret as failed: no answer: 0, busy: 0, priority: 4, call limit: 0, active calls: 0, latency: 0.000000, grace_time: 0, percent: 0, fake_ring: 0, save_call_log: 0, use pai: 0, 302 support: 0, common use: 0, owner_id: 1027
  92. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: prov_id: 249, SIP/ @ 67.216.35.162, device_id: 1372, prefix: 92300, rate: 0.0276, increment: 6, min_time: 30, conn_fee: 0.000000, exchange rate: 1.345800, cut: , add: 011, timeout: 60, interpret as failed: no answer: 0, busy: 0, priority: 1, call limit: 0, active calls: 0, latency: 0.000000, grace_time: 0, percent: 0, fake_ring: 0, save_call_log: 0, use pai: 0, 302 support: 0, common use: 0, owner_id: 1027
  93. [2011-11-22 11:15:15] NOTICE[17897] app_mor_callingdata.c: Retrieved 4 route(s)
  94. [2011-11-22 11:15:15] DEBUG[17897] app_mor.c: User call limit: 1, tariff type: user
  95. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Balance: 0.237049, total_arates: 4
  96. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: 1|0|2|90|0.050000
  97. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Price: 0.057551, billsec: 0, can_pass: 1
  98. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: 1|10|1|10|0.000000
  99. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Price: 0.057551, billsec: 10, can_pass: 1
  100. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: 11|600|1|60|0.030000
  101. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Price change: -0.165805, billsec delta: -360, round: 60
  102. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Price: 0.402855, billsec: 10, can_pass: 0
  103. [2011-11-22 11:15:15] DEBUG[17897] app_mor_various.c: Final Billsec(timeout): 10
  104. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: Initial timeout: 10
  105. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: DID owner timeout: -1, DID incoming timeout: -1, reseller timeout: -1
  106. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: Selected lowest timeout: 10
  107. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: Timeout: 7, real timeout: 10, user_id: 1043, callertype: Local, anitype: , postpaid: 0
  108. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: Caller/card balance to freeze: 0.053500
  109. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: SQL: UPDATE cards SET frozen_balance = frozen_balance + 0.053500 WHERE number = '1110000001' AND pin = '009876'
  110. [2011-11-22 11:15:15] NOTICE[17897] app_mor.c: SRC record: 0, record_forced: 0, rec_forced_enabled: 0, DST record: 0, record_forced: 0, rec_forced_enabled: 0
  111. [2011-11-22 11:15:15] NOTICE[17897] app_mor_activecalls.c: SQL: UPDATE activecalls SET src_device_id = '1382', dst_device_id = '0', channel = 'SIP/11071-000a0c3f', dstchannel = '', prefix = '92300', did_id = '353', user_id = '1043', owner_id = '1027', localized_dst = '923009548214', user_rate = '0.034530' WHERE uniqueid = '1321956867.664978';
  112. [2011-11-22 11:15:15] NOTICE[17897] app_mor_tells.c: Seconds: 10, tell time modifier: 1.000000
  113. [2011-11-22 11:15:17] NOTICE[17897] app_mor_tells.c: Minutes: 0, seconds: 10
  114. [2011-11-22 11:15:17] NOTICE[17897] app_mor_tells.c: Minutes: 0, seconds: 10 after tell_time_modifier applied
  115. [2011-11-22 11:15:18] DEBUG[17897] app_mor.c: Provider's call limit (0) not reached. Active calls: 1
  116. [2011-11-22 11:15:18] DEBUG[17897] app_mor_various.c: Rates. Provider: 0.010774, reseller: 0.017270, user: 0.034530
  117. [2011-11-22 11:15:18] NOTICE[17897] app_mor_various.c: Reseting CDR! Previously answered billsec: 51
  118. [2011-11-22 11:15:18] NOTICE[17897] app_mor_routing.c: SQL: SELECT IF( (SELECT server_id FROM serverproviders WHERE serverproviders.provider_id = 255 AND serverproviders.server_id = 1) IS NULL, (SELECT server_id FROM serverproviders WHERE serverproviders.provider_id = 255 order by rand() LIMIT 1), 1);
  119. [2011-11-22 11:15:18] NOTICE[17897] app_mor_routing.c: Do routing: 0, route_device_name:
  120. [2011-11-22 11:15:18] NOTICE[17897] app_mor_activecalls.c: SQL: UPDATE activecalls SET provider_id = '255' WHERE uniqueid = '1321956867.664978';
  121. [2011-11-22 11:15:18] NOTICE[17897] app_mor_callerid.c: SQL: SELECT providerrules.cut, providerrules.add FROM providerrules WHERE provider_id = '255' AND enabled = 1 AND pr_type = 'src' AND LENGTH('11071') BETWEEN minlen AND maxlen AND (SUBSTRING('11071',1,LENGTH(cut)) = cut OR LENGTH(cut) = 0 OR ISNULL(cut) OR cut = '*') ORDER BY LENGTH(cut) DESC LIMIT 1;
  122. [2011-11-22 11:15:18] NOTICE[17897] app_mor_callerid.c: CallerID after Provider Rules applied: 11071 (cut: , add: )
  123. [2011-11-22 11:15:18] NOTICE[17897] app_mor.c: Destination after Provider Rules applied: 00001923009548214 (cut: , add: 00001)
  124. [2011-11-22 11:15:18] NOTICE[17897] app_mor.c: Terminator IP: sip.voicetrading.com
  125. [2011-11-22 11:15:18] NOTICE[17897] app_mor.c: Dial string (Local to Outside): 'SIP/00001923009548214@prov1387|60|L(7000:120000:60000)HiM(mor_answer|1321956867.664978)'
  126. [2011-11-22 11:15:18] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  127. [2011-11-22 11:15:18] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten = '442080990359' AND context = 'mor' AND priority = '-1'
  128. [2011-11-22 11:15:18] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  129. [2011-11-22 11:15:18] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten LIKE '\\_%' AND context = 'mor' AND priority = '-1' ORDER BY exten
  130. [2011-11-22 11:15:47] WARNING[17897] app_dial.c: Unable to forward voice frame
  131. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Res after dialing '-1', hangup cause: NO ANSWER
  132. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: real duration: 29.342960, duration: 30
  133. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Seconds to bill: 0
  134. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID billsec: 51, duration: 81
  135. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: LegA: ANSWERED, LegB: NO ANSWER
  136. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Provider's grace time: 0, reseller's billsec after grace time: 0
  137. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Reseller billsec: 0, price: 0.000000, rate: 0.000000
  138. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: User's grace time: 0, user billsec after grace time: 0
  139. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID's grace time: 0, user billsec after grace time: 0
  140. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Provider billsec: 0, price: 0.000000, rate: 0.000000, dd_index: 0
  141. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: User billsec: 0, price: 0.000000, rate: 0.000000
  142. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID owner billsec: 51, price: 0.000000, rate: 0.000000
  143. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID incoming billsec: 51, price: 0.000000, rate: 0.000000
  144. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID provider billsec: 51, price: 0.000000, rate: 0.000000
  145. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Reseller prices after convert to default currency: rate: 0.000000, price: 0.000000
  146. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Prices after convert to default currency: prov_rate: 0.000000, prov_price: 0.000000, user_rate: 0.034530, user_price: 0.000000
  147. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Reseller's rate: 0.000000, price: 0.000000 changed to Provider's because reseller used his own providers.
  148. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: SQL: INSERT INTO calls (calldate, clid, src, dst, duration, billsec, disposition, accountcode, uniqueid, src_device_id, dst_device_id, provider_id, provider_rate, provider_billsec, provider_price, user_id, user_rate, user_billsec, user_price, reseller_id, reseller_rate, reseller_billsec, reseller_price, prefix, callertype, card_id, hangupcause, did_price, server_id, peerip, recvip, sipfrom, uri, useragent, peername, t38passthrough, did_inc_price, did_prov_price, localized_dst, did_provider_id, did_id, channel, originator_ip, terminator_ip, real_duration, real_billsec, did_billsec) VALUES ('2011-11-22 11:14:27', '11071', '11071', '923009548214', '81', '0', 'ANSWERED', '1382', '1321956867.664978', '1382', '0', '255', '0.000000', '0', '0.000000', '1043', '0.034530', '0', '0.000000', '1027', '0.000000', '0', '0.000000', '92300', 'Local', '423263', '0', '0.000000', '1', '', '', '', '', '', '', '0', '0.000000', '0.000000', '923009548214', '175', '353', 'SIP/11071-000a0c3f', '213.197.141.162', 'sip.voicetrading.com', '29.342960', '0.000000', '51' );
  149. [2011-11-22 11:15:47] NOTICE[17897] app_mor_debug.c: RTPAUDIOQOS: ssrc=714650752;themssrc=2468102124;lp=1;rxjitter=0.006037;rxcount=4032;txjitter=1.662964;txcount=2123;rlp=32;rtt=0.000000
  150. [2011-11-22 11:15:47] NOTICE[17897] app_mor_debug.c: PDD:
  151. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Reseller's balance will not be changed because he used his own provider.
  152. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Cards' balance will be deducted by: 0.000000, and frozen balance will become 0.
  153. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: SQL: UPDATE cards SET balance = balance - 0.000000, frozen_balance = 0 WHERE id = '423263'
  154. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: DID Owner's balance will be deducted by: 0.000000, and frozen balance by: 0.000000.
  155. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: SQL: UPDATE users SET balance = balance - 0.000000, frozen_balance = frozen_balance - 0.000000 WHERE id = '0'
  156. [2011-11-22 11:15:47] NOTICE[17897] app_mor_activecalls.c: SQL: DELETE FROM activecalls WHERE uniqueid = '1321956867.664978';
  157. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Hangupcause: ANSWERED, chan->hangupcause: 0, mor hangupcause: 0, hangupcause to DB: 0
  158. [2011-11-22 11:15:47] NOTICE[17897] app_mor.c: Application mor started and ended succesfully, with end code: 0!
  159. [2011-11-22 11:15:47] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  160. [2011-11-22 11:15:47] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten = 'h' AND context = 'mor' AND priority = '7'
  161. [2011-11-22 11:15:47] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Everything is fine.
  162. [2011-11-22 11:15:47] DEBUG[17897] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extlines WHERE exten LIKE '\\_%' AND context = 'mor' AND priority = '7' ORDER BY exten
  163. [pauliusb@ns27150 asterisk]$
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!