HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials - View Single Post - Problems with the Virtual Users And Domains With Postfix, Courier And MySQL tutorial

falko · #6 22nd July 2006, 17:07

Can you try

Code:

query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'

(no spaces)

instead of

Code:

query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email = '%s'

?

Do the same for the other queries and restart Postfix.