Problem with configuring 32-bit MySQL 5.0 on Windows Vista x64
I had previously installed the 64-bit version of MySQL 5.1 server under Windows Vista x64 and both the installation and configuration were successful. Then for compatibility reasons with something on which I am working I realized I needed to install the 32-bit version of MySQL 5.0 server. Since I did not see anything about installing both on the same machine, I decided to uninstall the 64-bit version and then install the 32-bit version. The uninstall ran successfully. When I installed MySQL 5.083 32-bit under Windows Vista x64 it installed successfully. When I try to configure an instance of that version, all steps work successfully until the Apply Security Settings step, which fails. The failure message is: The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 1045 Accessed denied for user 'root'@'localhost' [using password: YES]' I have never changed the password from the previous 64-bit version I installed and then uninstalled and the 32-bit version I installed. Any ideas of solving this problem ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Trying again, SSL between client and server using SslOption/mysql_ssl_set ( C++/C )
I have a few questions about the parameters for SslOption/mysql_ssl_set ( C++/C ) and about SSL in general between the server and the client. I do understand what a certificate, a private key, and a public key is in general but I am having trouble understandng how they work in MySql. 1) Are the first three parameters just the file name portions of the full file specifications for the private key, public key, and certificate respectively ? The documentation suggets that they can be file paths, but then the fourth parameter would seem redundant. 2) Is the fourth parameter the file path for all of the first three file names ? If this is so and the path is the current directory, can this be 0 ? 3) What determines a valid cipher name, and where is that specified in MySql SSL in general ? Is there a way to say that all ciphers are valid with this parameter ? When SSL goes between the client and the server, using the same certificate authority certificate, is there one set of public-private keys where the server's private key is the client's public key and the server's public key is the client's private key ? Or are there actually two distinct sets of public-private keys, one each for the client and the server ? The former seems logically correct but maybe I am missing something about how this works in SSL. If someone can explain this to me it would be appreciated. The MySql manual does not explain it. In general the documentation for MySql SSL in section 5.5.7 of the MySql manual is pretty abysmal, which makes me think that either no one ever uses SSL in MySql, MySql is an inadequate database for SSL, or that no one cares to actually explain how SSL works under MySql. I am hoping that someone know how this works from the programming point of view and can explain it adequately to me or actually point me to documentation/examples which does explain it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SSL between client and server using SslOption/mysql_ssl_set ( C++/C )
I have a few questions about the parameters for SslOption/mysql_ssl_set ( C++/C ) and about SSL in general between the server and the client. I do understand what a certificate, a private key, and a public key is in general but I am having trouble understandng how they work in MySql. 1) Are the first three parameters just the file name portions of the full file specifications for the private key, public key, and certificate respectively ? The documentation suggets that they can be file paths, but then the fourth parameter would seem redundant. 2) Is the fourth parameter the file path for all of the first three file names ? If this is so and the path is the current directory, can this be 0 ? 3) What determines a valid cipher name, and where is that specified in MySql SSL in general ? Is there a way to say that all ciphers are valid with this parameter ? When SSL goes between the client and the server, using the same certificate authority certificate, is there one set of public-private keys where the server's private key is the client's public key and the server's public key is the client's private key ? Or are there actually two distinct sets of public-private keys, one each for the client and the server ? The former seems logically correct but maybe I am missing something about how this works in SSL. If someone can explain this to me it would be appreciated. The MySql manual does not explain it. In general the documentation for MySql SSL in section 5.5.7 of the MySql manual is pretty abysmal, which makes me think that either no one ever uses SSL in MySql, MySql is an inadequate database for SSL, or that no one cares to actually explain how SSL works under MySql. I am hoping that someone know how this works from the programming point of view and can explain it adequately to me or actually point me to documentation/examples which does explain it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Windows source distribution
The MySql manual in section 2.4.15.6.2 mentions building MySql from the Windows source distribution. I need to do this in order to add SSL support to my MySql server on Windows. From where do I download the Windows source distribution ? The source distributions listed at http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any as the Windows source distribution. I downloaded the .zip file, thinking that might be the one, but it is not. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Windows source distribution
Warren Young wrote: Edward Diener wrote: The source distributions listed at http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any as the Windows source distribution. I downloaded the .zip file, thinking that might be the one, but it is not. I just downloaded it, and it looks like the source code to me. I think you're just not finding the build instructions, or not understanding them. No, I am not finding the VC++ .sln files as explained in the MySql reference manual section 2.4.15.6.2. Building MySQL from a Windows Source Distribution. The zip file contains just one top-level directory, mysql-5.0.67. Inside that is a file called INSTALL-WIN-SOURCE. Read it, ignoring the claims that you should find .sln files within the package; it's clearly outdated information. You will probably need to get cmake from somewhere to generate the .sln and .vcproj files. At that point, building MySQL should be straightforward. Essentially then the entire 2.4.15.6.2* *section in the MySql reference is just obsolete and the reference manual never was updated to reflect that. In fact what you are saying is that in 2.4.15.6, where it says: There are three solutions available for building from the source code on Windows: * Build from the standard MySQL source distribution. For this you will need CMake and Visual C++ Express Edition or Visual Studio. Using this method you can select the storage engines that are included in your build. To use this method, see Section 2.4.15.6.1, “Building MySQL from the Standard Source Distribution” ch02s04.html#windows-source-build-cmake. * Build from the MySQL Windows source distribution. The Windows source distribution includes ready-made Visual Studio solution files that enable support for all storage engines (except |NDB|). To build using using method you only need Visual C++ Express Edition or Visual Studio. To use this method, see Section 2.4.15.6.2, “Building MySQL from a Windows Source Distribution” ch02s04.html#windows-vc-plus-plus-build. * Build directly from the BitKeeper source repository. For this you will need CMake, Visual C++ Express Edition or Visual Studio, and |bison|. For this method you need to create the distribution on a Unix system and then copy the generated files to your Windows build environment. To use this method, see Section 2.4.15.6.5, “Creating a Windows Source Package from the BitKeeper Repository” ch02s04.html#windows-bitkeeper-build. that the middle way does not really exist. Getting it to find the openssl libraries, as discussed on the other list, is another question... I've not done this myself, just reporting on what I've figured out in a few minutes' poking around. I guess I actually believed the docs. Thanks for telling me that they are just plain wrong. I will follow the INSTALL-WIN-SOURCE file and just ignore the reference manual in this situation. But really the docs should be corrected so that others do not attempt to follow the incorrect path it outlines in 2.4.15.6.2 ch02s04.html#windows-vc-plus-plus-build. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Building MySql for Windows with SSL
In the MySql manual section 5.5.7.2 it specifies how to build MySql on a Unix/Linux platform with SSL by using 'configure'. I need to build MySql for Windows with SSL support. In section 2.4.15.6.1 for building MySql for Windows itr specifies the available options for using win/configure, but SSL is not among them. How then can I build MySql for Windows with SSL support ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Sending a message to the GMane mirror for this mailing list fails
I signed up for the Server | General Discussion mailing list using an e-mail address I created at my web host, and through which I have received numerous e-mails without problem. The subscription went correctly. I then attempted to send a message to the GMane newsgroups which mirrors the list. The message was sent without error. I then received a Gmane authorization to have the message sent to the newsgroup, then replied to that and received a further message from Gmane saying that I was now authorized and my original message would appear on the list within 10 minutes. Finally I received a message from Gmane: 'This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: mysql@lists.mysql.com mailto:mysql@lists.mysql.com SMTP error from remote mailer after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded threshold (#5.6.1)' What followed was a copy of the original message. When I queried GMane about this they told me the problem was from the MySql list, not them. I then unsubscribed to the mailing list and subscribed using a completely different e-mail address from my ISP provider, through which I have received numerous e-mails without problem. Once again the exact same error occurred. I am not a spammer and have never sent spam of any kind. Here is the full header of the returned e-mail: 'From - Mon Oct 06 17:33:13 2008 X-Account-Key: account2 X-UIDL: 20081006212921M1000852qfe1h X-Mozilla-Status: 0001 X-Mozilla-Status2: X-Mozilla-Keys: Received: from lo.gmane.org ([80.91.229.12]) by isp.att.net (frfwmxc10) with ESMTP id 20081006212920M1000ihkoee; Mon, 6 Oct 2008 21:29:21 + X-Originating-IP: [80.91.229.12] Received: from list by lo.gmane.org with local (Exim 4.50) id 1Kmxea-0002m0-95 for [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]; Mon, 06 Oct 2008 23:30:08 +0200 Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by lo.gmane.org with esmtp (Exim 4.50) id 1KmxeQ-0002hc-Gz for [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]; Mon, 06 Oct 2008 23:29:58 +0200 Received: from Debian-exim by ciao.gmane.org with local (Exim 4.43) id 1KmxdK-0003ZS-4K for [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]; Mon, 06 Oct 2008 21:28:50 + X-Failed-Recipients: mysql@lists.mysql.com mailto:mysql@lists.mysql.com Auto-Submitted: auto-generated From: Mail Delivery System [EMAIL PROTECTED] To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject: Mail delivery failed: returning message to sender Message-Id: [EMAIL PROTECTED] Date: Mon, 06 Oct 2008 21:28:50 + X-Spam-Report: 30.0 points; * 4.0 BOUNCE_MAIL_DELIVERY_FAILED Subject: 'Mail delivery failed', bounce message * 5.0 BOUNCE_EMPTY_RETURN_PATH Return-Path: * 0.0 IS_A_BOUNCE IS_A_BOUNCE * 10 BOUNCE_FROM_MAILER_DAEMON From: [EMAIL PROTECTED], likely bounce * 2.0 BOUNCE_TRANSCRIPT_RECEIVED BODY: Looks like message transcript with 'Received:' header * 2.5 BOUNCE_COULD_NOT_BE_DELIVERED BODY: Message says 'could not be delivered', so probably a bounce * 2.5 BOUNCE_SMTP_ERROR BODY: Looks like SMTP transcript with 'SMTP error' * 2.0 BOUNCE_CREATED_AUTOMATICALLY BODY: Message says created by mail delivery software * 2.0 BOUNCE_COPY_OF_MESSAGE BODY: 'a copy of the message', likely a failure report * 0.0 BAYES_50 BODY: Bayesian spam probability is 40 to 60% * [score: 0.5026] Why is my message failing when sent to the Gmane mirror for this list but succeeding when sent directly to this list as I am doing so now ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]