Portál AbcLinuxu, 24. dubna 2024 10:53
Aug 16 15:08:45 localhost postfix/smtpd[12741]: connect from unknown[213.210.179.211] Aug 16 15:09:17 localhost postfix/smtpd[12741]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Aug 16 15:09:17 localhost postfix/smtpd[12741]: fatal: mysql:/etc/postfix/mysql-recipient.cf: table lookup problem Aug 16 17:09:18 localhost postfix/master[12169]: warning: process /usr/libexec/postfix/smtpd pid 12741 exit status 1 Aug 16 17:09:46 localhost postfix/smtpd[12742]: connect from unknown[192.168.0.1] Aug 16 15:09:47 localhost postfix/smtpd[12742]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Aug 16 15:09:47 localhost postfix/smtpd[12742]: fatal: mysql:/etc/postfix/mysql-recipient.cf: table lookup problem Aug 16 17:09:48 localhost postfix/master[12169]: warning: process /usr/libexec/postfix/smtpd pid 12742 exit status 1 Aug 16 17:09:48 localhost postfix/master[12169]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttlingPritom, by to melo fungovat, i hesla jsou spravne nastavene. Diky za jakoukoliv radu
Recipient address rejected: Relay access denied; from=mail odesilatele to=mail prijemce proto=SMTP helo=homeKam bych mel napsat povoleni relaye ? Dekuji
smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/mysql-recipient.cf, reject_unknown_sender_domain, permit_mynetworks, permit_sasl_authenticated, check_relay_domains, rejectv /usr/lib/sasl2/smtpd.conf mam:
log_level: 3 sasl_pwcheck_method: auxprop sasl_auxprop_plugin: sql login plain crammd6 digestmd5 sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: UZIVATEL sql_passwd: NEJAKYHESLO sql_select: SELECT clear FROM postfix_users WHERE email = '%u@%r' sql_usessl: no sql_verbose: yesdo logu mi to pise hasky:
Aug 16 21:54:06 localhost postfix/qmgr[20680]: 42C232A01FF: from=mail odesilatele, size=928, nrcpt=1 (queue active) Aug 16 21:54:06 localhost postfix/qmgr[20680]: warning: connect to transport smtp: Connection refused Aug 16 21:54:06 localhost postfix/qmgr[20680]: F011A2A08D3: from=mail odesilatele, size=816, nrcpt=1 (queue active) Aug 16 21:54:06 localhost postfix/qmgr[20680]: F011A2A08D3: to=mail prijemce, relay=none, delay=4384, status=deferred (delivery temporarily suspended: transport is unavailable) Aug 16 21:54:11 localhost postfix/smtpd[20705]: connect from unknown[192.168.0.1] Aug 16 19:54:11 localhost postfix/smtpd[20705]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: Bad file descriptor Aug 16 19:54:11 localhost postfix/smtpd[20705]: warning: SASL authentication problem: unable to open Berkeley db /etc/sasldb2: Bad file descriptor Aug 16 19:54:11 localhost postfix/smtpd[20705]: warning: unknown[192.168.0.1]: SASL LOGIN authentication failed Aug 16 19:54:11 localhost postfix/smtpd[20705]: lost connection after AUTH from unknown[192.168.0.1] Aug 16 19:54:11 localhost postfix/smtpd[20705]: disconnect from unknown[192.168.0.1]
auth_userdb = mysql /etc/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot-mysql.conf default_mail_env = mbox:~/mail/:INBOX=/var/spool/mail/%u/etc/dovecot-mysql.conf
#TABULKA PRO MYSQL # CREATE TABLE users ( # userid VARCHAR(128) NOT NULL, # password VARCHAR(64) NOT NULL, # home VARCHAR(256) NOT NULL, # uid INTEGER NOT NULL, # gid INTEGER NOT NULL, # active CHAR(1) DEFAULT 'Y' NOT NULL # ); db_host = localhost db_port = 3306 db_unix_socket = /var/lib/mysql/mysql.sock db = DATABAZE db_user = UZIVATEL db_passwd = TAJNEHESLO db_client_flags = 0 # Default password scheme. # # Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and CRYPT. # default_pass_scheme = crypt # Query to retrieve the password. # # The query should return one row, one column. If more than one row or column # is returned, authentication will automatically fail. # # Available substitutions: # %u = entire userid # %n = user part of user@domain # %d = domain part of user@domain # # Example: # password_query = SELECT password FROM users WHERE userid = '%n' AND domain = '%d' # password_query = SELECT password FROM users WHERE userid = '%u' AND active = 'Y' # #password_query = SELECT password FROM users WHERE userid = '%u' password_query = SELECT password FROM users WHERE userid = '%u' AND active = 'Y' # Query to retrieve the user information. # # The query must return only one row. The columns to return are: # home - Home directory # mail - MAIL environment # system_user - System user name (for initgroups()) # uid - System UID # gid - System GID # # Either home or mail is required. uid and gid are required. If more than one # row is returned or there's missing fields, login will automatically fail. # # Examples # user_query = SELECT home, uid, gid FROM users WHERE userid = '%n' AND domain = '%d' # user_query = SELECT dir AS home, user AS uid, group AS gid FROM users where userid = '%u' #user_query = SELECT home, 91 AS uid, 91 AS gid FROM users WHERE userid = '%u' # #user_query = SELECT home, uid, gid FROM users WHERE userid = '%u'
mkpasswd --hash=md5 heslo
(GNU mkpasswd 4.7.5).
smtps inet n - n - - smtpd -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
Tiskni Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.