All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by dhijrwn » Wed Aug 24, 2022 11:39 am
Hi, we are facing this issue when exporting call logs in the export calls report.
What I know that we have so many calls per day and if we extracted 1 month or 3 months, it will fail, timeout returns 500 status.
Variables and filters:
We are averaging 700k outbound calls on this month of august.
Total leads: 7764195
Campaign: 1 campaign
Inbound groups: inbound groups related to the selected campaign
List: All lists (165 lists)
Status: All
User Group: All
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 » Mon Aug 29, 2022 9:51 pm
try adding this to the bottom of your /etc/php.ini
error_reporting = E_ALL & ~E_NOTICE
memory_limit = 448M
short_open_tag = On
max_execution_time = 6330
max_input_time = 3360
post_max_size = 448M
upload_max_filesize = 442M
default_socket_timeout = 6360
date.timezone = America/New_York
hope this helps
Chris
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 » Tue Aug 30, 2022 1:51 am
carpenox wrote:try adding this to the bottom of your /etc/php.ini
error_reporting = E_ALL & ~E_NOTICE
memory_limit = 448M
short_open_tag = On
max_execution_time = 6330
max_input_time = 3360
post_max_size = 448M
upload_max_filesize = 442M
default_socket_timeout = 6360
date.timezone = America/New_York
hope this helps
Chris
Hi Nox, It works but needed to modified the memory_limit to 8000MB. Thank you.
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 » Tue Aug 30, 2022 3:52 am
no problem bro, glad to help, imn the future check out my blog at
http://vicidial.blog - it handles most issues people have on here
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 » Tue Aug 30, 2022 1:12 pm
carpenox wrote:no problem bro, glad to help, imn the future check out my blog at
http://vicidial.blog - it handles most issues people have on here
When I open the text file copied the content and pasted it to excel, it only contains 1million+ records? I'm expecting it to be 15 millions+ of call logs.
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 » Sat Sep 03, 2022 1:22 am
try increasing the memory_limit
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
-
Return to Support
Who is online
Users browsing this forum: Google [Bot], Majestic-12 [Bot], MSN [Bot] and 112 guests