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

[Tabi Tabe Tabi]

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> 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> 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/
>>> 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
>> Email: alutay at sipwise.com
>> Website: http://www.sipwise.com
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
>>
>
>
>
> --
> ...Tabi
>
>


-- 
...Tabi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140829/00928f4b/attachment-0001.html>