[Spce-user] Call reminder does not work

[Marcos Pytel]

Hi!

 

This is the script: 

 

SELECT a.username, b.domain, c.recur, c.id

FROM voip_subscribers a, voip_domains b, voip_reminder c,

     billing.v_subscriber_timezone t

WHERE c.subscriber_id = a.id

  AND a.domain_id = b.id

  AND t.uuid = a.uuid

  AND c.time = time_format(CONVERT_TZ(now(), "localtime", t.name),
'%H:%i:00')

  AND c.active = 1;

 

t.name = "America/Argentina/Buenos_Aires"

 

MariaDB [provisioning]> select now();

+---------------------+

| now()               |

+---------------------+

| 2019-03-01 11:05:01 |

+---------------------+

 

MariaDB [provisioning]> select localtime();

+---------------------+

| localtime()         |

+---------------------+

| 2019-03-01 11:07:13 |

+---------------------+

1 row in set (0.00 sec)

 

root at spce:~# date

Fri Mar  1 11:05:19 -03 2019

 

root at spce:~# cat /etc/timezone 

America/Argentina/Buenos_Aires

 

MariaDB [provisioning]> select CONVERT_TZ(now(), "localtime",
"America/Argentina/Buenos_Aires");

+------------------------------------------------------------------+

| CONVERT_TZ(now(), "localtime", "America/Argentina/Buenos_Aires") |

+------------------------------------------------------------------+

| 2019-03-01 07:06:31                                              |

+------------------------------------------------------------------+

1 row in set (0.00 sec)

 

I dont know why the CONVERT is changing the time!

 

Thank you guys.

Marcos.

 

 

 

De: Marcos Pytel <marcos.pytel at cotesma.com.ar> 
Enviado el: viernes 1 de marzo del 2019 10:16
Para: 'spce-user at lists.sipwise.com' <spce-user at lists.sipwise.com>
Asunto: Call reminder does not work

 

 

Hi,

 

I set the call reminder, but the call never is executed.

In the db, the entry for the reminder does not change, is "active" = 1

The system time looks ok.

 

I'm using mr7.0.2

 

Thanks,

Marcos.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20190301/fe1d5911/attachment-0001.html>