* the column is needed to separate the date per site,
when multi site is enabled, as well as to solve possible
replication issues when mediators on each site concurrently write
into the table concurrently.
Change-Id: Iba46ac1bcb7d635fade3896f6e2b04b3396058e8
For each possible storage location, adds a bool flag to indicate whether
the media file is expected to be there.
For S3 and GCS, additionally add a field to store the URI to access the
media.
Change-Id: I7ad44275b8ffcfc0202968fcf9ad4cd883b07228
At the same time the 'conference_pin' preference has been
exposed to the profile preferences setting prof_pref = 1.
Both the changes are needed to be able to configure and
use them in the profile preference and tune what has to
be shown in the CSC panel.
Change-Id: I9f1c151100488b55f55250da08f653feb0e885f9
* all id AUTO INCREMENT fields in:
- accounting.cdr* tables (except the dictionary tables)
- acounting.acc* tables
- accounting.events tables
- cdr and events related reference fields
that are of int(10)/int(11) are converted to bigint(20).
that is to overcome the id auto increment overflow issue.
* SQL_MODE=STRICT_ALL_TABLES is used to prevent potential data loss
if the value cannot be safely converted (mostly needed in the .down
script).
Change-Id: I37ee0ea7160582ffae71fb4fc59df4148e95b02c
Added two new preferences needed for the new lnp local_qor type.
connect_on_ported: In case of successful lockup in the lnp table
for a call to non-local ported number, send the outgoing call to
the ported number.
ported_n1_to_ruri: If the caller subscriber is ported and the CLI
ported number (N2) matches the allowed CLIs, substitute the CLI
with the original number (N1)
At the same time, all the preferences related to the number
portability have been migrated into the new 'Number Portability'
group, for an easy finding.
Change-Id: I5889997a260e52c5c661f49624d984776ab3b384
Introduce new boolean preference to enable rtpengine flag
'allow-asymmetric-codecs' which accepts mismatched RTP payload
type numbers between SDP offer and answer.
Available at domain, subscriber, and peer levels.
Change-Id: I7a945fd3edcb0fe9cd6c797a0d19110264f99691
* Original (Forwarding) called user / Forwarder's NPN > original/npn
* Original (Forwarding) called user / Forwarder's UPN > original/upn
Change-Id: I0f42e3f8e78d00ca6facdef42d8057e208a1dfeb
* with 15770 and 15771 introducing the subscriber 'reseller_id'
preference, the related values for existing subscribers were
synced to kamailio.usr_preferences but not for
provisioning.voip_usr_preferences. this script inserts missing
'reseller_id' preference values into provisioning.voip_usr_preferences
Change-Id: I276811f1798710be4dbc0fce8c5951c7a1a3b382
* site_id contains site id the peering server belongs to,
can be NULL, in which case it's considered global (default state)
Change-Id: I8f6757e809cfc0a705b92577cf396574f0e9cb7f
* increase keys size from 20 to 128 to avoid truncated values
leading to duplicate entries and triggering index violation.
Change-Id: I8325bebb43fbce0b7c1bbf3698ffbd82159a20b7
* this fix addresses voip_peer_preferences default values
restoration in 15797 and it from now on only restores missing
default values for preferences that do not have peer_pref
with non default value NULL, so that scenarios where a
preference does not exists in voip_peer_preference because
it was manually selected by the customer with the value NULL
so it does not exists in voip_peer_preferences for that reason.
Change-Id: I83ee3294cab896679575187066a3960818dc2f77
Update the log_debug preference from boolean version to enum with
three log levels : NOTICE, INFO and DEBUG.
Update the attribute name to call_log_level.
Change-Id: Iab2edbaec82702d74859a687cb814f5c71c68d3f
By default, Prosody automatically handles table management.
As a result, executing the down script will fail because the index
has already been created by Prosody.
Adding IF NOT EXISTS prevents errors when the index already exists.
Change-Id: Ie9289ec5381fd1082047e5c9a762e7a31cf1c55c
In some cases, the prosody.prosody table contains duplicated entries.
This causes the 15841.up migration script to fail when creating the
new index.
To prevent this, add a step before dropping/creating the index to
remove all duplicate rows from the table.
Change-Id: I912dd8484231689d5b1f3dc5087bb69a96c496eb
Added a downscript for 15418/15780 upscript so in the case a downgrade
is executed, it will bring the schema back to pre-trixie situation.
Change-Id: Ib7aff58fe101318a80628a065a983d66546390b3
Move the 'log_debug' preference in the 'Internals' group.
Hide the 'log_debug' preference on domain and profile level,
Withdraw the usage of this preference on subscriber and customer level.
Change-Id: Id62962aa9b69d330ecaf43f78292e4934f4d6e1f
Add new 'log_debug' preference in voip_preferences for Cloud PBX,
allowing scoped SIP debug logging to be enabled at subscriber,
domain or peer level. Preference is exposed to subscribers,
default is disabled.
Change-Id: Ic55bdc937a9804fe266cb2072b786429af2a1828
The upscript 15418.up was created in 2018 and recently it was adapted
for debian/trixie. In turn, this will cause warnings in ngcp-status as
ngcp-mysql-compare-dbs script shows inconsistencies between the json
file and the db itself.
Original change:
719fd2750b
Adaptations:
57b924cce039e6d65add374f456ffb
To fix these inconsistencies, add a new upscript with the exact same
details as in 15418.up including the latest adaptations and a 'DROP
PROCEDURE IF EXISTS.
Change-Id: I9a3d2373954326b2f6786dc8c5c27fc58cb73c44
The new column store a value 0 or 1 to define wether the
ncos is applied when the time_set matches or not.
Change-Id: I65a8085afc61f0607fc90521015a4ceef11adc7b
The new column allows to store the label to show on the
deskphone's displays for the line types 'speeddial', 'forward' and
'transfer'.
Change-Id: I1323a4ac941b9ed15aa0bbd4ed59f387b8349b12
* add column ngcp.db_schema.site_id that is for multi site environments
and defaults to 1.
* the column is relied upon by ngcp-update-db-schema, mainly
to apply not_replicated scripts on sites with the different
site_id but same node name.
* site_id is only inserted for db nodes and otherwise left as NULL
* site_id=NULL means that the revisions are also meant for for both
sites (for ngcp-upgrade scenarios)
* ngcp-update-db-schema improvements:
- add site_id support
- config.node_roles key is now stored as-is and values
are converted as following:
* "yes"/"no" -> boolean True/False
* true/false -> boolean True/False
* else -> string
- check_release_column_exists() is reworked to
check_column_exists(column_name: str)
- fix except cause in main() to return error with the
stack trace as RuntimeError, instead of Exception
(as the latter returned only the error value).
Change-Id: I7c92b37db6562fa39f90a748fc567b100a8d9334
COLR = 'Connected line identification restriction'.
If set to true, the CLI is not displayed to the repmote
party on incoming calls.
Change-Id: I6e41534d8bc5d222f1d19dff1b809869ee9d951d
Add "ON UPDATE CASCADE ON DELETE CASCADE" to the ALTER statement
to fix issue with other down scripts failing to delete the
corresponding voip_preferences_enum entries due to this missing
parameter in 15787.down script.
Change-Id: I6bb91e9c0ea5f03c774ff826e8a29c0f5635eaaf
The new handle contains the announcement that will be played
to the calleer when the callee has the preference 'dnd' activated.
Change-Id: Id3201e9d2ae6ecb56fd858558d0a20d790306033
The down script tries removing some triggers from the wrong database,
add "USE provisioning" to fix it.
Change-Id: I407fde403aa5ee0a87282db0cf53d57d11155422
* shared entries now correctly mutually exclude entries with the same
numbers that are defined by subscribers (goes by precedence).
* add own field to contract and subscriber phonebook views to
identify if the entry was created by the subscriber/contract_id
or inherited.
Change-Id: I5494974b3c16026bb718f9a499e4b25e6b56e4ad
2-Factor-Authentication (2FA) for subscribers based on
voip_preferences only, to support lazy OTP secret initialisation
by application logic.
Change-Id: I265fe1c6e5b75d96aa77b6169ac7508bbf65fbb3
- use coalesce(unix_timestamp(if(x)),if(x)) rather than
coalesce(unix_timestamp(if(x)),0)
- fix from_unixtime(0) also in transform_billing_mappings()
in 15418.up
Change-Id: I55a54deb9e6e3412650e56cefed87a6637a2c0d1
* _effective_start date is now correctly becomes 0 if undefined
to address the general from_unixtime() change in MariaDB 11.5
that requires a value.
* the fix is taken from:
e935ac42 2025-04-29 MT#62676 fixes for mariadb 10.8/debian trixie [Rene Krenn]
Change-Id: I01cf96af3095fbf6e3cb9def9ddeb6c1f1883929
base/8629.up introduced voip_preferences_enum with auto
named foreign key as
"FOREIGN KEY (preference_id) REFERENCES voip_preferences (id)"
which auto created a missing index as
`preference_id` (`preference_id`).
diff/15787.up re-created the foreign key as named
"ADD CONSTRAINT `pref_id_fk` FOREIGN KEY (`preference_id`) ... "
which normally should cause the auto created `preference_id` key
to be renamed to `pref_id_fk`.
but customers who had their database re-synced, had that index
turned from "auto created" to "permanent" and therefore, causing
diff/15787.up to keep the original index name as `preference_id`.
that in turn, caused ngcp-mysql-compare-dbs to report db inconsistencies
as the default schema/.sql files are built with `pref_id_fk`.
the current fix addresses the index issue by dropping it as either
`preference_id` or `pref_id_fk` and creating it as a named index
`pref_id_idx`, so that it wont be affected by the issue anymore.
Change-Id: I4c777902251f915a1b07e92744d78e81087d607c
* fix peering hosts weight update to be correctly performed
only for the same peering host (was for the whole peering group).
Change-Id: Iaca327b1d49f2e50f9aa258e72392ffafe271fd3
* recreate provisioning.voip_phost_*_trig triggers with the same
content to fix a possible discrepancy caused by
15783_not_replicated.up
Change-Id: Id184e50c94ba9f92eb4ba6d243457e0343353704
* triggers are removed from the not replicated script because
they create an issue if this script is applied on the other
node after 15791.up and 15797.up and revert the triggrs to
inintended state.
Change-Id: Iac830c24d0d51d693e6dbe76cea3766feebf7dd8
Added 2 new prefereences inside group "Cloud PBX"
to let the admin to control how many times the AA welcome message
must be played before overflowing in case of timeout or wrong key selection.
Change-Id: I19debd3dc06cd9234355a67ffdc8b5c9db42f61f
* make 15798 as "not_replicated" otherwise the "freeswitch"
database creation is not replicated to the other nodes during
upgrade because there are no my.cnf yet with
"replicate-wild-do-table=freeswitch.%"
* all CREATE statements in the .up script adjusted to be as
CREATE ... IF NOT EXISTS, as the not_replicated script will
be executed once more on the existing deployments.
Change-Id: Idf6c9e8a304639ecabab0a442273cba4b306a6e1
The newly implemented manual ban release needs extra fields to
return for the client.
* Add `last_banned_at` timestamp for admins and subscribers
* Add `last_banned_ip` varchar(45) for admins and subscribers
Change-Id: I691bf2f5c62180d6fb010c3e844a79384f81b3d3
* v_contract_phonebook - returns shared+contract+reseller phonebook
entries, where same numbers are merged into contract > shared > reseller
entries
* v_contract_shared_phonebook - returns shared+contract phonebook
entries, where same numbers are merged into contract > shared entries
* v_contract_reseller_phonebook - returns contract+reseller phonebook
entries, where same numbers are merged into contract > reseller entries
* v_subscriber_phonebook - returns subscriber+contract+reseller phonebook
entries, where same numbers are merged into
subscriber > contract > reselelr entries
* v_subscriber_contract_phonebook - returns subscriber+contract phonebook
entries, where same numbers are merged into
subscriber > contract entries
* v_subscriber_reseller_phonebook - returns subscriber+reseller phonebook
entries, where same numbers are merged into
subscriber > reseller entries
* shared entries of subscribers within the same customer are considered
"customer" entries and shown in v_subscriber_phonebook or
v_subscriber_contract_phonebook
Change-Id: Id66502fadea93be05e3dab7f386e92068fcde21d
Kirill Solomko
Richard Fuchs
Marco Capetta
Bit-Savva Mikhail
Kéryl Thiry
Rene Krenn
Jose Su
Fabricio Santolin da Silva
Victor Seva
Alessio Garzi
Bertold Vincze