APPLY-TRANSFORMATION: '+550'

Angelo Delphini (Professor Delphini)

unread,

Oct 8, 2025, 3:24:54 PM10/8/25

to ivozprovider-users

Good afternoon, could someone please give me some insight into what might be happening here? This started after the platform update, and I’d especially like to know how I should proceed to fix it. Thank you!

Proxy Trunks: [15331]: NOTICE: [c3e8f2ed] APPLY-TRANSFORMATION: '+550' -> '0' (applied rule: 'From e164 to national').

receive PABX: To: <sip:3403...@pbx.ivozprovider.tel;user=phone>

Angelo Delphini (Professor Delphini)

unread,

Oct 8, 2025, 4:47:09 PM10/8/25

to ivozprovider-users

 dpkg-reconfigure ivozprovider                                                                                                                                                                    
ERROR 1062 (23000) at line 1: Duplicate entry '201.XXX.XXX.XX3' for key 'ProxyTrunks.proxyTrunk_ip'       

Kaian

unread,

Oct 10, 2025, 2:04:51 AM10/10/25

to ivozprovider-users

Hi,

These are two different logs that doesn't seem to be related.

> Proxy Trunks: [15331]: NOTICE: [c3e8f2ed] APPLY-TRANSFORMATION: '+550' -> '0' (applied rule: 'From e164 to national').

This looks like an outbound call that is using a Numeric transformation (Brazil?) and is converting from E.164 to Brazil National format by removing the Country Code prefix (+55).

Internally, ivozprovider uses E.164 bewteen proxies and application servers, and uses Numeric Transformations to convert from E.164 to User/Carrier/Provider format and vice versa.

NOTE: It's quite probably Braizilian numeric transformation is wrong in base configuration, we've done some guesses to create a Numeric transformation for each country but in most cases there are wrong :-\

https://irontec.github.io/ivozprovider/en/tempest/administration_portal/brand/settings/numeric_transformations.html

> ERROR 1062 (23000) at line 1: Duplicate entry '201.XXX.XXX.XX3' for key 'ProxyTrunks.proxyTrunk_ip'

This is caused by some code in ivozprovider package postinstall script. It's assuming you have only a single ProxyTrunks address, and it looks like you have multiple addresses.

We rearely encounter this problems because ivozprovider package is only used in standalone installs (and we don't have many of those)

https://github.com/irontec/ivozprovider/blob/main/debian/ivozprovider.postinst#L86

This could be fixed by adding a WHERE id = 1 in both queries, because these entries with id = 1 can not be deleted.

I've created an issue for this: https://github.com/irontec/ivozprovider/issues/3028

Best Regards,

Angelo Delphini (Professor Delphini)

unread,

Oct 10, 2025, 11:52:54 AM10/10/25

to ivozprovider-users

Kaian, thank you very much for the report! Regarding this point: Proxy Trunks: [15331]: NOTICE: [c3e8f2ed] APPLY-TRANSFORMATION: '+550' -> '0' (applied rule: 'From e164 to national'). I was required to redo the REGEX in the database to meet the needs of Brazil. Should you wish, I can provide the updated table details in this report.

Regarding the point about the error ERROR 1062 (23000) at line 1: Duplicate entry '201.XXX.XXX.XX3' for key 'ProxyTrunks.proxyTrunk_ip', I will take action according to your guidance (the material provided) and report back. Thank you once again!

Kaian

unread,

Oct 14, 2025, 5:35:37 AM10/14/25

to ivozprovider-users

Hi!

> Should you wish, I can provide the updated table details in this report.

Sure, we can update existing rules with the correct ones matching Brazil.

> Regarding the point about the error ERROR 1062 (23000) at line 1: Duplicate entry ....