Problème postfix sur kimsufi debian sarge

[loupiot]

Bonjour,

D'abord un grand merci pour ce tutoriel qui m'a sauvé du désespoir (étant neophyte).
http://olange.developpez.com/article...?page=sommaire

Seulement j'aimerai avoir quelques précisions sur la page 6 (postfix)
En rouge mes questions....
Merci de votre futur aide, car je me suis surment mélangé les pinceaux pour l'install de postfix, helas ca ne fonctionne pas.

---------------------------------------------------------

Ma configue: sur un kimsufi Linux debian sarge
Nom de domaine : site.fr
Adresse ip : xxx.xxx.xxx.xxx
Mysql : root passQSL
Base de donné « postfix »

---------------------------------------------------------

nano /etc/mysql/my.cnf
bind-address = 127.0.0.1 (pour un serveur en ligne xxx.xxx.xxx.xxx?)
# skip-networking

---------------

On se connecte à mysql en root, afin de le configurer :
# mysql -p
On entre le mot de passe lorsque le shell nous le demande. On va maintenant ajouter nos paramètres Mysql :

---------------

> create database postfix;
> CREATE TABLE `domain` (
`domain` varchar(255) NOT NULL default '',
`actif` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`domain`)
) ENGINE=MyISAM COMMENT='Postfix Admin - Domaines Virtuels';
> CREATE TABLE `mailbox` (
`email` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`quota` int(10) NOT NULL default '0',
`actif` tinyint(1) NOT NULL default '1',
`imap` tinyint(1) NOT NULL default '1',
`pop3` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`email`)
) ENGINE=MyISAM COMMENT='Postfix Admin - Boites Emails Virtuelles';
> CREATE TABLE `alias` (
`source` varchar(255) NOT NULL default '',
`destination` text NOT NULL,
`actif` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`source`)
) ENGINE=MyISAM COMMENT='Postfix Admin - Alias Virtuels';

---------------

On rajoute l'utilisateur mysql pour postfix (pensez à remplacer MONMOTDEPASSE par le mot de passe désiré).
> GRANT SELECT ON `postfix`.* TO 'postfix'@'%' IDENTIFIED BY 'MONMOTDEPASSE';
> FLUSH PRIVILEGES;
> exit;
(On rajoute l'utilisateur mysql pour postfix? Euh root ou postfix?)
(pensez à remplacer MONMOTDEPASSE? PassSQL ou cree un mots de passe « passpostfix »?

---------------

# nano /etc/postfix/main.cf
smtp_banner = $myhostname ESMTP (Debian / GNU)
biff = no
disable_vrfy_command = yes
smtpd_helo_required = yes

append_dot_mydomain = no

mydestination = nom_de_votre_serveur, localhost, localhost.localdomain (site.fr?)

mydomain = nom_de_votre_serveur (site.fr?)

myhostname = nom_de_votre_serveur (site.fr?)

relayhost =

mynetworks = 127.0.0.0/8 ip_de_votre_serveur (xxx.xxx.xxx.xxx?)
inet_interfaces = all

smtpd_sender_restrictions =
permit_mynetworks,
reject_unknown_sender_domain,
warn_if_reject reject_unverified_sender

smtpd_recipient_restrictions =
permit_mynetworks,
reject_unauth_destination,
reject_unknown_recipient_domain,
reject_non_fqdn_recipient

smtpd_client_restrictions =
reject_unknown_client,
permit_mynetworks

virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_aliases.cf, mysql:/etc/postfix/mysql-virtual_aliases_mailbox.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/spool/vmail/
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000

virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "Desole, la boite email de l'utilisateur est pleine. Veuillez re-essayer plus tard !"
virtual_overquota_bounce = yes

---------------

# nano /etc/postfix/mysql-virtual_mailbox_limit_maps.cf
hosts = 127.0.0.1 (on ne met pas xxx.xxx.xxx.xxx?)
user = postfix (user root ou postfix)
password = VOTREMOTDEPASSE (passSQL ou passpostfix)
dbname = postfix
select_field = quota
table = mailbox
where_field = email

# nano /etc/postfix/mysql-virtual_aliases_mailbox.cf
hosts = 127.0.0.1 (on ne met pas xxx.xxx.xxx.xxx?)
user = postfix (user root ou postfix)
password = VOTREMOTDEPASSE (passSQL ou passpostfix)
dbname = postfix
select_field = email
table = mailbox
where_field = email
additional_conditions = AND actif='1'

# nano /etc/postfix/mysql-virtual_aliases.cf
hosts = 127.0.0.1 (on ne met pas xxx.xxx.xxx.xxx?)
user = postfix (user root ou postfix)
password = VOTREMOTDEPASSE (passSQL ou passpostfix)
dbname = postfix
select_field = destination
table = alias
where_field = source
additional_conditions = AND actif='1'

# nano /etc/postfix/mysql-virtual_mailboxes.cf
hosts = 127.0.0.1 (on ne met pas xxx.xxx.xxx.xxx?)
user = postfix (user root ou postfix)
password = VOTREMOTDEPASSE (passSQL ou passpostfix)
dbname = postfix
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
table = mailbox
where_field = email
additional_conditions = AND actif='1'

# nano /etc/postfix/mysql-virtual_domains.cf
hosts = 127.0.0.1 (on ne met pas xxx.xxx.xxx.xxx?)
user = postfix (user root ou postfix)
password = VOTREMOTDEPASSE (passSQL ou passpostfix)
dbname = postfix
select_field = 'virtual'
table = domain
where_field = domain
additional_conditions = AND actif='1'

---------------

On modifie les droits de ces fichiers de configuration :
# chgrp postfix /etc/postfix/mysql-virtual_*.cf
# chmod u=rw,g=r,o= /etc/postfix/mysql-virtual_*.cf
Un redémarage de Postfix, et un test de la configuration :
# /etc/init.d/postfix restart
# postfix check


# apt-get install courier-base courier-authdaemon courier-authmysql courier-imap courier-pop

# nano /etc/courier/authdaemonrc
authmodulelist="authmysql"

---------------

# nano /etc/courier/authmysqlrc
MYSQL_SERVER localhost

MYSQL_USERNAME postfix (on met pas root?)

MYSQL_PASSWORD MOTDEPASSE (passSQL ou passpostfix)

MYSQL_PORT 0

MYSQL_OPT 0

MYSQL_DATABASE postfix

MYSQL_USER_TABLE mailbox

MYSQL_CRYPT_PWFIELD password

MYSQL_UID_FIELD 5000

MYSQL_GID_FIELD 5000

MYSQL_LOGIN_FIELD email

MYSQL_HOME_FIELD "/var/spool/vmail/"

MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')

MYSQL_QUOTA_FIELD quota

---------------

# /etc/init.d/courier-authdaemon restart
# /etc/init.d/courier-imap restart
# /etc/init.d/courier-pop restart

# apt-get install mailutils
# host -t MX nom_domaine

---------------

# mysql -u root -p
==> On entre le mot de passe
> use postfix;
> INSERT INTO domain (domain, actif) VALUES ('nom_domaine.com', '1'); ('site.fr', '1')
> INSERT INTO mailbox (email,password,quota,actif,imap,pop3) VALUES ('user@nom_domaine.com',ENCRYPT('MONMOTDEPASSEDUCOMPTEMAIL'),0,1,1,1);
> exit;
('user@site.fr',ENCRYPT('passSQL ou passpostfix'),0,1,1,1);

---------------

mail -s sujet
To : user@site.fr
Cc : user@free.fr (exemple)
texte du mail
.
pop: mail.site.fr
smtp: votre FAI
login: user@site.fr
pass: ***** (passpostfix, normalement)

[loupiot]

Bonjour,

J'ai pu trouver les informations que je souhaitais, seulement j'ai toujours le même problème après deux reinstall.


mail.log

Code :

1
2
3
4
5
 
May 27 17:18:14 ksxxxxx postfix/pickup[10561]: F102A414F: uid=0 from=<root>
May 27 17:18:14 ksxxxxx postfix/cleanup[13254]: F102A414F: message-id=<20070527150132.F102A414F@mail.site.fr>
May 27 17:18:14 ksxxxxx postfix/cleanup[13254]: warning: F102A414F: virtual_alias_maps map lookup problem for webmaster@site.fr
May 27 17:18:14 ksxxxxx postfix/pickup[10561]: warning: maildrop/3D205412F: Error writing message file

Voila ma config, demandez moi s'il vous faut d'autre conf...

main.cf

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 
 
biff = no
 
append_dot_mydomain = no
 
myhostname = mail.site.fr
mydomain = site.fr
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = site.fr
mydestination = site.fr, localhost.site.fr, localhost, $mydomain
relayhost = 213.251.xxx.xxx
mynetworks = 127.0.0.0/8
mailbox_command = /usr/bin/procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
 
smtpd_sender_restrictions =
        permit_mynetworks,
        reject_unknown_sender_domain,
        warn_if_reject reject_unverified_sender
 
smtpd_recipient_restrictions =
        permit_mynetworks,
        reject_unauth_destination,
        reject_unknown_recipient_domain,
        reject_non_fqdn_recipient
 
smtpd_client_restrictions =
        reject_unknown_client,
        permit_mynetworks
 
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_aliases.cf, mysql:/etc/postfix/mysql-virtual_aliases_mailbox.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/spool/vmail/
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
 
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "Desole, la boite email de l'utilisateur est pleine. Veuillez re-essayer plus tard !"
virtual_overquota_bounce = yes
 
queue_directory = /var/spool/postfix

mysql-virtual_aliases

Code :

1
2
3
4
5
6
7
8
hosts = 127.0.0.1
user = postfix
password = xxx
dbname = postfix
select_field = destination
table = alias
where_field = source
additional_conditions = AND actif='1'

mysql-virtual_aliases_mailbox

Code :

1
2
3
4
5
6
7
8
hosts = 127.0.0.1
user = postfix
password = xxx
dbname = postfix
select_field = email
table = mailbox
where_field = email
additional_conditions = AND actif='1'

Un grand merci a tous ceux qui pouraient m'aider.

[m14w]

essaye cà:
nano /etc/postfix/master.cf

Code :

1
2
3
4
5
6
7
8
 
# ====================================================== 
# service type  private unpriv  chroot  wakeup  maxproc command + args 
#               (yes)   (yes)   (yes)   (never) (50) 
# ====================================================== 
smtp      inet  n       -       n       -       -       smtpd 
cleanup   unix  n       -       n       -       0       cleanup 
rewrite   unix  -       -       n       -       -       trivial-rewrite

il faut rajouter les n je pense.