Displaying 17 results from an estimated 17 matches for "pw_clear_passwd".
2018 Oct 04
3
vpopmail
...ain_tld'. So, we're limited to these
configurations (no dovecot-mysql.conf.ext) : passdb { args =
cache_key=%u webmail=127.0.0.1 driver = vpopmail } userdb { args
= cache_key=%u quota_template=quota_rule=*:backend=%q driver =
vpopmail } If there is a clear text password (pw_clear_passwd)
present it seems that Dovecot will use that instead of using the hash
(pw_passwd). It seems that in the code 'passdb-vpopmail.c' (below)
that if the clear password (pw_clear_passwd) is present Dovecot skips
the hashed password (pw_passwd), and we want authentication against
the...
2018 Oct 04
2
vpopmail
...t;
>> passdb {
>> args = cache_key=%u webmail=127.0.0.1
>> driver = vpopmail
>> }
>>
>> userdb {
>> args = cache_key=%u quota_template=quota_rule=*:backend=%q
>> driver = vpopmail
>> }
>>
>> If there is a clear text password (pw_clear_passwd) present it
>> seems that Dovecot will use that instead of using the hash
>> (pw_passwd).
>>
>> It seems that in the code 'passdb-vpopmail.c' (below) that if the
>> clear password (pw_clear_passwd) is present Dovecot skips the
>> hashed password (...
2018 Oct 04
2
vpopmail
Quoting Aki Tuomi <aki.tuomi at open-xchange.com>:
> On 03.10.2018 23:30, Eric Broch wrote:
>> Hello list,
>>
>> I run Dovecot with the vpopmail driver and have found that it
>> authenticates against the clear text password in the vpopmail
>> database. Is there a configuration option either at compile time, link
>> time, or a setting in one of the
2018 Oct 04
0
vpopmail
...ydomain_tld'.
So, we're limited to these configurations (no dovecot-mysql.conf.ext) :
passdb {
args = cache_key=%u webmail=127.0.0.1
driver = vpopmail
}
userdb {
args = cache_key=%u quota_template=quota_rule=*:backend=%q
driver = vpopmail
}
If there is a clear text password (pw_clear_passwd) present it seems that Dovecot will use that instead of using the hash (pw_passwd).
It seems that in the code 'passdb-vpopmail.c' (below) that if the clear password (pw_clear_passwd) is present Dovecot skips the hashed password (pw_passwd), and we want authentication against the hashed pas...
2018 Oct 04
0
vpopmail
...NO????? PRI???? NULL
pw_passwd?????? char(40)??????? YES???????????? NULL
pw_uid? int(11) YES???????????? NULL
pw_gid? int(11) YES???????????? NULL
pw_gecos??????? char(48)??????? YES???????????? NULL
pw_dir? char(160)?????? YES???????????? NULL
pw_shell??????? char(20)??????? YES???????????? NULL
pw_clear_passwd char(16)??????? YES???????????? NULL
As you can see there is no 'pw_domain' field from which to draw.
Again we are limited to the passdb, and userdb options already described.
> When configuring vpopmail for our purposes we use (now) the
> configuration option:
>
> --disa...
2018 Oct 04
0
vpopmail
...; args = cache_key=%u webmail=127.0.0.1
>>> driver = vpopmail
>>> }
>>>
>>> userdb {
>>> args = cache_key=%u quota_template=quota_rule=*:backend=%q
>>> driver = vpopmail
>>> }
>>>
>>> If there is a clear text password (pw_clear_passwd) present it
>>> seems that Dovecot will use that instead of using the hash
>>> (pw_passwd).
>>>
>>> It seems that in the code 'passdb-vpopmail.c' (below) that if the
>>> clear password (pw_clear_passwd) is present Dovecot skips the
>&g...
2008 Mar 24
1
Authentication: Dovecot -> Vpopmail - > MySQL with one table per domain
...r current) backed by MySQL with one table per
domain (--disable-many-domains) . What I cannot figure
out is how to have Dovecot authenticate to Vpopmail
when Vpopmail uses one table per domain. Basically I
need dynamic SQL in the Dovecot-sql.conf file.
Currently I have:
password_query = select pw_clear_passwd as password
from domainname_com where pw_name = '%n'
I need something like
password_query = select pw_clear_passwd as password
from %d where pw_name = '%n'
Where %d is the name of the table. I can't use the
exact domain name at it will not match the vpopmail
format domai...
2011 Apr 25
1
dovecot lda aliases doesn't work
...resses but couldn't find forwarding
addresses.
This is my /usr/local/etc/dovecot-sql.conf:
driver = mysql
connect = host=localhost user=vpopmailuser password=vpopmailpassword
dbname=vpopmail
default_pass_scheme = PLAIN
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND
pw_domain = '%d'
user_query = SELECT pw_dir as home, 89 AS uid, 89 AS gid FROM vpopmail
WHERE pw_name = '%n' AND pw_domain = '%d'
It is querying vpopmail table all the time but forwarding addresses are
in the val...
2010 Oct 07
1
Qmail+Vpopmail+Mysql+Dovecot 2.x (Notes on a successful conversion)
...lapse the tables.
2. Switch to mysql authentication. The following snippet works well.
driver = mysql
connect = host=/var/run/mysqld/mysqld.sock user=vpopmail
password=YOURPASS dbname=vpopmail
default_pass_scheme = PLAIN
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND
pw_domain = '%d'
user_query = SELECT pw_dir as home, 1008 AS uid, 1003 AS gid FROM
vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'
3. When integrating Sieve, vpopmail apparently needs to own auth-master
and a...
2008 Jan 25
2
proxy logging
...b:
driver: sql
args: /etc/dovecot-sql.conf
userdb:
driver: static
args: uid=0 gid=0
plugin:
quota: maildir
mail_log_events: delete undelete expunge copy mailbox_delete
mailbox_rename
mail_log_fields: uid box msgid size
/etc/dovecot-sql.conf:
password_query = SELECT pw_clear_passwd AS password, pw_domain AS
domain, '192.168.224.2' AS host, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS
proxy FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d' limit 1
2016 Dec 13
0
replication and backend vpopmail
...| int(11) | YES | | NULL | |
| pw_gid | int(11) | YES | | NULL | |
| pw_gecos | char(48) | YES | | NULL | |
| pw_dir | char(160) | YES | | NULL | |
| pw_shell | char(20) | YES | | NULL | |
| pw_clear_passwd | char(16) | YES | | NULL | |
+-----------------+-----------+------+-----+---------+-------+
8 rows in set (0.00 sec)
MariaDB [vpopmail]>
Thank you.
Havrla
2017 May 12
0
Dovecot 2.2.29.1 + VPopMail 5.4.33
Hi all,
I have a fresh installation of a Vpopmail 5.4.33 + Dovecot 2.2.29.1 + SQL
As usual I followed the AuthDatabase/VPopMail wiki
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, \
pw_clear_passwd AS password \
FROM vpopmail \
WHERE pw_name = '%n' AND pw_domain = '%d'
user_query = SELECT pw_dir as home, \
89 AS uid, 89 AS gid \
FROM vpopmail \
WHERE pw_name = '%n' AND pw_domain = '%d'
For VPopMail, I prefer to have an individual table...
2009 Mar 02
0
an intresting problem
...vpopmail & installed it to /home/vpopmail
I added joojoo domain. & postmaster at joojoo user.
When i use mysql vpopmail,and use select
pw_domain,pw_name,pw_clear_password from vpopmail;
Then i see following message:
+------------+------------+-----------------+
| pw_domain | pw_name | pw_clear_passwd |
+------------+------------+-----------------+
| joojoo | postmaster | 123456 |
| final.com | postmaster | 123456 |
| janjan.com | postmaster | 123456 |
| final.com | mohsen | 123456 |
| final.com | kamal | 123456 |
+------------+--...
2009 Mar 13
2
New to list, got a quota question
...extra
features like IMAP quotas.
I'm using the sql passdb, with the following config:
driver = mysql
connect = host=/var/lib/mysql/mysql.sock user=username password=password
dbname=vpopmail
default_pass_scheme = PLAIN
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND
pw_domain = '%d'
user_query = SELECT pw_dir as home, 508 AS uid, 503 AS gid FROM vpopmail
WHERE pw_name = '%n' AND pw_domain = '%d'
My vpopmail installation keeps the quota information in the mysql
database (pw_...
2011 Mar 24
1
pigeonhole and roundcube install problem
...postmaster at example.com
sendmail_path = /var/qmail/bin/sendmail
}
dovecot-sql.conf ??kt?s?:
driver = mysql
connect = host=localhost user=vpopmailuser password=vpopmailpassword
dbname=vpopmail
default_pass_scheme = PLAIN
password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND
pw_domain = '%d'
user_query = SELECT pw_dir as home, 89 AS uid, 89 AS gid FROM vpopmail
WHERE pw_name = '%n' AND pw_domain = '%d'
[1]: http://wiki2.dovecot.org/LDA/Qmail
--
Selcuk MIYNAT
Endersys Ltd.
Sistem Deste...
2009 Dec 14
2
vpopmail/mysql/quota
...iver: sql
args: /home/vpopmail/dovecotsql.conf
userdb:
driver: vpopmaildriver = mysql
#
connect = host=/var/lib/mysql/mysql.sock user=vpopuser password=xxxxxxxx
dbname=vpopmail
#
default_pass_scheme = PLAIN
# NOTE: '\' line splitting works only with v1.1+
password_query = SELECT pw_clear_passwd AS password, CONCAT(pw_name, '@',
pw_domain) AS user FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'
user_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_dir as home,
508 AS uid, 503 AS gid, concat('maildir:backend=%q', pw_shell) AS quota_...
2007 Nov 22
4
SIGSEGV login process
...l
args: /usr/local/etc/dovecot-sql.conf
mail# grep -v '^ *\(#.*\)\?$' /usr/local/etc/dovecot-sql.conf
driver = mysql
connect = host=/tmp/mysql.sock dbname=exim_users user=exim password=**
default_pass_scheme = PLAIN
password_query = SELECT concat(pw_name, '@', domain) as user, pw_clear_passwd
as password FROM vusers WHERE pw_name = '%n' AND domain = '%d'
user_query = SELECT pw_dir AS home, 26 AS uid, 26 AS gid,
concat('maildir:storage=', quota*1024) AS quota FROM vusers WHERE pw_name
= '%n' AND domain = '%d'
backtrace from core file:
mail#
g...