[Spce-user] adding permanent registrations/contacts fails following DB restore

[Gavin Sweet]

Thanks Jon - even advice on a manual workaround would be great as otherwise it looks like we have to do a total re-build of our lab system.

Also, if anyone can tell me why we cant cut the data for kamailio and provisioning from a production system dump and restore in lab/dev system, or how to do this, I would love to know.
We tried to update all the IP addressing tables etc, but doesn’t work???

Cheers
Gavin


> -----Original Message-----
> From: Jon Bonilla (Manwe) [mailto:jbonilla at sipwise.com]
> Sent: 02 May 2013 11:25
> To: spce-user at lists.sipwise.com
> Cc: gavin.sweet at skyracktelecom.com
> Subject: Re: [Spce-user] adding permanent registrations/contacts fails
> following DB restore
> 
> El Mon, 22 Apr 2013 10:18:18 +0100
> "Gavin Sweet" <gavin.sweet at skyracktelecom.com> escribió:
> 
> > -Nudge-
> >
> > Anyone got any prior experience with this kind of problem?
> >
> >
> >
> > Alternatively, if we chose to "start again" is there a simple way to
> > reset all the databases form scratch?
> >
> > Before the problem reported below, we did try a "ngcp-reset-db" but
> it
> > didn't seem to work.
> >
> > The manual says this, but we still had old data after running this.
> >
> > "To reset database to its original state you can use the script
> > provided by
> > CE: * Execute ngcp-reset-db. It will assign new unique password for
> > the NGCP services and restart all services. IMPORTANT: All existing
> > data will be wiped out without possibility of restoring."
> >
> >
> 
> Hi Gavin
> 
> Yes, I think ngcp-reset-db is not working since 2.7. I need to check it
> as I think we already have a open issue regarding it