Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning: MySQL Connection Failed: Lost connection to MySQL server during
query...
I'm assuming this is a MySQL issue since everything worked fine before the
upgrade from MySQL 3.32.22 to MySQL 3.23.37.
I'm doing very simple query to see if it works and no success. Even code
that worked before I upgraded doesn't work anymore. Here's the test query I
made... (BTW, the below query works fine via MySQL/MySQL GUI Client)
$szQuery = "SELECT * FROM People WHERE First_Name='adouglas'";
$dbconnection = mysql_connect("207.195.58.33","webuser","adamacc226");
mysql_select_db("venmar", $dbConnection) or die("could not connect to venmar
for security authentication.");
$saResults = mysql_query($szQuery, $dbConnection) or die ("2could not query
venmar for security authentication.");
$obResults = mysql_fetch_row($saResults)
echo "$obResults[0], $obResults[1], $obResults[2], $obResults[3],
$obResults[4], $obResults[5]";
The MySQL Database has it's own dedicated machine running on OpenBSD 2.9.
The web server accessing the MySQL Database is on it's own machine with
Apache 1.3.12 and OpenBSD 2.9. Any other details needed let me know.
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 6 |
| Bytes_received | 4125 |
| Bytes_sent | 45247 |
| Connections | 15 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 4 |
| Handler_read_first | 7 |
| Handler_read_key | 16 |
| Handler_read_next | 2 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 2597 |
| Handler_update | 1 |
| Handler_write | 4 |
| Key_blocks_used | 4 |
| Key_read_requests | 28 |
| Key_reads | 4 |
| Key_write_requests | 18 |
| Key_writes | 12 |
| Max_used_connections | 1 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 22 |
| Open_files | 44 |
| Open_streams | 0 |
| Opened_tables | 38 |
| Questions | 135 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 15 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Table_locks_immediate | 52 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 14 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 7235 |
+--------------------------+-------+
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
--------------------------------------+
| Variable_name | Value
|
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
--------------------------------------+
| ansi_mode | OFF
|
| back_log | 50
|
| basedir | /usr/local/
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 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/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_ssl | NO
|
| init_file |
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
|
| language | /usr/local/share/mysql/english/
|
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| 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 | 100
|
| 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_recover_options | OFF
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| 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/mysql/centauri.pid
|
| port | 3306
|
| protocol_version | 9
|
| record_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | OFF
|
| server_id | 0
|
| skip_locking | OFF
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /var/mysql/mysql.sock
|
| sort_buffer | 2097144
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_stack | 65536
|
| transaction_isolation | READ-COMMITTED
|
| timezone | CST
|
| tmp_table_size | 1048576
|
| tmpdir | /tmp/
|
| version | 3.23.37
|
| 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
