Dotaz: Problem s Postfixem potrebuji nakopnout

[Karel]

postfix/error[31829]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problém

Prosím co s tím, zdá se že server odesílá spam.

Odpovědi

[Petr Šobáň]

Že by nastavit?

Viz: 6. Služby mailového servera

Nějak z jedné řádky těžko můžeme usuzovat kde je chyba.

[Karel]

Samozřejmě chápu. Pokud někdo vyžádá další informace rád je poskytnu. Vážím si každé pomoci.

Aspon kousek mail error logu. Feb 20 07:44:50 server postfix/trivial-rewrite[513]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:09 server postfix/smtp[6186]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:40 server postfix/smtp[7198]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:41 server postfix/smtp[7194]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:41 server postfix/smtp[7196]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:45 server postfix/smtp[7206]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:47 server postfix/smtp[7211]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:59 server postfix/trivial-rewrite[5398]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem Feb 20 08:00:59 server postfix/smtp[7275]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem

[NN]

Databaze bazi ? Manualne se pres prihasovaci udaje uvedene v konfiguraci prihlasis ? Tabulky na ktere odkazuje konfigurace existuji ?

[Karel]

Jak to zjistim? Prosim o shovivavost, zacinam s linux serverem a googlim se s tim uz od rana, takze me hned neukamenujte.

[Karel]

Jo uz to vidim. DB bezí, soude dle toho ze funguje ispconfig3, tabulky v databázích dle cf souboru existuji, jen nevim jak zkusit rucni prihlaseni. prikladamjeden z cf souboru

mysql-virtual_relaydomains.cf

user = ispconfig password = e1e0681a6dc07dfb6edxxxxx7638e8d6 dbname = dbispconfig table = mail_transport select_field = domain where_field = domain additional_conditions = and active = 'y' and server_id = 1 hosts = 127.0.0.1

[NN]

mysql -u ispconfig -p dbispconfig

heslo tam mas napsane staci napastovat

show tables;

over, ze existuje tabulka mail_transport.

[Karel]

mysql> show tables; +-----------------------+ | Tables_in_dbispconfig | +-----------------------+ | attempts_login | | client | | client_template | | country | | cron | | dns_rr | | dns_slave | | dns_soa | | dns_template | | domain | | firewall | | ftp_user | | help_faq | | help_faq_sections | | iptables | | mail_access | | mail_content_filter | | mail_domain | | mail_forwarding | | mail_get | | mail_mailinglist | | mail_relay_recipient | | mail_traffic | | mail_transport | | mail_user | | mail_user_filter | | monitor_data | | openvz_ip | | openvz_ostemplate | | openvz_template | | openvz_traffic | | openvz_vm | | remote_session | | remote_user | | server | | server_ip | | shell_user | | software_package | | software_repo | | software_update | | software_update_inst | | spamfilter_policy | | spamfilter_users | | spamfilter_wblist | | support_message | | sys_config | | sys_datalog | | sys_dbsync | | sys_filesync | | sys_group | | sys_ini | | sys_log | | sys_remoteaction | | sys_session | | sys_user | | web_database | | web_domain | | web_folder | | web_folder_user | | web_traffic | | webdav_user | +-----------------------+ 61 rows in set (0.00 sec)

mysql>

Dekuju, zda se ze mail_transport i ostatní tabulky existují. Jak byste postupovali dál. Moc dík.

[NN]

Dej jeste:

select * from mail_transport;

jestli neni prazdna..

[Karel]

mysql> select * from mail_transport; +--------------+------------+-------------+---------------+----------------+----------------+-----------+-- ------+-----------+------------+--------+ | transport_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | d omain | transport | sort_order | active | +--------------+------------+-------------+---------------+----------------+----------------+-----------+-- ------+-----------+------------+--------+ | 1 | 1 | 1 | riud | riud | | 1 | | smtp: | 5 | y | +--------------+------------+-------------+---------------+----------------+----------------+-----------+-- ------+-----------+------------+--------+ 1 row in set (0.00 sec)

mysql>

[NN]

Je tam jeden radek ? NEni tam nejak malo hodnot ? Jako treba domena ? Nepreinstaloval/upgradoval si ISPconfig ? Pres webove rozhrani se nastaveni posty jevi normalni ?