Hallow, everyone! Got some problem with logging after migration.
Old:
Kernel
Linux(x86_64)-3.10.0-229.14.1.el7.x86_64
Elastix
elastix-4.0.0-1
FreePBX
freePBX-2.11.0-26
Asterisk
asterisk-11.25.0-0.el7.centos
New:
Kernel
Linux(x86_64)-3.10.0-1062.el7.x86_64
Issabel
issabel-4.0.0-1
IssablPBX
issabelPBX-2.11.0-48
Asterisk
asterisk16-16.16.1-1.el7
- Too much records in asterisccdrdb.cdr with fileld 'lastapp'=Queue
Elastix - only one record:
13.09.2023 18:48 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000cbc Local/100@from-queue-00000a89;1 Queue
issabel - number of records equal number of queue members:
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/100@from-queue-000005eb;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/101@from-queue-000005ec;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/102@from-queue-000005ed;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/103@from-queue-000005ee;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/104@from-queue-000005ef;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/105@from-queue-000005f0;1 Queue
2023-09-14 20:25:12.000 SAB: XXXXXXXXXXX <XXXXXXXXXXX> XXXXXXXXXXX 10 ext-queues SIP/BL_Static-00000720 Local/106@from-queue-000005f1;1 Queue
Resalt: too much records in cdr db table. How I can fix it?
In Unembedded IssabelPBX -> CDR Reports don't work reference to UniqueID in System Coloumn like '1694774807.16222'. When I press UniqueID I have got empty table. In asteriskcdrdb.cel there are no record after migration. How I can fix it?
In menu PBX -> Calls Recordings I see 'Unknown' in coloumn 'Source' when operator got incoming call and make transfer on queue number. In Elastix I had see CID of incoming call. And extra lines in Issabel.
Elastix:
Date Time Source Destination Duration Type
13 Sep 2023 20:26:22 XXXXXXXXXXX 355 0:04:09 Incoming
13 Sep 2023 20:26:22 XXXXXXXXXXX 354 0:00:07 Incoming
13 Sep 2023 20:26:22 XXXXXXXXXXX 353 0:00:07 Incoming
13 Sep 2023 20:26:22 XXXXXXXXXXX 351 0:00:07 Incoming
13 Sep 2023 20:26:22 XXXXXXXXXXX 350 0:00:07 Incoming
13 Sep 2023 20:26:22 XXXXXXXXXXX 35 0:04:09 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 106 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 105 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 104 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 103 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 102 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 101 0:00:04 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 100 0:00:29 Incoming
13 Sep 2023 20:25:53 XXXXXXXXXXX 10 0:04:38 Incoming
Issabel:
Date Time Source Destination Duration Type
15 Sep 2023 14:07:02 XXXXXXXXXXX 346 0:00:28 Incoming
15 Sep 2023 14:07:02 XXXXXXXXXXX 345 0:00:05 Incoming
15 Sep 2023 14:07:02 XXXXXXXXXXX 344 0:00:05 Incoming
15 Sep 2023 14:07:02 XXXXXXXXXXX 342 0:00:05 Incoming
15 Sep 2023 14:07:02 XXXXXXXXXXX 341 0:00:05 Incoming
15 Sep 2023 14:07:02 XXXXXXXXXXX 340 0:00:05 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 106 0:00:09 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:28 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:05 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:05 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:00 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:05 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:05 Incoming
15 Sep 2023 14:07:02 Unknown 34 0:00:05 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 104 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 103 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 102 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 101 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 100 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:57 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
15 Sep 2023 14:06:34 XXXXXXXXXXX 10 0:00:09 Incoming
How I can fix it?