Kirill Solomko
4dcc2ffdfc
MT#12707 - add 'identifier' domain and peer preference
...
- add 'source' field for accounting.malicious_calls
Change-Id: I65eed3657fe6f9c37350529c923715728711c2d5
10 years ago
Rene Krenn
584b376584
MT#14255 add balance underrun detection timestamp cols
...
+add "hour" balance interval enum value
Change-Id: Ic52ebf4af8744bf2d1f732a7aa689730e0300db5
10 years ago
Kirill Solomko
34e08ad886
MT#14875 - Peer preferences update trigger fixes
...
- fix updates based on id instead of ip
- fix duplicate kamailio.peer_preferences on peer enable/disable
- fix duplicate 'transport_protocol' peer_preferences
Change-Id: I6598afbf93d1ab3bfe553f6f3de0c526e7898267
10 years ago
Andrew Pogrebennyk
ca64bb31b8
MT#13459 MT#11831 add Romanian language to the enum preference
...
Change-Id: I8b43de9435e1dbf1ba6d3331b93f2f27bbdcb443
10 years ago
Kirill Solomko
54f1988337
MT#12707 - add accounting.malicious_calls table
...
- add malicious_call_identification voip_preference
- add malicious_call_identification sound set
- add 'Applications' voip_preference_group
Change-Id: I6707913b576ec7066d6c5a5af06eeff903c2ce20
10 years ago
Andrew Pogrebennyk
2a0b09550d
MT#14227 add preference for choosing libswrate/libinewrate for prepaid
...
Change-Id: I31bb09e2fe62cf1bdbbccc6c765f00dd7fe31544
11 years ago
Rene Krenn
b039943d76
MT#14301 drop prof package 'status' column
...
Change-Id: I0563dc38c3ce41b7614864ccae157c61712b65ec
11 years ago
Rene Krenn
0f7770117e
MT#13903 add 'topup_interval' start mode
...
Change-Id: Ia191c37379f9b0a977436dd662f7e820efdd67d9
11 years ago
Rene Krenn
be14d6fe7f
MT#13903 add package_id column to vouchers
...
+topup counter columns for contract_balances
Change-Id: I9e44cdc38f06b5248aa595222128a3c82b4e8580
11 years ago
Rene Krenn
4f0043b6b2
Revert "MT#11917 extended journal table"
...
This reverts commit 2431bb6374 .
Change-Id: Iaf9a3a4acd932fb36733fad16ec14aa5a1ae8e92
11 years ago
Rene Krenn
2431bb6374
MT#11917 extended journal table
...
columns username and content_format added. 3 formats
for storing a resource data snapshot are supported:
json (default), json_deflate, storable
Change-Id: I8cb1fed7a5d6d01437c2129ea1b3053b2252cae9
11 years ago
Irina Peshinskaya
fe1c0e12fb
MT#13971 Remove unnecessary debug from fill_billing_fees procedure
...
Added as additional script to disable debug in already installed procedure,
as fixed 15167 will not run again on upgrade.
Change-Id: I9c8556187b472e4a45faf00e68b3e93f43d99965
11 years ago
Irina Peshinskaya
4fd69bd40c
MT#13971 Remove unnecessary debug from fill_billing_fees procedure
...
Change-Id: Id28dfcd9b088b3142630d404873c7d7cd14722cd
11 years ago
Alexander Lutay
08136a0355
Revert "MT#13971 Remove unnecessary debug from fill_billing_fees procedure"
...
This reverts commit db9c2a05f6 .
Change-Id: I8dae173a22d3cc8fb18a5ef3dc2da9ea1b534319
11 years ago
Irina Peshinskaya
db9c2a05f6
MT#13971 Remove unnecessary debug from fill_billing_fees procedure
...
Change-Id: I397f10fb8564a3edbdc0ad83e9d6d97a4e3bd13d
11 years ago
Victor Seva
5f024cd506
MT#13919 PRO: add ldap database
...
Change-Id: I67d4d3853017a0d2b4a564735551758c3931eb6c
11 years ago
Victor Seva
7588c96f3d
MT#13329 adapt rewrite rules to new upstream syntax [*] -> [+]
...
Change-Id: If13e0fc7ea42f99d98835402fee148d27198cfea
11 years ago
Victor Seva
1c77b0c04a
MT#10339 kamailio: upgrade to 4.3.0
...
This will be executed in every node in order to
be able to have different versions during the upgrade
process
Change-Id: I0fd2b1c858f792b233b9fea348320c7635f4ebd2
11 years ago
Jenkins Git User
4e02874733
MT#12643 billing network, profile packages
...
Change-Id: Ic904086fac4ac5b76e5dd5174b86fa09d838526f
11 years ago
Andrew Pogrebennyk
750e43a504
MT#13595 add new option to pref bypass_rtpproxy
11 years ago
Irina Peshinskaya
ce353865a6
MT#13369 Extend enum for lineranges positions variants
...
Change-Id: I2689180e84793379c124f6c9a9c4d7063c24288b
11 years ago
Andreas Granig
2f03406c1d
MT#13201 Add billing_data acl to admins
...
Change-Id: Ibd2cc1ff29fe00924b37a05614ce8b1066749bdd
11 years ago
Irina Peshinskaya
086250db36
MT#7227 Fill billing_fees from temporary location with not unique records.
...
Change-Id: I3171ce5b57b15830b46a187aa332516b2f8ebe17
11 years ago
Kirill Solomko
63e368d9e2
MT#11225 - add billing_profiles.fraud_use_reseller_rates
...
Change-Id: I592bd5a41743ce8a21aed493d9cb0d851cb7192f
11 years ago
Gerhard Jungwirth
5b61f8174e
MT#12303 expose dialogic configs optical, nfs and snmp
...
Change-Id: I63e12ea78dd0c9819d3d53f176f696f7e1fca737
11 years ago
Irina Peshinskaya
7c19a94456
MT#11791 Fix typo in the build fix
...
Change-Id: I9183a86e49f07f2d44205cad146b2e27aadc09bf
11 years ago
Irina Peshinskaya
07431b9129
MT#11791 Fix broken PRO SP2 installation.
...
It doesn't have mentioned columns, 13219 was "not_replicated".
Change-Id: I20a5fffadbf097c3488f367479cfb5414f6d2845
11 years ago
Irina Peshinskaya
8bf9cddb5a
MT#11791 Increase costs precisions to 6 number after point
...
Change-Id: Iba4d3ef4ab6b73e4eadfc6b2e6d10b9174db13ec
11 years ago
Alexander Lutay
178736df06
MT#12507 Fix 15139.up: remove hardcoded reference to voip_preference_groups
...
Otherwise 2.8-mr3.8 upgrade failed with error:
> Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/15139.up:
> ERROR 1452 (23000) at line 4: Cannot add or update a child row: a foreign key constraint fails
> (`provisioning`.`voip_preferences`, CONSTRAINT `vpgid_ref` FOREIGN KEY
> (`voip_preference_groups_id`) REFERENCES `voip_preference_groups` (`id`) ON UPDATE CASCADE)
It happens because statements are executed on sp1/sp2 (even/odd id's):
> mysql> select * from voip_preference_groups;
> +----+----------------------------+
> | id | name |
> +----+----------------------------+
> | 2 | Call Forwards |
> | 4 | Call Blockings |
> | 6 | Access Restrictions |
> | 8 | Number Manipulations |
> | 10 | NAT and Media Flow Control |
> | 12 | Remote Authentication |
> | 14 | Session Timers |
> | 16 | Internals |
> | 18 | Cloud PBX |
> | 20 | XMPP Settings |
> +----+----------------------------+
> 10 rows in set (0.00 sec)
Change-Id: I90782a5dae5017f22c240ced15661b88594cff69
11 years ago
Andreas Granig
6d0b93fc7e
MT#12503 Drop ngcp.cfg_schema table
...
Has been moved to sqlite, no need to keep it in db anymore.
Change-Id: I5839bda96d5e9e20faa089eb4cc8524b2cadca41
11 years ago
Andrew Pogrebennyk
17420f0392
MT#12465 add new option to force_outbound_calls_to_peer enum pref
...
Change-Id: Idc4b249bb85a9c53ca3484ae49fb5e69ef13198d
11 years ago
Andrew Pogrebennyk
d4c006e4a8
MT#11859 update kamailio.version for table sca_subscriptions
...
Change-Id: I7120e388117ef0c24536d9fbac653a5352c5c4df
11 years ago
Andrew Pogrebennyk
2e9ce240c2
MT#11501 fix the type for dialogic enum prefs
...
Change-Id: If2204d477e54bbae5143d193662fe4fabc3d94b8
11 years ago
Andreas Granig
69276708cb
MT#12385 Add reseller_id to EDR head.
...
Change-Id: I29a56f38e12a5f7ed703397d456cf7b10030e44c
11 years ago
Gerhard Jungwirth
db5440d041
MT#12303 peer preferences for dialogic as ss7
...
Change-Id: I24b389e5fa3456c83cf1edc8b8416365079939f9
11 years ago
Rene Krenn
7c6ab9d539
MT#11917 Adapt journals table
...
Change-Id: Ibfd27acbd37c929358b2ec8d4412fc6707f69753
11 years ago
Richard Fuchs
578191201c
MT#12227 unify srtp/avpf prefences into a single protocol preference
...
Change-Id: Id34fd60dd7f6d2b837848f7b5349453f54858cd9
11 years ago
Kirill Solomko
08252f5543
MT#11493 - add set sql_log_bin=0 to 15148 and 15151 not_replicated
...
Change-Id: Icebde6369f83451faaef91cea9330a1610d9a68d
11 years ago
Gerhard Jungwirth
b9d20d874e
MT#11501 dialogic add isdn config option
...
Change-Id: Id2cdd9edf81eb2c6ca79aab04e189334d0c01ad1
11 years ago
Irina Peshinskaya
1237ae3129
MT#11147 Add possibility to have some field extensions of the same model
...
Change-Id: Id2525047ff7f1993b081ed69ee91099af4b5d4e8
11 years ago
Kirill Solomko
a932d63799
MT#11157 - grant SELECT on stats.call_info to nagios@localhost
...
Change-Id: I7aaef7dc2f66579f335b38a50539091ebd037ba2
11 years ago
Kirill Solomko
f7892e7027
MT#11157 - rename "stats" db initial creation into not_replicated
...
Change-Id: I3f1808810b80d1755e9cd30314d2a5343dc91a8f
11 years ago
Andrew Pogrebennyk
7d717e9579
MT#12053 Add conference_max_participants preference and sound handle
11 years ago
Gerhard Jungwirth
75b8236573
MT#11501 create dialogic config options
...
Change-Id: I4fae4521bf458b7ab18b656615c30f4d53453822
11 years ago
Kirill Solomko
6c54fdfb66
MT#11157 - create db "stats", move sipstats.call_info to stats.call_info
...
Change-Id: Iae82b3a64e9a74f137a8e18e37a97dc84a7dc154
11 years ago
Rene Krenn
a17f37a480
MT#11917 Add billing.journals table
11 years ago
Andrew Pogrebennyk
b342a0f8da
MT#11615 introduce preference ignore_cf_when_hunting
11 years ago
Kirill Solomko
b8172987ca
MT#11157 - add sipstats.call_info table
...
Change-Id: I84d16fcabc78684686986bd77a4644ae67a3626f
11 years ago
Irina Peshinskaya
61ecaeb723
MT#11147 Rename forgotten devices with empty types.
...
Change-Id: I499f475840d27b9967bdc7cb96999206a7a7a77e
11 years ago
Andrew Pogrebennyk
950852114a
MT#11241 add sound handles: conference_pin, conference_waiting_music
11 years ago
Irina Peshinskaya
4918c79fde
MT#11147 Rename already existing phones types from 'basic' to 'phone'
...
Change-Id: I362c6f949005a87adc06bf3765ead078fc20623c
11 years ago
Irina Peshinskaya
4c07f83a9e
MT#11147 Add forgotten extensions_num
...
Extension doesnt have bootsrtap uri
And rename type basic to phone
Change-Id: I7a4cd795850b16afcba8259b3f85e4e82c5ad230
11 years ago
Andrew Pogrebennyk
8a75a8c1d1
MT#11219 rename prompts x1..9.wav to 1..9-and.wav
...
The reason is that we should use the same naming convention as in ngcp-prompts.
While at it, add conference_first handle.
Change-Id: Ie88bc5d9844eddb38107079508ea23d2371a9328
11 years ago
Irina Peshinskaya
816c3fb049
MT#11147 DB changes for device phones-extensions link
...
Change-Id: I1113faf6b43f87a0e54f15a589e54a00c44eb518
11 years ago
Andreas Granig
88f528fcb2
MT#10879 Increase mailbox column to fit uuid.
...
Needed for when there is no primary number.
Change-Id: I618bbd83fb74ea369ecdd697fcd06dda45949b57
11 years ago
Richard Fuchs
100ba51795
add "rtp_interface" preference
11 years ago
Andrew Pogrebennyk
ac544f4b5d
MT#8129 fix the conference prompts and language preference
...
Change-Id: Ifb0b233a7e1ed0df48fdef628b887e1b1a05e598
11 years ago
Andrew Pogrebennyk
7ae378e395
MT#11005 add queue wrap-up time and max length prefs
...
Change-Id: I0d51bb1057a2fd0e8692898edda7e6bef2a4457c
11 years ago
Andrew Pogrebennyk
21bf3c51e5
MT#8129 add conference sound group and handles
...
Change-Id: Icf9f5c4c1ad864147689cccd74ea715abb4f4b72
11 years ago
Kirill Solomko
8a0addfaad
MT#10169 - peer host/rule updated triggers with the "enabled" column logic
...
Change-Id: Id54389a7043080875b9c6a580e4a1f9f321b6868
11 years ago
Irina Peshinskaya
c0fdacbe32
MT#10715 Add polycom profile parameter
...
Change-Id: I232a1eae6c905372e76510ed9127a749de18fb71
11 years ago
Irina Peshinskaya
5dade741b3
MT#10715 Change bootstrap method parameters to enable custom ztp profile.
...
Change-Id: Ic4a5391dfd32c71d576332bcfc6468196841a1b1
11 years ago
Andrew Pogrebennyk
c637b34b46
MT#8129 introduce conference_pin preference
...
Change-Id: Ie24e9faf6bc5e3564a1b743737916c55a30178df
11 years ago
Andrew Pogrebennyk
d533529724
MT#9453 introduce CF adm NCOS level.
...
Change-Id: I5409d2657b670000fd3b45dc1213081d9910e5fa
11 years ago
Irina Peshinskaya
b1a81d0b0e
MT#10715 Add Polycom vendor
...
Change-Id: I5b8dfefbdcaf0eb120e59e634eaa091db8c70270
11 years ago
Kirill Solomko
dc1c7e6eca
MT#10169 - add voip_rewrute_rules.enabled columns creation into 15129.up/down
11 years ago
Kirill Solomko
2ba55d1c76
MT#10169 - add voip_rewrute_rules.enabled logic into the dialplan triggers
11 years ago
Andrew Pogrebennyk
5eaef5f0aa
MT#10367 add language for voicemail/conf sounds a preference
11 years ago
Andrew Pogrebennyk
cef701074e
MT#10691 add cloud_pbx_callqueue preference and sound_handles
11 years ago
Andreas Granig
c27ba3ed26
MT#10587 Add autoprov_field_devices.encryption_key
...
Change-Id: I0f5ef8ab8fdc7b65584e0667612feb5fa35913b3
11 years ago
Andreas Granig
a35672e47c
MT#10543 Add enable_t38 preference.
...
Change-Id: I442347314051876ca80a24df04443d61c353e90d
11 years ago
Andrew Pogrebennyk
1c9ffd2f1a
MT#10381 add concurrent_max[_out] as contract pref
11 years ago
Richard Fuchs
18ed7a9d15
MT#9763 add key for device_id column
11 years ago
Richard Fuchs
9b6ddd46b9
MT#9763 add device_id column for pushd
11 years ago
Andreas Granig
2188e1bb08
MT#10199 Fix triggers for subscriber profile pref.
...
Change-Id: Id4bb50f69070ef2e91744b6fad3145507b7f39e2
11 years ago
Andreas Granig
a8b22502e3
MT#10199 Add triggers for subscriber profile pref.
...
Change-Id: Ide255d33879528dd3d36891fb44af0fc9ff69541
11 years ago
Andreas Granig
d030a61d5b
MT#10199 Add subscriber profile preferences.
...
Change-Id: I165faf42ec5d48f8df8d685b9a727585765ed0b8
11 years ago
Irina Peshinskaya
71e1006bb4
MT#9177 No linksys redirect
...
Change-Id: I88e8b454a92996f58f3e8cdc553f02c7a2bccd41
11 years ago
Andrew Pogrebennyk
96fa869576
MT#10029 add preference outbound_to_user
11 years ago
Kirill Solomko
27d06994a2
MT#8645 - add billing_profiles columns status, create_timestamp,
...
modify_timestamp, terminate_timestamp
11 years ago
Andrew Pogrebennyk
62901ad3df
MT#10025 migrate force_strict_number_match to "extended_dialing_mode"
11 years ago
Irina Peshinskaya
3a5fdb77b7
MT#9177 Add custom provisionin uri
...
Change-Id: I809691bacb8cc337c9fcf70e30a1443eea9f46b2
11 years ago
Andreas Granig
f65e3aee79
MT#9177 Remove duplicate file.
...
Change-Id: I9f826725d400a280b114a82ce4d0b5890deea3a6
11 years ago
Andreas Granig
576ed435d4
MT#9177 More fixes.
...
Change-Id: I6be6892434bf9ec93feac35537921a34a1f10990
11 years ago
Andreas Granig
942dcd05c9
MT#9177 Fix stray key on non-existent column
...
Change-Id: Ie820ea54c2c096340ffb648aea14141b289464de
11 years ago
Irina Peshinskaya
82ed0d71a1
MT#9177 Fix device vendor credentials table creation.
11 years ago
Andreas Granig
6c51a53b57
MT#9177 Rework autoprov vendor credentials.
...
Hook it up to a device model.
Change-Id: Id89d6b639bbd16b486a3b33f02de5c02707e77e3
11 years ago
Irina Peshinskaya
26bfba0d69
MT#9177 Remove DB version with searated cisco sync fields
11 years ago
Irina Peshinskaya
a6e40411f0
MT#9177 Rename scripts to proper numbers.
11 years ago
Irina Peshinskaya
3cac4cb07d
MT#9177 Add potentially yealink. Add storage for credentials.
11 years ago
Irina Peshinskaya
b91916fd07
MT#9177 Restore separated table schema too.
11 years ago
Irina Peshinskaya
58515ef31c
MT#9177 Centralized sync preferences table
11 years ago
Andrew Pogrebennyk
50a6588e8d
MT#9277 voice prompts list for the playbalance app
...
Change-Id: I8fec916657bee35ecf6d3f090c15b1b65ef14be8
11 years ago
Andrew Pogrebennyk
5a58058dec
MT#9277 voice prompts list for the voucher app
...
Change-Id: Ie8a8de0df5b690a0e1928e5e3745efcb70deac71
11 years ago
Andrew Pogrebennyk
9bfb7ff459
MT#9565 move new columns on CDR to separate file
...
Those *are* replicated, so having them in 15108_not_replicated didn't work.
Change-Id: I92bdda92e4daaec57bb8d0a35e82808f2a7552dd
11 years ago
Andrew Pogrebennyk
e0ad744615
MT#9565 rename to 15108 because 15106 was already taken.
...
Also fix the typo that caused:
Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/15106_not_
replicated.up: ERROR 1060 (42S21) at line 25: Duplicate column name 'src_leg'
Change-Id: Icd3690c9e996134e9aa0d137cf0ed4c37a710f7a
11 years ago
Andreas Granig
30a67a396d
MT#9565 Increase src/dst-leg acc columns
...
Change-Id: Iaeb1084d2b9ec6bfab44b2785010bcc2e0056627
11 years ago
Andreas Granig
79a6e540a1
MT#9565 Introduce gpp0-gpp9 and change cdr schema.
...
Change-Id: I18ea8356e06c45741dfabd2dc19e21fe728d4bd8
11 years ago
Irina Peshinskaya
21eafdeaf1
MT#9431 Add proper enum values for cloud_pbx_hunt_policy preferences.
11 years ago
Andreas Granig
016b4d5668
MT#9277 Add voucher schema.
11 years ago