Probleme postfix multidomaine mysql
waffa
Messages postés
4
Date d'inscription
Statut
Membre
Dernière intervention
-
waffa Messages postés 4 Date d'inscription Statut Membre Dernière intervention -
waffa Messages postés 4 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
Bonjour a tous :D,
comment va??;)
bon je vous expose mon petit probleme donc j'essaye d'installé un serveur de mail postfix multidomaine avec authentification mysql j'ai suivie quelque tuto puis sa marche pas :( sa fait 1 semaine je suis dessus je desespere .
mon premier problème déja est que les mail sont envoyé mais pas dans le bon format je l'ai voudrai en maildir puis en plus de cela il vont pas dans le dossier que je lui est indiqué il vont dans /var/spool/mail alors que j'ai indiqué /var/spool/vmail :( :( :(
mon deuxieme souci enfin je sais si s'en ai un mais faut que je créé le user en local pour que le mail soit envoyer sinon il me dit ID inconnu dans va/log/mail.log alor que je voudrai q'uil prennent juste l'adresse mail comme user ou créé un champs user dans la table sql puis il va la pompé labas mais sa ne sais pas tro comment faire lol.
et derniere question est ce que j'ai besoin de dovecot alors que j'ai courier-pop
bon deja c'est pas mal je verai pour la suite
voila les fichier de conf
main.cf
smtp_banner = $myhostname ESMTP (Debian / GNU)
biff = no
disable_vrfy_command = yes
smtpd_helo_required = yes
append_dot_mydomain = no
mydestination = mon_domaine, localhost, localhost.localdomain
mydomain = mon_domaine
myhostname = mon_domaine
relayhost =
mynetworks = 127.0.0.0/8
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
main.log
Jan 14 12:21:58 waffa-laptop postfix/pickup[3760]: F3EFAFA13E: uid=0 from=<root>
Jan 14 12:21:59 waffa-laptop postfix/cleanup[3768]: F3EFAFA13E: message-id=<20100114112158.F3EFAFA13E@mon_domain>
Jan 14 12:21:59 waffa-laptop postfix/qmgr[3761]: F3EFAFA13E: from=<root@mon_domain>, size=325, nrcpt=2 (queue active)
Jan 14 12:21:59 waffa-laptop postfix/trivial-rewrite[3769]: warning: do not list domain mon domain in BOTH mydestination and virtual_mailbox_domains
Jan 14 12:21:59 waffa-laptop postfix/trivial-rewrite[3769]: warning: do not list domain mon_domain in BOTH mydestination and virtual_mailbox_domains
Jan 14 12:21:59 waffa-laptop postfix/local[3770]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Jan 14 12:21:59 waffa-laptop postfix/local[3771]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Jan 14 12:21:59 waffa-laptop postfix/local[3770]: F3EFAFA13E: to=<root@mon_domain>, relay=local, delay=0.06, delays=0.04/0.01/0/0.01, dsn=2.0.0, status=sent (delivered to mailbox)
Jan 14 12:21:59 waffa-laptop postfix/local[3771]: F3EFAFA13E: to=<wawa@mon_domain>, relay=local, delay=0.06, delays=0.04/0.02/0/0, dsn=2.0.0, status=sent (delivered to mailbox)
Jan 14 12:21:59 waffa-laptop postfix/qmgr[3761]: F3EFAFA13E: removed
mysql-virtual_aliases.cf
hosts = 127.0.0.1
user = use sql
password = passwd sql
dbname = nomdb
select_field = destination
table = alias
where_field = source
additional_conditions = AND actif='1'
mysql-virtual_aliases_mailboxes.cf
hosts = 127.0.0.1
user = use sql
password = paswd sql
dbname = postfix
select_field = email
table = mailbox
where_field = email
additional_conditions = AND actif='1'
mysql-virtual_domains.cf
hosts = 127.0.0.1
user = use sql
password = passwdsql
dbname = postfix
select_field = 'virtual'
table = domain
where_field = domain
additional_conditions = AND actif='1'
mysql-virtual_mailboxes.cf
hosts = 127.0.0.1
user = use sql
password = passwdsql
dbname = postfix
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
table = mailbox
where_field = email
additional_conditions = AND actif='1'
mysql-virtual_mailbox_limit_maps.cf
hosts = 127.0.0.1
user = use sql
password = passwd sql
dbname = postfix
select_field = quota
table = mailbox
where_field = email
authdaemonrc
##VERSION: $Id: authdaemonrc.in,v 1.13 2005/10/05 00:07:32 mrsam Exp $
#
# Copyright 2000-2005 Double Precision, Inc. See COPYING for
# distribution information.
#
# authdaemonrc created from authdaemonrc.dist by sysconftool
#
# Do not alter lines that begin with ##, they are used when upgrading
# this configuration.
#
# This file configures authdaemond, the resident authentication daemon.
#
# Comments in this file are ignored. Although this file is intended to
# be sourced as a shell script, authdaemond parses it manually, so
# the acceptable syntax is a bit limited. Multiline variable contents,
# with the \ continuation character, are not allowed. Everything must
# fit on one line. Do not use any additional whitespace for indentation,
# or anything else.
##NAME: authmodulelist:2
#
# The authentication modules that are linked into authdaemond. The
# default list is installed. You may selectively disable modules simply
# by removing them from the following list. The available modules you
# can use are: authuserdb authpam authpgsql authldap authmysql authcustom authpipe
authmodulelist="authmysql"
##NAME: authmodulelistorig:3
#
# This setting is used by Courier's webadmin module, and should be left
# alone
authmodulelistorig="authuserdb authpam authpgsql authldap authmysql authcustom authpipe"
##NAME: daemons:0
#
# The number of daemon processes that are started. authdaemon is typically
# installed where authentication modules are relatively expensive: such
# as authldap, or authmysql, so it's better to have a number of them running.
# PLEASE NOTE: Some platforms may experience a problem if there's more than
# one daemon. Specifically, SystemV derived platforms that use TLI with
# socket emulation. I'm suspicious of TLI's ability to handle multiple
# processes accepting connections on the same filesystem domain socket.
#
# You may need to increase daemons if as your system load increases. Symptoms
# include sporadic authentication failures. If you start getting
# authentication failures, increase daemons. However, the default of 5
# SHOULD be sufficient. Bumping up daemon count is only a short-term
# solution. The permanent solution is to add more resources: RAM, faster
# disks, faster CPUs...
daemons=5
##NAME: authdaemonvar:2
#
# authdaemonvar is here, but is not used directly by authdaemond. It's
# used by various configuration and build scripts, so don't touch it!
authdaemonvar=/var/run/courier/authdaemon
##NAME: DEBUG_LOGIN:0
#
# Dump additional diagnostics to syslog
#
# DEBUG_LOGIN=0 - turn off debugging
# DEBUG_LOGIN=1 - turn on debugging
# DEBUG_LOGIN=2 - turn on debugging + log passwords too
#
# ** YES ** - DEBUG_LOGIN=2 places passwords into syslog.
#
# Note that most information is sent to syslog at level 'debug', so
# you may need to modify your /etc/syslog.conf to be able to see it.
DEBUG_LOGIN=0
##NAME: DEFAULTOPTIONS:0
#
# A comma-separated list of option=value pairs. Each option is applied
# to an account if the account does not have its own specific value for
# that option. So for example, you can set
# DEFAULTOPTIONS="disablewebmail=1,disableimap=1"
# and then enable webmail and/or imap on individual accounts by setting
# disablewebmail=0 and/or disableimap=0 on the account.
DEFAULTOPTIONS=""
##NAME: LOGGEROPTS:0
#
# courierlogger(1) options, e.g. to set syslog facility
#
LOGGEROPTS=""
##NAME: LDAP_TLS_OPTIONS:0
#
# Options documented in ldap.conf(5) can be set here, prefixed with 'LDAP'.
# Examples:
#
#LDAPTLS_CACERT=/path/to/cacert.pem
#LDAPTLS_REQCERT=demand
#LDAPTLS_CERT=/path/to/clientcert.pem
#LDAPTLS_KEY=/path/to/clientkey.pem
authmysqlrc
MYSQL_SERVER localhost
MYSQL_USERNAME use sql
MYSQL_PASSWORD passwd sql
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/code
en tout cas je vous remercie beaucoup d'avance parce que la je commence a secher et j'espere que j'ai bien mis tout les fichier de conf qu il faut
merci beaucoup:D
PS: desolé pour les fautes d'orthographe ;)
Bonjour a tous :D,
comment va??;)
bon je vous expose mon petit probleme donc j'essaye d'installé un serveur de mail postfix multidomaine avec authentification mysql j'ai suivie quelque tuto puis sa marche pas :( sa fait 1 semaine je suis dessus je desespere .
mon premier problème déja est que les mail sont envoyé mais pas dans le bon format je l'ai voudrai en maildir puis en plus de cela il vont pas dans le dossier que je lui est indiqué il vont dans /var/spool/mail alors que j'ai indiqué /var/spool/vmail :( :( :(
mon deuxieme souci enfin je sais si s'en ai un mais faut que je créé le user en local pour que le mail soit envoyer sinon il me dit ID inconnu dans va/log/mail.log alor que je voudrai q'uil prennent juste l'adresse mail comme user ou créé un champs user dans la table sql puis il va la pompé labas mais sa ne sais pas tro comment faire lol.
et derniere question est ce que j'ai besoin de dovecot alors que j'ai courier-pop
bon deja c'est pas mal je verai pour la suite
voila les fichier de conf
main.cf
smtp_banner = $myhostname ESMTP (Debian / GNU)
biff = no
disable_vrfy_command = yes
smtpd_helo_required = yes
append_dot_mydomain = no
mydestination = mon_domaine, localhost, localhost.localdomain
mydomain = mon_domaine
myhostname = mon_domaine
relayhost =
mynetworks = 127.0.0.0/8
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
main.log
Jan 14 12:21:58 waffa-laptop postfix/pickup[3760]: F3EFAFA13E: uid=0 from=<root>
Jan 14 12:21:59 waffa-laptop postfix/cleanup[3768]: F3EFAFA13E: message-id=<20100114112158.F3EFAFA13E@mon_domain>
Jan 14 12:21:59 waffa-laptop postfix/qmgr[3761]: F3EFAFA13E: from=<root@mon_domain>, size=325, nrcpt=2 (queue active)
Jan 14 12:21:59 waffa-laptop postfix/trivial-rewrite[3769]: warning: do not list domain mon domain in BOTH mydestination and virtual_mailbox_domains
Jan 14 12:21:59 waffa-laptop postfix/trivial-rewrite[3769]: warning: do not list domain mon_domain in BOTH mydestination and virtual_mailbox_domains
Jan 14 12:21:59 waffa-laptop postfix/local[3770]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Jan 14 12:21:59 waffa-laptop postfix/local[3771]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Jan 14 12:21:59 waffa-laptop postfix/local[3770]: F3EFAFA13E: to=<root@mon_domain>, relay=local, delay=0.06, delays=0.04/0.01/0/0.01, dsn=2.0.0, status=sent (delivered to mailbox)
Jan 14 12:21:59 waffa-laptop postfix/local[3771]: F3EFAFA13E: to=<wawa@mon_domain>, relay=local, delay=0.06, delays=0.04/0.02/0/0, dsn=2.0.0, status=sent (delivered to mailbox)
Jan 14 12:21:59 waffa-laptop postfix/qmgr[3761]: F3EFAFA13E: removed
mysql-virtual_aliases.cf
hosts = 127.0.0.1
user = use sql
password = passwd sql
dbname = nomdb
select_field = destination
table = alias
where_field = source
additional_conditions = AND actif='1'
mysql-virtual_aliases_mailboxes.cf
hosts = 127.0.0.1
user = use sql
password = paswd sql
dbname = postfix
select_field = email
table = mailbox
where_field = email
additional_conditions = AND actif='1'
mysql-virtual_domains.cf
hosts = 127.0.0.1
user = use sql
password = passwdsql
dbname = postfix
select_field = 'virtual'
table = domain
where_field = domain
additional_conditions = AND actif='1'
mysql-virtual_mailboxes.cf
hosts = 127.0.0.1
user = use sql
password = passwdsql
dbname = postfix
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
table = mailbox
where_field = email
additional_conditions = AND actif='1'
mysql-virtual_mailbox_limit_maps.cf
hosts = 127.0.0.1
user = use sql
password = passwd sql
dbname = postfix
select_field = quota
table = mailbox
where_field = email
authdaemonrc
##VERSION: $Id: authdaemonrc.in,v 1.13 2005/10/05 00:07:32 mrsam Exp $
#
# Copyright 2000-2005 Double Precision, Inc. See COPYING for
# distribution information.
#
# authdaemonrc created from authdaemonrc.dist by sysconftool
#
# Do not alter lines that begin with ##, they are used when upgrading
# this configuration.
#
# This file configures authdaemond, the resident authentication daemon.
#
# Comments in this file are ignored. Although this file is intended to
# be sourced as a shell script, authdaemond parses it manually, so
# the acceptable syntax is a bit limited. Multiline variable contents,
# with the \ continuation character, are not allowed. Everything must
# fit on one line. Do not use any additional whitespace for indentation,
# or anything else.
##NAME: authmodulelist:2
#
# The authentication modules that are linked into authdaemond. The
# default list is installed. You may selectively disable modules simply
# by removing them from the following list. The available modules you
# can use are: authuserdb authpam authpgsql authldap authmysql authcustom authpipe
authmodulelist="authmysql"
##NAME: authmodulelistorig:3
#
# This setting is used by Courier's webadmin module, and should be left
# alone
authmodulelistorig="authuserdb authpam authpgsql authldap authmysql authcustom authpipe"
##NAME: daemons:0
#
# The number of daemon processes that are started. authdaemon is typically
# installed where authentication modules are relatively expensive: such
# as authldap, or authmysql, so it's better to have a number of them running.
# PLEASE NOTE: Some platforms may experience a problem if there's more than
# one daemon. Specifically, SystemV derived platforms that use TLI with
# socket emulation. I'm suspicious of TLI's ability to handle multiple
# processes accepting connections on the same filesystem domain socket.
#
# You may need to increase daemons if as your system load increases. Symptoms
# include sporadic authentication failures. If you start getting
# authentication failures, increase daemons. However, the default of 5
# SHOULD be sufficient. Bumping up daemon count is only a short-term
# solution. The permanent solution is to add more resources: RAM, faster
# disks, faster CPUs...
daemons=5
##NAME: authdaemonvar:2
#
# authdaemonvar is here, but is not used directly by authdaemond. It's
# used by various configuration and build scripts, so don't touch it!
authdaemonvar=/var/run/courier/authdaemon
##NAME: DEBUG_LOGIN:0
#
# Dump additional diagnostics to syslog
#
# DEBUG_LOGIN=0 - turn off debugging
# DEBUG_LOGIN=1 - turn on debugging
# DEBUG_LOGIN=2 - turn on debugging + log passwords too
#
# ** YES ** - DEBUG_LOGIN=2 places passwords into syslog.
#
# Note that most information is sent to syslog at level 'debug', so
# you may need to modify your /etc/syslog.conf to be able to see it.
DEBUG_LOGIN=0
##NAME: DEFAULTOPTIONS:0
#
# A comma-separated list of option=value pairs. Each option is applied
# to an account if the account does not have its own specific value for
# that option. So for example, you can set
# DEFAULTOPTIONS="disablewebmail=1,disableimap=1"
# and then enable webmail and/or imap on individual accounts by setting
# disablewebmail=0 and/or disableimap=0 on the account.
DEFAULTOPTIONS=""
##NAME: LOGGEROPTS:0
#
# courierlogger(1) options, e.g. to set syslog facility
#
LOGGEROPTS=""
##NAME: LDAP_TLS_OPTIONS:0
#
# Options documented in ldap.conf(5) can be set here, prefixed with 'LDAP'.
# Examples:
#
#LDAPTLS_CACERT=/path/to/cacert.pem
#LDAPTLS_REQCERT=demand
#LDAPTLS_CERT=/path/to/clientcert.pem
#LDAPTLS_KEY=/path/to/clientkey.pem
authmysqlrc
MYSQL_SERVER localhost
MYSQL_USERNAME use sql
MYSQL_PASSWORD passwd sql
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/code
en tout cas je vous remercie beaucoup d'avance parce que la je commence a secher et j'espere que j'ai bien mis tout les fichier de conf qu il faut
merci beaucoup:D
PS: desolé pour les fautes d'orthographe ;)
A voir également:
- Probleme postfix multidomaine mysql
- Mysql community server - Télécharger - Bases de données
- Could not connect to mysql! please check your database settings! - Forum Redhat
- Mysql error 1 ✓ - Forum Réseaux sociaux
- Phpmyadmin a tenté de se connecter au serveur mysql, et le serveur a rejeté la connexion. merci de vérifier les valeurs de host, username et password dans la configuration et de s'assurer qu'elles correspondent aux informations fournies par l'administrateur du serveur mysql. ✓ - Forum PHP
- Access vs mysql - Forum Webmastering
4 réponses
Tu as essayé avec une base d'annuaire comme openLDAP, j'ai fais un stage avec un serveur PostFix est une base d'annuaire LDAP, c'est super simple à mettre en place, et pas mal de tuto sont dispo