[Spce-user] SIP Error 500 Internal Error

[Tabi Tabe]

Hi, 

The only error we see is MySQL. Cannot connect to database=provisioning at localhost:3306 local MySQL server through socket /var/run/mysqld/myqsld.sock (2).


We are running the latest version of SPCE 3.7.1

Tabi

-----Original Message-----
From: "Daniel Grotti" <dgrotti at sipwise.com>
Sent: ‎3/‎1/‎2015 11:37
To: "Tabi Tabe Tabi" <tabi.tabe at gmail.com>
Cc: "William Fulton" <wfulton at thirdhatch.com>; "spce-user at lists.sipwise.com" <spce-user at lists.sipwise.com>
Subject: Re: [Spce-user] SIP Error 500 Internal Error

Tabi,
Kamailio-proxy.log and lb log would help.

Daniel
On 1 Mar 2015 08:39, Tabi Tabe Tabi <tabi.tabe at gmail.com> wrote:
>
> Got enough resources. 50% of memory still available and only 10% of disk used.
>
> On Sun, Mar 1, 2015 at 8:45 AM, William Fulton <wfulton at thirdhatch.com> wrote:
>>
>> Yeah, I would check resources.
>>
>>  
>>
>> From: Tabi Tabe Tabi [mailto:tabi.tabe at gmail.com] 
>> Sent: Saturday, February 28, 2015 10:33 PM
>>
>>
>> To: William Fulton
>> Cc: spce-user at lists.sipwise.com
>> Subject: Re: [Spce-user] SIP Error 500 Internal Error
>>
>>  
>>
>> I am checking memory utilization to see whether it could be running low and causing the MySql to fail on insert.
>>
>>  
>>
>> On Sun, Mar 1, 2015 at 8:05 AM, William Fulton <wfulton at thirdhatch.com> wrote:
>>
>> Are you running this on a VM?
>>
>>  
>>
>> From: Tabi Tabe Tabi [mailto:tabi.tabe at gmail.com] 
>> Sent: Saturday, February 28, 2015 9:58 PM
>> To: William Fulton
>> Cc: spce-user at lists.sipwise.com
>> Subject: Re: [Spce-user] SIP Error 500 Internal Error
>>
>>  
>>
>> Thanks William.
>>
>> I'd been tailing the Kamailio log file and using grep to show only for particular string.
>>
>>  
>>
>> I found database insert errors before SPCE drops the call.
>>
>> Mar  1 07:46:44 sipbc-2 proxy[4581]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query
>>
>>  
>>
>> Then the next call comes through and is successful.
>>
>> It looks like a MySQL error. The Service is running fine.
>>
>> Any ideas how to resolve this one?
>>
>> Much appreciated.
>>
>> Tabi
>>
>>  
>>
>> On Sun, Mar 1, 2015 at 4:06 AM, William Fulton <wfulton at thirdhatch.com> wrote:
>>
>> Tail the kamailio log when the calls are being rejected and see why:
>>
>>  
>>
>> tail -f /var/log/ngcp/kamailio-proxy.log
>>
>>  
>>
>> Best Regards,
>>
>> William
>>
>>  
>>
>> From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Tabi Tabe Tabi
>> Sent: Saturday, February 28, 2015 2:40 PM
>> To: spce-user at lists.sipwise.com
>> Subject: [Spce-user] SIP Error 500 Internal Error
>>
>>  
>>
>> Hi,
>>
>> Does anyone know what would cause SPCE to reject a call with error code 500 Internal error?
>>
>> So calls are dropped and some are processed.
>>
>> Thanks.
>>
>>
>> --
>>
>> ...Tabi
>>
>>  
>>
>>
>>
>>
>> --
>>
>> ...Tabi
>>
>>  
>>
>>
>>
>>
>> --
>>
>> ...Tabi
>>
>>  
>
>
>
>
> -- 
> ...Tabi
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150301/d927295a/attachment-0001.html>