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

Mon Apr 22 05:18:18 EDT 2013

-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."

Thanks again

Gavin

From: spce-user-bounces at lists.sipwise.com
[mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Gavin Sweet
Sent: 19 April 2013 14:33
To: spce-user at lists.sipwise.com
Subject: [Spce-user] adding permanent registrations/contacts fails following
DB restore

Hi all - 

We are suddenly unable to get device registrations to properly apply when
made through the GUI admin interface or through the SOAP API. Both methods
appear to return normally - the GUI reports that the registration has been
added, the API returns an Ok. But, in fact the registrations haven't been
added to the DB, and no changes are updated in the GUI. All other functions
(add subscribers, change preferences etc) all seem to still work properly
over the GUI and the SOAP API.

The only change that we can imagine could have caused this is that we have
restored the databases on the system concerned (our lab server) from one of
our production servers. 

Does this sound likely? Anyone know why or how to solve it? 

Restoring from production to lab is just part of the process to baseline
again after testing (we have recently started testing with the SOAP API).
The backup from which the restore was done was from production to lab server
. just mysqldump > db.sql on production server, then mysql <db.sql on target
lab server. The db's that we backed up and restored were kamailio, billing
and provisioning. When that didn't work we also included the ngcp DB. 

The only other change that has recently been made was to run the
ngcp-reset-db script at one point when the databases appeared to have failed
to restore correctly. (By the way, this did not seem to actually wipe out
all data in the way it is intended).

Looking in the oss.log and comparing between the working production server
and the not-working lab server I can see no differences for the same
function. In both cases, create_subscriber_registered_device is called and
then a POST to /subscriber/add_permanent_contact made - seeming to return
properly, but the records are simply not stored in the db, and so not
returned in the GUI.

Any help /suggestions / offers of counselling would be greatly appreciated.

Cheers

Gavin

Heres a full snippet from oss.log:

Apr 19 13:23:49 skt-salem03 provisioning:
Sipwise::Provisioning::_log_xmldata: create_subscriber_registered_device
called with: {'authentication' => {'password' => '***

*****','type' => 'admin','username' => 'administrator'},'parameters' =>
{'contact' => 'sip:a112 at 1.2.3.4','domain' => 'skyrack.net','username' =>
'a001001'}}

Apr 19 13:23:49 skt-salem03 provisioning:
Sipwise::Provisioning::handle_request: calling function
'create_subscriber_registered_device' for admin 'administrator'

Apr 19 13:23:49 skt-salem03 provisioning:
Sipwise::Provisioning::Config::new: using config file
"/etc/ngcp-ossbss/provisioning.conf"

Apr 19 13:23:49 skt-salem03 provisioning: Sipwise::Provisioning::new:
Sipwise::Provisioning::XMLDispatcher object initialized

Apr 19 13:23:49 skt-salem03 provisioning:
Sipwise::Provisioning::XMLDispatcher::dispatch: dispatching xmlrpc proxy
request to 10.239.110.182:8000/RPC2

Apr 19 13:23:54 skt-salem03 provisioning:
Sipwise::Provisioning::_log_xmldata: create_subscriber_registered_device
returned with: 1

Apr 19 13:23:54 skt-salem03 /usr/sbin/apache2: ***Provisioning::call_prov
calling 'billing::get_voip_account_subscriber_by_id'

Apr 19 13:23:54 skt-salem03 oss: 213.152.52.193 - - [19/Apr/2013:13:23:49
+0100] "POST /subscriber/add_permanent_contact HTTP/1.1" 302 818
"https://109.239.110.183:1443

/subscriber/detail?subscriber_id=18" "Mozilla/5.0 (Windows NT 6.2; WOW64;
rv:20.0) Gecko/20100101 Firefox/20.0"

Apr 19 13:23:54 skt-salem03 /usr/sbin/apache2: ***Provisioning::call_prov
calling 'voip::create_subscriber_registered_device'

Apr 19 13:23:54 skt-salem03 apache2: [info] Subsequent (No.6) HTTPS request
received for child 12 (server myserver:443)

  _____  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2904 / Virus Database: 3162/6250 - Release Date: 04/17/13

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130422/094ac8a0/attachment-0001.html>