Wietse Venema: > Rune Elvemo: > > Den 25. okt. 2013 11:30, skrev Mikael Bak: > > > Hi, > > > > > > On 10/25/2013 09:48 AM, Rune Elvemo wrote: > > >> Does anyone know how to use a mysql database for mynetworks? > > >> We did manage to use it to match a single ip address, but is there a way > > >> to > > >> match entire networks? > > >> > > > That can be done at the sql level. > > > See mysql functions "INET_ATON" and "INET_NTOA" for more info. > > > > > > HTH, > > > Mikael > > > > > What result/data does postfix expect from this query? (true, accept,...) > > http://www.postfix.org/DATABASE_README.html#lists > > Postfix lists versus tables > > [...] > > With some tables, however, Postfix needs to know only if the lookup > key exists. The lookup result itself is not used. Examples are the > local_recipient_maps that determine what local recipients Postfix > accepts in mail from the network, the mydestination parameter that > specifies what domains Postfix delivers locally, or the mynetworks > parameter that specifies the IP addresses of trusted clients or > client networks. Technically, these are lists, not tables. Despite > the difference, Postfix lists are described here because they use > the same underlying infrastructure as Postfix lookup tables.
As long as the database returns *something* it will be sufficient to show that the key exists. Wietse