[Spce-user] SIP Error 500 Internal Error

[Clint Wiley]

Hi,

Can you:

SHOW GRANTS FOR 'sipwise'@'localhost';

You probably need to grant privileges to the user 'sipwise' 

Clint

> On Mar 1, 2015, at 12:48 PM, Tabi Tabe Tabi <tabi.tabe at gmail.com> wrote:
> 
> Here is the screen dump.
> 
> 
> 
> On Sun, Mar 1, 2015 at 7:46 PM, Tabi Tabe Tabi <tabi.tabe at gmail.com> wrote:
> Hi mates,
> 
> We build a new SPCE server with 8GB RAM and enough HDD. Clean install and MySql failed to start during bootup. Same as the old server. SPCE 3.7.1
> 
> Previously it straight from build to processing live traffic took less than an hour. We have compared all the MySQL version and running V5.5.40.
> 
> What have we missed?
> 
> Your feedback is much apprecaited.
> 
> Regards,
> 
> Tabi
> 
> On Sun, Mar 1, 2015 at 1:13 PM, Tabi Tabe <tabi.tabe at gmail.com> wrote:
> We noticed now that after restarting the server, MySQL failed to start.
> 
> Tried several times still won't start.
> 
> Tabi
> From: Daniel Grotti
> Sent: ‎3/‎1/‎2015 11:37
> To: Tabi Tabe Tabi
> Cc: William Fulton; 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
> >
> 
> 
> 
> -- 
> ...Tabi
> 
> 
> 
> 
> -- 
> ...Tabi
> 
> <MySQL error.PNG>_______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user