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@24.com'

Empty set (0.51 sec)

mysql> select * from access_maps where mail_username = "cami@24.com";
+---------------+-------------------------------------------------+----------------------------------+
| mail_username | mail_host_map | loginid |
+---------------+-------------------------------------------------+----------------------------------+
| cami@24.com | f2ef77fe86754109b347dd97a79444eb@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@newstyledata.net
Sent:2010-08-13 17:13:16
To: perdition-users@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@mweb.co.za wrote:
> Hi All,
>
>
> I've been trying to upgrade from perdition 1.15 to perdition 1.18
> without any luck.
>
> The behaviour is different with regards to MySQL data which are returned.
>
>
> The query:
>
>
> select mail_username,mail_host_map,143 from access_maps where
> mail_username='cami@24.com';
> +---------------+-------------------------------------------------+-----+
> | mail_username | mail_host_map | 143 |
> +---------------+-------------------------------------------------+-----+
> | cami@24.com | f2ef77fe86754109b347dd97a79444eb@152.111.194.93 | 143 |
> +---------------+-------------------------------------------------+-----+
>
>
> In 1.15 "f2ef77fe86754109b347dd97a79444eb" is correctly returned as seen
> here:
>
>
> Aug 13 16:18:25 mailstore01 imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1],
> command=LOGIN
> Aug 13 16:18:25 mailstore01 imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1],
> username=f2ef77fe86754109b347dd97a79444eb
> Aug 13 16:18:25 mailstore01 imapd: LOGIN: DEBUG: ip=[::ffff:127.0.0.1],
> password=XXXX
> Aug 13 16:18:25 mailstore01 imapd: authdaemon: starting client module
> Aug 13 16:18:25 mailstore01 imapd: authdaemon: ACCEPT, username
> f2ef77fe86754109b347dd97a79444eb
> Aug 13 16:18:25 mailstore01 imapd: LOGIN,
> user=f2ef77fe86754109b347dd97a79444eb, ip=[::ffff:127.0.0.1], protocol=IMAP
>
> (the imap server being used is Courier)
>
>
> In 1.18 "cami@24.com" is being returned and passed onto Courier instead
> of "f2ef77fe86754109b347dd97a79444eb"
>
>
> Aug 13 15:07:15 mailstore01 imapd: LOGIN: DEBUG:
> ip=[::ffff:152.111.194.109], command=LOGIN
> Aug 13 15:07:15 mailstore01 imapd: LOGIN: DEBUG:
> ip=[::ffff:152.111.194.109], username=cami@24.com
> Aug 13 15:07:15 mailstore01 imapd: LOGIN: DEBUG:
> ip=[::ffff:152.111.194.109], password=XXXX
> Aug 13 15:07:15 mailstore01 imapd: authdaemon: starting client module
> Aug 13 15:07:15 mailstore01 imapd: authdaemon: REJECT
>
>
> Can anyone tell me how to revert back to the old behaviour to how to go
> about trouble shooting this?
>
>
> Regards,
>
> Cami
>
>
>
> ______________________________________________
> Perdition-users mailing list
> Perdition-users@vergenet.net
> http://lists.vergenet.net/listinfo/perdition-users
______________________________________________
Perdition-users mailing list
Perdition-users@vergenet.net
http://lists.vergenet.net/listinfo/perdition-users