[Spce-user] API: subscribers/?page=1&rows=100

[Martin Stix]

Hi!

First here's the output of api.log, first attempt with rows=1 was succesful, second one with rows=100 throws that error:

Nov 17 13:16:49 spce ngcp-panel: INFO: IP=185.52.56.222 CALLED=API[GET]/api/subscribers/ TX=13A77298E5B489C0 USER=administrator DATA={ 'page' => '1', 'rows' => '100'} MSG="" LOG=""
Nov 17 13:16:49 spce ngcp-panel: ERROR: IP=185.52.56.222 CALLED=API[GET 200]/api/subscribers/ TX=13A77298E5B489C0 USER=administrator DATA={ 'page' => '1', 'rows' => '100'} MSG="" LOG="Caught exception in NGCP::Panel::Controller::API::Subscribers->GET "Can't call method "get_inflated_columns" on an undefined value at /usr/share/perl5/NGCP/Panel/Role/API/Subscribers.pm line 32.""
Nov 17 13:16:49 spce ngcp-panel: INFO: IP=185.52.56.222 CALLED=API[GET 500]/api/subscribers/ TX=13A77298F1E8C670 USER=administrator DATA={ 'page' => '1', 'rows' => '100'} MSG="" LOG="{"message":"Internal Server Error","code":"500"}"

thanks

mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at
www.pluteus.at
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

-----Ursprüngliche Nachricht-----
Von: Alex Lutay [mailto:alutay at sipwise.com] 
Gesendet: Montag, 17. November 2014 13:11
An: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] API: subscribers/?page=1&rows=100

Dear Martin,

On 17/11/14 10:08, Martin Stix wrote:
> This ouputs a lot, what do you exactly need?

The picture you attached says about internal server error only.
It doesn't provide the reason of the error itself.

I have tried to reproduce your problem on mr3.5.1 Vagrant image:

> https://www.sipwise.com/doc/mr3.5.1/spce/ar01s04.html#_vagrant_box_for
> _virtualbox

> vagrant init spce-mr3.5.1 
> http://deb.sipwise.com/spce/images/sip_provider_CE_mr3.5.1_vagrant.box
> vagrant up
> firefox https://X.X.X.X:1443/ # (logged in as 
> administrator/administrator to Admin interface) firefox 
> https://X.X.X.X:1443/api/subscribers/?page=1&row=100  # (open the test 
> URL you provided)

I have got the proper application/hal+json reply from server.

I suppose that something wrong with your database, we need to find out what exactly.

We need the ngcp-panel REST API error message (which usually is "exception"). That is why Irina asked you to grep log files.
It should be also in /var/log/ngcp/api.log

Lets try another way, please execute:
> sudo tail -n0 -f /var/log/ngcp/* | grep -i "subscribers"
then repeat your test (open /api/subscribers/?page=1&row=100) and share the output you will get.

Thank you!

--
Alexander Lutay
_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
https://lists.sipwise.com/listinfo/spce-user
-------------- next part --------------
A non-text attachment was scrubbed...
Name: api.log
Type: application/octet-stream
Size: 2859 bytes
Desc: api.log
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20141117/a0340dd3/attachment-0001.log>