Help using SSL from VB client, using MyODBC

[William Blair Wagner]

I'm kind of new to the SSL scene.
I've read all I can find on MySQL.org about setting up and using SSL.
I'm on MySLQ 4.20 and have built mysql after configuring with --use-vio
and --use-openssl.  HAVE_OPENSSL = YES.  I can handle setting up the
user talbe and GRANTS to require SSL for users and connections.
What I don't know how to do it make my client use SSL with MySQL. Can
you help me?  or give me some direction?
My application runs on M$ Windows.
It's written in M$ Visual Basic 6 from Visual Studio 6.
I'm using MDAC 2.7 and M$ ADO.
I'm using MyODBC 2.50 but can easily and happily upgrade to 3.51
   (is 3.51 needed?)
I have no idea what to do (set properties?) to cause my VB client to
connect to the MySQL DB server using SSL?
Any help would be huge! Thanx.

--

 William Blair Wagner : Education is not always knowing the answer,
 [EMAIL PROTECTED] : ...but rather knowing where to look for it!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 2006: MySQL server has gone away

[William Blair Wagner]

Hi Gurus,

I'm relatively new to MySQL - been studying it for the past 2 months. So 
far, so good (or Great).

I recently moved from MySQL 3.23.22 to 4.0.2-alpha-debug-log on our 
4.6.1-RELEASE-p10 FreeBSD server. Using the mysql client, I noticed an 
annoying message immediately after every query:

ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:13

I checked in the error log file and find this repeated, for every 
occurance of this error on my screen:

/usr/local/libexec/mysqld: read looped with error 35, aborting thread

I've checked the variables and settings. All of the timeouts are default.

+--+---+
| Variable_name| Value |
+--+---+
| connect_timeout  | 30|
| delayed_insert_timeout   | 300   |
| flush_time   | 0 |
| innodb_lock_wait_timeout | 50|
| interactive_timeout  | 28800 |
| long_query_time  | 10|
| net_read_timeout | 120   |
| net_write_timeout| 180   |
| slave_net_timeout| 3600  |
| slow_launch_time | 2 |
| timezone | EDT   |
| wait_timeout | 28800 |
+--+---+


If I type queries real fast, immediately after eachother, I don't get 
this error. The error gets logged in the log file exactly 5 seconds 
after a query if I dont' type anything. 5 seconds!!!

I've checked the /etc/my.cnf file and its default. No .my.cnf files to 
worry about.

Any thoughts?


Is this info useful at all:


mysql status;
--
mysql  Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386)

Connection id:  10
Current database:   samp_db
Current user:   blairwag@localhost
SSL:Not in use
Current pager:  stdout
Using outfile:  ''
Server version: 4.0.2-alpha-debug-log
Protocol version:   10
Connection: Localhost via UNIX socket
Client characterset:latin1
Server characterset:latin1
UNIX socket:/tmp/mysql.sock
Uptime: 20 min 22 sec

Threads: 1  Questions: 90  Slow queries: 0  Opens: 14  Flush tables: 1 
Open tables: 8  Queries per second avg: 0.074  Memory in use: 46839K 
Max memory used: 46902K

-- 

  William Blair Wagner : Education is not always knowing the answer,
  [EMAIL PROTECTED] : ...but rather knowing where to look for it!



-
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