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

[Tabi Tabe Tabi]

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> 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>
> 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
>
>


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