Displaying 3 results from an estimated 3 matches for "iwmailsystem".
2007 Feb 19
2
NTLM oddities
...rd, v.storeIP AS host,
CONCAT(IF('John' LIKE
'%@%.%',CONCAT(LCASE('John'),''),CONCAT(LCASE('John'),'@',p.host)),'*masteruser')
AS destuser, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS proxy, 'masterpass' AS
pass FROM iwmailsystem.virtmailbox AS v INNER JOIN
iwmailsystem.popserversAS p ON (
p.storeIP = '204.17.177.60') INNER JOIN authenticate.users AS a ON
(a.userID= IF('John' LIKE
'%@%.%',CONCAT(LCASE('John'),''),CONCAT(LCASE('John'),'@',
p.host))) WHERE v.userID = IF(...
2006 Dec 17
1
Proxy with MasterUser + Authentication issues
...9;m running into running RC15:
#1: My Proxy's SQL password_query line:
password_query = SELECT a.clearpasswd AS password, v.storeIP AS host,
CONCAT(v.userID,'*someuser') AS destuser, 'Y' AS nologin, 'Y' AS nodelay,
'Y' AS proxy, 'somepass' AS pass FROM iwmailsystem.virtmailbox AS v NATURAL
JOIN authenticate.users AS a WHERE
v.userID = '%u' and v.imap_active = 1
I'm wanting to authenticate the user on the proxy before I send it off via
the MasterUser to the destination server. However, I show this in the logs:
Info: auth(default): client in: AU...
2007 Jan 02
1
"Not connected to database" MySQL errors
...n
passdb sql {
args = /usr/local/etc/dovecot-sql.conf
}
userdb static {
args = uid=5000 gid=5000 home=/dev/null
}
user = root
# Number of authentication processes to create
count = 10
## dovecot-sql.conf
driver = mysql
connect = host=/tmp/mysql.sock dbname=iwmailsystem user=imap_proxy
password=***** client_flags=65536
default_pass_scheme = MD5
password_query = CALL pop_auth('%u','%l','%r')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dovecot.org/pipermail/dovecot/attachments/20070102/d3c01948/a...