similar to: LDAP and MySQL in the same configuration

Hello all: I am trying to use the mysql command to retrieve information from a mysql database. my example here was formed from using the wiki reference to using the mysql command. The problem is with the fetch command. Here is the macro code: Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\ ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString}) Mysql(Fetch fetchid ${r} dbuserpass)

some one knows, how to configure quotas with dovecot and mysql databases ? my dovecot was compiled with: CPPFLAGS=-I/opt/mysql/include/mysql LDFLAGS=-L/opt/mysql/lib/mysql ./ configure --with-sql --with-mysql and my dovecot.conf and dovecot-sql.conf have the following configurations: =========== dovecot.conf =========== protocol imap { listen = *:143

hi all when i setup plugin quota by quota = dict: mysql:/etc/quota-dict.conf i get the folowing error: deliver(zzzz at zzzz.zz): Unknown dict module: mysql deliver(zzzz at zzz.zz): dict quota: dict_init() failed quota-dict.conf: connect = host=localhost dbname=zzzz user=zzzz password=zzzz table = mailbox select_field = quota where_field = maildir username_field = username dovecot.conf: #

Hello there, I'm trying to use the doveadm expunge function, but it doesn't seems to work.. I have installed a mail test server using iredmail, Dovecot and postfix using mysql for authentications. I sent a email to this server, and change the timestamp using touch. the mail boxes are as follow : /home/mail/vmail1/mydomain.fr/n/i/c/nicolas-2013.09.05.14.30.49/Maildir I want to delete

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 |

Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf : driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u';

Hello, I've had a look through past messages and I think this has been brought up but I'm not sure what the outcome of it was. I'm trying to use quotas with a MySQL dict backend. I am using Dovecot version 1.0.rc6-1 from the Debian Testing package on a x86 machine. My dovecot.conf file has the following entries which I took from the Wiki: dict { quotadict =

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)

Following on from this thread: http://www.dovecot.org/list/dovecot/2010-September/052704.html <https://owa2010.webfusion.com/owa/redir.aspx?C=a447887e3d204944a8c766142df41453&URL=http%3a%2f%2fwww.dovecot.org%2flist%2fdovecot%2f2010-September%2f052704.html> in 2.0.16 I am seeing the same issues. I believe this would be related to some timeouts set on our mysql servers which are pretty

Hi, Just yesterday I successfully installed ruby in my pc, means I am new in this technology. Today I am trying to fetch the data in my ruby application and successfully done this. Now I want to speed up the performance of the fetching data by making use of prepare and execute method.In case of select query also I am using this like require ''mysql'' mysql =

dict quota is known to have this problem that it is not always updated on time. You should use quota count with quota_clone plugin instead (might require upgrade). Please remember to change password for mysql user pfadmin, as you accidentically sent it to the list. Aki > On 15 November 2018 at 20:52 SUnsin at gv-bayern.de wrote: > > > > > Hi, > > I have a working

> We also spotted these sql connections getting aborted, upon upgrading MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!) I have a mailserver running MySQL 5.6.44 which is not very busy that logs these warnings. Another busy one running MySQL 5.6.45 does not log any warnings. MySQL interactive-/wait_timeout is 28800 (8 hours), which is more than enough time to wait for a

Hi All, I'm getting a strange warning message when I perform a MYSQL data lookup. The operation performs fine, I retrive the data I'm looking for and continue on through the dial sequence without an issue. I'm wondering if this warning message is something to be concerned about, can't find any info about it. warning message: Mar 28 15:55:40 WARNING[27481]:

I'm on asterisk 1.6.1.0 and asterisk addons 1.6.1.0 (also using freepbx 2.5 with cidlookup module from mysql database). There are some incompatible changes in asterisk 1.6 about MYSQL addon application syntax for querying a mysql database. It seems that escaping of space and single quotes is no longer needed - see 3rd line of attached example from

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

Hello list, I was able to get passive mode worked out. I'm really glad I was able to do this. I'm able to log into the ftp server, list directories, enter subdirectories and upload/download files. However my next task is to enable virtual users using mysql. I have installed proftpd-mysql and enabled the sql modules in the config. I found a good article on how to do this here:

Hello all. I am trying to use app_mysql. It works for selects and functions, but does not want to work with procedures. Pls have a look: Calling function: CREATE FUNCTION f_1(a VARCHAR(20)) RETURNS INTEGER RETURN (SELECT count(*) from peer where name = a); Result: -- Executing Macro("IAX2/100-3", "local|100") in new stack -- Executing MYSQL("IAX2/100-3",

Hello i have the following field (text string) in a MySQL database : "${KNUMMER} ${phone_number_to} ${phone_number_from} ${CHANNEL:4}" I read this string form the database and want to have the dialplan variables to be replaced with the correct content. How can I do this ? Currently this is not working. The variable ${PARAMS} contains the exact string of the database field : my

I have a query that query's my database based on the read input for an ID number. exten => s,4,MYSQL(Query resultid ${connid} SELECT\ `FirstName`\ `HomePhone`\ FROM\ `contacts`\ WHERE\ `ContactID`= \'${ID}\') exten => s,5,MYSQL(Fetch foundRow ${resultid} var1 var2) ; fetch row Problem is is that when I do the following: exten => s,7,Cepstral(The Phone number for ${var1} is

It should work, I have to check why it's not working. Aki On 16.11.2018 11.47, SUnsin at gv-bayern.de wrote: > 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