[asterisk-bugs] [JIRA] (ASTERISK-27174) res_calendar_icalendar: Recurring events not being loaded from Google calendar using ical

Mon Aug 7 18:20:08 CDT 2017

     [ https://issues.asterisk.org/jira/browse/ASTERISK-27174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Thompson updated ASTERISK-27174:
-------------------------------------

    Status: Waiting for Feedback  (was: Waiting for Feedback)

Hi Rusty,

Thanks for picking up on this. Is the information below enough for clarity? The problem, on this end, is continuously reproducible. Let me know what else would be helpful.

Hardware
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
root at pstarspbx:~#  uname -r
3.13.0-125-generic

root at pstarspbx:~# lshw
pstarspbx                 
    description: Mini Tower Computer
    product: OptiPlex 760 ()
    vendor: Dell Inc.
    serial: 366S9K1
    width: 64 bits
    capabilities: smbios-2.5 dmi-2.5 vsyscall32
    configuration: administrator_password=disabled boot=normal chassis=mini-tower power-on_password=disabled uuid=44454C4C-3600-1036-8053-B3C04F394B31
  *-core
       description: Motherboard
       product: 0M858N
       vendor: Dell Inc.
       physical id: 0
       version: A00
       serial: ..CN1374094R0117.
     *-firmware
          description: BIOS
          vendor: Dell Inc.
          physical id: 0
          version: A05
          date: 08/17/2009
          size: 64KiB
          capacity: 4032KiB
          capabilities: pci pnp apm upgrade shadowing escd cdboot bootselect edd int13floppytoshiba int13floppy720 int5printscreen int9keyboard int14serial int17printer acpi usb biosbootspecification netboot

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Asterisk 13.15.0    Incredible GUI 12.0.30
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

/etc/asterisk/calendar.conf
[eventscal]
type = ical
url = https://calendar.google.com/calendar/ical/eventscal%40gmail.com/public/basic.ics
user = eventscal at gmail.com
secret = XXXXXXXXXXXXXXXXXXX
refresh = 15
timeframe = 11520

/etc/asterisk/extensions-custom.conf
[from-internal-custom]
;# // Events today - TTS appication
exten => 795,1,Answer
exten => 795,n,Wait(1)
exten => 795,n,Set(DayEnd=${STRFTIME(${EPOCH},,%Y-%m-%d 23:59:59)})
exten => 795,n,Set(EpochDayEnd=${STRPTIME(${DayEnd},,%Y-%m-%d %H:%M:%S)})
exten => 795,n,Set(id=${CALENDAR_QUERY(eventscal,${EPOCH},$[${EpochDayEnd}])})
exten => 795,n,Set(num=${CALENDAR_QUERY_RESULT(${id},getnum)})
exten => 795,n,Set(i=1)
exten => 795,n,agi(googletts.agi,"Today's events and music",en-US)
exten => 795,n,ExecIf($[${num}=0]?agi(googletts.agi,"No events are currently scheduled for today.")
exten => 795,n,While($[${i} <= ${num}])
exten => 795,n,SayUnixTime(${CALENDAR_QUERY_RESULT(${id},start,${i})},,q 'digits/at' IMp)
exten => 795,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},summary,${i})}",en-US,,1.1)
exten => 795,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},description,${i})}",en-US)
exten => 795,n,Set(i=$[${i} + 1])
exten => 795,n,EndWhile
exten => 795,n,Goto(790,1)
exten => 795,n,Hangup()

;# // Events tomorrow
exten => 793,1,Answer
exten => 793,n,Wait(1)
exten => 793,n,Set(DayEnd=${STRFTIME(${EPOCH},,%Y-%m-%d 23:59:59)})
exten => 793,n,Set(EpochDayEnd=${STRPTIME(${DayEnd},,%Y-%m-%d %H:%M:%S)})
exten => 793,n,Set(id=${CALENDAR_QUERY(eventscal,$[${EpochDayEnd}],$[${EpochDayEnd}+24*60*60])})
exten => 793,n,Set(num=${CALENDAR_QUERY_RESULT(${id},getnum)})
exten => 793,n,Set(i=1)
exten => 793,n,agi(googletts.agi,"Tomorrow's events and music",en-US)
exten => 793,n,ExecIf($[${num}=0]?agi(googletts.agi,"No events are currently scheduled for tomorrow.")
exten => 793,n,While($[${i} <= ${num}])
exten => 793,n,SayUnixTime(${CALENDAR_QUERY_RESULT(${id},start,${i})},,q 'digits/at' IMp)
exten => 793,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},summary,${i})}",en-US,,1.1)
exten => 793,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},description,${i})}",en-US)
exten => 793,n,Set(i=$[${i} + 1])
exten => 793,n,EndWhile
exten => 793,n,Goto(790,1)
exten => 793,n,Hangup()

;# // Events upcoming week
exten => 791,1,Answer
exten => 791,n,Wait(1)
exten => 791,n,Set(DayEnd=${STRFTIME(${EPOCH},,%Y-%m-%d 23:59:59)})
exten => 791,n,Set(EpochDayEnd=${STRPTIME(${DayEnd},,%Y-%m-%d %H:%M:%S)})
exten => 791,n,Set(id=${CALENDAR_QUERY(eventscal,$[${EPOCH}],$[${EpochDayEnd}+8*24*60*60])})
exten => 791,n,Set(num=${CALENDAR_QUERY_RESULT(${id},getnum)})
exten => 791,n,Set(i=1)
exten => 791,n,agi(googletts.agi,"Events and music for the next 7 days",en-US)
exten => 791,n,ExecIf($[${num}=0]?Playback(from))
exten => 791,n,While($[${i} <= ${num}])
exten => 791,n,SayUnixTime(${CALENDAR_QUERY_RESULT(${id},start,${i})},,ABd 'digits/at' IMp)
exten => 791,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},summary,${i})}",en-US,,1.1)
exten => 791,n,agi(googletts.agi,"${CALENDAR_QUERY_RESULT(${id},description,${i})}",en-US)
exten => 791,n,Set(i=$[${i} + 1])
exten => 791,n,EndWhile
exten => 791,n,Goto(790,1)
exten => 791,n,Hangup()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Google calendar "Events" is public. Recurring events were successfully displayed in FullCalendar (while not showing up in Asterisk), however, I do not have that hosting environment currently set up.

> res_calendar_icalendar: Recurring events not being loaded from Google calendar using ical
> -----------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-27174
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27174
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_calendar_icalendar
>    Affects Versions: 13.15.0
>         Environment: IncrediblePBX 13-12.3 for Ubuntu 14, Linux  3.13.0-125-generic #174-Ubuntu SMP Mon Jul 10 18:51:24 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>            Reporter: Mark Thompson
>            Assignee: Mark Thompson
>            Severity: Minor
>
> type = ical
> Calendar functions okay with single events. All single events in the configured timeframe are listed in "calendar show calendar <calendar name>". For recurring events only the initial event is listed. All other events in the series are omitted. This problem has been reported at least twice in the Asterisk forums:
> https://community.asterisk.org/t/google-calendar-integration-missing-periodic-events/48338
> https://community.asterisk.org/t/google-calendar-integration-repeat-events-not-retrieved/69957
> Note that I had a workaround of switching calendar type from "ical" to "caldav" (along with the appropriate url). However, caldav no longer works due to unknown certificate rejection errors.

--
This message was sent by Atlassian JIRA
(v6.2#6252)