Hi, Just to follow up. The issue was fixed by enabling: # U|username_from_database: # Substitute username from popmap lookup. #U username_from_database Someone care to explain exactly what that is doing? Regards, Cami From: cami(a)mweb.co.za Sent:2010-08-13 20:32:46 To: perdition-users(a)vergenet.net Cc: Subject: Re: [PERDITION-USERS] upgrading from perdition-1.15 toperdition-1.18 Hi, Thanks for the help. I tried that but the SQL query isn't returning the correct data. mysql> select mail_host_map,mail_username,143 from access_maps where mail_host_map='cami(a)24.com' Empty set (0.51 sec) mysql> desc access_maps; +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | mail_username | char(60) | NO | PRI | | | | mail_host_map | char(60) | NO | | | | | loginid | char(32) | NO | MUL | NULL | | +---------------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> select * from access_maps where mail_username = "cami(a)24.com".com"; +---------------+-------------------------------------------------+----------------------------------+ | mail_username | mail_host_map | loginid | +---------------+-------------------------------------------------+----------------------------------+ | cami(a)24.com | f2ef77fe86754109b347dd97a79444eb(a)152.111.194.93 | f2ef77fe86754109b347dd97a79444eb | +---------------+-------------------------------------------------+----------------------------------+ 1 row in set (0.00 sec) IMAP4_FLAGS="-l 143 -M /usr/lib64/libperditiondb_mysql.so.0.0.0 -m 152.111.194.116:3306:MAIL:access_maps:postfix:XXX:mail_host_map:mail_username:143 -d" Any other ideas? Is there any way to debug what Perdition is doing when it receives data from SQL? Cami From: uk(a)newstyledata.net Sent:2010-08-13 17:13:16 To: perdition-users(a)vergenet.net Cc: Subject: Re: [PERDITION-USERS] upgrading from perdition-1.15 toperdition-1.18 Hi, Seems you have the map_library_opt option in the wrong order, just switch mail_username and mail_host_map and it should work again. [:[:[:[:[:[:[:[:]]]]]]]] greetings JS On 2010-08-13 16:21, cami(a)mweb.co.za wrote: ______________________________________________ Perdition-users mailing list Perdition-users(a)vergenet.net http://lists.vergenet.net/listinfo/perdition-users