[Postfixbuch-users] MySQL-basierter Web-Free-Mailer 2.Versuch

[Giuseppe Potenza]

Crash Bandicot schrieb:

>Ups,
>
>hate noch eine wenig getestet. Ist aber nicht weiter schlimm, wenn Du das log in
>mysqld einschaltest sieht die abfrage wie folgt aus:
>SELECT account, "", password, uid, gid, home, maildir, "", account, "" FROM
>mailusers WHERE account= "cbandicot at slushynet.de"
>
>Wenn Du uid und gid herausnimmst wird es nicht in der Abfrage erscheinen.
>
>Gruß Heiko
>  
>
>  
>
Hi Heiko,

endlich gibts logs zu dem Ding.... aber was ist hier los:

040415  0:17:16      16 Connect     root at localhost on
                     16 Query       SELECT VERSION() AS version
                     16 Query       show databases
                     16 Query       SELECT COUNT(*) FROM mysql.user
                     16 Query       USE mysql
                     16 Query       SET PASSWORD FOR 
"postfix"@"localhost" = PASSWORD("passwort")
                     16 Query       SELECT "foo" FROM `user` WHERE 
`User` = "postfix" AND `Host` = "localhost"
                     16 Query       SELECT * FROM `user` WHERE `User` = 
"postfix" AND `Host` = "localhost"
                     16 Query       SELECT * FROM `db` WHERE `Host` = 
"localhost" AND `User` = "postfix" ORDER BY `Db` ASC
                     16 Query       SHOW DATABASES
                     16 Query       SELECT USER()
                     16 Quit
040415  0:19:24      17 Connect     Access denied for user: 
'potstfix at localhost' (Using password: YES)

linhome:/etc/postfix # cat mailbox.mysql
user=postfix
password=passwort
hosts=localhost
dbname=mailbase
table=mailusers
select_field=home
where_field=account

gruss
Giuseppe