Problem with openSSL and MySQL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysqlshow databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - 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
Master/Slave reversal in Replication
Hello I'm new to MySQL, Unix and Replication. I would like to know if in a scenario where I have one master and several slaves I can convert one of the slaves to master in the event my master goes down. Once I can bring the master back up, how to I reverse the operation? Does any one know how to make the switch or where I can read up on it? I'm using FreeBSD with MySQL v4.0.1 alpha. Thanks. - 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
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysqlshow databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** when I do a show status I get the following. mysql show status; ++---+ | Variable_name | Value | ++---+ | Aborted_clients| 8 | | Aborted_connects | 0 | | Bytes_received | 529 | | Bytes_sent | 1049 | | Com_admin_commands | 0 | | Com_alter_table| 0 | | Com_analyze| 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function| 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_drop_db| 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush | 0 | | Com_grant | 2 | | Com_ha_close | 0 | | Com_ha_open| 0 | | Com_ha_read| 0 | | Com_insert | 0 | | 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_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace| 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 0 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create| 0 | | Com_show_databases | 10| | Com_show_fields| 0 | | Com_show_grants| 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_stat | 0 | | Com_show_new_master| 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_stat| 0 | | Com_show_status| 2 | | Com_show_tables| 0 | | Com_show_variables | 0 | | Com_slave_start| 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Connections| 10| | 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 | 0 | | Handler_read_first | 1 | | Handler_read_key | 1 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 11| | Handler_update | 0 | | Handler_write | 1 | | Key_blocks_used| 1 | | Key_read_requests | 2 | | Key_reads | 1 | | Key_write_requests | 1 | | Key_writes | 1 | | Max_used_connections | 0 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables| 2 | | Open_files | 6 | | Open_streams | 0 | | Opened_tables | 8 | | Questions | 8 | | Qcache_queries_in_cache| 0 | |
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysqlshow databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - 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
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysqlshow databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - 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
Storing Binary data in MySQL
Hello, I'm new to Unix and MySQL. I would like to store binary data in MySQL, but cannot find any sample code on how to go about doing this in C. The binary data is variable size ranging from 3k to 10k. I want to store it in a row along with a User ID so I can retrieve it by doing a query on this ID. How do I store and retrive this binary data in MySQL? I see references to BLOB and mysql_real_escape_string(). Am I on the right track? or is there more to it? Thanks. - 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
how to setup mysqlgui in Win2000
I have MySQL running on my FreeBSD server and I want to connect to it from my Windows 2000 workstation using mysqlgui. I put the ip address of the FreeBSD server in the my.cnf file under host, but it keeps trying to connect to the Win2000 machine instead of the FreeBSD box. Am I doing something wrong? Thanks. - 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
