Displaying 20 results from an estimated 10000 matches similar to: "Example records for SQL AUTH"
2014 Nov 08
3
Help on dict with QUOTA / perms
I'm setting up quota for my users, my users have a UID starting on >5000 and
GID = 5000, and when I query the quota, for example in IMAP, I get:
Nov 8 14:13:28 fastmail dovecot: imap-login: Login: user=<a at a.com>,
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=18660, secured,
session=<uByciFkH2gB/AAAB>
Nov 8 14:13:37 fastmail dovecot: imap(a at a.com): Error:
2019 Nov 14
2
SASL AUTH with postfix
Hi Benny,
I've tried to search for the realm part in dovecot but didn't found it,
Could you guide me to it?
-----Original Message-----
From: dovecot <dovecot-bounces at dovecot.org> On Behalf Of Benny Pedersen via
dovecot
Sent: 13 de novembro de 2019 23:33
To: dovecot at dovecot.org
Subject: Re: SASL AUTH with postfix
Jorge Bastos via dovecot skrev den 2019-11-13 23:53:
> Jorge
2014 Nov 08
1
Help on dict with QUOTA / perms
Hi,
Ok managed to solve this with the permissions on the socket.
One related question, the quota units are only Kb,M,G ? not possible to
define it in bytes?
> -----Original Message-----
> From: dovecot [mailto:dovecot-bounces at dovecot.org] On Behalf Of Jorge
> Bastos
> Sent: s?bado, 8 de Novembro de 2014 14:22
> To: 'Dovecot Mailing List'
> Subject: Help on dict with
2009 Aug 31
3
Migration - wrong SQL statement is created
Hi,
I am doing my first steps with RoR and I have the following problem:
I execute my migration file with the following content on a
MySQL-database via Rake:
<code>
class CreateUsers < ActiveRecord::Migration
def self.up
create_table :users do |t|
t.integer :id
t.string :username, :size => 100
t.string :password, :size => 100
t.string :email, :size
2014 Feb 19
1
Dovecot, mysql, and quota
Hello,
I'm running dovecot 2.2 and wanting to get quotas going. 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)
2019 Jan 04
1
Unexpected accounts showing up in replication status (doveadm replicator status '*')
I have a replication set up with two dovecot 2.3.4 servers.
Messages appear to be replicating fine between them, however there is an
oddity when I run doveadm replicator status '*' and I'm worried work is
being carried out needlessly.
Both machines have identical configs and have a mysql backend for
username/passwords.? Both machines point to the same mysql server and
same
2005 Oct 10
1
Need help with SQL queries after updating to 1.0a3
I upgraded to 1.0a3 - i have everything in the config migrated over,
but I'm unsure about the way i should be querying postgres
my db handles virtual accounts only, and is set as such:
CREATE TABLE accounts (
local_part VARCHAR(64) NOT NULL,
domain VARCHAR(64) NOT NULL,
password VARCHAR(64) NULL,
home_dir VARCHAR(256) NOT NULL,
uid INTEGER DEFAULT
2018 Nov 15
1
Dovecot proxy: per user/domain 'namespace/inbox/prefix' from MySQL
As a way to try and avoid using "prefix = INBOX." ad infinitum for the
inbox namespace, I'm looking for ways to move on to "prefix =" for new
mail accounts, and grandfather the existing ones. Previously running
Courier-IMAP, now Dovecot, I looked at
https://wiki.dovecot.org/Namespaces#Backwards_Compatibility:_Courier_IMAP
and decided it's too risky to go down that
2018 Apr 11
3
two unrelated issues, lastlogin, and an out of memory fatal error
Hello Aki,
Thanks for your suggestion. I followed it and the wiki at:
https://wiki.dovecot.org/Plugins/LastLogin
Good news, I get a record in the users table, with the username that
just logged in. This is good. Bad news is I got unexpected output from
the last_login time stamp. Here's the table and the user:
mysql> describe users;
2018 Apr 10
2
two unrelated issues, lastlogin, and an out of memory fatal error
Hello,
I've got a few misc issues that I'm trying to get a handle on.
I'm having what is probably a simple error with last logins. It's not
working, unable to write values to the database. Here's the log lines:
2018-04-10 10:43:34 imap-login: Info: Login: user=<user at domain.com>,
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=75934, TLS,
2019 Sep 21
2
Dovecot proxying to some backend using LOGIN proxy_mech
Hello list,
I am currently testing a setup for a PoC wit this configuration.
- 1 x Frontend dovecot for proxying IMAP/POP3/LMTP/ManageSieve/Submission
- 2 x Backend dovecot with local mail storage
The frontend does the user authentification and communicate with the backends using a master password
The fronted accepts PLAIN and LOGIN auth mechanisms and talk with backends using PLAIN auth
2019 Nov 13
2
SASL AUTH with postfix
Jorge Bastos via dovecot skrev den 2019-11-13 22:00:
> How can i have the same with dovecot SASL?
> Thanks in advanced,
https://wiki2.dovecot.org/HowTo/PostfixAndDovecotSASL
Hi benny,
Thanks,
That's exactly what i have in postfix:
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
smtpd_sasl_auth_enable = yes
plus:
smtpd_sasl_local_domain = fastmail
but the user that i have
2018 Mar 10
3
dovecot sha512-crypt database storage
Hello,
I've got dovecot authenticating to a MySQL database. I've got a field
varchar(128) called password. Whenever I create a password I use
doveadm pw as in:
doveadm pw -s sha512-crypt
now i'd like to get MySQL to make a dovecot-specific password. My goal
is to eventually have roundcube's password plugin working with this
MySQL database to change the password.
Thanks.
Dave.
2019 Jul 21
2
Help with IMAP IDLE
Sorry...
I meant to past dovecot and not postfix, doing simultaneously stuff ends up
in this!
Yes, i migrated from DBMail and it was working OK.
Here it is:
root at fastmail:/etc/dovecot# doveconf -n|grep -i idle
imap_idle_notify_interval = 1 mins
imapc_max_idle_time = 1 days
root at fastmail:/etc/dovecot#
-----Original Message-----
From: dovecot <dovecot-bounces at dovecot.org> On
2019 Jul 21
4
Help with IMAP IDLE
Hi,
I'm becaming crazy about this!
I've asked before, not no matter what i do or conf, never works.
How can i make IDLE work for real with MSOutlook, so that i can receive
emails when they arrive, instead of changing folder/get out and in my
account?
Here's my conf, should it be reflected in postconf -n (is it the running
conf?):
==================
root at
2015 Jul 06
4
CDR in an MySQL-Database
Hi list!
I'd like to save all information about calls (CDR) in a MySQL-Database.
I created the DB and a user for Asterisk on a separate server, then I
configured my cdr_mysql.conf so:
[global]
hostname=192.168.10.3
dbname=asterisk
table=cdr
password=MYSECRET
user=asterisk
port=3306
and my cdr.conf so:
[general]
enable=yes
unanswered = yes
safeshutdown=yes
[mysql]
usegmtime=no
2006 Mar 15
10
Scaffold with Foreign Key
I have two tables:
------------------------------
drop table if exists users;
create table users (
id int not null auto_increment,
username varchar(100) not null,
password varchar(20) not null,
firstname varchar(20) not null,
lastname varchar(20) not null,
primary key (id)
) TYPE = InnoDB;
------------------------------
drop table
2008 Apr 30
4
Beginner mysql problem
I am new to rails and have come across a problem with a sample
application I was working on.
When trying to use rake migrate I got the error listed below.
my db file contains the following
class ContactDb < ActiveRecord::Migration
def self.up
create_table "people" do |t|
t.column "id", :integer
t.column "name",
2012 Jan 18
1
Quota won't work
I tried to set a quota setting. I installed dovecot with newest
version, patched it and started it.
dovecot -n:
# 1.2.15: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.3 ext4
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s
ssl_listen: 143
ssl_cipher_list: ALL:!LOW:!SSLv2
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
2013 Jul 05
1
Ambiguous behavior with prefetch database?
Hello,
Let's say dovecot.conf contains:
mail_uid = dovemailer
mail_gid = dovemailer
mail_home = /some/path/%n
mail_location = mbox:~/mboxes:INBOX=~/mboxes/inbox
and that the password database query is of the form:
password_query = \
SELECT \
passwd AS password, \
nickname AS user, \
mail_home AS userdb_home, \
mail_location AS userdb_mail, \
WHERE \
...
The database