search for: from_unixtime

Displaying 11 results from an estimated 11 matches for "from_unixtime".

2007 Jul 10
0
Plot dies with memory not mapped (segfault) (PR#9785)
...} } # Query for each date segmentation for(k in 1:length(query_dates)) { #for(k in 4:4) { #for(k in 2:2) { QUERY_DATE<-query_dates[k] userTime<-NULL failures<-NULL # Date Clamp Limits Us To The Middle 80% Of All Data usageDateClamp<-paste(" WHERE FROM_UNIXTIME(submit_time) >= (SELECT ", "FROM_UNIXTIME(MIN(submit_time)) + INTERVAL 0.10*", "DATEDIFF(MAX(FROM_UNIXTIME(submit_time)),MIN(FROM_UNIXTIME(", "submit_time))) DAY FROM ",systems[iter],") AND FROM_UNIXTIME(&quo...
2008 Mar 13
2
queue log vs. cdr
Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000 and 20080313145900 group by uniqueid; 219 rows in set (0.19 sec) Thanks! ________________________________________...
2018 Apr 12
0
two unrelated issues, lastlogin, and an out of memory fatal error
...ot. That did it. >> >> Do you have any idea as to my other issue, the fatal out of memory one? >> >> Thanks. >> Dave. >> >> >> On 4/11/18, Reio Remma <reio at mrstuudio.ee> wrote: >>> Hello, try: >>> >>> SELECT userid, FROM_UNIXTIME(last_login) FROM users; >>> >>> Reio >>> >>> On 11.04.2018 21:39, David Mehler wrote: >>>> Hi, >>>> >>>> Can I get the database display to display those timestamps in a >>>> particular format? >>>> >&...
2019 Jun 22
1
last login user tracking
On 22/6/2019 16:07, John Fawcett via dovecot wrote: > > You can easily view the value in a readable format with the > FROM_UNIXTIME mysql funciton > > https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime > > To get remote ip > > define the rip field in your table and add it to the primary key > > add %r to the last_login_key > > last_login_key = last-logi...
2010 Dec 01
0
Problem with Queue_log and CDR.
...ers without problems. With this another SELECT [2], I get the events Abaddon normally. With this other [3] I can get all the channels that joined the queue with no problems. Both tables are recording normally and Asterisk has no errors in the logs. Only happens with the event Abandon. [1] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql WHERE c.uniqueid = ql.callid AND ql.event = 'ABANDON'; [2] SELECT * FROM queue_log WHERE event = 'ABANDON'; [3] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql WHERE c.uniqueid = ql.callid AND ql.event = ...
2019 Jun 21
3
last login user tracking
Hello, I'm trying to get last login user tracking going, using Dovecot and mysql. I'm using: https://docs.iredmail.org/track.user.last.login.html and it is working, I am seeing an entry and it is updated, the problem is the last login value does not mean anything to me. I was wondering if it's possible to have the value be of a last login date and time, and also a remote ip would be
2009 Jul 23
8
expire plugin no delete 1.2.1
Hi Timo, all of my tests fail with expire plugin, mail simply not get deleted i cant find any stuff in the logs why it does not or should not work. My guess that there is a problem with virtual plugin and/or shared namespace. It shouldnt be a problem with acl starting the script over cron as root am i right ? do you have any idea why it fails, is there a way to ignore all unneeded shared or
2018 Apr 11
3
two unrelated issues, lastlogin, and an out of memory fatal error
Hello Aki, Thanks for your suggestion. I followed it and the wiki at: https://wiki.dovecot.org/Plugins/LastLogin Good news, I get a record in the users table, with the username that just logged in. This is good. Bad news is I got unexpected output from the last_login time stamp. Here's the table and the user: mysql> describe users;
2019 Jun 22
0
last login user tracking
...anything to me. I was wondering > if it's possible to have the value be of a last login date and time, > and also a remote ip would be helpful so I can see from where users > are logging in from. > > Thanks. > Dave. You can easily view the value in a readable format with the FROM_UNIXTIME mysql funciton https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime To get remote ip define the rip field in your table and add it to the primary key add %r to the last_login_key last_login_key = last-login/%u/%d/%r add $rip to the pattern and fields sec...
2003 Aug 13
1
How do i configure so an incoming call triggers an http request?
Hi all, I'm about to start setting up my first asterisk/cti system in our test lab. I've read through all the documentation I can find and relevant posts in the list archives but can't seem to find anything explaining how to go about initiating an http request upon an incoming call. I basically want asterisk to request an uri on our intranet, which will pass call details to our
2019 Nov 12
3
CDR extract call numbers on interval on unique callers
hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are