Hopper doesn't load leads because of GMT

[phil_discount]

Hello,

i found my problem...
i've got a call time from 8 am to 8 pm.

date in console is correct

Code: Select all

Thu Sep 24 09:09:16 CEST 2009

in vicidial admin is correct

Code: Select all

Thursday September 24, 2009 9:04:33 AM

in vicidial agent screen is correct

Code: Select all

24/09/2009 09:10:42

one server with GMT +2 in ADMIN section configured
all leads have got gmt_offset_now value "2"
when vicidial makes a call, modify date changes with the correctly time.

but my hopper always shows another time...why?
GMT: 06:04
when i change calltime from 6 am to 8 pm, the hopper loads leads in the morning.

output from hopper --debugX

Code: Select all

[root@vici ~]# /usr/share/astguiclient/AST_VDhopper.pl --debugX
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: 2.00|3|1|   GMT: 06:04
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  2
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('999','998');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-09-24 9:01:59' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0

   |GMT-DAY-HOUR|   |13.00-4-1901||12.75-4-1846||12.50-4-1831||12.25-4-1816||12.00-4-1801||11.75-4-1746||11.50-4-1731||11.25-4-1716||11.00-4-1701||10.75-4-1646||10.50-4-1631||10.25-4-1616||10.00-4-1601||9.75-4-1546||9.50-4-1531||9.25-4-1516||9.00-4-1501||8.75-4-1446||8.50-4-1431||8.25-4-1416||8.00-4-1401||7.75-4-1346||7.50-4-1331||7.25-4-1316||7.00-4-1301||6.75-4-1246||6.50-4-1231||6.25-4-1216||6.00-4-1201||5.75-4-1146||5.50-4-1131||5.25-4-1116||5.00-4-1101||4.75-4-1046||4.50-4-1031||4.25-4-1016||4.00-4-1001||3.75-4-946||3.50-4-931||3.25-4-916||3.00-4-901||2.75-4-846||2.50-4-831||2.25-4-816||2.00-4-801||1.75-4-746||1.50-4-731||1.25-4-716||1.00-4-701||0.75-4-646||0.50-4-631||0.25-4-616||0.00-4-601||-0.25-4-546||-0.50-4-531||-0.75-4-516||-1.00-4-501||-1.25-4-446||-1.50-4-431||-1.75-4-416||-2.00-4-401||-2.25-4-346||-2.50-4-331||-2.75-4-316||-3.00-4-301||-3.25-4-246||-3.50-4-231||-3.75-4-216||-4.00-4-201||-4.25-4-146||-4.50-4-131||-4.75-4-116||-5.00-4-101||-5.25-4-46||-5.50-4-31||-5.75-4-16||-6.00-4-1||-6.25-3-2346||-6.50-3-2331||-6.75-3-2316||-7.00-3-2301||-7.25-3-2246||-7.50-3-2231||-7.75-3-2216||-8.00-3-2201||-8.25-3-2146||-8.50-3-2131||-8.75-3-2116||-9.00-3-2101||-9.25-3-2046||-9.50-3-2031||-9.75-3-2016||-10.00-3-2001||-10.25-3-1946||-10.50-3-1931||-10.75-3-1916||-11.00-3-1901||-11.25-3-1846||-11.50-3-1831||-11.75-3-1816||-12.00-3-1801||-12.25-3-1746||-12.50-3-1731||-12.75-3-1716|
   |SELECT * FROM vicidial_call_times where call_time_id='8_20Uhr';|
LocalCallTime No-Call Gap: |43200|2000(20 00)|0800(08 00)|4|3|


regards
philip

[phil_discount]

i don't know why he calculates the gmt? and why 3?

Code: Select all

[root@vici ~]# /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug

-----DEBUGGING -----

STARTING TIME ZONE DAYLIGHT SAVING TIME CALCULATION SCRIPT



SEED TIME  1253829150      :   2009-09-24 23:52:30  LOCAL GMT OFFSET NOW: 3
 - Unique Country dial codes found: 2

RUNNING LOOP FOR COUNTRY CODE:
Area Code Updates: 0
Postal Updates:    0
NANPA Updates:     0

RUNNING LOOP FOR COUNTRY CODE: 1
Area Code Updates: 0
Postal Updates:    0
NANPA Updates:     0

GRAND TOTALS:
Postal Updates:    0
Area Code Updates: 0
NANPA Updates:     0

DONE
     - process runtime      (1 sec) (0.0166666666666667 minutes)

[mflorell]

What is the phones table entry that agent is using set to?

[phil_discount]

some SIP and EXTERNAL phones with GMT 2 too.

[mflorell]

There is a time non-sync issue going on somewhere. I would suggest looking at all server involved and ensuring that all of them are set to the exact same timezone.

[phil_discount]

it's only one server.
i installed vicibox, perhaps the problem is lost.
i will report

[mflorell]

We have a lot of clients in production without this issue that are using ViciBox.

[phil_discount]

in the past i worked with vicidialnow.
I'm working hard to install my sangoma card on vicibox with asterisk 1.4
after that i can say if there is any problem left with the timezone.

[phil_discount]

ok it's working with vicibox.
perhaps i made something wrong in my old installation
thanks a lot!