All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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
by 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
-
by 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
by 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
-
by 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: 20254
- Joined: Wed Oct 31, 2007 4:17 pm
- Location: Davenport, FL (By Disney!)
-
by 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: Google [Bot], Majestic-12 [Bot] and 104 guests