Rene Krenn
4d22df227d
MT#58896 possibility to include redis registrations in customer exporter
...
Change-Id: I2dfdab69fdf116ad128706ec4296e492f8224868
(cherry picked from commit 38a6857546 )
(cherry picked from commit 91f4670bd1 )
1 year ago
Rene Krenn
5bf47d4706
MT#60120 fix typo in lnp_providers.pm
...
Change-Id: Ic4f92b71f0f78ae2858d5e1205ead6e0b31b3ded
(cherry picked from commit 7bc53812f2 )
(cherry picked from commit 1e2fc6c739 )
2 years ago
Rene Krenn
6e25dc435d
MT#60120 dao methods to purge lnp numbers
...
Change-Id: I80a642557c7f118a9e1b9aba763147915ec9ccf4
(cherry picked from commit f234067ef8 )
(cherry picked from commit 6b1bc3691f )
2 years ago
Rene Krenn
bb3e9d0dd9
MT#60189 support multi-insert stmts for lnp_numbers
...
Change-Id: I2baf3ace876c4d869ec40668a61c9899f5c7ba85
(cherry picked from commit d785be99f5 )
(cherry picked from commit 707948b099 )
2 years ago
Rene Krenn
9b9a031dec
TT#123451 CDR graph exporter/importer #1
...
Change-Id: I146ae01f4ae6a8825b64c4403e26f5d64a8e8c50
3 years ago
Rene Krenn
d569230722
TT#92350 TT#175101 LNP database bulk loader
...
this tool provides loading and updating the ngcp LNP
database from customer-specific textfiles with many
GBytes and tens of mio. of rows. in a *fast* way.
Change-Id: Ie64b1a9c7dfe3251c41dd443ed937cf8da18cb36
4 years ago
Rene Krenn
bca22edb84
TT#166652 add prov_subscriber->subscriber_profile relation
...
Change-Id: Id809f750969ed6778255d87f3e92876f6a672d34
4 years ago
Rene Krenn
591663cb6f
TT#161550 properly report inserted/ignored cdr records
...
Change-Id: I2d16cca01ef86bf27d862598adecc5231c8ca347
4 years ago
Rene Krenn
3552503117
TT#161550 support loading CDR graphs
...
Change-Id: Ic67d36e15ebe64d4bc84943df785782981ba8974
4 years ago
Rene Krenn
7210135109
TT#161550 file processors: support processing directory structures
...
Change-Id: Ica509e95596d3b5f13486087ba47c190bab2e4db
4 years ago
Rene Krenn
d812c82aa6
TT#155901 LGI: exporter for EDR transition data
...
Change-Id: Ie3b6aef065d236c1d80589b3efc8c0545dea4d6a
4 years ago
Rene Krenn
b75069b799
TT#138950 add missing accounting.cdr field defs
...
-source_user_out
-destination_user_out
-source_lnp_type
-destination_lnp_type
Change-Id: I53a237fb6c198ca7e0c592bada366119f15320f7
4 years ago
Rene Krenn
51c91d368d
TT#129852 export registration to .csv or sqlite
...
Change-Id: If7561752ece1c5daff9e479646592ae59e5539d4
4 years ago
Rene Krenn
854ed66481
TT#136902 render UML class diagrams
...
Change-Id: I3fe040e3a277bb4c2c937450b2b6540fd6f324dc
4 years ago
Rene Krenn
b672c4f53c
TT#138400 fix findby_domain_usernames finder method query
...
Change-Id: I9e41ff0845e3476c81cfb6141f574db9563b7e12
(cherry picked from commit 79bc78feca )
4 years ago
Rene Krenn
e2f6b74779
TT#138400 provisioning.voip_subscribers.findby_domain_usernames
...
Change-Id: Ibd88950516ac86d2fb966636f40041f5e75e3758
4 years ago
Rene Krenn
94e086773b
TT#127150 contract/susbcriber exporter: sqlite tabular export
...
Change-Id: I88ad999230421b7aa3c17a99c5783d047c621473
5 years ago
Rene Krenn
ef52bd86b9
TT#121785 provisioning::voip_subscribers::findby_id finder method
...
Change-Id: Ic6e377c7b89cdedcc6e94b541f4db37b023b5a56
5 years ago
Rene Krenn
72ab33d02b
TT#119460 openser "location" DAO
...
Change-Id: I998a2d2c80e2a56d3faea2f159ce0dbb2dcbc36d
5 years ago
Rene Krenn
b1c9101fba
TT#111750 add trunk kamailio.voicemail_spool DAO
...
Change-Id: Ia0632e0b69429a1ee2e15917244e7b6355ef7f65
5 years ago
Rene Krenn
9c90f7998d
TT#111206 add mr1.0.3 openser.voicemail_spool DAO
...
Change-Id: Iec3bfd97e98a82f2633b2a184a2f677c5dd3ca2f
5 years ago
Rene Krenn
565cafde3b
TT#109163 fix contracts dao for mr1.0.3 schema
...
Change-Id: I5000731027c83711e9d03dcce52d5aef286b0e26
5 years ago
Rene Krenn
d5dec06fff
TT#104251 cdr paging queries: force index
...
Change-Id: I373d638313385e43d08b00ca0b0f3146fb6ec048
(cherry picked from commit d78ed162cd )
5 years ago
Rene Krenn
04e8fb04e1
TT#104251 refactor paging queries for cdr tables
...
the implementation used queries based on "OR",
causing a perfromance problem as the query time
depends on the cardinality of the accounting.cdr
table.
Change-Id: I1dbb23cf8802179b89c44718915ca090a2b17b5e
5 years ago
Rene Krenn
72f22eb5a0
TT#81770 magenta openser mig: comply mr103 and trunk db schema
...
Change-Id: I06daf4af0dc374c649a0617b438d2b89703a3285
(cherry picked from commit 82e6d73750 )
5 years ago
Rene Krenn
3e7bab759b
TT#87561 remove fax prefs from openser mr1.0.2 dao db schema
...
Change-Id: Ie31e3d67d6bdaced8e51596fc5ce111648029053
5 years ago
Rene Krenn
d3f81b356c
TT#95953 define BLOCK_IN_CLIR and BLOCK_OUT_OVERRIDE_PIN attrs
...
Change-Id: Ib9d05b131fd7e8b224bd9719b5988aa3431d3bd2
5 years ago
Rene Krenn
5010a23968
TT#87561 openser/ngcp mr1.0.2 dao db schema
...
Change-Id: I37a174b71c80bc24d9246eafc20a12e18256d736
5 years ago
Rene Krenn
e0d143ec3b
TT#75901 cdr_status_data UPSERT should return 0 if already exported
...
CDR export jobs such as ama exporter or cdr-exporter must never execute
on both active/passive node. because the output folder resides on a
glusterfs filesystem, this will cause merged or duplicate files, and
calls charged twice to customers subsequentially.
for .ama, the 2-phase commit steps for exporting CDRs were separated
already:
(a) rename .tmp file to final output file name
(b) commit db transaction:
- cdrexportstatus of all cdrs of that file
- file sequence number increment
The implemented 2PC flow will prevent (a) properly, if (b) fails.
This is now leveraged (by escalating the UPSERT not changing anything) to
abandon a whole file, if a single CDR shows an exportstatus other than
"unexported". Such CDRs indicate there is a race condition with another
exporter (which was quicker here).
the same thechnique also has to be added to cdr-exporter, which
unfortunately has no 2PC flow impl yet.
Change-Id: Ice40fa79d2b263018ee7825e314d63c9abe888ce
6 years ago
Rene Krenn
6f3ed53106
TT#81154 subscriber_profile DAO
...
Change-Id: Ib14ec6ac92bcd295bb0f793677799f2d13cc141c
6 years ago
Rene Krenn
8e4de26084
TT#81155 subscriber_profile_set DAO
...
Change-Id: I0bf4ed63d999d86449a5ed3912934f0549a2b851
6 years ago
Rene Krenn
9885b9e8cd
TT#79802 is_boolean() method for voippref
...
Change-Id: I8346932f2819eeb07aec1cadd09f28802780bdb5
6 years ago
Rene Krenn
00bba0da7b
TT#77954 merge tool: location records
...
Change-Id: I94d493730b4ea6c2aa0e48581ebc651a380f4897
6 years ago
Rene Krenn
71d805440a
TT#72650 cdr-generator: fix random subscriber selection
...
if the number of exisiting subscribers (used as caller/callee
in created cdrs) is low, there is a higher risk that it can
fail to randomize one.
Change-Id: Id8f37f259e07f1b50251008a207a3e6122a628ea
6 years ago
Rene Krenn
7ff2336957
TT#71363 contract_preferences, ccs prov tool "*" allowed cli
...
Change-Id: Ie5b16da0361408cabccf7ec41c85bbe1884a9d1a
6 years ago
Rene Krenn
f763ad109c
TT#69125 mr1.0.3 source db schema
...
Change-Id: I35b67c66236696af6c041e34dc4a732fdca1069d
6 years ago
Rene Krenn
8b934eb8b2
TT#69853 support resetting .ama export status by call-id(s)
...
Change-Id: Iac1ceaf333a6e431cb59fc03e8015d337d0ac692
6 years ago
Rene Krenn
1b96d8923b
TT#67109 TT#63655 migrate voipnumbers.listtimestamp
...
Change-Id: I24ae999cb7807e764bb38797689be0477d021655
6 years ago
Rene Krenn
dd3ad894be
TT#67109 TT#63655 remove debug limit
...
Change-Id: I7b99fbb13feed2d11ca37b863ca2b6aa006cf5be
6 years ago
Rene Krenn
51edb2e561
TT#67109 TT#63655 move projects, dbschema for mergemigration tool
...
Change-Id: I8db0588c43fd96cdf7f6d9901773b29e940cae16
6 years ago
Rene Krenn
cc37f38d5b
TT#64001 .ama: accept also CFB for "callforward on ncgp" sceanrio
...
Change-Id: I4e7bbe396b246548935fe0ada58e53992542ffa3
7 years ago
Rene Krenn
70b5b93596
TT#64001 .ama: process User-To-User instead of $ivr_duration_limit
...
Change-Id: Ib118e8f543cf67fabde75e12bdda71653df277f8
7 years ago
Rene Krenn
8a0c240282
TT#58688 CCS importer: set CFU for subs with "1:1" routing typ
...
Change-Id: Ifc4f2d4ca4e11770f3375c57d7c72443f9b830b1
7 years ago
Rene Krenn
05b2d9c8a1
TT#58651 ama exporter: add cfu_no_ivr scenario
...
Change-Id: I58ed4c428632b4bac1ad3b701650a77cd29233e8
7 years ago
Rene Krenn
dbf0f0c6c6
TT#57614 ccs importer: implement writing pbx prefs
...
Change-Id: Iaab35f040b567656051541204285a9e035e623c6
7 years ago
Rene Krenn
0d481d1cc9
TT#55815 TT#55816 TT#55817 .ama export: scenarios
...
- "blind xfer"
- "no xfer"
- "attn xfer"
Change-Id: I51d536992eeb031a6a49fa45eb091dc6c49599dd
7 years ago
Rene Krenn
8750c0fd16
TT#54661 .ama exporter: skip malformed CDRs
...
use export status "failed" for CDRs w/o destination
Change-Id: Idcd411124d96b12df6f82da005f1a7238e71d9a0
7 years ago
Rene Krenn
60b86558a6
TT#54612 cashback tool WIP
...
Change-Id: I3ce428de311471be1d401dd8f51f50a41ad94032
7 years ago
Guillem Jover
bee151585a
TT#53701 Remove executable bit from perl module files
...
Change-Id: I8598dc0ce9382b7b31c946e8f2864fa54c9a92d2
7 years ago
Rene Krenn
f00fbe2873
TT#50974 ama: ccs "direct forwarder" scenario
...
Change-Id: Ifa6cba9d8429dcb1c72569dd12ba7f59aaef975e
7 years ago