search for: virtual_user

Displaying 20 results from an estimated 108 matches for "virtual_user".

Did you mean: virtual_users
2010 Jan 12
1
Best way of dealing with Case-Sensitive Issues in Dovecot
...: %Lu passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: static args: uid=5000 gid=5000 home=/vmail/%Ld/%Ln allow_all_users=yes In dovecot-sql.conf: password_query = select concat(virtual_users.user, '@', virtual_domains.name) AS user, virtual_users.password as password \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%Ln' and virtual_domains.name='%Ld' and virtual_users...
2011 Mar 30
8
trouble with my virtual user setup
Hello, I''m a puppet newbie and I''m having trouble getting my virtual user setup to work. Can someone please tell me what''s wrong with this setup? # virtual.pp # class virtual_users::virtual { @group { "users": gid => "100", ensure => present } @user { "lmoore": password => "$1$WLx?v4oo#ajnxqrNG?ECT?00fh?P?H1", uid => "8050", comment => "Lucy Moore",...
2014 Feb 19
1
Dovecot, mysql, and quota
...I've got the plugins loaded appropriately and am wanting to configure a dictionary backend to talk to my mysql database. I've got a single database called mail which has all the mail-related items in it. One table is for virtual users which postfix uses. It looks like this: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `password` varchar(128) NOT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT C...
2012 Mar 20
2
dovecot, sieve and vacation
Hi there ! Have a small problem with sieve and vacation: it seems to descard the vacation filter I created instead of sending back an email: Mar 20 11:56:28 hostname dovecot: deliver(virtual_user): sieve: msgid=unspecified: discarding vacation response for message implicitly delivered to <virtual_user at hostname> after searching a bit on the net, I stumbled on another (old) thread: http://www.mail-archive.com/dovecot at dovecot.org/msg25955.html I'm not really sure it's the...
2012 Jan 18
1
Quota won't work
...master: path: /var/run/dovecot/auth-master mode: 384 user: vmail /etc/dovecot/dovecot-sql.conf: driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailuser password=****** default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; user_query = SELECT CONCAT('/var/mail/', maildir) AS home, CONCAT('*:bytes=', quota) AS quota_rule \ FROM virtual_users WHERE email='%u' virtual_users has this: CREATE TABLE IF NOT EXISTS `virtual_users` ( `id` int(11) NOT NULL AUTO_INCRE...
2010 Jul 22
1
problem mysql and dovecot 1.2
Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages | +----+-----------+----------------------------------+-------------------------...
2012 Oct 19
4
still having difficulties with per-user quotas
...sql.conf.ext driver = sql } protocol imap { mail_plugins = " quota imap_quota" } Oct 19 15:23:52 auth-worker(29279): Info: mysql(/var/run/mysqld/mysqld.sock): Connected to database mail Oct 19 15:23:52 auth-worker(29279): Debug: sql(xxx,::1): query: SELECT user as user, password FROM virtual_users WHERE user='xxx at domain'; Oct 19 15:23:52 auth: Debug: client passdb out: OK 1 user=xxx Oct 19 15:23:52 auth: Debug: master in: REQUEST 3523346433 29276 1 f5cd16e3f5e078c28d850749e42c86cc Oct 19 15:23:52 auth-worker(29279): Debug: sql(xxx,::1): SELECT concat('*:storage=', bytes,...
2018 May 27
0
Best mail encryption solution for per-user
...onf.ext > >>> ============== > >>> driver = mysql > >>> connect = host=x.x.x.x dbname=mailserver user=mailuser password=mailpasswordexample > >>> default_pass_scheme = SHA256-CRYPT > >>> password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; > >>> ============== > >>> Where do i need to set : mail_crypt_private_password = %w ? > >>> > >>> password as private password. You might want to run it thru some hash, so %{sha1:password} might be > >>> a good...
2009 Sep 12
1
1.2.4 Maildir Quota Issues
...ebian 5.0.3 xfs My default configurations quota configurations: plugin: quota: maildir:User quota quota_rule: *:storage=2G Customized Use Configurations at the Mysql level: user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%d/%n' as home, \ concat('*:storage= ', virtual_users.quota_kb) AS quota_rule \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%n' and virtual_domains.name='%d' When I change quota at the SQL level (per user), that quota becomes...
2008 Mar 17
1
Realizing Users in Nodes
I''m trying to work with Users and the realize function, and it''s driving me batty. Puppet is 0.23.2. My definition looks something like: class virtual_users { @user { fred : uid => 500 ... } @user { derf : uid => 501 ... } } node base-node { include virtual_users } node "testnode.domain.local" inherits base-node { realize User[fred] } puppetd throws an error of: err: Could not retrieve configuration: Failed to find virtu...
2018 May 28
0
Best mail encryption solution for per-user
...n i have in dovecot-sql.conf.ext >>> ============== >>> driver = mysql >>> connect = host=x.x.x.x dbname=mailserver user=mailuser password=mailpasswordexample >>> default_pass_scheme = SHA256-CRYPT >>> password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; >>> ============== >>> Where do i need to set : mail_crypt_private_password = %w ? >>> >>> password as private password. You might want to run it thru some hash, so %{sha1:password} might be >>> a good option. >>> >...
2014 Jan 28
1
Problem to setup replication
..._path = /var/log/protocol-lda.log mail_plugins = sieve postmaster_address = postmaster at domain.dom } ----------------- sql-conf: driver = mysql connect = host=127.0.0.1 dbname=xxx user=mailuser password=xxx default_pass_scheme = SSHA512 password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; user_query = SELECT email as user FROM virtual_users WHERE email ='%u'; iterate_query = SELECT email as user FROM virtual_users WHERE email='%u'; ------------------ The config on the other node is similar, except the mail_replica settings. The weird t...
2020 Jul 03
0
Mail replication fails between v2.2.27 and v2.3.4.1
...ver = mysql connect = host=127.0.0.1 dbname=mailer user=mailer password=***reducted*** default_pass_scheme = PLAIN-MD5 user_query = SELECT '/home/vmail/%d/%n' as home, 'vmail' as uid, 'vmail' as gid, mailbox as mail, 'tcps:mx1.example.com:12345' as mail_replica FROM virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id = virtual_domains.id WHERE virtual_users.user='%n' AND virtual_domains.name='%d'; password_query = SELECT password FROM virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id = virtual_domains.id WHERE virtual_users....
2018 Oct 15
2
Problems with qouta_clone plugin
...ince it might yield some information :) It is probably something simple but apparantly i'm failing to see it :) Hope someone can help. ------------- dovecot --version 2.3.2.1 (0719df592) cat dovecot-quota-clone-sql.conf.ext connect = **** map { pattern = priv/quota/storage table = virtual_users value_field = usage_in_bytes username_field = email } map { pattern = priv/quota/messages table = virtual_users value_field = messages username_field = email } # 2.3.2.1 (0719df592): /etc/dovecot/dovecot.conf # OS: Linux 3.10.0-862.11.6.el7.x86_64 x86_64 CentOS Linux release 7....
2013 Dec 08
1
Expire plugin - empty expires table
...____________________________________________________________ ________________________ dovecot-sql.conf.ext driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailuser password=************************* default_pass_scheme = PLAIN-MD5 iterate_query = SELECT email AS user FROM virtual_users password_query = SELECT email AS user, password, \ uid AS userdb_uid, gid AS userdb_gid, \ concat('*:bytes=', quota_bytes) AS userdb_quota_rule \ FROM virtual_users WHERE email = '%u' user_query = SELECT uid, gid, \ CONCAT('/data/vmail/storage/',CONCAT(SUBSTR...
2018 May 20
0
Best mail encryption solution for per-user
...ave in dovecot-sql.conf.ext > >> ============== > >> driver = mysql > >> connect = host=x.x.x.x dbname=mailserver user=mailuser password=mailpasswordexample > >> default_pass_scheme = SHA256-CRYPT > >> password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; > >> ============== > >> Where do i need to set : mail_crypt_private_password = %w ? > >> > >> password as private password. You might want to run it thru some hash, so %{sha1:password} might be > >> a good option. > >&g...
2017 Apr 29
2
most secure password scheme
Hello, I have a few questions on password schemes. Is SHA512 the most secure? Is there a difference between SHA512 and SHA512-CRYPT? What about SSHA512 and SSH512-CRYPT? Is there a problem with this sql statement: UPDATE virtual_users SET password=CONCAT(?{SHA256-CRYPT}?, ENCRYPT (?Password Goes Here?, CONCAT(?$5$?, SUBSTRING(SHA(RAND()), -16)))) WHERE user=?user at example.com?; I'm getting an error 1064 at the ending email address. Thanks. Dave.
2017 May 29
1
mailserver.users does not exist
...Error: sql( aj at example.com,): User query failed: Table 'mailserver.users' doesn't exist May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< aj at example.com>, method=PLAIN, rip=, lip=, mpid=10894, TLS, ses...QZwBg9rlR> But I already have the users data under virtual_users. So what should I do? Regards, Amaechi Janneh
2015 May 01
1
Fatal: Unknown scheme: SHA512-CRYPT. On a Mac-mini
...Distrib 5.6.19, for osx10.9 (x86_64) using EditLine wrapper The MySQL code used to create the user/password table. Which seems to work fine, and creates the table as it should - even though the resulting password doesn't appear to be quite right for SHA512-CRYPT INSERT INTO `mailserver`.`virtual_users` (`id`, `domain_id`, `password` , `email`) VALUES ('1', '1', ENCRYPT('firstpassword', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), 'email1 at example.com'), ('2', '1', ENCRYPT('secondpassword', CONCAT('$6$...
2017 May 29
3
MySQL issue
...Error: sql( aj at example.com,): User query failed: Table 'mailserver.users' doesn't exist May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< aj at example.com>, method=PLAIN, rip=, lip=, mpid=10894, TLS, ses...QZwBg9rlR> But I already have the users data under virtual_users. So what should I do? Regards, Amaechi Janneh I am running dovecot 2.2.13 Debian 8