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. But for all I know it
could be PHP I guess.
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
|
+---------------------------------+-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
