similar to: last_logon SQL mapping

Hello I have this little dataset, my goal is create one column in the data.frame with between the diference DataTime and Duration. I'm using the next code to make do this TIME_STAMP SESSIONTIME Time TimeStart 1162343932 8320 2006-10-31 19:01:34 2006-10-31 16:42:54 1162343215 592 2006-10-31 19:02:04 2006-10-31 18:52:12 1162341465 11875

Hi, I''m using postgresql 8.1, rails 1.0, and I have a strange problem on a datetime field (timestamp without time zone in postgresql). As shown below, the field "value" sometimes returns a string, and sometimes a Time instance, depending of where the value is used....: * breakpoint session _from inside an instance method_ of the object: value => "1996-05-01

I''ve commited code for win32-etc 0.2.2, which adds the configure_user and configure_group methods. Testing appreciated. On my home system, I can''t get configure_user to work, but I haven''t any real idea why it fails. The configure_group method seems to work fine, however. Dan _________________________________________________________________ Fast. Reliable. Get

Can someone tell me what has to happen to get the aliases working in samba? Below is an earlier posting. Thanks!! Does anyone have aliases working correctly? Suppose I am moving the samba to one server to another, say VIPER > to JOKER. > > In smb.conf I change the 'netbios name = VIPER' to JOKER > and I also want the old name to be seen as well. To do this > I create

Device manufacturer: Fideltronik INIGO Device name: Viper 1200 Device type: UPS Bus type: USB WWW: http://fideltronikinigo.com/viper/viper-1200/ " nut-scanner -U" output: [nutdev1] driver = "blazer_usb" port = "auto" vendorid = "0001" productid = "0000" product = "MEC0003" vendor =

Hi all, i've installed Delphi7ENT and DevExpr_v45 components on wine. When i launch delphi i get this error: Can't load package C:\Programmi\DevExpress\Library\Delphi7 \dclcxPivotGridD7.bpl. I get this for each .bpl in C:\Programmi\DevExpress\Library\Delphi7\ It seems like delphi can't find them, but every file is present, readable and executable. Any ideas? Delphi 7 Enterprise

Dear R experts, I have a problem in modifying one column of a dataframe with a datatime format using a datetime operator. Here is my dataframe A: DATACONT PROVINCIA VALORE 1 2007-12-31 MI 1 2 2007-12-31 PV 2 3 2007-12-31 NA 3 4 2007-12-31 MI 4 5 2007-12-31 RM 5 6 2007-12-31 RM 6 7 2007-12-31 MI 7 8

Okay, I've narrowed the problem down quite a bit. As previously reported, in CentOS 5.2 I get this: $ cvs log Makefile poll: protocol failure in circuit setup cvs [log aborted]: end of file from server (consult above messages if any) Turns out this is a problem with rsh: $ rsh khan ls connect to address 10.24.15.48 port 544: Connection refused Trying krb4 rsh... connect to address

Hi, I have a strange problem with a Windows Server 2008 R2-System as a member of a samba domain (Samba-Version on PDC: 3.4.12). Join was successfully, but when I log on Windows I got an error "Unknown user name or bad password." (Event ID 4625). Here an abstract of logfile for Windows Server 2008 R2-System (log level 10). Maybe some of you has an idea:

http://bugs.freedesktop.org/show_bug.cgi?id=12056 Summary: "Error initialising the nouveau kernel module: -16" on GF6100 Product: xorg Version: git Platform: Other OS/Version: All Status: NEW Severity: normal Priority: medium Component: Driver/nouveau AssignedTo:

Hello folkz, Is it possible to setup in dovecot-sql.conf file to run user_query twice if its first run didn't yield any values. And likewise don't proceed with the second run if the first user_query execution produced the result. I have to query two tables which specify there email messages shall be delivered via Dovecot deliver LDA depending on the incoming email addresses. Please

Dear all, This is the first time I am sending mail to the mailing list, so I hope I do not make a mistake... The last months I have been working on my MSc thesis project on performing data mining techniques on user logs of a software-as-a-service application. The main problem I am experiencing is how to process the huge amount of data. More specifically: I am using R 2.10.1 in a laptop with

Hi; As a prerequisite for IBM's db2 Viper they say: "For RHEL, all available compat-libstdc ++ RPM-packages must be installed." Can anyone please advise how to achieve this quickly via yum? (64bit software running on 64bit centos 4.3.) Thanks; nat

Hi, in my current setup, LDAP authentication + userdb works fine. I'd like to integrate Dovecot with Shibboleth. I have a custom module at the IdP (*) that inserts short-time tokens to an SQL table at user authentication, and I want Dovecot to use the token table for passdb but keep LDAP for storing the userdb (uid, quota, etc) I thought it was simple as omitting the sql user_query, but I

I have been running Postfix/Dovecot with a Postgresql backend for several months, and everything has been running great. Now I want to add server side filtering, so I'm attempting to configure deliver. The SQL maps for Postfix are all keyed upon the recipient email address. The SQL map (user_query) for Dovecot is keyed upon the IMAP login name, which is potentially unrelated to the email

I need pop-before-smtp (let's not discuss the advisability of the method), but I'm annoyed at the inefficiency of the classical perl script that parses the logs. A long time ago I modified the perl to add the tuple (IP, time) to an SQL table that the MTA looks at, and to clean up periodically. I found that this was the best way to deal with multiple servers that have to share an SQL

We have about 4 servers connected to an APC UPS. The UPS only has one UPS connection. So my question is, in a power outage how do i get all my servers to safely shutdown? Do i run a USB hub? Do i write a script on the one machine connected to turn off all the other machines? I'm confused. Jamie

Dovecot (1.1.1) criticises a sql user_query that's working on the sql console and thats correct. DOVECOT-LOG: "dovecot: Jul 06 22:58:29 Error: auth(default): sql(nti): User query failed: ERROR: syntax error at or near "mbox" dovecot: Jul 06 22:58:29 Error: auth(default): LINE 1: ...gid, home, (CASE WHEN smtp like '/var/pop3/ THEN 'mbox:' || ..." QUERY:

Currently I'm using user_query = SELECT 1000 AS uid, 1000 AS gid, '/srv/vmail/%2.256Hu/%Lu' AS home, ... so I'm hashing based on %u (basically). But in my SQL db I have a "unique_identifier" field, which never changes, even when the user is changing his/her email address (due to marriage or the like). What I'd really like to do is to use %u to find the value of the

Hello, I'm trying to setup a dovecot imap server. version is 2.0.9 I've setup a mysql database using: user_query = \ SELECT home, uid, gid, home as userdb_home, uid as userdb_uid, gid as userdb_gid, \ FROM user WHERE username = '%n' AND domain = '%d' AND active = 'Y' password_query = \ SELECT username AS user, password, home as userdb_home, uid as