TNG Not Importing Data

Web based, multi-user, Telephone Management System with budget management and barring control

Moderators: Leon van Heerden, Luanda_Junzi, Belinda Frick, Lee Hendricks

TNG Not Importing Data

Postby Andrew.Engelbrecht » Fri Feb 08, 2013 11:22 am

TNG is not importing data. Doing a manual export from cdr table as TNG drops some records due to formatting of LastData in Asterisk 1.8 (last data field periodically has quotes as part of the data [SIP/2505,"",trM(auto-blkvm)]). Setup an export script to export data as comma seperated, enclosed in quotes and replacing "" with || in lastdata and " in clid with [] every two minutes to /var/log/asterisk/cdr-custom.

Stopped TNG; deleted [12]data.* from /opt/datatex/tng/data and restarted tng. Re-dumped all data, but tng not processing; datafile is 426KB in size (only 1 datafile). Moved csv files to import directory for raw import; no luck

Logfile
2013-02-08 11:01:01:542 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 11:00:34:507 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 11:00:01:798 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:59:34:381 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:59:01:534 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:58:34:261 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:58:02:279 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:57:34:141 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:57:02:003 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:56:39:031 [1.1.1.11] - [AMI LOG] - Requesting Dialplan...[Process Reload]
2013-02-08 10:56:39:031 [1.1.1.11] - [AMI LOG] - No Dialplan/Peer List Received since last request. Reloading...
2013-02-08 10:56:24:001 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:56:01:755 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:55:23:645 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:55:01:509 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:54:23:525 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:54:01:764 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:53:24:529 [1.1.1.11] - ApplyGeneralSettings: OK - Tech Saving=True!
2013-02-08 10:53:24:528 [1.1.1.11] - Import Raw Data Enabled
2013-02-08 10:53:24:518 [1.1.1.11] - Raw Data Logging Enabled to 2013-02-08 18:53
2013-02-08 10:53:24:517 [1.1.1.11] - AMI Strip Breakout Digit set to:True
2013-02-08 10:53:23:405 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:53:02:020 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:52:23:280 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:52:02:276 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:51:58:230 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/Telviva-00074162[10]UniqueID: 1360312850.1953114[10]DialStatus: NOANSWER[10]
2013-02-08 10:51:58:230 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:51:54:222 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/6706@from-internal-23cd;2[10]UniqueID: 1360312905.1953179[10]DialStatus: ANSWER[10]
2013-02-08 10:51:54:222 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:51:31:177 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2348-00074154[10]UniqueID: 1360312820.1953100[10]DialStatus: ANSWER[10]
2013-02-08 10:51:31:176 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:51:30:217 [1.1.1.11] - ApplyGeneralSettings: OK - Tech Saving=True!
2013-02-08 10:51:30:216 [1.1.1.11] - Import Raw Data Enabled
2013-02-08 10:51:30:207 [1.1.1.11] - Raw Data Logging Enabled to 2013-02-08 18:51
2013-02-08 10:51:30:205 [1.1.1.11] - AMI Strip Breakout Digit set to:True
2013-02-08 10:51:23:160 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:51:02:031 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:50:22:840 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:50:01:785 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:49:22:720 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:49:01:539 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:48:34:145 [1.1.1.11] - ApplyGeneralSettings: OK - Tech Saving=True!
2013-02-08 10:48:34:145 [1.1.1.11] - Import Raw Data Disabled
2013-02-08 10:48:34:135 [1.1.1.11] - Raw Data Logging Enabled to 2013-02-08 18:48
2013-02-08 10:48:33:265 [1.1.1.11] - AMI connected to port 5038 on 127.0.0.1
2013-02-08 10:48:33:038 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:936 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:834 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:732 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:630 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:529 [1.1.1.11] - AMI Disconnected:Host application forced disconnect
2013-02-08 10:48:32:528 [1.1.1.11] - AMI Disconnected:0 -
2013-02-08 10:48:32:136 [1.1.1.11] - Logging Raw Data Enabled
2013-02-08 10:48:32:135 [1.1.1.11] - AMI Strip Breakout Digit set to:True
2013-02-08 10:48:22:597 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:48:02:297 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:47:52:526 [1.1.1.11] - [AMI LOG] - Dialplan Processed.
2013-02-08 10:47:18:244 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:47:18:244 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2497-0007416f[10]UniqueID: 1360312877.1953143[10]DialStatus: CANCEL[10]
2013-02-08 10:47:18:244 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:47:10:334 [1.1.1.11] - User admin connected from 10.0.13.251
2013-02-08 10:47:02:051 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:46:55:059 [1.1.1.11] - User admin disconnected
2013-02-08 10:46:50:188 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2506@from-internal-b678;2[10]UniqueID: 1360312866.1953133[10]DialStatus: ANSWER[10]
2013-02-08 10:46:50:188 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:46:34:156 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2301@from-internal-e584;2[10]UniqueID: 1360312866.1953137[10]DialStatus: CANCEL[10]
2013-02-08 10:46:34:156 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:46:33:154 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2300@from-internal-5256;2[10]UniqueID: 1360312866.1953135[10]DialStatus: CANCEL[10]
2013-02-08 10:46:33:154 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:46:20:128 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6889-00074164[10]UniqueID: 1360312854.1953118[10]DialStatus: CANCEL[10]
2013-02-08 10:46:20:128 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:46:18:124 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:46:01:805 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:45:35:038 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/6704@from-internal-f632;2[10]UniqueID: 1360312862.1953130[10]DialStatus: ANSWER[10]
2013-02-08 10:45:35:038 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:45:18:004 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:45:01:057 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:44:29:908 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/6709@from-internal-1fc8;2[10]UniqueID: 1360312859.1953121[10]DialStatus: ANSWER[10]
2013-02-08 10:44:29:908 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:44:17:884 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:44:01:815 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:43:47:824 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/6705@from-internal-8740;2[10]UniqueID: 1360312850.1953116[10]DialStatus: ANSWER[10]
2013-02-08 10:43:47:824 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:43:18:766 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2324-00074142[10]UniqueID: 1360312763.1953072[10]DialStatus: ANSWER[10]
2013-02-08 10:43:18:766 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:43:17:764 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:43:02:071 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:42:33:676 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2374-00074158[10]UniqueID: 1360312828.1953104[10]DialStatus: CANCEL[10]
2013-02-08 10:42:33:676 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:42:28:666 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2333-000740fd[10]UniqueID: 1360312504.1952964[10]DialStatus: ANSWER[10]
2013-02-08 10:42:28:666 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:42:27:389 [1.1.1.11] - User admin connected from 10.0.13.251
2013-02-08 10:42:20:579 [1.1.1.11] - Owner from IP : 10.0.13.251 got timed out.
2013-02-08 10:42:17:644 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:42:16:642 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6889-0007415c[10]UniqueID: 1360312836.1953108[10]DialStatus: ANSWER[10]
2013-02-08 10:42:16:642 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:42:13:559 [1.1.1.11] - Owner from IP : 10.0.13.251 got timed out.
2013-02-08 10:42:06:622 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2425-00073fc5[10]UniqueID: 1360311555.1952050[10]DialStatus: ANSWER[10]
2013-02-08 10:42:06:622 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:42:02:327 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:41:37:564 [1.1.1.11] - [AMI LOG] - Requesting Dialplan...[CDRStatusResponse]
2013-02-08 10:41:17:524 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-08 10:41:14:518 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6889-00074152[10]UniqueID: 1360312815.1953098[10]DialStatus: CANCEL[10]
2013-02-08 10:41:14:518 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:41:08:506 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6683-00074133[10]UniqueID: 1360312717.1953050[10]DialStatus: ANSWER[10]
2013-02-08 10:41:08:506 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-08 10:41:02:082 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:40:36:442 [1.1.1.11] - AMI Exception:No such command 'show version' (type 'core show help show version' for other possible commands)
2013-02-08 10:40:24:408 [1.1.1.11] - Activation server check-in completed
2013-02-08 10:40:23:596 [1.1.1.11] - HandleDisconnect: active - last activation okay
2013-02-08 10:40:23:596 [1.1.1.11] - Response from activation server "disconnect|788|PERM|||"
2013-02-08 10:40:23:427 [1.1.1.11] - Response from activation server "upload|inifile|"
2013-02-08 10:40:23:304 [1.1.1.11] - Activation server check-in starting (forced)
2013-02-08 10:40:23:304 [1.1.1.11] - Activation server check-in completed
2013-02-08 10:40:23:011 [1.1.1.11] - Barring: Server [20009]: Started OK
2013-02-08 10:40:23:011 [1.1.1.11] - Integration: Server [20003]: Started OK
2013-02-08 10:40:22:923 [1.1.1.11] - HandleDisconnect: active - last activation okay
2013-02-08 10:40:22:923 [1.1.1.11] - Response from activation server "disconnect|7822|PERM|||"
2013-02-08 10:40:22:713 [1.1.1.11] - Response from activation server "upload|inifile|"
2013-02-08 10:40:22:536 [1.1.1.11] - AMI connected to port 5038 on 127.0.0.1
2013-02-08 10:40:22:462 [1.1.1.11] - RateBook : za_telkom Loaded [ver 2011.08.01.03]
2013-02-08 10:40:22:460 [1.1.1.11] - Loading Ratebook: /opt/datatex/tng/rates/za_telkom.so
2013-02-08 10:40:22:460 [1.1.1.11] - 9661 exchange entries loaded.
2013-02-08 10:40:22:443 [1.1.1.11] - Exchange Library [ver 2011.08.01.02]: Version Ok!
2013-02-08 10:40:22:418 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-08 10:40:22:412 [1.1.1.11] - Exchange Library : Verifying Versions...
2013-02-08 10:40:22:412 [1.1.1.11] - AMI Process thread ID 4001131408
2013-02-08 10:40:22:411 [1.1.1.11] - AMI Reader thread ID 4011621264
2013-02-08 10:40:22:411 [1.1.1.11] - Import thread ID 4022111120
2013-02-08 10:40:22:411 [1.1.1.11] - Report Schedule thread ID 4032600976
2013-02-08 10:40:22:411 [1.1.1.11] - Flush thread ID 4043090832
2013-02-08 10:40:22:411 [1.1.1.11] - Plugin thread ID 4053580688
2013-02-08 10:40:22:411 [1.1.1.11] - Call Activity Monitor thread ID 4064070544
2013-02-08 10:40:22:411 [1.1.1.11] - Barring object thread ID 4085050256
2013-02-08 10:40:22:411 [1.1.1.11] - Integration thread ID 4106029968
2013-02-08 10:40:22:411 [1.1.1.11] - Comms thread ID 4116519824
2013-02-08 10:40:22:411 [1.1.1.11] - Startup for ***[/opt/datatex/tng/tng --Asterisk-- ]*** OK
2013-02-08 10:40:22:411 [1.1.1.11] - AMI Strip Breakout Digit set to:True
2013-02-08 10:40:22:411 [1.1.1.11] - Setting AMI CDR FileName to:/var/log/asterisk/cdr-custom/*.csv
2013-02-08 10:40:22:411 [1.1.1.11] - [AMI LOG] - Clearing File List.
2013-02-08 10:40:22:411 [1.1.1.11] - Setting AMI Interface Option to :CDR File
2013-02-08 10:40:22:411 [1.1.1.11] - Setting AMI Login Name :tng
2013-02-08 10:40:22:411 [1.1.1.11] - Setting AMI Port :5038
2013-02-08 10:40:22:411 [1.1.1.11] - Setting AMI Host :127.0.0.1
2013-02-08 10:40:22:411 [1.1.1.11] - User tngreportschedule connected from 127.0.0.1
2013-02-08 10:40:22:410 [1.1.1.11] - Loading Scheduled Reports.. Completed.
2013-02-08 10:40:22:410 [1.1.1.11] - Loading Scheduled Reports..
2013-02-08 10:40:22:410 [1.1.1.11] - Plugin: Loading Rules.. Completed.
2013-02-08 10:40:22:410 [1.1.1.11] - Plugin: Loading Rules..
2013-02-08 10:40:22:409 [1.1.1.11] - Raw Data Logging disabled
2013-02-08 10:40:22:409 [1.1.1.11] - Plugin: Reading Settings.
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Created: Trunk Alarm: 0 minutes. Total Alarm: 0 minutes.
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/i1/
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/31
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/30
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/29
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/28
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/27
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/26
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/25
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/24
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/23
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/22
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/20
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/19
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/18
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/17
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/16
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/15
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/14
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/13
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/12
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/11
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/10
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/09
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/08
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/07
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/06
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/05
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/04
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/03
2013-02-08 10:40:22:408 [1.1.1.11] - CAM: Adding trunk DAHDI/02
2013-02-08 10:40:22:407 [1.1.1.11] - CAM: Adding trunk DAHDI/01
2013-02-08 10:40:22:407 [1.1.1.11] - Barring Object Created
2013-02-08 10:40:22:407 [1.1.1.11] - Barring: Server Created
2013-02-08 10:40:22:407 [1.1.1.11] - Integration Object Created
2013-02-08 10:40:22:407 [1.1.1.11] - Integration: Server Created
2013-02-08 10:40:22:407 [1.1.1.11] - SerialThread : 4116519824
2013-02-08 10:40:22:406 [1.1.1.11] - Settings Read
2013-02-08 10:40:22:406 [1.1.1.11] - Reading Settings
2013-02-08 10:40:22:406 [1.1.1.11] - Activation server check-in starting
2013-02-08 10:40:21:610 [1.1.1.11] - Reserving Unused Memory
2013-02-08 10:40:21:610 [1.1.1.11] - Loaddata completed: TNGCalldata Count = 1
2013-02-08 10:40:21:610 [1.1.1.11] - Loading: Open File -- Failed (No such file or directory. Creating new file.
2013-02-08 10:40:21:606 [1.1.1.11] - Loading: Assigned File -- OK
2013-02-08 10:40:21:606 [1.1.1.11] - Loading: /opt/datatex/tng/data/1data_1.1.1.11.dat
2013-02-08 10:40:21:606 [1.1.1.11] - Loading Monitored Trunks
2013-02-08 10:40:21:605 [1.1.1.11] - Last File Saved Checksum: Check:[57010F987A13A8D9B1330B03BDFA2A71]
2013-02-08 10:40:21:605 [1.1.1.11] - Last File Saved: 2data_1.1.1.11
2013-02-08 10:40:21:475 [1.1.1.11] - Available Memory: NPR = 464 ATT = 2000000000 TOT = 8359886848 MCC = 4310345
2013-02-08 10:40:21:474 [1.1.1.11] - Memory Status Object Created
You do not have the required permissions to view the files attached to this post.
Andrew.Engelbrecht
 
Posts: 27
Joined: Mon Oct 15, 2012 8:47 am

Re: TNG Not Importing Data

Postby Odette Danster » Fri Feb 08, 2013 4:04 pm

Referring to log entry below:

Code: Select all
AMI Disconnected:Host application forced disconnect


It appears that the AMI is not allowing TNG to connect. Thereafter we noticed connection entries.
This could be why it appears to stop importing call details and then starts again.

Can you please investigate why the AMI on Asterisk side would not allow connection?

Other suggestions:

Odette Danster
 
Posts: 126
Joined: Thu Nov 18, 2010 12:01 pm

Re: TNG Not Importing Data

Postby Andrew.Engelbrecht » Mon Feb 11, 2013 1:04 pm

Followed suggestions, but no joy; still no data being loaded (please see csv file included in first post for file format). Ran tng in non-daemon mode. Screen displayed no errors; output was

ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;1" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;1" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;1" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;1" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;1" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;1" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;1" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;1" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;1" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;1" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6704@from-internal-c574;1" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;1" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;2" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;2" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;1" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;1" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6709@from-internal-a570;1" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;1" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;2" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;2" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6704@from-internal-c574;2" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6704@from-internal-c574;2" cleanExt="6704@from" aliasExt="LOCAL/6704"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6706@from-internal-5c94;2" cleanExt="6706@from" aliasExt="LOCAL/6706"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6702@from-internal-e73a;2" cleanExt="6702@from" aliasExt="LOCAL/6702"
ChannelInExtensions: channel="Local/6709@from-internal-a570;2" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;2" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;1" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6709@from-internal-a570;1" cleanExt="6709@from" aliasExt="LOCAL/6709"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"
ChannelInExtensions: channel="Local/6710@from-internal-aaed;2" cleanExt="6710@from" aliasExt="LOCAL/6710"


TNG Logfile
2013-02-11 12:28:28:697 [1.1.1.11] - Memory Status Object Created
2013-02-11 12:28:28:698 [1.1.1.11] - Available Memory: NPR = 464 ATT = 2000000000 TOT = 8359886848 MCC = 4310345
2013-02-11 12:28:28:827 [1.1.1.11] - Last File Saved: 2data_1.1.1.11
2013-02-11 12:28:28:827 [1.1.1.11] - Last File Saved Checksum: Check:[C9AC1F5319F00A96419AE3AF8C692DC1]
2013-02-11 12:28:28:827 [1.1.1.11] - Loading Monitored Trunks
2013-02-11 12:28:28:828 [1.1.1.11] - Loading: /opt/datatex/tng/data/2data_1.1.1.11.dat
2013-02-11 12:28:28:828 [1.1.1.11] - Loading: Assigned File -- OK
2013-02-11 12:28:28:828 [1.1.1.11] - Loading: Opened File -- OK
2013-02-11 12:28:28:829 [1.1.1.11] - Loading: 1 Record(s) Loaded -- OK -- Check:[C9AC1F5319F00A96419AE3AF8C692DC1]
2013-02-11 12:28:28:829 [1.1.1.11] - Loaddata completed: TNGCalldata Count = 1
2013-02-11 12:28:28:829 [1.1.1.11] - Reserving Unused Memory
2013-02-11 12:28:29:610 [1.1.1.11] - Reading Settings
2013-02-11 12:28:29:610 [1.1.1.11] - Settings Read
2013-02-11 12:28:29:610 [1.1.1.11] - SerialThread : 4117019536
2013-02-11 12:28:29:610 [1.1.1.11] - Integration: Server Created
2013-02-11 12:28:29:610 [1.1.1.11] - Integration Object Created
2013-02-11 12:28:29:611 [1.1.1.11] - Barring: Server Created
2013-02-11 12:28:29:611 [1.1.1.11] - Barring Object Created
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/01
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/02
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/03
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/04
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/05
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/06
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/07
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/08
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/09
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/10
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/11
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/12
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/13
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/14
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/15
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/16
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/17
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/18
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/19
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/20
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/22
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/23
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/24
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/25
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/26
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/27
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/28
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/29
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/30
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/31
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Adding trunk DAHDI/i1/
2013-02-11 12:28:29:611 [1.1.1.11] - CAM: Created: Trunk Alarm: 0 minutes. Total Alarm: 0 minutes.
2013-02-11 12:28:29:612 [1.1.1.11] - Plugin: Reading Settings.
2013-02-11 12:28:29:612 [1.1.1.11] - Raw Data Logging Permanently Enabled
2013-02-11 12:28:29:613 [1.1.1.11] - Plugin: Loading Rules..
2013-02-11 12:28:29:613 [1.1.1.11] - Plugin: Loading Rules.. Completed.
2013-02-11 12:28:29:613 [1.1.1.11] - Loading Scheduled Reports..
2013-02-11 12:28:29:613 [1.1.1.11] - Loading Scheduled Reports.. Completed.
2013-02-11 12:28:29:614 [1.1.1.11] - User tngreportschedule connected from 127.0.0.1
2013-02-11 12:28:29:614 [1.1.1.11] - Setting AMI Host :127.0.0.1
2013-02-11 12:28:29:614 [1.1.1.11] - Setting AMI Port :5038
2013-02-11 12:28:29:614 [1.1.1.11] - Setting AMI Login Name :tng
2013-02-11 12:28:29:614 [1.1.1.11] - Setting AMI Interface Option to :CDR File
2013-02-11 12:28:29:614 [1.1.1.11] - [AMI LOG] - Clearing File List.
2013-02-11 12:28:29:614 [1.1.1.11] - Setting AMI CDR FileName to:/var/log/asterisk/cdr-custom/2012-08.csv
2013-02-11 12:28:29:614 [1.1.1.11] - AMI Strip Breakout Digit set to:True
2013-02-11 12:28:29:614 [1.1.1.11] - Exchange Library : Verifying Versions...
2013-02-11 12:28:29:614 [1.1.1.11] - Startup for ***[/opt/datatex/tng/tng --Asterisk-- ]*** OK
2013-02-11 12:28:29:614 [1.1.1.11] - Comms thread ID 4117019536
2013-02-11 12:28:29:614 [1.1.1.11] - Integration thread ID 4106529680
2013-02-11 12:28:29:615 [1.1.1.11] - Barring object thread ID 4085549968
2013-02-11 12:28:29:615 [1.1.1.11] - Call Activity Monitor thread ID 4064570256
2013-02-11 12:28:29:615 [1.1.1.11] - Plugin thread ID 4054080400
2013-02-11 12:28:29:615 [1.1.1.11] - Flush thread ID 4043590544
2013-02-11 12:28:29:615 [1.1.1.11] - Report Schedule thread ID 4033100688
2013-02-11 12:28:29:615 [1.1.1.11] - Import thread ID 4022610832
2013-02-11 12:28:29:615 [1.1.1.11] - AMI Reader thread ID 4012120976
2013-02-11 12:28:29:615 [1.1.1.11] - AMI Process thread ID 4001631120
2013-02-11 12:28:29:621 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:28:29:646 [1.1.1.11] - Exchange Library [ver 2011.08.01.02]: Version Ok!
2013-02-11 12:28:29:664 [1.1.1.11] - 9661 exchange entries loaded.
2013-02-11 12:28:29:664 [1.1.1.11] - Loading Ratebook: /opt/datatex/tng/rates/za_telkom.so
2013-02-11 12:28:29:666 [1.1.1.11] - RateBook : za_telkom Loaded [ver 2011.08.01.03]
2013-02-11 12:28:29:713 [1.1.1.11] - Integration: Server [20003]: Started OK
2013-02-11 12:28:29:713 [1.1.1.11] - Barring: Server [20009]: Started OK
2013-02-11 12:28:29:739 [1.1.1.11] - AMI connected to port 5038 on 127.0.0.1
2013-02-11 12:28:35:743 [1.1.1.11] - Owner from IP : 10.64.5.156 got timed out.
2013-02-11 12:29:02:257 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:29:24:763 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:29:41:935 [1.1.1.11] - User admin connected from 10.64.5.156
2013-02-11 12:29:48:810 [1.1.1.11] - AMI Exception:No such command 'show version' (type 'core show help show version' for other possible commands)
2013-02-11 12:30:02:001 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:30:24:882 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:31:01:745 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:31:25:003 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:31:25:003 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2497-00077032[10]UniqueID: 1360578477.2025663[10]DialStatus: ANSWER[10]
2013-02-11 12:31:25:003 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:31:31:015 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:31:31:015 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2546-00077034[10]UniqueID: 1360578483.2025685[10]DialStatus: ANSWER[10]
2013-02-11 12:32:01:993 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:32:25:136 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:32:45:202 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:32:45:202 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/6710@from-internal-6426;2[10]UniqueID: 1360578513.2025788[10]DialStatus: ANSWER[10]
2013-02-11 12:33:01:738 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:33:25:286 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:33:56:349 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:33:56:349 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2508-00077048[10]UniqueID: 1360578516.2025794[10]DialStatus: CONGESTION[10]
2013-02-11 12:34:01:484 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:34:12:381 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:34:12:381 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/2508-00077048[10]UniqueID: 1360578516.2025794[10]DialStatus: CHANUNAVAIL[10]
2013-02-11 12:34:25:407 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:35:01:229 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:35:25:527 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:35:31:639 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:35:31:639 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6721-0007703e[10]UniqueID: 1360578501.2025747[10]DialStatus: CANCEL[10]
2013-02-11 12:35:55:687 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:35:55:688 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2301@from-internal-966a;2[10]UniqueID: 1360578516.2025797[10]DialStatus: ANSWER[10]
2013-02-11 12:36:01:977 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:36:25:747 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:37:01:219 [1.1.1.11] - /opt/datatex/tng/import/extensions.txt moved to processed folder
2013-02-11 12:37:25:867 [1.1.1.11] - [AMI LOG] - Waiting on Dial Plan and Peer List
2013-02-11 12:37:27:871 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-02-11 12:37:27:871 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/6721-00077052[10]UniqueID: 1360578526.2025839[10]DialStatus: ANSWER[10]


Asterisk shows tng connected via manager interface
[root@pbx-ast01 asterisk]# asterisk -rx "manager show connected"
Username IP Address Start Elapsed FileDes HttpCnt Read Write
tng 127.0.0.1 1360579301 1068 354 0 01151 01151
1 users connected.
Andrew.Engelbrecht
 
Posts: 27
Joined: Mon Oct 15, 2012 8:47 am

Re: TNG Not Importing Data

Postby Andrew.Engelbrecht » Mon Feb 11, 2013 3:08 pm

Comparison of data from Master.csv and custom extract

Master.csv
"${CDR(clid)} ","${CDR(src)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(channel)} ","${CDR(dstchannel)}","${CDR(lastapp)}","${CDR(lastdata)} ","${CDR(start)} ","${CDR(answer)} ","${CDR(end)} ","${CDR(duration)}","${CDR(billsec)}","${CDR(disposition)}","${CDR(amaflags)}","${CDR(accountcode)}","${CDR(uniqueid)} ","${CDR(userfield)} "
""00anonymous" <00>","00 ","6702 ","from-internal ","Local/6702@from-internal-3d03;2","SIP/6702-0007776b ","Dial ","SIP/6702,"",trM(auto-blkvm)","2013-02-11 14:34:08","2013-02-11 14:34:09","2013-02-11 14:34:09","1 ","0 ","ANSWERED ","DOCUMENTATION "," ","1360586048.2038394 ","IN6702-20130211-143408-1360586048.2038394.WAV"

CDR Extract
"${CDR(clid)} ","${CDR(src)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(channel)}" ,"${CDR(dstchannel)}","${CDR(lastapp)}","${CDR(lastdata)} ","${CDR(start)} ","${CDR(answer)} ","${CDR(end)} ","${CDR(duration)}","${CDR(billsec)}","${CDR(disposition)}","${CDR(amaflags)}","${CDR(accountcode)}","${CDR(uniqueid)} ","${CDR(userfield)} "
"[00anonymous] <00>","00 ","6702 ","from-internal ","Local/6702@from-internal-3d03;2","SIP/6702-0007776b ","Dial ","[SIP/6702,||,trM(auto-blkvm)]","2013-02-11 14:34:08","2013-02-11 14:34:09","2013-02-11 14:34:09","1 ","0 ","ANSWERED ","3 "," ","1360586048.2038394","IN6702-20130211-143408-1360586048.2038394.WAV"


mysql asteriskcdrdb --password=ct3l\!root --execute="select concat('\"',clid,'\",\"',src,'\",\"',dst,'\",\"',dcontext,'\",\"',channel,'\",\"',dstchannel,'\",\"',lastapp,'\",\"[',lastdata,']\",\"',start,'\",\"',answer,'\",\"',end,'\",\"',duration,'\",\"',billsec,'\",\"',disposition,'\",\"',amaflags,'\",\"',accountcode,'\",\"',uniqueid,'\",\"',userfield,'\"') from (select clid,src,dst,dcontext,channel,dstchannel,lastapp,replace(lastdata,'\"\"','') as lastdata,calldate as start,date_add(calldate,interval duration-billsec second) as answer,date_add(calldate,interval duration second) as end,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield from cdr where date_format(calldate,'%Y-%m') = '2013-01') as field1" | grep -v concat > 2013-01.csv
Andrew.Engelbrecht
 
Posts: 27
Joined: Mon Oct 15, 2012 8:47 am

Re: TNG Not Importing Data

Postby Andrew.Engelbrecht » Tue Feb 12, 2013 12:15 pm

Changes made to manager user for peerlist and dialplan

[tng]
Code: Select all
secret = datatex
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,command ; only require these to process dialplan and peerlist; reduces overhead and
write = system,command ; only require these to process dialplan and peerlist
writetimeout=20000


Also changed memory to 20% (stability on 64bit).

Processing Data

To set the memory precentage to be allocate log into "TNG WebAdmin", Click on the "HOME" icon and select the "General Settings" icon. You need to enter the technical password.
Under the "Data Configuration" section, next to "Percentage of Available Memory to reserve" enter the percentage you wish to allocate for TNG. You need to click on "Apply Changes". It will display "UPDATE SUCCESSFULL" in the left hand top corner of the screen.
Andrew.Engelbrecht
 
Posts: 27
Joined: Mon Oct 15, 2012 8:47 am


Return to TNG

Who is online

Users browsing this forum: No registered users and 1 guest

cron