similar to: User data over Mysql

I use dovecot-0.99.11 from RHEL4. dovecot-mysql.conf: === db_host = dbhost db_port = 3306 db = db db_user = dovecot db_passwd = pass default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE username = '%u' user_query = select maildir AS home,u_id AS uid,g_id AS gid from users WHERE username = '%u' === When I try "telnet localhost 110" and enter

Hi I am wanting to install : dovecot 1.0-stable I currently have dovecot 0.99.11-1 which came packaged on Fedora Core 3 It is doing auth off a MySQL db an working well I have downloaded the latest stable tarball and extracted ... I don't see how to enable mysql lookups at compile time... Help please ... I am getting a lot of pressure from the people at work ... Regards Andrew Andrew

After running ./configure --with-ldap --with-ssl=openssl --with-pgsql --with-mysql --without-cyrus-sasl2 --sysconfdir=/etc (Settings taken from the debian/rules of debian package version 0.99.11-3) of the cvs HEAD or test46 I get the following error during make: db-mysql.o(.text+0x116): In function `db_mysql_query': /tmp/dovecot-1.0-test46/src/auth/db-mysql.c:82: undefined reference to

Hi, I have a working Installation with: Ubuntu 16.04 LTS Dovecot 2.2.22 MySql 5.7.24 Postfixadmin 3.2 Apache 2.4.18 Rainloop 1.12.1 I manage the E-Mail Accounts with postfixadmin in a MySql-DB. Also I use quotas with Quota Backend postfixadmin-DB (dict). Everything works fine. Now I installed a new Server with the following Versions and migrate the Configs to the new System. Ubuntu 18.04 LTS

Hi list, i use dovecot-1.0-1.2.rc15.el5 installed from rpm centos 5.0 I cant get mysql authetication working: this is my /etc/dove-mysql.conf ######dove-mysql.conf should look like this########## #db_host = 127.0.0.1 #db_port = 3306 db = postfix db_user = postfix db_passwd = secret db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT password FROM mailbox WHERE username

my mailsystem is using postfix and virtual mailbox which stored in mysql db. SMTP AUTH is using PAM, pam-mysql to authenticate against a mysql db. I installed dovecot 0.99-14. In the dovecot example config file it mentioned that auth_passdb can check against thru PAM but auth_userdb didn't Does it mean that auth_userdb should use other means e.g. /etc/passwd, shadow, vpopmail, etc and in my

Hello! I'm attempting to get Dovecot working with MySQL user database on another machine. I can connect to the MySQL (5.7.26) instance with SSL enabled: ?mysql -h db.mrst.ee --ssl-ca=/etc/dovecot/ca.pem --ssl-cert=/etc/dovecot/client-cert.pem --ssl-key=/etc/dovecot/client-key.pem --ssl-cipher=DHE-RSA-AES256-SHA -u vmail -p However if I use the same values in dovecot-sql.conf.ext, I

With quota count and quota_clone it works, but can I use noenforcing with quota count? quota = count:User quota:noenforcing When I test this config, I receive no quota-warning E-Mail: service quota-warning { executable = script /usr/local/bin/quota-warning.sh # user = dovecot user = vmail unix_listener quota-warning { user = vmail group = vmail mode = 0660 } } plugin {

On 20 Jul 2019, at 23.02, Reio Remma via dovecot <dovecot at dovecot.org> wrote: > > On 20.07.2019 22:37, Aki Tuomi via dovecot wrote: >> >>> On 20/07/2019 21:07 Reio Remma via dovecot <dovecot at dovecot.org> <mailto:dovecot at dovecot.org> wrote: >>> >>> >>> On 20.07.2019 18:03, Aki Tuomi via dovecot wrote: >>>>

Hi everyone, I am new to Puppet and try to make some simple "automation things". I have succeed with apache2, ssh modules, but have problems with Puppetlabs mysql module. It installs mysql server, changes/creates admin user password, but does not create database and user. I cannot find anything wrong in logs (--debug --verbose). I see that manifests is read, but no db/user in mysql.

I am I a situation where I have to wipe my remote server and reinstall, Its been a while since I built a server and I am not as sharp as I use to be I am running FreeBSD 12.1. well at least the server is... I am getting constant authentication errors like Dec 28 22:10:18 triggerfish dovecot[21809]: imap-login: Aborted login (auth failed, 1 attempts in 6 secs): user=<jason at example.com>,

<!doctype html> <html> <head> <meta charset="UTF-8"> </head> <body> <div> <br> </div> <blockquote type="cite"> <div> On 20/07/2019 21:07 Reio Remma via dovecot <dovecot@dovecot.org> wrote: </div> <div> <br> </div> <div> <br>

<!doctype html> <html> <head> <meta charset="UTF-8"> </head> <body> <div> <br> </div> <blockquote type="cite"> <div> On 20/07/2019 13:12 Reio Remma via dovecot < <a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote: </div>

Dear All, wasn't sure my last question got posted, i decided to re-post with more concise explanation of the problem i'm facing. I have samba PDC (version 3.0.14a) working fine before with smbpasswd backend. a few weeks ago, we decide to move to mysql backend since we have email server with mysql backend as well. I'm trying to use one username and password for both email and samba

Hi all, I'm setting up a new email server based on the softwares list below: * Postfix * Dovecot 2.0.9 * MySQL * Postfixadmin 2.3.6 My current problem is I'm unsure whether quota feature is well configured or not. In order to test and validate, I use Roundcubemail GUI which provides percentage of the space used by the mailbox (quota should be applied per mailbox). Here, my

Hi everyone, I have certain values retrieved from mysql database.How can i do certain analysis like histogram, correlational analysis tc using this data,I tried it. But when i tried to plot a histogram it actually showed error the data is not numeric evenif it was stored as integer data type in mysql db. Please anyone help. Can anyone specify the steps for doing data analysis after

Is it possible? It is mentioned in AWDWR but I cannot find that option in the MySQL documentation. I can dump the whole db or just the structure, but I''d like to be able to dump just the contents. bruce

I updated samba from 3.10 to 3.13 to get the updated print fixes, but I noticed today that the smbpasswd script no longer functions. It fails to update the the following fields. domain

Hello list, I keep on getting the error : ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' (using password: YES) I have a 'cdr' table in my MySQL-DB. On this table the user 'asteriskcdr' has select, insert, update privileges. GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr`

Hello, I am using InstantRails 2.0 on windows. When building an app,I get this error when hit the browser(Action ControllerException caught): Access denied for user ''root''@''localhost'' (using password: NO) ----------------------------------------------------------------------------------------------- The database.yml file is configured like this: # MySQL.