Recommended options for ADMIN_archive_log_tables.pl

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Recommended options for ADMIN_archive_log_tables.pl

Postby jessiekidfernando » Fri Apr 05, 2019 9:00 pm

Hello VICI Team,

Just like to know your inputs. We would like to know the recommended options for this script.


/usr/share/astguiclient/ADMIN_archive_log_tables.pl

print " [--daily] = only archives call_log, vicidial_log_extended, vicidial_dial_log and vicidial_drop_log tables, only last 24 hours kept\n";
print " [--carrier-daily] = will also archive the vicidial_carrier_log table when --daily is run\n";
print " [--vlog-daily] = will also archive the vicidial_log table when --daily is run\n";
print " [--days=XX] = number of days to archive past, default is 732(2 years)\n";
print " [--months=XX] = number of months to archive past, default is 24(2 years) If 'days' used then 'months' ignored\n";
print " [--queue-log] = archive QM queue_log records\n";
print " [--only-trim-archive-level-one] = will not perform normal archive process, instead this will only delete records\n";
print " that are older than XX months from least important log archive tables:\n";
print " call_log_archive, vicidial_log_extended_archive, vicidial_dial_log_archive, vicidial_drop_log\n";
print " [--only-trim-archive-level-two] = same as --only-trim-archive-level-one, except includes tables:\n";
print " vicidial_carrier_log_archive, vicidial_api_log_archive, vicidial_rt_monitor_log_archive\n";
print " [--only-trim-archive-level-three] = same as --only-trim-archive-level-two, except includes tables:\n";
print " vicidial_log_archive, vicidial_agent_log_archive, vicidial_closer_log_archive, vicidial_xfer_log_archive\n";
print " [--recording-log-days=XX] = OPTIONAL, number of days to archive recording_log table only past\n";
print " [--did-log-days=XX] = OPTIONAL, number of days to archive vicidial_did_log table only past\n";
print " [--cpd-log-purge-days=XX] = OPTIONAL, number of days to purge vicidial_cpd_log table only past\n";
print " [--wipe-closer-log] = OPTIONAL, deletes all records from vicidial_closer_log after archiving\n";
print " [--wipe-all-being-archived] = OPTIONAL, deletes all records from most tables after archiving\n";
print " [--quiet] = quiet\n";
print " [--calc-test] = date calculation test only\n";

Our cluster consists of 10 agent/dialer server and single database with slave replication.

Regards,

Jessie
OS: Linux version 4.4.155-68-default (geeko@buildhost) (gcc version 4.8.5 (SUSE Linux) )
VERSION: 2.14-717a
BUILD: 190724-1603
Asterisk: 13.21.1-vici
Dahdi: 2.11.1
jessiekidfernando
 
Posts: 152
Joined: Fri Feb 08, 2019 5:49 pm

Re: Recommended options for ADMIN_archive_log_tables.pl

Postby williamconley » Wed May 01, 2019 7:49 pm

the answer to that question is based entirely on YOUR needs.

every single option there suits a specific need.

If you're not sure, set the system to archive monthly and to retain 12 months of data and not to delete anything.

Or just uncomment the first archive option in the crontab at its default settings.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Recommended options for ADMIN_archive_log_tables.pl

Postby jessiekidfernando » Mon May 06, 2019 11:47 am

Thanks a lot for your response Williamconley. I have adjusted it based from our current settings.
OS: Linux version 4.4.155-68-default (geeko@buildhost) (gcc version 4.8.5 (SUSE Linux) )
VERSION: 2.14-717a
BUILD: 190724-1603
Asterisk: 13.21.1-vici
Dahdi: 2.11.1
jessiekidfernando
 
Posts: 152
Joined: Fri Feb 08, 2019 5:49 pm

Re: Recommended options for ADMIN_archive_log_tables.pl

Postby dhijrwn » Sun Jun 19, 2022 10:29 am

williamconley wrote:the answer to that question is based entirely on YOUR needs.

every single option there suits a specific need.

If you're not sure, set the system to archive monthly and to retain 12 months of data and not to delete anything.

Or just uncomment the first archive option in the crontab at its default settings.


Is there an option where the agents can see their archived call logs on the agent web interface?
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: Recommended options for ADMIN_archive_log_tables.pl

Postby williamconley » Tue Jun 21, 2022 1:57 pm

You would do better to check that by logging in as an agent and looking at the page in question to see if there is an "acrhived" button available rather than taking anyone's word for it (other than Matt, of course 8-) ). But I don't think so.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 81 guests