[Spce-user] SPCE 3.4.1 not showing call history in Web portal

Tabi Tabe Tabi tabi.tabe at gmail.com
Wed Sep 3 16:36:53 EDT 2014


HI Andreas,


I have done both checks. I can connect to MySQL and even checked the CDR
table and it is empty. Also no OOM message. Not sure what could be the
cause.

Regards,

Tabi


On Sat, Aug 30, 2014 at 12:09 AM, Andreas Granig <agranig at sipwise.com>
wrote:

> Hi,
>
> You need to check if mysqld is running and if you can connect to it via
> command line.
>
> Usual suspects for such issues are running out of memory (check dmesg
> for OOM messages) and running out of disk space.
>
> Andreas
>
> On 08/29/2014 07:04 PM, Tabi Tabe Tabi wrote:
> > Please ignore the email on the .tt template. Was not awake :-)
> >
> > Problem still with database connection though. Any ideas?
> >
> > Regards,
> >
> > Tabi
> >
> >
> > On Fri, Aug 29, 2014 at 6:39 PM, Tabi Tabe Tabi <tabi.tabe at gmail.com
> > <mailto:tabi.tabe at gmail.com>> wrote:
> >
> >     Hi Alex,
> >
> >     An interesting observation. I checked Kamailio.log and found this
> >     errors:
> >
> >     Aug 29 18:23:56 sipbc-2 proxy[16661]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:23:56 sipbc-2 proxy[16661]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:23:56 sipbc-2 proxy[16661]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:25:58 sipbc-2 proxy[16665]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:25:58 sipbc-2 proxy[16665]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:25:58 sipbc-2 proxy[16665]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:25:59 sipbc-2 proxy[16671]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:25:59 sipbc-2 proxy[16671]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:25:59 sipbc-2 proxy[16671]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:26:02 sipbc-2 proxy[16667]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:26:02 sipbc-2 proxy[16667]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:26:02 sipbc-2 proxy[16667]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:27:22 sipbc-2 proxy[16661]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:27:22 sipbc-2 proxy[16661]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:27:22 sipbc-2 proxy[16661]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:27:23 sipbc-2 proxy[16665]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:27:23 sipbc-2 proxy[16665]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:27:23 sipbc-2 proxy[16665]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >     Aug 29 18:27:24 sipbc-2 proxy[16667]: ERROR: db_mysql
> >     [km_dbase.c:122]: db_mysql_submit_query(): driver error on query:
> >     Lost connection to MySQL server during query
> >     Aug 29 18:27:24 sipbc-2 proxy[16667]: ERROR: <core>
> >     [db_query.c:235]: db_do_insert_cmd(): error while submitting query
> >     Aug 29 18:27:24 sipbc-2 proxy[16667]: ERROR: acc [acc.c:509]:
> >     acc_db_request(): failed to insert into database
> >
> >
> >
> >     Also checked the CDR table in MySQL and found zero record. Can't
> >     connect MySQL. MySQL is running. What parameters should I check? All
> >     serv
> >
> >     Regards,
> >
> >     Tabi
> >
> >
> >     On Fri, Aug 29, 2014 at 6:15 PM, Tabi Tabe Tabi <tabi.tabe at gmail.com
> >     <mailto:tabi.tabe at gmail.com>> wrote:
> >
> >         Will do. After updating the .tt file, do I need to run any
> >         command to update the system?
> >
> >         Regards,
> >
> >         Tabi
> >
> >
> >         On Fri, Aug 29, 2014 at 3:03 PM, Alex Lutay <alutay at sipwise.com
> >         <mailto:alutay at sipwise.com>> wrote:
> >
> >             Dear Tabi!
> >
> >
> >             On 28/08/14 14:11, Tabi Tabe Tabi wrote:
> >
> >                 I installed SPCE 3.4.1 and got is working fine. However
> >                 it does not show
> >                 call history under call distribution or subscriber menu.
> >                 Any idea what
> >                 could be the cause?
> >
> >
> >             Can you try this fix:
> >
> >
> https://github.com/sipwise/__ngcp-panel/commit/__cf93f0bf63dca1b66775feb5c7622a__f0c4d4cae6
> >                 <
> https://github.com/sipwise/ngcp-panel/commit/cf93f0bf63dca1b66775feb5c7622af0c4d4cae6
> >
> >
> >             if it helps you we will include it in next build mr3.4.2.
> >             Thank you!
> >
> >             --
> >             Alexander Lutay
> >             Head of Quality Assurance
> >             Sipwise GmbH, Campus 21/Europaring F15
> >             AT-2345 Brunn am Gebirge
> >
> >             Office: +43(0)13012036 <tel:%2B43%280%2913012036>
> >             Email: alutay at sipwise.com <mailto:alutay at sipwise.com>
> >             Website: http://www.sipwise.com
> >             _________________________________________________
> >             Spce-user mailing list
> >             Spce-user at lists.sipwise.com <mailto:
> Spce-user at lists.sipwise.com>
> >             https://lists.sipwise.com/__listinfo/spce-user
> >             <https://lists.sipwise.com/listinfo/spce-user>
> >
> >
> >
> >
> >         --
> >         ...Tabi
> >
> >
> >
> >
> >     --
> >     ...Tabi
> >
> >
> >
> >
> > --
> > ...Tabi
> >
> >
> >
> > _______________________________________________
> > Spce-user mailing list
> > Spce-user at lists.sipwise.com
> > https://lists.sipwise.com/listinfo/spce-user
> >
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>



-- 
...Tabi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140903/24f37f90/attachment.html>


More information about the Spce-user mailing list