Question about ADMIN_archive_log_tables.pl script

All installation and configuration problems and questions

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

Question about ADMIN_archive_log_tables.pl script

Postby dhijrwn » Wed Jun 29, 2022 10:31 am

### roll logs monthly on high-volume dialing systems
#30 1 1 * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl --months=6

### roll call_log and vicidial_log_extended daily on very high-volume dialing systems
#20 1 * * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl --daily

Hi guys I have a question about these 2 entries in the crontab, currently it is commented but when I tried to run these script it just only inserted the current data to their archive log per table.
Is is ok to add these flags --wipe-all-being-archived --wipe-closer-log so after they are inserted, they will be deleted automatically on the live tables?
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: Question about ADMIN_archive_log_tables.pl script

Postby carpenox » Wed Jun 29, 2022 4:13 pm

yes sir, thats why they are available options, you can see them all by just adding help to your /usr/share/astguiclient/ADMIN_archive_log_tables.pl --help
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2420
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Question about ADMIN_archive_log_tables.pl script

Postby dhijrwn » Wed Jun 29, 2022 4:31 pm

carpenox wrote:yes sir, thats why they are available options, you can see them all by just adding help to your /usr/share/astguiclient/ADMIN_archive_log_tables.pl --help


Thank you. Can I enable them both? Daily and monthly?
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: Question about ADMIN_archive_log_tables.pl script

Postby carpenox » Thu Jun 30, 2022 8:43 am

yes on separate crontab lines
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2420
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Question about ADMIN_archive_log_tables.pl script

Postby williamconley » Fri Jul 01, 2022 3:44 pm

Basically the --daily is for cleaning out logs that really don't have any reports based on them, they are primarily for troubleshooting. So running that as an option can be considered a completely separate feature compared to archiving the rest of the logs.
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: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Question about ADMIN_archive_log_tables.pl script

Postby dhijrwn » Sat Jul 02, 2022 8:58 am

I see, activating that in crontab will help the database reduce records, Thank you for your answers.
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


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 133 guests