mysql connect problemer med postfix
HejJeg er ved at opsætte postfix, hvor jeg følger denne guide.
http://workaround.org/articles/ispmail-sarge/#id2454991
Under denne test, hænger det hele, så jeg bliver nød til at lukke min ssh-session og oprette en ny.
chieftec:/var/log# telnet utysket.dk 25
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
220 mailfx.dk ESMTP Postfix (Debian/GNU)
ehlo anywhere.org
250-utysket.dk
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH LOGIN PLAIN DIGEST-MD5 CRAM-MD5
250-AUTH=LOGIN PLAIN DIGEST-MD5 CRAM-MD5
250 8BITMIME
mail from:info@mailfx.dk
----- mail.log
*utysket authdaemond.mysql: modules="authmysql", daemons=5
*utysket authdaemond.mysql: modules="authmysql", daemons=5
*utysket postfix/smtpd[3034]: connect from localhost.localdomain[127.0.0.1]
*utysket postfix/trivial-rewrite[3036]: warning: connect to mysql server 127.0.0.1: connect to MySQL server on '127.0.0.1' (110)
*utysket postfix/trivial-rewrite[3036]: fatal: mysql:/etc/postfix/virtual_mailboxes.cf(0,100): table lookup problem
*utysket postfix/smtpd[3034]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
*utysket postfix/smtpd[3034]: warning: problem talking to service rewrite: Success
*utysket postfix/master[3011]: warning: process /usr/lib/postfix/trivial-rewrite pid 3036 exit status 1
---- udklip af /etc/postfix/main.cf
#Virtuals
virtual_alias_domains=
virtual_alias_maps= mysql:/etc/postfix/virtual_forwardings.cf,mysql:/etc/postfix/virtual_email2email.cf
virtual_mailbox_domain= mysql:/etc/postfix/virtual_domains.cf
virtual_mailbox_maps= mysql:/etc/postfix/virtual_mailboxes.cf
virtual_uid_maps= static:5000
virtual_gid_maps= static:5000
virtual_mailbox_base= /var/vmail
------ /etc/postfix/virtual_mailboxes.cf
user = postfixadmin
password = XXX
dbname = postfix
table = mailboxes
select_field = CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/')
where_field = username
hosts = 127.0.0.1
mysql> describe mailboxes;
+----------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------------------+-------+
| username | varchar(255) | | PRI | | |
| password | varchar(255) | | | | |
| fullname | varchar(255) | | | | |
| quota | int(10) | | | 0 | |
| created | datetime | | | 0000-00-00 00:00:00 | |
+----------+--------------+------+-----+---------------------+-------+
Jeg synes jeg har kigget alt igennem, men kan ikke spotte nogen tastefejl eller lign. Jeg har også prøvet at åbne helt op for min firewall, men det ændrer heller ikke noget...
/Lars
