Am 02.08.2010 um 20:44 schrieb Dave Evans:
>
> Of course, AFAICT you haven't yet shown us what the +local_domains
> domain list
> is, and my guess is you're trying to debug the pgsql lookup part:
>
>> 72219 key="SELECT name FROM localdomain WHERE name ='localhost' "
>> partial=-1 affix=NULL starflags=0
>
> which does indeed seem to be using "localhost" - but we can't tell
> you why that
> is until you show us the definition of +local_domains.
This *is* the query to look for 'localhost' and nothing else:
-----------
operations=# select * from localdomain where name = 'localhost';
id | name | accountfk | status | created | updated | remarks
----+------+-----------+--------+---------+---------+---------
(0 rows)
-----------
There is nothing to debug:
-----------
operations=# select * from localdomain where name = 'chaos1.de';
id | name | accountfk | status | created | updated |
remarks
----+-----------+-----------+--------+------------+------------
+------------------
1 | chaos1.de | 1 | U | 2010-07-16 | 2010-07-16 |
Initially loaded
-----------
The definition of + local_domains is:
-----------
domainlist local_domains = \
${lookup pgsql {SELECT name FROM localdomain \
WHERE name ='${lc:$domain}' }}
-----------
No doubt: a bug.
Axel
---
axel.rau@??? PGP-Key:29E99DD6 +49 151 2300 9283 computing @
chaos claudius