Results 1 to 1 of 1
Hello, All!
I'm working in x64 Ubuntu Server 8.04, and have very strange problem with Postfix + MySQL. I'm install and config Postfix by this HowTo: Virtual Users And Domains ...
- 08-25-2008 #1Just Joined!
- Join Date
- Aug 2008
- Posts
- 1
Postfix + MySQL error: very strange variable %s
Hello, All!
I'm working in x64 Ubuntu Server 8.04, and have very strange problem with Postfix + MySQL. I'm install and config Postfix by this HowTo: Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS) | HowtoForge - Linux Howtos and Tutorials
All seems like a works:
I'm put all info in to mysql tables, configure *.cf-files, clam, antispam etcCode:# netstat -tap tcp 0 0 localhost:10024 *:* LISTEN 4908/amavisd (maste tcp 0 0 localhost:10025 *:* LISTEN 13043/master tcp 0 0 localhost:mysql *:* LISTEN 10152/mysqld tcp 0 0 *:www *:* LISTEN 5699/apache2 tcp 0 0 example.com:domain *:* LISTEN 4849/named tcp 0 0 localhost:domain *:* LISTEN 4849/named tcp 0 0 *:smtp *:* LISTEN 13043/master tcp 0 0 localhost:953 *:* LISTEN 4849/named tcp6 0 0 [::]:imaps [::]:* LISTEN 5427/couriertcpd tcp6 0 0 [::]:pop3s [::]:* LISTEN 5461/couriertcpd tcp6 0 0 [::]:pop3 [::]:* LISTEN 5441/couriertcpd tcp6 0 0 [::]:imap2 [::]:* LISTEN 5407/couriertcpd tcp6 0 0 [::]:domain [::]:* LISTEN 4849/named
But postfix work very strange (not create mail folder, only receive mail's and so one). After long debug, i'm understand, that problem in mysql query from *.cf files – in %s variable (Postfix manual - mysql_table(5)). In this variable, in this situation, must be e-mail address of e-mail recipient (eg: admin@example.com), But...
If I'm write in mysql-virtual_mailboxes.cf
in mysql log file I see, that %s = example.comCode:query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email = '%s'
But, if I'm write (only for test of course
):
I'm see in %s place my admin@example.comCode:query = SELECT '%s'
I'm really don't understand, whats happen, and why in the same place I have different results...
Any ideas?..


Reply With Quote
