[Spce-user] 500 Internal Server Error after uploading a .wave file

[Hohl Matthias]

Hello,

 

this is the result:

 

MariaDB [(none)]> select `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as cnt from kamailio.voicemail_spool group by dir having cnt>1;

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

| dir                                                                                | mailboxcontext | mailboxuser                          | msgnum | origtime   | cnt |

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

| /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/INBOX   | default        | 15d95e8d-38a9-4e1f-9504-f3808d265081 |      0 | 1527060205 |  17 |

| /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/Old     | default        | 15d95e8d-38a9-4e1f-9504-f3808d265081 |      0 | 1522754696 |   3 |

| /var/spool/asterisk/voicemail/default/522f1f30-5317-46ee-a4ef-0f3b8fbbe52f/INBOX   | default        | 522f1f30-5317-46ee-a4ef-0f3b8fbbe52f |      0 | 1515516247 |  28 |

| /var/spool/asterisk/voicemail/default/56850236-a35d-40ec-9448-276004b63da2/INBOX   | default        | 56850236-a35d-40ec-9448-276004b63da2 |      0 | 1478708840 |  11 |

| /var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail | default        | e893a9ab-28a3-48a0-8d5a-faebb297d286 |     -1 | 1539193407 |   2 |

+------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+

5 rows in set (0.02 sec)

 

MariaDB [(none)]>

 

Von: Irina Peshinskaya <ipeshinskaya at sipwise.com> 
Gesendet: Sonntag, 4. November 2018 10:29
An: Hohl Matthias <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com
Betreff: Re: AW: [Spce-user] 500 Internal Server Error after uploading a .wave file

 

Dear Matthias,

Could you please check if you have duplicates in voicemal_spool table:

select `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as cnt from kamailio.voicemail_spool group by dir having cnt>1;

Thank you in advance.

Best regards,
Irina Peshinskaya



On 2018-10-16 10:08, Hohl Matthias wrote:

Hello,

 

i sent it to you private :)

thank you for your help.

 

 

Von: Irina Peshinskaya  <mailto:ipeshinskaya at sipwise.com> <ipeshinskaya at sipwise.com> 
Gesendet: Montag, 15. Oktober 2018 11:21
An: Hohl Matthias  <mailto:matthias.hohl at telematica.at> <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> 
Betreff: Re: [Spce-user] 500 Internal Server Error after uploading a .wave file

 

Dear Matthias,

Could you please send me your log files from dates, related to the situation
"The upload started but failed and next the customer saw a 500 Internal Server Error screen"

Necessary log files you can find as:

/var/log/ngcp/old/panel.log-2018*.gz
/var/log/ngcp/old/panel-debug.log-2018*.gz
/var/log/ngcp/old/api.log-2018*.gz

Thank you in advance.

Best regards,
Irina Peshinskaya




On 2018-10-11 11:06, Hohl Matthias wrote:

Hello,

 

Server: mr5.5.5

 

One of our customers wanted to upload a .wave file for the voicebox over his customer care panel.

The upload started but failed and next the customer saw a 500 Internal Server Error screen.

The customer report this issue to us and we also get now a 500 Internal Server Error if we want to open the subscriber preferences page.

It is the only subscriber witch has this Error by accessing the prefences page. All other once work fine.

In the panel.log and panel-debug.log I see this entries:

 

1.       Oct 11 10:57:24 spce ngcp-panel: ERROR: fatal error, id=155C821F96E17CC0, timestamp=2018-10-11T08:57:24.840824000Z, error=Caught exception in NGCP::Panel::Controller::Subscriber->preferences "Not a HASH reference at /usr/share/perl5/NGCP/Panel/Controller/Subscriber.pm line 651."

2.        

3.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: *** Root::auto grant access for authenticated user

4.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: NGCP::Panel::Controller::Subscriber::auto

5.       Oct 11 10:57:24 spce ngcp-panel: DEBUG: catchup contract 324 contract_balances (now = 2018-10-11 10:57:24)

 

Anybody an idea what is going on there and how to fix it?

 

Mit freundlichen Grüßen,

Matthias Hohl







_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com> 
https://lists.sipwise.com/listinfo/spce-user

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181104/42815f9b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5532 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181104/42815f9b/attachment-0001.p7s>