Hello.
> [EMAIL PROTECTED]:~# telnet localhost 43306 > Trying 127.0.0.1... > Connected to localhost. > Escape character is '^]'. > Connection closed by foreign host. I had an experience with similar symptoms which was caused by TCP wrapper. Check your /etc/hosts.allow. Lance Rochelle wrote: > OK here goes I've had a problem for a few days that I can't resolve. > > At the OS level > If I ping the name localhost I get a good return and if I ping > 127.0.0.1 I also get a good return as noted below. > [EMAIL PROTECTED]:~# ping localhost -c 2 > PING localhost (127.0.0.1) 56(84) bytes of data. > 64 bytes from localhost (127.0.0.1): icmp_seq=3D1 ttl=3D64 time=3D0.034 ms > 64 bytes from localhost (127.0.0.1): icmp_seq=3D2 ttl=3D64 time=3D0.028 ms > > --- localhost ping statistics --- > 2 packets transmitted, 2 received, 0% packet loss, time 999ms > rtt min/avg/max/mdev =3D 0.028/0.031/0.034/0.003 ms > [EMAIL PROTECTED]:~# ping 127.0.0.1 -c 2 > PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data. > 64 bytes from 127.0.0.1: icmp_seq=3D1 ttl=3D64 time=3D0.031 ms > 64 bytes from 127.0.0.1: icmp_seq=3D2 ttl=3D64 time=3D0.029 ms > > --- 127.0.0.1 ping statistics --- > 2 packets transmitted, 2 received, 0% packet loss, time 999ms > rtt min/avg/max/mdev =3D 0.029/0.030/0.031/0.001 ms > > when I run the restart script I get the following in syslog > Jan 10 15:35:51 www mysqld[2334]: 060110 15:35:51 [Note] > /usr/sbin/mysqld: Normal shutdown > Jan 10 15:35:51 www mysqld[2334]: > Jan 10 15:35:51 www mysqld[2334]: 060110 15:35:51 InnoDB: Starting shutdow= > n... > Jan 10 15:35:54 www mysqld[2334]: 060110 15:35:54 InnoDB: Shutdown > completed; log sequence number 0 43884 > Jan 10 15:35:54 www mysqld[2334]: 060110 15:35:54 [Note] > /usr/sbin/mysqld: Shutdown complete > Jan 10 15:35:54 www mysqld[2334]: > Jan 10 15:35:54 www mysqld_safe[2590]: ended > Jan 10 15:35:55 www mysqld_safe[2649]: started > Jan 10 15:35:55 www mysqld[2652]: 060110 15:35:55 InnoDB: Started; > log sequence number 0 43884 > Jan 10 15:35:55 www mysqld[2652]: /usr/sbin/mysqld: ready for connections. > Jan 10 15:35:55 www mysqld[2652]: Version: ' > 4.1.11-Debian_4sarge2-log' socket: '/var/run/mysqld/mysqld.sock'=20 > port: 43306 Source distribution > > All looks good so far > > > here is my my.cnf file > [EMAIL PROTECTED]:/etc/mysql# grep -v ^# my.cnf > [client] > port=3D 43306 > socket=3D /var/run/mysqld/mysqld.sock > [mysqld_safe] > socket=3D /var/run/mysqld/mysqld.sock > nice=3D 0 > [mysqld] > user=3D mysql > pid-file=3D /var/run/mysqld/mysqld.pid > socket=3D /var/run/mysqld/mysqld.sock > port=3D 43306 > basedir=3D /usr > datadir=3D /var/lib/mysql > tmpdir=3D /tmp > language=3D /usr/share/mysql/english > skip-external-locking > key_buffer=3D 16M > max_allowed_packet=3D 16M > thread_stack=3D 128K > query_cache_limit=3D 1048576 > query_cache_size =3D 16777216 > query_cache_type =3D 1 > log-bin=3D /var/log/mysql/mysql-bin.log > max_binlog_size=3D 104857600 > skip-bdb > [mysqldump] > quick > quote-names > max_allowed_packet=3D 16M > [mysql] > [isamchk] > key_buffer=3D 16M > > here is the variables from mysqladmin -u root -p variables > +----------------------------- > ----+----------------------------------------------------------+ > | Variable_name | Value =20 > | > +---------------------------------+----------------------------------------= > ------------------+ > | back_log | 50 =20 > | > | basedir | /usr/ =20 > | > | bdb_cache_size | 8388600 =20 > | > | bdb_home | =20 > | > | bdb_log_buffer_size | 0 =20 > | > | bdb_logdir | =20 > | > | bdb_max_lock | 10000 =20 > | > | bdb_shared_data | OFF =20 > | > | bdb_tmpdir | =20 > | > | binlog_cache_size | 32768 =20 > | > | bulk_insert_buffer_size | 8388608 =20 > | > | character_set_client | latin1 =20 > | > | character_set_connection | latin1 =20 > | > | character_set_database | latin1 =20 > | > | character_set_results | latin1 =20 > | > | character_set_server | latin1 =20 > | > | character_set_system | utf8 =20 > | > | character_sets_dir | /usr/share/mysql/charsets/ =20 > | > | collation_connection | latin1_swedish_ci =20 > | > | collation_database | latin1_swedish_ci =20 > | > | collation_server | latin1_swedish_ci =20 > | > | concurrent_insert | ON =20 > | > | connect_timeout | 5 =20 > | > | datadir | /var/lib/mysql/ =20 > | > | date_format | %Y-%m-%d =20 > | > | datetime_format | %Y-%m-%d %H:%i:%s =20 > | > | default_week_format | 0 =20 > | > | delay_key_write | ON =20 > | > | delayed_insert_limit | 100 =20 > | > | delayed_insert_timeout | 300 =20 > | > | delayed_queue_size | 1000 =20 > | > | expire_logs_days | 0 =20 > | > | flush | OFF =20 > | > | flush_time | 0 =20 > | > | ft_boolean_syntax | + -><()~*:""&| =20 > | > | ft_max_word_len | 84 =20 > | > | ft_min_word_len | 4 =20 > | > | ft_query_expansion_limit | 20 =20 > | > | ft_stopword_file | (built-in) =20 > | > | group_concat_max_len | 1024 =20 > | > | have_archive | YES =20 > | > | have_bdb | DISABLED =20 > | > | have_blackhole_engine | NO =20 > | > | have_compress | YES =20 > | > | have_crypt | YES =20 > | > | have_csv | YES =20 > | > | have_example_engine | NO =20 > | > | have_geometry | YES =20 > | > | have_innodb | YES =20 > | > | have_isam | YES =20 > | > | have_ndbcluster | DISABLED =20 > | > | have_openssl | NO =20 > | > | have_query_cache | YES =20 > | > | have_raid | YES =20 > | > | have_rtree_keys | YES =20 > | > | have_symlink | YES =20 > | > | init_connect | =20 > | > | init_file | =20 > | > | init_slave | =20 > | > | innodb_additional_mem_pool_size | 1048576 =20 > | > | innodb_autoextend_increment | 8 =20 > | > | innodb_buffer_pool_awe_mem_mb | 0 =20 > | > | innodb_buffer_pool_size | 8388608 =20 > | > | innodb_data_file_path | ibdata1:10M:autoextend =20 > | > | innodb_data_home_dir | =20 > | > | innodb_fast_shutdown | ON =20 > | > | innodb_file_io_threads | 4 =20 > | > | innodb_file_per_table | OFF =20 > | > | innodb_flush_log_at_trx_commit | 1 =20 > | > | innodb_flush_method | =20 > | > | innodb_force_recovery | 0 =20 > | > | innodb_lock_wait_timeout | 50 =20 > | > | innodb_locks_unsafe_for_binlog | OFF =20 > | > | innodb_log_arch_dir | =20 > | > | innodb_log_archive | OFF =20 > | > | innodb_log_buffer_size | 1048576 =20 > | > | innodb_log_file_size | 5242880 =20 > | > | innodb_log_files_in_group | 2 =20 > | > | innodb_log_group_home_dir | ./ =20 > | > | innodb_max_dirty_pages_pct | 90 =20 > | > | innodb_max_purge_lag | 0 =20 > | > | innodb_mirrored_log_groups | 1 =20 > | > | innodb_open_files | 300 =20 > | > | innodb_table_locks | ON =20 > | > | innodb_thread_concurrency | 8 =20 > | > | interactive_timeout | 28800 =20 > | > | join_buffer_size | 131072 =20 > | > | key_buffer_size | 16777216 =20 > | > | key_cache_age_threshold | 300 =20 > | > | key_cache_block_size | 1024 =20 > | > | key_cache_division_limit | 100 =20 > | > | language | /usr/share/mysql/english/ =20 > | > | large_files_support | ON =20 > | > | license | GPL =20 > | > | local_infile | ON =20 > | > | locked_in_memory | OFF =20 > | > | log | OFF =20 > | > | log_bin | ON =20 > | > | log_error | =20 > | > | log_slave_updates | OFF =20 > | > | log_slow_queries | OFF =20 > | > | log_update | OFF =20 > | > | log_warnings | 1 =20 > | > | long_query_time | 10 =20 > | > | low_priority_updates | OFF =20 > | > | lower_case_file_system | OFF =20 > | > | lower_case_table_names | 0 =20 > | > | max_allowed_packet | 16776192 =20 > | > | max_binlog_cache_size | 4294967295 =20 > | > | max_binlog_size | 104857600 =20 > | > | max_connect_errors | 10 =20 > | > | max_connections | 100 =20 > | > | max_delayed_threads | 20 =20 > | > | max_error_count | 64 =20 > | > | max_heap_table_size | 16777216 =20 > | > | max_insert_delayed_threads | 20 =20 > | > | max_join_size | 4294967295 =20 > | > | max_length_for_sort_data | 1024 =20 > | > | max_relay_log_size | 0 =20 > | > | max_seeks_for_key | 4294967295 =20 > | > | max_sort_length | 1024 =20 > | > | max_tmp_tables | 32 =20 > | > | max_user_connections | 0 =20 > | > | max_write_lock_count | 4294967295 =20 > | > | myisam_data_pointer_size | 4 =20 > | > | myisam_max_extra_sort_file_size | 2147483648 =20 > | > | myisam_max_sort_file_size | 2147483647 =20 > | > | myisam_recover_options | OFF =20 > | > | myisam_repair_threads | 1 =20 > | > | myisam_sort_buffer_size | 8388608 =20 > | > | ndb_autoincrement_prefetch_sz | 32 =20 > | > | ndb_force_send | ON =20 > | > | ndb_use_exact_count | ON =20 > | > | ndb_use_transactions | OFF =20 > | > | net_buffer_length | 16384 =20 > | > | net_read_timeout | 30 =20 > | > | net_retry_count | 10 =20 > | > | net_write_timeout | 60 =20 > | > | new | OFF =20 > | > | old_passwords | OFF =20 > | > | open_files_limit | 1024 =20 > | > | pid_file | /var/run/mysqld/mysqld.pid =20 > | > | port | 43306 =20 > | > | preload_buffer_size | 32768 =20 > | > | protocol_version | 10 =20 > | > | query_alloc_block_size | 8192 =20 > | > | query_cache_limit | 1048576 =20 > | > | query_cache_min_res_unit | 4096 =20 > | > | query_cache_size | 16777216 =20 > | > | query_cache_type | ON =20 > | > | query_cache_wlock_invalidate | OFF =20 > | > | query_prealloc_size | 8192 =20 > | > | range_alloc_block_size | 2048 =20 > | > | read_buffer_size | 131072 =20 > | > | read_only | OFF =20 > | > | read_rnd_buffer_size | 262144 =20 > | > | relay_log_purge | ON =20 > | > | relay_log_space_limit | 0 =20 > | > | rpl_recovery_rank | 0 =20 > | > | secure_auth | OFF =20 > | > | server_id | 1 =20 > | > | skip_external_locking | ON =20 > | > | skip_networking | OFF =20 > | > | skip_show_database | OFF =20 > | > | slave_net_timeout | 3600 =20 > | > | slave_transaction_retries | 0 =20 > | > | slow_launch_time | 2 =20 > | > | socket | /var/run/mysqld/mysqld.sock =20 > | > | sort_buffer_size | 2097144 =20 > | > | sql_mode | =20 > | > | storage_engine | MyISAM =20 > | > | sql_notes | ON =20 > | > | sql_warnings | ON =20 > | > | sync_binlog | 0 =20 > | > | sync_replication | 0 =20 > | > | sync_replication_slave_id | 0 =20 > | > | sync_replication_timeout | 0 =20 > | > | sync_frm | ON =20 > | > | system_time_zone | EST =20 > | > | table_cache | 64 =20 > | > | table_type | MyISAM =20 > | > | thread_cache_size | 0 =20 > | > | thread_stack | 131072 =20 > | > | time_format | %H:%i:%s =20 > | > | time_zone | SYSTEM =20 > | > | tmp_table_size | 33554432 =20 > | > | tmpdir | /tmp =20 > | > | transaction_alloc_block_size | 8192 =20 > | > | transaction_prealloc_size | 4096 =20 > | > | tx_isolation | REPEATABLE-READ =20 > | > | version | 4.1.11-Debian_4sarge2-log =20 > | > | version_bdb | Sleepycat Software: Berkeley DB > 4.1.24: (April 1, 2005) | > | version_comment | Source distribution =20 > | > | version_compile_machine | i386 =20 > | > | version_compile_os | pc-linux-gnu =20 > | > | wait_timeout | 28800 =20 > | > +---------------------------------+----------------------------------------= > ------------------+ > > [EMAIL PROTECTED]:~# cat /etc/hosts > 127.0.0.1 localhost localhost.localdomain > > [EMAIL PROTECTED]:~# iptables --list > Chain INPUT (policy ACCEPT) > target prot opt source destination > > Chain FORWARD (policy ACCEPT) > target prot opt source destination > > Chain OUTPUT (policy ACCEPT) > target prot opt source destination > [EMAIL PROTECTED]:~# ipchains --list > ipchains: Incompatible with this kernel > > [EMAIL PROTECTED]:~# telnet localhost 43306 > Trying 127.0.0.1... > Connected to localhost. > Escape character is '^]'. > Connection closed by foreign host. > > [EMAIL PROTECTED]:~# telnet 127.0.0.1 43306 > Trying 127.0.0.1... > Connected to 127.0.0.1. > Escape character is '^]'. > Connection closed by foreign host. > > [EMAIL PROTECTED]:~# netstat -an |grep LISTEN > tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:43306 0.0.0.0:* LISTEN > > > Now for the fun part > > [EMAIL PROTECTED]:~# mysqladmin -h localhost -u root -p ping > Enter password: > mysqld is alive > [EMAIL PROTECTED]:~# mysqladmin -h 127.0.0.1 -u root -p ping > Enter password: > mysqladmin: connect to server at '127.0.0.1' failed > error: 'Lost connection to MySQL server during query' > > > ok so my issue is the software that i am using is hardcoded to use > 127.0.0.1 and not localhost. Even if i add the bind-address to my.cnf > I still get the same error. If I bind it to an external ip address I > then can still connect to localhost but not 127.0.0.1 nor the external > IP adress. Any ideas or point me to some good documentation on this > would be great. I tried to search through several search engines but > they all lead me nowhere, any help is appreciated. > > > --Lance > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
