db-schema

Author SHA1 Message Date

Author	SHA1	Message	Date
Kirill Solomko	d08a0f94db	TT#54914 fix provisoniong.voip_peer_rules triggers ip_addr join * provisioning.voip_peer_rules triggers use internally a join by IP address to insert/update entries in kamailio.lcr_rule_target. in cases where there are 2 hosts per peering group with the same IP address, the triggers fail because they select duplicate peer hosts. to address that the "lcr_rule_target join" in the relevant triggers is adjusted to join the hosts tables by gw_name isntead, since gw_name is guaranteed unique per peer group (controlled by a unique key) Change-Id: I36669efc22bb62ad34c57aac4d978435dbb26f0c (cherry picked from commit `b6d98d8464`)	7 years ago

Kirill Solomko

TT#54914 fix provisoniong.voip_peer_rules triggers ip_addr join

* provisioning.voip_peer_rules triggers use internally
      a join by IP address to insert/update entries in
      kamailio.lcr_rule_target. in cases where there are 2 hosts
      per peering group with the same IP address, the triggers
      fail because they select duplicate peer hosts. to address
      that the "lcr_rule_target join" in the relevant triggers
      is adjusted to join the hosts tables by gw_name isntead,
      since gw_name is guaranteed unique per peer group
      (controlled by a unique key)

Change-Id: I36669efc22bb62ad34c57aac4d978435dbb26f0c
(cherry picked from commit b6d98d8464)

1 Commits (mr5.5.13)