I know that this is somewhat off-topic but I thought someone here may have encountered this already and be able to direct me with a subtle (or not so subtle) RTFM. BTW, I have looked up all references in the MySQL manual and searched/read the MySQL site docs as well as a few Google searches.

I upgraded to MySQL-Max 4.02-alpha (Solaris binary) today and everything seems fine except--I was hoping to take advantage of the SSL support advertised in the MySQL manual:

In MySQL 4.0, the mysqld server daemon process can itself use Secure Sockets Layer (SSL), thus enabling secure traffic to MySQL databases from, say, a Windows application residing outside the firewall.
Another excerpt from the manual states that you can determine whether on not the installation of MySQL you are using has the SSL support by:
To get secure connections to work with MySQL you must do the following:
  1. Install the openssl library. We have tested MySQL with openssl 0.9.6. http://www.openssl.org/.
  2. Configure MySQL with  --with-vio --with-openssl.
  3. If you are using an old MySQL installation, you have to update your mysql.user table with some new columns. You can do this by running the  mysql_fix_privilege_tables.sh script.
  4. You can check if a running mysqld server supports openssl by examining if  SHOW VARIABLES LIKE 'have_openssl' returns 'YES'.
Well, I have openssl (OpenSSL 0x0090603f) installed, the variable 'have_openssl' returns 'NO' and when I use  --with-vio or  --with-openssl I get the messages: 
ERROR: unknown option '--with-vio'
ERROR: unknown option '--with-openssl'

[download]

Any info on this would be appreciated. The next step provided that this isn't a stupid question would be to contact MySQL. I just wanted some input from the Monastery first. As always, TIA.

Note: This is for development purposes, not production.

--Jim

Edited: ~Thu Aug 1 13:53:59 2002 (GMT) by footpad: Moved to Meditations.

Replies are listed 'Best First'.
Re: OT: MySQL 4.02 (alpha)
by talexb (Chancellor) on Aug 01, 2002 at 00:09 UTC
    You say you downloaded a binary -- that means you don't know what options were compiled in, is that right? Could it be that the VIO and OpenSSL options were not compiled in?

    --t. alex

    "Mud, mud, glorious mud. Nothing quite like it for cooling the blood!"
    --Michael Flanders and Donald Swann

[reply]
      That was my suspicion but it seems strange that such a major feature would be left out. The binary was downloaded from MySQL. I ran the  mysql-test-run script after my first post and it skipped the tests for  openssl_1 and openssl_2. Thanks for replying, I'll contact MySQL and find out what gives.

      --Jim

[reply]
[d/l]
[select]
        That was my suspicion but it seems strange that such a major feature would be left out.
        Not really, since it adds a dependency on the openssl lib and most people will never need this feature anyway.

        T I M T O W T D I
[reply]

Back to Meditations