And so after having no problems all yesterday afternoon, what is the first
thing that system does this morning when I login? Fail to auth, twice.
Someone ahead of me failed then I failed.  Checked connections, 14/100.  10
Authdaemon processes running... no mysql errors reported... sigh.  Any other
ideas? :)  It boggles me because this is server is hardly even used.

I'm going to attach the printout of my status and vars from mysql, if anyone
sees anything wrong with whats in there please let me know.

Thanks
-David

> -----Original Message-----
> From: David Erickson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, August 21, 2005 12:32 PM
> To: vchkpw@inter7.com
> Subject: RE: [vchkpw] Sporadic mail auth failures
> 
> Yes, max connections are set to 100, and it reported the max ever used was
> 9.. (since I restarted it early this morning).. but ive had problems since
> then so that leads me to believe connections isn't the problem.
> 
> -David
> 
> > -----Original Message-----
> > From: Roman Volf [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, August 21, 2005 12:28 PM
> > To: vchkpw@inter7.com
> > Subject: Re: [vchkpw] Sporadic mail auth failures
> >
> > David Erickson wrote:
> >
> > >Ok I repaired the database files, (just said clients were using them or
> > they
> > >weren't closed properly, so I shutdown mysql and ran it with -r
> anyway).
> > >Also increased the authdaemonrc processes from 5 to 10.  Time to let it
> > run
> > >for awhile and see what happens.  Also the db is local so shouldn't
> > >encounter network latency.
> > >
> > >-David
> > >
> > >
> > >
> > >>-----Original Message-----
> > >>From: Wouter van der Schagt [mailto:[EMAIL PROTECTED]
> > >>Sent: Sunday, August 21, 2005 12:24 PM
> > >>To: vchkpw@inter7.com
> > >>Subject: Re: [vchkpw] Sporadic mail auth failures
> > >>
> > >>Another time i had this problem was when the database to be
> > authenticated
> > >>against wasn't the localhost. If the network was clogged up (long ping
> > >>replies can check this), i would have such failures.
> > >>
> > >>----- Original Message -----
> > >>From: "Jason S" <[EMAIL PROTECTED]>
> > >>To: <vchkpw@inter7.com>
> > >>Sent: Sunday, August 21, 2005 7:51 PM
> > >>Subject: Re: [vchkpw] Sporadic mail auth failures
> > >>
> > >>
> > >>On 8/21/05, Wouter van der Schagt <[EMAIL PROTECTED]> wrote:
> > >>
> > >>
> > >>>I had this problem when my database was corrupt. You can check this
> > >>>with
> > >>>
> > >>>cd /var/lib/mysql/vpopmail
> > >>>myisamchk *.MYI
> > >>>
> > >>>if any is corrupt, just add -r
> > >>>
> > >>>
> > >>>----- Original Message -----
> > >>>From: "David Erickson" <[EMAIL PROTECTED]>
> > >>>To: <vchkpw@inter7.com>
> > >>>Sent: Sunday, August 21, 2005 6:34 PM
> > >>>Subject: [vchkpw] Sporadic mail auth failures
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>>Hi we've been battling a very strange problem with our server for
> > >>>>
> > >>>>
> > >>awhile
> > >>
> > >>
> > >>>>now.  Periodically when a user tries to send mail (using smtp auth),
> > >>>>
> > >>>>
> > >>or
> > >>
> > >>
> > >>>>check his/her pop3 box, we get auth failures.  What happens is youll
> > >>>>
> > >>>>
> > >>have
> > >>
> > >>
> > >>>to
> > >>>
> > >>>
> > >>>>auth 3-4 times before it'll actually go through (even though you are
> > >>>>entering the same credentials every time).  It is very frustrating.
> > >>>>
> > >>>>
> > >>Upon
> > >>
> > >>
> > >>>>examining the logs here is what we are getting:
> > >>>>
> > >>>>Aug 21 10:08:04 mail authdaemond: vmysql: sql error[3]: Lost
> > >>>>
> > >>>>
> > >>connection
> > >>to
> > >>
> > >>
> > >>>>MySQL server during query
> > >>>>
> > >>>>Now I know the username/pw work to connect to the database because
> it
> > >>>>
> > >>>>
> > >>does
> > >>
> > >>
> > >>>>eventually auth.  The mysql server is on the same machine as well.
> > >>>>
> > >>>>
> > >>>Anybody
> > >>>
> > >>>
> > >>>>have any ideas what this could be indicative of?
> > >>>>
> > >>>>Mysql server 4.1.8
> > >>>>Vpopmail 5.4.10
> > >>>>
> > >>>>
> > >>>>Thanks,
> > >>>>David
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>
> > >>>
> > >>I don't use authdaemon, but I saw something on google in the
> > >>authdaemonrc file about not having enough authdaemon child processes
> > >>causing intermittent auth failures...something to check
> > >>--
> > >>
> > >>Jason
> > >>[EMAIL PROTECTED]
> > >>
> > >>--
> > >>No virus found in this incoming message.
> > >>Checked by AVG Anti-Virus.
> > >>Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date:
> > 8/19/2005
> > >>
> > >>
> > >>
> > >
> > >
> > >
> > Did you check the max_connections?
> >
> > --
> > Roman Volf
> > Keystreams Internet Solutions
> > [EMAIL PROTECTED]
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date:
> 8/19/2005
> >
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/2005
> 
+---------------------------------+----------------------------------------+
| Variable_name                   | Value                                  |
+---------------------------------+----------------------------------------+
| back_log                        | 50                                     |
| basedir                         | /usr/local/mysql/                      |
| binlog_cache_size               | 32768                                  |
| bulk_insert_buffer_size         | 8388608                                |
| character_set_client            | latin1                                 |
| character_set_connection        | latin1                                 |
| character_set_database          | latin1                                 |
| character_set_results           | latin1                                 |
| character_set_server            | latin1                                 |
| character_set_system            | utf8                                   |
| character_sets_dir              | /usr/local/mysql/share/mysql/charsets/ |
| collation_connection            | latin1_swedish_ci                      |
| collation_database              | latin1_swedish_ci                      |
| collation_server                | latin1_swedish_ci                      |
| concurrent_insert               | ON                                     |
| connect_timeout                 | 5                                      |
| datadir                         | /storage/data/                         |
| date_format                     | %Y-%m-%d                               |
| datetime_format                 | %Y-%m-%d %H:%i:%s                      |
| default_week_format             | 0                                      |
| delay_key_write                 | ON                                     |
| delayed_insert_limit            | 100                                    |
| delayed_insert_timeout          | 300                                    |
| delayed_queue_size              | 1000                                   |
| expire_logs_days                | 0                                      |
| flush                           | OFF                                    |
| flush_time                      | 0                                      |
| ft_boolean_syntax               | + -><()~*:""&|                         |
| ft_max_word_len                 | 84                                     |
| ft_min_word_len                 | 4                                      |
| ft_query_expansion_limit        | 20                                     |
| ft_stopword_file                | (built-in)                             |
| group_concat_max_len            | 1024                                   |
| have_archive                    | NO                                     |
| have_bdb                        | NO                                     |
| have_compress                   | YES                                    |
| have_crypt                      | YES                                    |
| have_csv                        | NO                                     |
| have_example_engine             | NO                                     |
| have_geometry                   | YES                                    |
| have_innodb                     | YES                                    |
| have_isam                       | NO                                     |
| have_ndbcluster                 | NO                                     |
| have_openssl                    | NO                                     |
| have_query_cache                | YES                                    |
| have_raid                       | NO                                     |
| have_rtree_keys                 | YES                                    |
| have_symlink                    | YES                                    |
| init_connect                    |                                        |
| init_file                       |                                        |
| init_slave                      |                                        |
| innodb_additional_mem_pool_size | 1048576                                |
| innodb_autoextend_increment     | 8                                      |
| innodb_buffer_pool_awe_mem_mb   | 0                                      |
| innodb_buffer_pool_size         | 8388608                                |
| innodb_data_file_path           | ibdata1:10M:autoextend                 |
| innodb_data_home_dir            |                                        |
| innodb_fast_shutdown            | ON                                     |
| innodb_file_io_threads          | 4                                      |
| innodb_file_per_table           | OFF                                    |
| innodb_locks_unsafe_for_binlog  | OFF                                    |
| innodb_flush_log_at_trx_commit  | 1                                      |
| innodb_flush_method             |                                        |
| innodb_force_recovery           | 0                                      |
| innodb_lock_wait_timeout        | 50                                     |
| innodb_log_arch_dir             |                                        |
| innodb_log_archive              | OFF                                    |
| innodb_log_buffer_size          | 1048576                                |
| innodb_log_file_size            | 5242880                                |
| innodb_log_files_in_group       | 2                                      |
| innodb_log_group_home_dir       | ./                                     |
| innodb_max_dirty_pages_pct      | 90                                     |
| innodb_max_purge_lag            | 0                                      |
| innodb_table_locks              | ON                                     |
| innodb_max_purge_lag            | 0                                      |
| innodb_mirrored_log_groups      | 1                                      |
| innodb_open_files               | 300                                    |
| innodb_thread_concurrency       | 8                                      |
| interactive_timeout             | 28800                                  |
| join_buffer_size                | 131072                                 |
| key_buffer_size                 | 268435456                              |
| key_cache_age_threshold         | 300                                    |
| key_cache_block_size            | 1024                                   |
| key_cache_division_limit        | 100                                    |
| language                        | /usr/local/mysql/share/mysql/english/  |
| large_files_support             | ON                                     |
| license                         | GPL                                    |
| local_infile                    | ON                                     |
| locked_in_memory                | OFF                                    |
| log                             | ON                                     |
| log_bin                         | ON                                     |
| log_error                       |                                        |
| log_slave_updates               | OFF                                    |
| log_slow_queries                | OFF                                    |
| log_update                      | OFF                                    |
| log_warnings                    | 1                                      |
| long_query_time                 | 10                                     |
| low_priority_updates            | OFF                                    |
| lower_case_file_system          | OFF                                    |
| lower_case_table_names          | 0                                      |
| max_allowed_packet              | 1047552                                |
| max_binlog_cache_size           | 18446744073709551615                   |
| max_binlog_size                 | 1073741824                             |
| max_connect_errors              | 10                                     |
| max_connections                 | 100                                    |
| max_delayed_threads             | 20                                     |
| max_error_count                 | 64                                     |
| max_heap_table_size             | 16777216                               |
| max_insert_delayed_threads      | 20                                     |
| max_join_size                   | 18446744073709551615                   |
| max_length_for_sort_data        | 1024                                   |
| max_relay_log_size              | 0                                      |
| max_seeks_for_key               | 18446744073709551615                   |
| max_sort_length                 | 1024                                   |
| max_tmp_tables                  | 32                                     |
| max_user_connections            | 0                                      |
| max_write_lock_count            | 18446744073709551615                   |
| myisam_data_pointer_size        | 4                                      |
| myisam_max_extra_sort_file_size | 2147483648                             |
| myisam_max_sort_file_size       | 9223372036854775807                    |
| myisam_recover_options          | OFF                                    |
| myisam_repair_threads           | 1                                      |
| myisam_sort_buffer_size         | 67108864                               |
| net_buffer_length               | 16384                                  |
| net_read_timeout                | 30                                     |
| net_retry_count                 | 10                                     |
| net_write_timeout               | 60                                     |
| new                             | OFF                                    |
| old_passwords                   | OFF                                    |
| open_files_limit                | 1024                                   |
| pid_file                        | /storage/data/mail.pid                 |
| port                            | 3306                                   |
| preload_buffer_size             | 32768                                  |
| protocol_version                | 10                                     |
| query_alloc_block_size          | 8192                                   |
| query_cache_limit               | 1048576                                |
| query_cache_min_res_unit        | 4096                                   |
| query_cache_size                | 16777216                               |
| query_cache_type                | ON                                     |
| query_cache_wlock_invalidate    | OFF                                    |
| query_prealloc_size             | 8192                                   |
| range_alloc_block_size          | 2048                                   |
| read_buffer_size                | 1044480                                |
| read_only                       | OFF                                    |
| read_rnd_buffer_size            | 4190208                                |
| relay_log_purge                 | ON                                     |
| rpl_recovery_rank               | 0                                      |
| secure_auth                     | OFF                                    |
| server_id                       | 1                                      |
| skip_external_locking           | ON                                     |
| skip_networking                 | OFF                                    |
| skip_show_database              | OFF                                    |
| slave_net_timeout               | 3600                                   |
| slow_launch_time                | 2                                      |
| socket                          | /tmp/mysql.sock                        |
| sort_buffer_size                | 1048568                                |
| sql_mode                        |                                        |
| storage_engine                  | MyISAM                                 |
| sync_binlog                     | 0                                      |
| sync_frm                        | ON                                     |
| system_time_zone                | MDT                                    |
| table_cache                     | 256                                    |
| table_type                      | MyISAM                                 |
| thread_cache_size               | 8                                      |
| thread_stack                    | 196608                                 |
| time_format                     | %H:%i:%s                               |
| time_zone                       | SYSTEM                                 |
| tmp_table_size                  | 33554432                               |
| tmpdir                          |                                        |
| transaction_alloc_block_size    | 8192                                   |
| transaction_prealloc_size       | 4096                                   |
| tx_isolation                    | REPEATABLE-READ                        |
| version                         | 4.1.8-standard-log                     |
| version_comment                 | Official MySQL-standard binary         |
| version_compile_machine         | x86_64                                 |
| version_compile_os              | unknown-linux                          |
| wait_timeout                    | 28800                                  |
+---------------------------------+----------------------------------------+
+--------------------------+----------+
| Variable_name            | Value    |
+--------------------------+----------+
| Aborted_clients          | 8        |
| Aborted_connects         | 1        |
| Binlog_cache_disk_use    | 0        |
| Binlog_cache_use         | 0        |
| Bytes_received           | 7325998  |
| Bytes_sent               | 25314881 |
| Com_admin_commands       | 0        |
| Com_alter_db             | 0        |
| Com_alter_table          | 0        |
| Com_analyze              | 0        |
| Com_backup_table         | 0        |
| Com_begin                | 0        |
| Com_change_db            | 791      |
| Com_change_master        | 0        |
| Com_check                | 0        |
| Com_checksum             | 0        |
| Com_commit               | 0        |
| Com_create_db            | 0        |
| Com_create_function      | 0        |
| Com_create_index         | 0        |
| Com_create_table         | 0        |
| Com_dealloc_sql          | 0        |
| Com_delete               | 14749    |
| Com_delete_multi         | 0        |
| Com_do                   | 0        |
| Com_drop_db              | 0        |
| Com_drop_function        | 0        |
| Com_drop_index           | 0        |
| Com_drop_table           | 0        |
| Com_drop_user            | 0        |
| Com_execute_sql          | 0        |
| Com_flush                | 0        |
| Com_grant                | 0        |
| Com_ha_close             | 0        |
| Com_ha_open              | 0        |
| Com_ha_read              | 0        |
| Com_help                 | 0        |
| Com_insert               | 15007    |
| Com_insert_select        | 0        |
| Com_kill                 | 0        |
| Com_load                 | 0        |
| Com_load_master_data     | 0        |
| Com_load_master_table    | 0        |
| Com_lock_tables          | 0        |
| Com_optimize             | 0        |
| Com_preload_keys         | 0        |
| Com_prepare_sql          | 0        |
| Com_purge                | 0        |
| Com_purge_before_date    | 0        |
| Com_rename_table         | 0        |
| Com_repair               | 0        |
| Com_replace              | 921      |
| Com_replace_select       | 0        |
| Com_reset                | 0        |
| Com_restore_table        | 0        |
| Com_revoke               | 0        |
| Com_revoke_all           | 0        |
| Com_rollback             | 0        |
| Com_savepoint            | 0        |
| Com_select               | 9576     |
| Com_set_option           | 3        |
| Com_show_binlog_events   | 0        |
| Com_show_binlogs         | 0        |
| Com_show_charsets        | 0        |
| Com_show_collations      | 0        |
| Com_show_column_types    | 0        |
| Com_show_create_db       | 0        |
| Com_show_create_table    | 0        |
| Com_show_databases       | 1        |
| Com_show_errors          | 0        |
| Com_show_fields          | 0        |
| Com_show_grants          | 0        |
| Com_show_innodb_status   | 0        |
| Com_show_keys            | 0        |
| Com_show_logs            | 0        |
| Com_show_master_status   | 0        |
| Com_show_new_master      | 0        |
| Com_show_open_tables     | 0        |
| Com_show_privileges      | 0        |
| Com_show_processlist     | 0        |
| Com_show_slave_hosts     | 0        |
| Com_show_slave_status    | 0        |
| Com_show_status          | 1641     |
| Com_show_storage_engines | 0        |
| Com_show_tables          | 0        |
| Com_show_variables       | 1643     |
| Com_show_warnings        | 0        |
| Com_slave_start          | 0        |
| Com_slave_stop           | 0        |
| Com_truncate             | 468      |
| Com_unlock_tables        | 0        |
| Com_update               | 3077     |
| Com_update_multi         | 0        |
| Connections              | 2435     |
| Created_tmp_disk_tables  | 0        |
| Created_tmp_files        | 3        |
| Created_tmp_tables       | 0        |
| Delayed_errors           | 0        |
| Delayed_insert_threads   | 0        |
| Delayed_writes           | 0        |
| Flush_commands           | 1        |
| Handler_commit           | 0        |
| Handler_delete           | 15213    |
| Handler_discover         | 0        |
| Handler_read_first       | 757      |
| Handler_read_key         | 39485    |
| Handler_read_next        | 20313    |
| Handler_read_prev        | 186      |
| Handler_read_rnd         | 994      |
| Handler_read_rnd_next    | 91140    |
| Handler_rollback         | 0        |
| Handler_update           | 3542     |
| Handler_write            | 16396    |
| Key_blocks_not_flushed   | 0        |
| Key_blocks_unused        | 214299   |
| Key_blocks_used          | 44       |
| Key_read_requests        | 81319    |
| Key_reads                | 510      |
| Key_write_requests       | 45917    |
| Key_writes               | 31165    |
| Max_used_connections     | 14       |
| Not_flushed_delayed_rows | 0        |
| Open_files               | 86       |
| Open_streams             | 0        |
| Open_tables              | 42       |
| Opened_tables            | 991      |
| Qcache_free_blocks       | 22       |
| Qcache_free_memory       | 16426624 |
| Qcache_hits              | 14292    |
| Qcache_inserts           | 9574     |
| Qcache_lowmem_prunes     | 0        |
| Qcache_not_cached        | 2        |
| Qcache_queries_in_cache  | 175      |
| Qcache_total_blocks      | 405      |
| Questions                | 64587    |
| Rpl_status               | NULL     |
| Select_full_join         | 0        |
| Select_full_range_join   | 0        |
| Select_range             | 234      |
| Select_range_check       | 0        |
| Select_scan              | 1208     |
| Slave_open_temp_tables   | 0        |
| Slave_running            | OFF      |
| Slow_launch_threads      | 0        |
| Slow_queries             | 0        |
| Sort_merge_passes        | 0        |
| Sort_range               | 1        |
| Sort_rows                | 896      |
| Sort_scan                | 243      |
| Table_locks_immediate    | 44530    |
| Table_locks_waited       | 2        |
| Threads_cached           | 3        |
| Threads_connected        | 11       |
| Threads_created          | 14       |
| Threads_running          | 1        |
| Uptime                   | 70231    |
+--------------------------+----------+

Reply via email to