similar to: overriding userdb connection host for doveadm-user

Good Day, I'm using dovecot 2.1.8 and this is my dovecot -n output: # 2.1.8: dovecot.conf # OS: FreeBSD 9.0-STABLE i386 auth_default_realm = domain.xxx auth_mechanisms = plain login auth_realms = domainone.xxx domaintwo.xxx disable_plaintext_auth = no first_valid_gid = 5000 first_valid_uid = 5000 lda_mailbox_autocreate = yes mail_gid = 5000 mail_location = maildir:~/ mail_plugins = quota

Hi, I'm setting up SQL quota usage in Dovecot2. I've created a MAILBOX parameter table, 'PARAMS', that contains unique <user>@<domain> pairs, with quota data. mysql> select * from PARAMS; +----+------------------------+------------+-------------+------------+ | ai | MAILBOX_user_domain | quota | quota_bytes | quota_msgs |

Hi dovecot-comminity, can't get iterate_query working. doveadm cannot find mail_location which comes from userdb query. dovecot itself works fine with sql. Whats wrong? please help: [root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initialization failed:

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

Am 07.12.2014 um 00:56 schrieb Alexander Dalloz: > You did fulfill the requzirements for prefetch to work documented in the > wiki? > > http://wiki2.dovecot.org/UserDatabase/Prefetch Ehm, this is my SQL configuration 'dovecot-sql.conf.ext': > driver = mysql > connect = host=**** user=**** password=**** dbname=**** > default_pass_scheme = PLAIN > password_query = \

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

I am trying to configure RealTime Voicemail with MySQL. I downloaded compiled and installed the CVS HEAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the

Thanks John, You are my savior. This is such a great relief. Apparently realtime will not use either '127.0.0.1' or 'localhost' to connect to the database. I had to use the actual IP address attached to the NIC before it worked. My OS is Debian just a note and Asterisk HEAD from August 20, 2005 Details below for those who might be swimming in the same pool with me.

Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306

Hello So what i have: centos 5.6 postfix 2.3.3 dovecot 2.0.13 postfixadmin 2.3.3 roundcube 0.5.3 All general things are working right now i can send receive email with ssl connections etc... Now i'm trying to configure additional options like quota and some other plugins like sieve, trash, expire and deleted-to-trash. Configuration of quota is on first place. I have read wiki regarding quota

First of all, you can probably go online before you convert all passwords. You can modify your query in dovecot-sql.conf.ext to something like the following: SELECT IF(crypt_pass IS NULL OR crypt_pass='', CONCAT('{PLAIN}',plain_pass), crypt_pass) as password FROM mailuser .. This is assuming that: * for incoming users, you have a plain_pass column containing just the plaintext

On 13 Feb 2018, at 00:11, Aki Tuomi <aki.tuomi at dovecot.fi> wrote: > doveadm -u "*mask*" makes no sense. The ?index? that was in the first line was dropped out of my further examples. But now where was there a ?*mask*?. > what command are you trying to run? # doveadm index -u ?*@sqldomain.tld" "*? Error: User listing returned failure doveadm: Error: Failed to

Hi, I was able to connect to a MySQL database (called "zooscan" and with a table "serie" under Win XP with R 1.6.2 using: > library(DBI) > library(RMySQL) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > drv <- dbDriver("MySQL") > con <- dbConnect(drv, dbname="zooscan") > dbExistsTable(con,

I've been mucking about, experimenting with the expire plugin and using a dictionary. I've got the iteration query working when I do a normal expunge using: doveadm expunge -A mailbox "INBOX.Trash" savedbefore 1w and expunging works as expected. However, I've got over 12,000 accounts on this server, so I was hoping using the expire plugin to could help out. I've

Hi actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. I read on the wiki: =================================================== Database Config put the following in res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = myuser dbpass = mypass dbport = 3306 Values in sip.conf or iax.conf like in older versions of * are no longer used. Database Table Lets

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing

Hi there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

>>>> But I don't have an /etc/dovecot/users file. I also don't seem to >>>> have any mail user uid lower than 1000, but I do have some users above >>>> 1000 which aren?t mail users (nobody, etc). >>> >>> Hello Grant, >>> >>> So as to avoid any ambiguity, could you post the output of "doveconf -n"? >>

Okay, so here's the configuration I have for MySQL Realtime (Asterisk version 1.6.2.17): In /etc/asterisk/extconfig.conf: sipusers => mysql,mya2billing,cc_sip_buddies In /etc/asterisk/res_mysql.conf: [mya2billing] dbhost = localhost dbname = mya2billing dbuser = a2billinguser dbpass = REDACTED dbport = 3306 And here's the error messages I get: voip2*CLI> realtime mysql status

Hi, I'm about getting to know dovecot in details, I am about the command "doveadm user". The man page shows this example: userdb: jane uid : 8001 gid : 8001 home : /home/jane mail : sdbox:~/sdbox plugins : sieve quota_rule: *:storage=150M It seems to be nice, however I never got this only: ~# doveadm