Probleme postfix multidomaine mysql

Fermé
waffa Messages postés 4 Date d'inscription jeudi 14 janvier 2010 Statut Membre Dernière intervention 14 janvier 2010 - 14 janv. 2010 à 14:39
waffa Messages postés 4 Date d'inscription jeudi 14 janvier 2010 Statut Membre Dernière intervention 14 janvier 2010 - 14 janv. 2010 à 19:56
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 ;)

4 réponses

Utilisateur anonyme
14 janv. 2010 à 14:41
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
0
waffa Messages postés 4 Date d'inscription jeudi 14 janvier 2010 Statut Membre Dernière intervention 14 janvier 2010
14 janv. 2010 à 15:08
le probleme c'est que mon projet mon tuteur veut avec mysql donc voila quoi je suis un peux enmerdé lol
0
waffa Messages postés 4 Date d'inscription jeudi 14 janvier 2010 Statut Membre Dernière intervention 14 janvier 2010
14 janv. 2010 à 17:52
up up
0
waffa Messages postés 4 Date d'inscription jeudi 14 janvier 2010 Statut Membre Dernière intervention 14 janvier 2010
14 janv. 2010 à 19:56
mercie lucie ,
mais je ne trouve rien qui puissent m'aider sur se site
0

Discussions similaires