search for: unixtime

I'm new at R ... I've not done for loops in R - so this is very new to me. One of our students has a data frame that contains two columns data 1. unixtime time of an event (in unix time - #of seconds) 2. duration of event in seconds. We need to create new data - the unixtime (seconds) that these events occurred. We want to create a for loop (or nested for loops) that goes through the first column, and then creates a new unixtime value for each s...

...sets that come from databases. I'm using R 2.2.0 with the DBI package (0.1-9) and the RMySQL package (0.5-5). My get-my-feet-wet-with-R project is to make a histogram from a data set stored in a MySQL database. In particular, I have a table that describes some observed spam emails. The 'unixtime' column of the table contains the timestamps of the messages. My current goal is to plot the number of spams per day during the recording period. So far, this is my script (edited for brevity), and it works well: ----- library(RMySQL) drv <- dbDriver("MySQL") con <- dbConnect...

Hi, is there an R function to convert unixtime to one of the R time formats (using chron or POSIXct)? Example data: unixtime year month day hour 1183377301 2007 7 2 13 I would like to only use the first column. If such a function does not exist: What would be a good input format for R (I could parse the...

...see the hours also. 2. length(zeit) gives mit the length of one entry. But zeit exists of 500 entries. How can i get the amount of entries zeit got? 3. Im used to draw whith lines() into an existing plot. But something like lines(zeit,food) wouldnt work. All this works quit well, when Im using unixtime. But seconds since 1970 are not that nice on the x-achis:-) Regards Erkan Yanar -- ?ber den grenzen mu? die freiheit wohl wolkenlos sein

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...

In a quest to remove ?duplicate? messages sent to both me and lists I subscribe to I came up with this, which I think should clean out my Archive folder, but I?ve been unable to get it to work for scanning all on my list-user email. $ doveadm -f table fetch -u kremels 'hdr.message-id guid uid hdr.x-listname' mailbox "Archive" | sort| awk 'cnt[$1]++{if (cnt[$1]==2) print

...from doveadm if you specify an invalid field is: Available fetch fields: hdr.<name> body.<section> binary.<section> user mailbox mailbox-guid seq uid guid flags modseq hdr body body.snippet text text.utf8 size.physical size.virtual date.received date.sent date.saved date.received.unixtime date.sent.unixtime date.saved.unixtime imap.envelope imap.body imap.bodystructure pop3.uidl pop3.order refcount storageid >> First, even after expunging a message and running doveadm index -u >> kremels ?Archive?, subsequent runs still show the same duplicate >> messages. > &...

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

Hello all, On my system, some users have expire day user settings. I write a (python) script then parse the: 7.th selection in the master.passwd blabla:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:1064005200:xxxx:xxxx:xxxx:xxxx How can I conver the number like 1064005200 to human readable date format ? Or, there is a way to collect the information from a command interactively ? Regards, Murat Ustuntas

...o_ticket + imap/pop3/managesieve-login: Added postlogin_socket=path passdb extra field. This allows replacing the default service imap/pop3/managesieve {} settings for specific users (e.g. running their imap process via valgrind or strace). + doveadm fetch: Added date.sent/received/saved.unixtime + fs-posix: Added mode=auto parameter to set the created files' and directories' mode based on the parent dir if it has setgid-bit. + director: Support backends having hostnames, which makes it possible to verify their SSL certificates. - director: Directors' state became desyn...

...o_ticket + imap/pop3/managesieve-login: Added postlogin_socket=path passdb extra field. This allows replacing the default service imap/pop3/managesieve {} settings for specific users (e.g. running their imap process via valgrind or strace). + doveadm fetch: Added date.sent/received/saved.unixtime + fs-posix: Added mode=auto parameter to set the created files' and directories' mode based on the parent dir if it has setgid-bit. + director: Support backends having hostnames, which makes it possible to verify their SSL certificates. - director: Directors' state became desyn...

...hing 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...

Hi folks, i have some problems with my evaluation. We have collect tons of data from 23 testpersons for our new road study. I have now a time series for each person and all the logs when he accelerates or hits the break trying to solve five different tasks. The dataset lools like: # Unixtime time accelerate break UserID task #10372 1312358742 10:05:41.600 3.054 0.000 2 "lane" #10373 1312358742 10:05:41.700 3.056 1.000 2 "emergency" The break variable is binary and i want to test if...

...crated ID's and if this id is randomly crated number then there is a chance that unequeid get a duplicate entry.</font></font></span></div> <div><font>&nbsp;</font></div> </blockquote> <br> The uniqueid&nbsp; is the based on unixtime and a sequence number since * was started&nbsp; so yes you can thrust uniqueid as long as you have one * server.<br> I do use 'SetCDRUserField' to add 'uname' into the billing stream. Uname.uniqueid&nbsp; is a safe key for the CDR's.<br> Freddi<br> <...

Hello everyone, This is is my first email to this group. I'm am writing a small php program to pull some info out of our Asterisk's queue_log. I'm having trouble figuring out what some of the parameters mean. Here's an example: 1118098465|1118098465.47|salesq|NONE|ENTERQUEUE||"Ray Balbin 25" <(716)250-3405> I found a doc that tells me about everything from

Hi, How do I read (make sense of) the timestamp in the queue_log? I'm probably just slow but I don't understand it. Thanks! Regards, Jan

...t;somenumber>/60/L(3600000)M(td|${EPOCH}) where 60 is the seconds to wait for the callee (the called party) to answer L(3600000) is the absolute limit of the call once it has been answered, in ms M(td|${EPOCH}) is the macro to execute when the call gets answered. ${EPOCH} contains the current unixtime. That's the macro: [macro-td] exten => s,1,Set(myDiff=${MATH(${EPOCH}-${ARG1},i)}) exten => s,n,NoOp(${myDiff}) exten => s,n,GotoIf($[${myDiff} < 4]?hu:he) exten => s,n(hu),Set(TIMEOUT(absolute)=6) exten => s,n(he),NoOp(${myDiff}) where: exten => s,1,Set(myDiff=${MATH(${...

I have been monitoring AMI events and realized that they don't have timestamps. Is that standard behaviour, or is there some way to get them to include timestamps? I am on 1.4. Is it available on 1.6?

Hi, i have samba 3.0.10 installed with LDAP. I noticed few days ago that my adminsitrator account has expired. I think it's because of the sambaPwdMustChange field of LDAP. I changed the passwd now i have the value 1108741705 in it. What does it mean (when will i be prompted again to change my passwd) and do i have to put in this field so that the password will never expire ? Thanks for

...o_ticket + imap/pop3/managesieve-login: Added postlogin_socket=path passdb extra field. This allows replacing the default service imap/pop3/managesieve {} settings for specific users (e.g. running their imap process via valgrind or strace). + doveadm fetch: Added date.sent/received/saved.unixtime + fs-posix: Added mode=auto parameter to set the created files' and directories' mode based on the parent dir if it has setgid-bit. + director: Support backends having hostnames, which makes it possible to verify their SSL certificates. - director: Directors' state became desyn...