Users

Download

users@exim4u.org

February 2019

2 participants
2 discussions

Convert cleartext passwords to SHA512 crypt
by Odhiambo Washington 19 Feb '19

19 Feb '19

I am migrating about 250 users to a system where I'd like to use SHA512 crypt as the standard. I have been using the old versions of exim4u which still has the cleatext password field. What is the easiest way to change (in place) all the crypt field to SHA512 crypt, based on the cleartext passwords? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-)

2 1

Exim4u Group Router
by Odhiambo Washington 16 Feb '19

16 Feb '19

Hello listers, I am testing Exim4u with MySQL-8.0.14 and I find a situation where the group router sql query is not running. root(a)gw:/usr/local/etc/mail # exim -bt finance(a)crownkenya.com LOG: MAIN PANIC failed to expand "${if eq{Y}{${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${quote_mysql:$local_part}'}}} {$sender_address} {${lookup mysql{select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.name = '${quote_mysql:$local_part}' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' and u.username = '${quote_mysql:$sender_address}' }}}}" while checking a list: lookup of "select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'crownkenya.com' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'finance'" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g, domains d where d.enabled = '1' and d.domain = 'crownkenya.com' and d.' at line 1 Is anyone using mysql-8.0.x with Exim4U? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-)

2 4