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