I'll try and break up my questions the other day about extdata that went unanswered into pieces in the hopes it will be more specific and clear. In general, I am trying to figure out the syntax of the map statement and what is allowed in that statement. So, by map statement, I mean for example perhaps the?dovecot-dict-expire.conf.ext file as shown in the doc. Is the syntax the same for the various types of files (quota vs expire)? Is there syntax to allow the specification of a different key? If so, where is this documented. I have an existing table I want to use, not the table shown in the doc. The reason I am asking is I have seen web pages that reference all sorts of statements within the map statement, and I have no idea where they are documented. Specifically, I see an example here (which is LDAP), look in section 3: http://dovecot.org/patches/1.2/ldap/HOWTO_dictldap+extdata.txt You will see lots of statements, not sure which ones can be used for MySQL (instead of LDAP). So, would like to find a list of ALL valid syntax within the map.
----- Original Message -----> From: Steve Fatula <compconsultant at yahoo.com> > To: Dovecot List <dovecot at dovecot.org> > Cc: > Sent: Thursday, September 8, 2011 6:52 PM > Subject: [Dovecot] MySQL, map files > > I'll try and break up my questions the other day about extdata that went > unanswered into pieces in the hopes it will be more specific and clear. > > In general, I am trying to figure out the syntax of the map statement and what > is allowed in that statement. So, by map statement, I mean for example perhaps > the?dovecot-dict-expire.conf.ext file as shown in the doc. Is the syntax the > same for the various types of files (quota vs expire)? Is there syntax to allow > the specification of a different key? If so, where is this documented. I have an > existing table I want to use, not the table shown in the doc. > > The reason I am asking is I have seen web pages that reference all sorts of > statements within the map statement, and I have no idea where they are > documented. Specifically, I see an example here (which is LDAP), look in section > 3: > > http://dovecot.org/patches/1.2/ldap/HOWTO_dictldap+extdata.txt > > > You will see lots of statements, not sure which ones can be used for MySQL > (instead of LDAP). So, would like to find a list of ALL valid syntax within the > map. >I am guessing no one knows the answer then. Oh well, will have to give up on it then as it is un-documented.
On Thu, 2011-09-08 at 16:52 -0700, Steve Fatula wrote:> I'll try and break up my questions the other day about extdata that > went unanswered into pieces in the hopes it will be more specific and > clear. > > In general, I am trying to figure out the syntax of the map statement > and what is allowed in that statement. So, by map statement, I mean > for example perhaps the dovecot-dict-expire.conf.ext file as shown in > the doc. Is the syntax the same for the various types of files (quota > vs expire)? Is there syntax to allow the specification of a different > key? If so, where is this documented. I have an existing table I want > to use, not the table shown in the doc.They aren't really documented anywhere. Also I'm kind of hoping one day to replace the files anyway with a new syntax that allows mixed configuration of sql/file/other backends. The dict configuration itself is anyway generic and works basically the same for expire/quota/others, except they use different keys (=different patterns when matching). I'm not sure if there is any useful way to even explain how it works now. There is the example SQL configuration for expire and quota. Somewhere in wiki is example flat file config for them. There's really not much else you can do with them.> The reason I am asking is I have seen web pages that reference all > sorts of statements within the map statement, and I have no idea where > they are documented. Specifically, I see an example here (which is > LDAP), look in section 3: > > http://dovecot.org/patches/1.2/ldap/HOWTO_dictldap+extdata.txt > > > You will see lots of statements, not sure which ones can be used for > MySQL (instead of LDAP).That patch's mapping references to Pigeonhole's extdata plugin. If you install that plugin you can use SQL or flat file for the same maps.> So, would like to find a list of ALL valid syntax within the map.Plugins can always add more maps.