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

Fri Aug 29 18:09:45 EDT 2014

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
> 