Postfix - problem z virtual users w MySQL |
Postfix - problem z virtual users w MySQL |
03.03.2010 - 16:50
Post
#1
|
|
|
Początkujący ![]() Grupa: Użytkownik Postów: 6 Dołączył: 03.03.2010 Użytkownik nr: 927 |
Mam postfixa, a userów wirtualnych w bazie MySQL. Jakiś czas temu robiłem optymalizację MySQL - tak jak kazał mi robić support vBulletin. Od tego czasu pojawiają się takie błędy:
KOD Mar 2 10:32:09 kimsufi postfix/smtpd[25002]: connect from alv85.rev.netart.pl[85.128.178.85] Mar 2 10:32:09 kimsufi postfix/smtpd[25002]: warning: mysql query failed: MySQL server has gone away Mar 2 10:32:09 kimsufi postfix/smtpd[25002]: NOQUEUE: reject: RCPT from alv85.rev.netart.pl[85.128.178.85]: 451 4.3.0 <login1@host.pl>: Temporary lookup failure; from=<heniek@heniek.nazwa.pl> to=<login1@host.pl> proto=ESMTP helo=<heniek.nazwa.pl> Mar 2 10:32:09 kimsufi postfix/cleanup[25006]: D7A95CA045: message-id=<20100302093209.D7A95CA045@kimsufi.kimsufi.com> Mar 2 10:32:09 kimsufi postfix/qmgr[658]: D7A95CA045: from=<double-bounce@kimsufi.kimsufi.com>, size=1110, nrcpt=1 (queue active) Mar 2 10:32:09 kimsufi postfix/virtual[25007]: warning: mysql query failed: MySQL server has gone away Mar 2 10:32:09 kimsufi postfix/virtual[25007]: warning: table virtual_mailbox_maps: lookup postmaster@moj.org: Success Mar 2 10:32:09 kimsufi postfix/smtpd[25002]: disconnect from alv85.rev.netart.pl[85.128.178.85] Mar 2 10:32:09 kimsufi postfix/virtual[25007]: D7A95CA045: to=<postmaster@moj.org>, orig_to=<postmaster>, relay=virtual, delay=0.03, delays=0.01/0.01/0/0.01, dsn=4.3.5, status=deferred (mail system configuration error) Mar 2 10:35:29 kimsufi postfix/anvil[25004]: statistics: max connection rate 1/60s for (smtp:212.91.6.33) at Mar 2 10:31:24 Mar 2 10:35:29 kimsufi postfix/anvil[25004]: statistics: max connection count 1 for (smtp:212.91.6.33) at Mar 2 10:31:24 Mar 2 10:35:29 kimsufi postfix/anvil[25004]: statistics: max cache size 2 at Mar 2 10:32:09 Mar 2 10:38:55 kimsufi postfix/pickup[21521]: EBC20CA051: uid=33 from=<www-data> Mar 2 10:38:55 kimsufi postfix/cleanup[25469]: EBC20CA051: message-id=<20100302093851.0a1b99527c84@www.mojhost.org> Mar 2 10:38:55 kimsufi postfix/qmgr[658]: EBC20CA051: from=<www-data@kimsufi.kimsufi.com>, size=833, nrcpt=1 (queue active) Mar 2 10:38:56 kimsufi postfix/smtp[25472]: EBC20CA051: to=<beatika@op.pl>, relay=mx.poczta.onet.pl[213.180.147.146]:25, delay=0.44, delays=0.06/0.01/0.18/0.19, dsn=2.0.0, status=sent (250 2.0.0 Accepted; S134220631Ab0CBJgFjV3i0) Mar 2 10:38:56 kimsufi postfix/qmgr[658]: EBC20CA051: removed Mar 2 10:41:14 kimsufi postfix/qmgr[658]: D7A95CA045: from=<double-bounce@kimsufi.kimsufi.com>, size=1110, nrcpt=1 (queue active) Mar 2 10:41:14 kimsufi postfix/virtual[25770]: D7A95CA045: to=<postmaster@moj.org>, orig_to=<postmaster>, relay=virtual, delay=545, delays=544/0.04/0/0.01, dsn=2.0.0, status=sent (delivered to maildir) Mar 2 10:41:14 kimsufi postfix/qmgr[658]: D7A95CA045: removed Mar 2 10:41:58 kimsufi postfix/smtpd[25773]: warning: database /etc/aliases.db is older than source file /etc/aliases Mar 2 10:41:58 kimsufi postfix/smtpd[25773]: connect from alv85.rev.netart.pl[85.128.178.85] Mar 2 10:41:58 kimsufi postfix/smtpd[25773]: 6F18CCA045: client=alv85.rev.netart.pl[85.128.178.85] Mar 2 10:41:58 kimsufi postfix/cleanup[25777]: 6F18CCA045: message-id=<210cf83e4a11c6e7cd35c23cd1b26dfb@www.alfaclub.pl> Mar 2 10:41:58 kimsufi postfix/qmgr[658]: 6F18CCA045: from=<heniek@heniek.nazwa.pl>, size=1504, nrcpt=1 (queue active) Mar 2 10:41:58 kimsufi postfix/virtual[25770]: warning: mysql query failed: MySQL server has gone away Mar 2 10:41:58 kimsufi postfix/virtual[25770]: warning: table virtual_mailbox_maps: lookup login1@host.pl: Success To mój konfig mysql KOD [client] default-character-set=latin2 port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] language=/usr/share/mysql/polish character-sets-dir=/usr/share/mysql/charsets default-character-set=latin2 default-collation=latin2_general_ci skip-character-set-client-handshake bind-address = 127.0.0.1 user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english #skip-name-resolve safe-show-database #old_passwords back_log = 50 skip-innodb max_connections = 300 key_buffer_size = 80M myisam_sort_buffer_size = 64M myisam_max_sort_file_size = 2048M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 256 wait_timeout = 30 interactive_timeout = 60 connect_timeout = 20 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 100000 thread_concurrency = 4 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 2M query_cache_size = 48M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 range_alloc_block_size = 4096 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_write_lock_count = 8 [mysql] default-character-set=latin2 [mysql.server] default-character-set=latin2 [mysqldump] [mysqld_safe] socket = /var/run/mysqld/mysqld.sock open_files_limit = 8192 [mysqldump] default-character-set=latin2 quick max_allowed_packet = 64M [myisamchk] key_buffer_size = 128M sort_buffer_size = 64M read_buffer_size = 16M write_buffer_size = 16M [mysqlhotcopy] interactive-timeout Myślę, że to będzie miało coś wspólnego z timeoutami w mysql. Jakie ustawić? Może to inny problem? |
|
|
|
![]() |
03.03.2010 - 19:29
Post
#2
|
|
|
Początkujący ![]() Grupa: Użytkownik Postów: 6 Dołączył: 03.03.2010 Użytkownik nr: 927 |
No i właśnie nie masz timeoutów
|
|
|
|
dong Postfix - problem z virtual users w MySQL 03.03.2010 - 16:50
mlodszy Według mnie błąd leży po stronie Postfix'a.
K... 03.03.2010 - 17:43
dong A co ma postfix do tego, że baza raz działa raz ni... 03.03.2010 - 18:02
mlodszy No to trzeba było tak od razu ;] Otóż czasem może ... 03.03.2010 - 18:13
dong KOD * /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51... 03.03.2010 - 18:27
mlodszy Szczerze. To według mnie są dziwne. I to znacznie.... 03.03.2010 - 18:40
dong KOD-------- General Statistics -------------------... 03.03.2010 - 18:46
mlodszy CYTAT(dong @ 03.03.2010 - 16:50) To ... 03.03.2010 - 19:21![]() ![]() |
| Wersja Lo-Fi | Aktualny czas: 23.05.2012 - 12:40 |