I have several mysql servers installed, all without TZ variable, one of them, insists in set the "select now()" to 4 hours ahead of my internal clock, first I touch that I should set TZ to my time time zone in /etc/init.d/mysql, but when I do that, the "select now()" advances 4 more hours.
Below is the information about my system. now the --timezone option in /etc/init.d/mysql nor in /usr/bin/safe_mysql is not set. Any help will do, thanks Renato Lins # cat /etc/redhat-release Red Hat Linux release 7.2 (Enigma) #cat /etc/sysconfig/clock ZONE="America/Manaus" UTC=false ARC=false # rpm -qi MySQL Name : MySQL Relocations: (not relocateable) Version : 3.23.49 Vendor: MySQL AB Release : 1 Build Date: Sat 16 Feb 2002 05:26:33 PM AMT Install date: Sat 09 Mar 2002 12:07:41 PM AMT Build Host: hundin.mysql.fi Group : Applications/Databases Source RPM: MySQL-3.23.49-1.src.rpm Size : 48704200 License: GPL / LGPL # cat /etc/my.cnf [server] log-slow-queries = /var/lib/mysql/slowqueries.log set-variable = max_connections=512 # date ; echo -e "select now();\nshow variables;\n"|mysql -u root -pfdrops500 Tue Jul 23 14:25:39 AMT 2002 now() 2002-07-23 18:25:39 Variable_name Value back_log 50 basedir / binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir /var/lib/mysql/ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 0 have_bdb NO have_gemini NO have_innodb NO have_isam YES have_raid NO have_openssl NO init_file interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8388600 language /usr/share/mysql/english/ large_files_support ON locked_in_memory OFF log OFF log_update OFF log_bin OFF log_slave_updates OFF log_long_queries ON long_query_time 10 low_priority_updates OFF lower_case_table_names 0 max_allowed_packet 1048576 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 512 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file /var/lib/mysql/www.ecenter.com.br.pid port 3306 protocol_version 10 record_buffer 131072 record_rnd_buffer 131072 query_buffer_size 0 safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket /var/lib/mysql/mysql.sock sort_buffer 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 transaction_isolation READ-COMMITTED timezone America/Manaus tmp_table_size 33554432 tmpdir /tmp/ version 3.23.49-log wait_timeout 28800 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php