[Spce-user] A peering host with this IP address already exists

[Andrew Pogrebennyk]

On 02/12/2015 12:38 PM, Mykola Zaika wrote:
> I am running version mr2.8. I`ll try the new version.
> 
> Thanks.

well if you are brave try 2.8 with this statement:

USE provisioning;

-- remove the unique part of the key
ALTER TABLE kamailio.lcr_gw DROP KEY lcr_id_ip_addr_idx;
ALTER TABLE kamailio.lcr_gw ADD KEY lcr_id_ip_addr_idx(lcr_id, ip_addr);

That might do the trick. But if rate-o-mat fails or something like that
you may execute rollback:
ALTER TABLE kamailio.lcr_gw DROP KEY lcr_id_ip_addr_idx;
ALTER TABLE kamailio.lcr_gw ADD UNIQUE KEY lcr_id_ip_addr_idx(lcr_id,
ip_addr);

Andrew