similar to: Variable '%r' doesn't transfomr in Postgres query

Hi, I am wondering if it's possible to authenticate users that come from specific IP differently then other users. I will be authenticating them by postgresql so something like this would be very useful: password_query = SELECT password from get_user('%username','%host') Is that possible? Can it be done any other way? Thanks, Sebastjan

Hello, I have a postgresql database which contains users that will access dovecot, but their passwords are hashed and I don't have them in plain text. I was reading documentation that you can add tell dovecot which password scheme should it use. For example: password_query = "select '{MD5}'||password from users where userid=%u" Which would mean that dovecot will hash the

Hi, I'm trying to decide if I could use you mail server in our enviroment which has about 10k users and mailboxes size about ~1GB. So I made a few tests and it all worked quite fast, except that select command on large mailboxes. The first time I select a mailbox which has 10k messages it takes about 4s to process. I am deliberately trying this on a Celeron 850Mhz, 512 MB memory and some

Is there a way to list all keywords a mailbox uses? I fetch flags for all messages and then gorup them, but this is a very nasty solution. What's the situation with full text search? Will it ever be implemented? Is it already? Text search on my 0.99.14 is quite slow. Don't understand why no IMAP server wants to implement this feature. Does Dovecot support plugins? Thank you, Sebastjan

Hi, I have a few questions regarding copy and save_finish methods. How can I get a filename or processing mail from the parameters you get in that methods? How could I use the logger you use for dovecot inside my plugin? Thanks, Sebastjan -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, is there a quick way to disable keyword feature in dovecot? Thanks, Sebastjan

Hi, I'm trying to add a code in dovecot that will notify my services when a message is updated/added/moved/copied. I checked dovecot code a bit and mail-storage.c seems to be a nice place for tracking but I'm not sure if I can track all changes there. Does anyone have any experience with this topic or ideas? Thanks, Sebastjan -------------- next part -------------- An HTML

Hi, when I try to copy/move messages with keywords, IMAP process dies: dovecot: Jul 24 23:49:47 Info: imap-login: Login: user=<seba>, method=PLAIN, rip=192.168.0.192 <http://192.168.0.192>, lip=192.168.0.188<http://192.168.0.188> dovecot: Jul 24 23:49:47 Info: IMAP(seba): Effective uid=1000, gid=100 dovecot: Jul 24 23:49:47 Info: IMAP(seba): maildir: data=/home/seba/Maildir

Hi, is it possible to configure dovecot so that users from a specific IP (let's say 127.0.0.1) don't have to send password? They would be authenticated no matter if passwords match or not. Thanks, Sebastjan

Hi, while implementing thread support in our mail application I found a bug which kills IMAP(alpha5, SUSE 10) process... These are the commands: x OK Logged in. x select INBOX * FLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk $Forwarded Spam) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk $Forwarded Spam \*)] Flags permitted. * 2280 EXISTS * 1 RECENT *

Hi List Anybody could tell me how to set per-user quota with dovecot-lda? Thank in advance.

Hello everyone: I have a problem with the shorewall configuration. Let''s me tell you. I have installed shorewall 2.0.4 into a machine with 2.6.8 kernel. This machine works like a software-router: it has 2 netcard eth0 goes to the local network 192.168.0.0/24 eth1 is an interface for ppp0 (there is an ADSL conected) I have defined the Network Zones (net, loc); The Network Interfaces

Hello, I try to test joining new RODC (samba-tool domain join unn.global RODC -U Administrator -d5) and it's fail with message: Could not find machine account in secrets database: Failed to fetch machine account password for UNN from both secrets.ldb (Could not find entry to match filter: '(&(flatname=UNN)(objectclass=primaryDomain))' base: 'cn=Primary Domains': No

hi users! i'm trying to Install a new version of samba (samba-2.2.8a) since tree days! i have a Suse linux 8.2 Server and in my Server run alredy samba-2.2.7 ( smbd and nmbd run in /etc/samba) I 'v installed and configured now samba in the /usr/local/src/samba-2.2.8a/ directory like this : ./configure --sysconfdir=/etc/samba --localstatedir=/var/log/samba --mandir =/usr/local/man

Hi, I'm a new R user, with a lot of questions. At the moment I'm stoped on an error traying to fit a model: > x <- sandeel ## numeric data (2500-60000) > y <- Noss ## numeric data (0-1.2) > A <- 0.8 > B <- 0.6 > C <- 1/40000 > nls( y ~ A-B*exp(-C*x)) Error in match.call(definition, call, expand.dots) : .Primitive... is not a function I'm

5.6 is out. That is good news. I did a yum update on one of my non-critical server, and the server stoped responding to ping after the reboot, and never answered back. It's now been 10 minutes, so I'll have to take a ride to the colo... Nice work dev team, keep up the good work. Let's hope that C6 will come soon ! I'm eager to upgrade.

>-----Original Message----- >From: John Hodrien <J.H.Hodrien at leeds.ac.uk> >To: CentOS mailing list <centos at centos.org> >Sent: Tue, Feb 23, 2016 12:06 pm >Subject: Re: [CentOS] CentOS install disable USB keyboard on Acer AXC 603G UW13 > >On Tue, 23 Feb 2016, Juan De Mola wrote: > >> CentOS 6 has problems printing when the Internet goes down. And 7 is

I upgraded to beta7 from alpha4, and got this error during the auth process: dovecot: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=0.0.0.0 rip=0.0.0.0 resp=<hidden> dovecot: auth-worker(default): sql(webmaster at example.com,0.0.0.0): query: SELECT username as user, NULL as password FROM users WHERE username = 'webmaster at example.com' AND

Thank you Rowland! "Stop any running Samba binaries" resolved my problem. Actually I was only stoping Samba4 service before "make install" but this time also stoped named (dns) service as well. After "make install" named was working well but samba given alot of errors when i run ./samba-tool dbcheck Than I restarted the server and samba came back :) Nov 20 02:06:19

Hi, I am working through setting up a virtual hosting system using Dovecot, Postfix and Postgres on a CentOS 5 box running an install of the dovecot-1.0-1.2.rc15.el5 RPM. The question I have is, given this password_query SELECT clause, which all return valid values from the database: user password domain can I use a %d in the WHERE clause of my user_query? The reason I ask is that the