Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote: Hi, What's wrong with GNU-cc 2.96? AFAIK, stability problems have been reported which did go away when using a precompiled binary... Why could we use 2.95 (and old 2.91) or above 3.*? or one of these compiler versions. Is this the junction of MySQL's user to choose which Linux version and review the suitable Hardware and Software? I mentioned this statement because I have more MySQL Server for several purpose in my organization. Of course, I still wait for the better feature from MySQL. How should we do; if the future version need more hardware, latest compiler or migration (3.xx -- 4.xx)? Did we still have the strength feature from MySQL (easy setup, run fast, need low resource)? I am not fully able to follow your concerns... if you use the precompiled binaries, as Sinisa suggested, you have all that, don't you? Usually, there is no need to compile MySQL yourself. To compile yourself is an option, not a must. Bye, Benjamin. -- [EMAIL PROTECTED] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi Benjamin, Uhmm, I have not success with Pre-compiled / Binary code from MySQL. In the other hand (if I was success installed), could it placed all thing like static complied? I have been concern this because I must to install other program or library to use with MySQL. So, I have a little experience with *nix* platform and using MySQL with the basic instruction. By now, I will try the MySQL binary installed to avoid this problem. Thanks any way, Sommai. At 03:05 12/3/2002 +0100, Benjamin Pflugmann wrote: Hi. On Tue, Mar 12, 2002 at 08:20:46AM +0700, [EMAIL PROTECTED] wrote: Hi, What's wrong with GNU-cc 2.96? AFAIK, stability problems have been reported which did go away when using a precompiled binary... Why could we use 2.95 (and old 2.91) or above 3.*? or one of these compiler versions. Is this the junction of MySQL's user to choose which Linux version and review the suitable Hardware and Software? I mentioned this statement because I have more MySQL Server for several purpose in my organization. Of course, I still wait for the better feature from MySQL. How should we do; if the future version need more hardware, latest compiler or migration (3.xx -- 4.xx)? Did we still have the strength feature from MySQL (easy setup, run fast, need low resource)? I am not fully able to follow your concerns... if you use the precompiled binaries, as Sinisa suggested, you have all that, don't you? Usually, there is no need to compile MySQL yourself. To compile yourself is an option, not a must. Bye, Benjamin. -- [EMAIL PROTECTED] - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? No, but it is mandatory to make a backup (you should do on a regular basis even for a normal use, and obviously you MUST do it before a major upgrade - dump your databases and tar your /etc dir, al least). Many things are going to change, however. First of all, inetd is abandoned in favour of xinetd which is easier to configure but different. Also, many more packages are now compiled with the hosts.allow/hosts.deny support (don't spend too much time asking yourself why sendmail refuses connections, as I did). When you're upgrading choose to customize the packets you have to upgrade and unckeck MySQL. You will upgrade it yourself manually with a fresh version from the MySQL site (RedHat wants to replace your binaries with its ones, which are packaged differently) Don't install anything earlier tha version 7.2. Also, DON'T forget to patch your distribution with anything you can find from the RedHat support site. I would also suggest to download and install the latest kernel. I could easily upgrade my local system, but with a remote one i choosed to wait. If you don't want to upgrade now a (temporary?) solution is to upgrade just your gcc compiler (and NOT glibc) and rebuild the rpms from MySQL sources. This is a hint received from James C. McDonald (thanks a lot James!!): -- 1. downloaded the gcc-2.95.2-1i.src.rpm from http://rpmfind.net/linux/RPM/ (yes I know it's from a PPC distribution, but Yellow Dog is based on RedHat) [*] 2. built i386 rpms for gcc-2.95-2 by # rpm --rebuild gcc-2.95.2-1i.src.rpm on a RH 6.2 box [**] 3. on a test RH 6.2 system I removed egcs and installed the gcc-2.95-2 rpms I just built (or at least a subset of them (you need to install gperf-2.7-6.i386.rpm if it is not already installed) # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.2-1i.i386.rpm # rpm -ivh gcc-2.95.2-1i.i386.rpm # rpm -ivh libstdc++-2.10.0-1i.i386.rpm # rpm -ivh gcc-c++-2.95.2-1i.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm you should now have gcc 2.95.2 installed # gcc -v Reading specs from /usr/lib/gcc-lib/i386-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release/franzo) At this point, if you want, you can also --rebuild gcc 2.96, which requires binutils-2.11 (have to --rebuild this, also). 4. Now try to build the MySQL rpm's # rpm --rebuild MySQL-3.23.49-1.src.rpm now completes successfully giving ... -rw-r--r--1 root root 6288340 Mar 5 12:59 MySQL-3.23.49-1.i386.rpm -rw-r--r--1 root root 1397099 Mar 5 12:59 MySQL-Max-3.23.49-1.i386.rpm -rw-r--r--1 root root 690350 Mar 5 12:59 MySQL-bench-3.23.49-1.i386.rpm -rw-r--r--1 root root 1766978 Mar 5 12:59 MySQL-client-3.23.49-1.i386.rpm -rw-r--r--1 root root 622278 Mar 5 12:59 MySQL-devel-3.23.49-1.i386.rpm -rw-r--r--1 root root 234505 Mar 5 12:59 MySQL-shared-3.23.49-1.i386.rpm I haven't tested the functionality of the build yet, but at least it builds without error. [***] -- [*] You'll have to look directly into the Yellow Dog ftp site since rpmfind links are broken. [**] You need to have texinfo installed to build gcc (this package is on your RedHat CD) [***] I've tested it just a little but it really looks like it's working pretty well!!! My mysql binaries have been built with gcc 2.96 (but with gcc 2.95 it should work the same). - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? Thanks a lot. I. Piasecki. - Original Message - From: Gabriele Carioli [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:06 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Hi If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? No, but it is mandatory to make a backup (you should do on a regular basis even for a normal use, and obviously you MUST do it before a major upgrade - dump your databases and tar your /etc dir, al least). Many things are going to change, however. First of all, inetd is abandoned in favour of xinetd which is easier to configure but different. Also, many more packages are now compiled with the hosts.allow/hosts.deny support (don't spend too much time asking yourself why sendmail refuses connections, as I did). When you're upgrading choose to customize the packets you have to upgrade and unckeck MySQL. You will upgrade it yourself manually with a fresh version from the MySQL site (RedHat wants to replace your binaries with its ones, which are packaged differently) Don't install anything earlier tha version 7.2. Also, DON'T forget to patch your distribution with anything you can find from the RedHat support site. I would also suggest to download and install the latest kernel. I could easily upgrade my local system, but with a remote one i choosed to wait. If you don't want to upgrade now a (temporary?) solution is to upgrade just your gcc compiler (and NOT glibc) and rebuild the rpms from MySQL sources. This is a hint received from James C. McDonald (thanks a lot James!!): -- 1. downloaded the gcc-2.95.2-1i.src.rpm from http://rpmfind.net/linux/RPM/ (yes I know it's from a PPC distribution, but Yellow Dog is based on RedHat) [*] 2. built i386 rpms for gcc-2.95-2 by # rpm --rebuild gcc-2.95.2-1i.src.rpm on a RH 6.2 box [**] 3. on a test RH 6.2 system I removed egcs and installed the gcc-2.95-2 rpms I just built (or at least a subset of them (you need to install gperf-2.7-6.i386.rpm if it is not already installed) # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.2-1i.i386.rpm # rpm -ivh gcc-2.95.2-1i.i386.rpm # rpm -ivh libstdc++-2.10.0-1i.i386.rpm # rpm -ivh gcc-c++-2.95.2-1i.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm you should now have gcc 2.95.2 installed # gcc -v Reading specs from /usr/lib/gcc-lib/i386-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release/franzo) At this point, if you want, you can also --rebuild gcc 2.96, which requires binutils-2.11 (have to --rebuild this, also). 4. Now try to build the MySQL rpm's # rpm --rebuild MySQL-3.23.49-1.src.rpm now completes successfully giving ... -rw-r--r--1 root root 6288340 Mar 5 12:59 MySQL-3.23.49-1.i386.rpm -rw-r--r--1 root root 1397099 Mar 5 12:59 MySQL-Max-3.23.49-1.i386.rpm -rw-r--r--1 root root 690350 Mar 5 12:59 MySQL-bench-3.23.49-1.i386.rpm -rw-r--r--1 root root 1766978 Mar 5 12:59 MySQL-client-3.23.49-1.i386.rpm -rw-r--r--1 root root 622278 Mar 5 12:59 MySQL-devel-3.23.49-1.i386.rpm -rw-r--r--1 root root 234505 Mar 5 12:59 MySQL-shared-3.23.49-1.i386.rpm I haven't tested the functionality of the build yet, but at least it builds without error. [***] -- [*] You'll have to look directly into the Yellow Dog ftp site since rpmfind links are broken. [**] You need to have texinfo installed to build gcc (this package is on your RedHat CD) [***] I've tested it just a little but it really looks like it's working pretty well!!! My mysql binaries have been built with gcc 2.96 (but with gcc 2.95 it should work the same). - 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 -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? No, definitely Or i must it do with 2.96 You need at least gcc 2.95. Follow the instructions posted on my previous message and you'll succeed - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Sommai Fongnamthip wrote: If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai No, they should be fine. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? I would definitely recommend 2.96RH, as it has fixed many bugs from egcs. It also has far better C++ standards compliance, but that's not an issue here. It's probably still the most stable gcc available at this point... -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? Regards. I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Ireneusz Piasecki [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:51 PM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? I would definitely recommend 2.96RH, as it has fixed many bugs from egcs. It also has far better C++ standards compliance, but that's not an issue here. It's probably still the most stable gcc available at this point... -- Trond Eivind Glomsrød Red Hat, Inc. -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote: On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake -- Trond Eivind Glomsrød Red Hat, Inc. I find this rather unhelpful, as it really doesn't answer the question. I understand that as a RH representative, you stand by the decision to use gcc 2.96, but no matter how wonderful you think it is, the MySQL directions explicitly state not to use it, because Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. Has this issue been resolved? If so, the directions should be updated. If not, I question the helpfulness of advising people to ignore the directions. I have no interest in the arguments over whether 2.96 was a good idea or not, and I take you at your word when you tout the merits of 2.96, but that's not the question here. The question is which compiler to use for *mysql*. The list of people with stable copies of mysql compiled with gcc 2.95.3 is long, and it includes people who had problems with copies compiled with 2.96. Personally, I have no idea whether that's because of a flaw in gcc 2.96 or in mysql, but it's a moot point until it's found and fixed. Has it been? Michael Stassen University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Michael Stassen [EMAIL PROTECTED] writes: On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote: On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake I find this rather unhelpful, as it really doesn't answer the question. I understand that as a RH representative, you stand by the decision to use gcc 2.96, but no matter how wonderful you think it is, the MySQL directions explicitly state not to use it, because Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. None of these have been brought to our attention or documented. Note that the official ones use a different, statically linked version of glibc as well as a very old compiler. Has this issue been resolved? If so, the directions should be updated. If not, I question the helpfulness of advising people to ignore the directions. I have no interest in the arguments over whether 2.96 was a good idea or not, and I take you at your word when you tout the merits of 2.96, but that's not the question here. The question is which compiler to use for *mysql*. The list of people with stable copies of mysql compiled with gcc 2.95.3 is long, and it includes people who had problems with copies compiled with 2.96. Personally, I have no idea whether that's because of a flaw in gcc 2.96 or in mysql, but it's a moot point until it's found and fixed. Has it been? No issues in interaction between gcc 2.96RH and MySQL has been identified since just after the release of Red Hat Linux 7 a year and a half ago (we submitted fixes for these to the MySQL team, and they have been included since the 3.23.midtwenties or so). A generic issue with MySQL is that MySQL seems more stable when compiled with -fno-rtti -fno-exceptions regardless of the compiler version. The newest rpms at http://people.redhat.com/teg/mysql/ are compiled that way, older ones aren't. Still haven't heard of any issues or experience any myself. FWIW, I've ran quite a few tests (the regression tests, the benchmarks etc) with no stability problems whatsoever. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 2002-03-08 at 10:02, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? Ireneusz, Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. If you do choose to compile with 2.96RH, then you are most likely going to run into problems in a production system. We definitely have a difference of opinion with Trond here. The bottom line is that if you want a stable MySQL server, then you should compile with GCC 2.91 or 2.95. These are the compilers for which our extensive testing has shown MySQL to be stable with. In any large and complicated project there are going to be dependencies on the compiler that the software was written for. Please note that the reason (atleast one of the reasons) RedHat includes 2.91 EGCS in their distribution is to compile the Linux kernel correctly. The Linux kernel -- another large and complicated project -- requires 2.91 EGCS. Read the kernel documentation for more information (README file included in every stock kernel tarball). This is absolutely normal and acceptable for large, complex softwares. Software simply cannot be changed everytime a software vendor (RH in this case) decides to fork their own version of something as fundamental as a compiler. MySQL in particular is a software product that gives your system a real work-out. We have discovered many critical bugs in the libc's, kernels and compilers of various systems -- for instance Glibc, the Linux kernel, and RedHat's forked 2.96 compiler. You will find the same is true of projects like ReiserFS (who do not recommend 2.96 either). While RedHat's 2.96 compiler may indeed work fine for relatively lightweight software that is most likely not going to be used in a high-performance production environment. We (MySQL AB) have determined -- through many investigations of MySQL under high-load compiled with 2.96RH -- that this compiler is not good for MySQL. Now that GCC 3.x has been released, we will be looking at making MySQL 4.x series (and higher) work well with it. GCC 3.x is looking very promising. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi! Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. Your (MySQL AB) source rpm does not build at all with the egcs/gcc 2.91 compiler. In fact, it gives this error: [..snip...] creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-const ructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exception s -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:195: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai At 10:59 6/3/2002 -0500, Trond Eivind Glomsrød wrote: Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a newer glibc, upgrade it all (newer versions of RHL has mysql included, too :) -- Trond Eivind Glomsrød Red Hat, Inc. - 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 -- Please be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? I don't would like to change to RH 7.2 I use rpm 4.0.2. regrads I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Dr. Michael Wittmann [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:32 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. P.S: I don't understand word: cos. Is it: Computer Operating System ? regards. - Original Message - From: Ben Edwards [EMAIL PROTECTED] To: Ireneusz Piasecki [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:44 PM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Cos redhat is at least at 7, you have an old version. At 08:33 06/03/2002, you wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? I don't would like to change to RH 7.2 I use rpm 4.0.2. regrads I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Dr. Michael Wittmann [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:32 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - 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 * Ben Edwards +44 (0)117 9400 636 * * Critical Site Builderhttp://www.criticaldistribution.com * * online collaborative web authoring content management system * * i-Contact Progressive Video http://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol Indymedia http://bristol.indymedia.org * * Bristol's radical news http://www.bristle.org.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
*mysql, to please stupid filter* On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote: On Wed, 6 Mar 2002, Ireneusz Piasecki wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? As I told you, that's a very bad idea. Very bad. I don't would like to change to RH 7.2 You're introducing a _lot_ more risk by just upgrading that part of the system. Upgrading to RHL 7.2 should be painfree, upgrading just glibc will be painful. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a newer glibc, upgrade it all (newer versions of RHL has mysql included, too :) -- Trond Eivind Glomsrød Red Hat, Inc. - 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
Why v3.23.49 does not build on RedHat 6.2 ?????
Hi everybody... I've searched thrugh the lists (IMHO the search engine is slow and the output sucks: what about a date column at the beginning of each row in the post list and in search results?) and the manual. This is the 3rd time I post about this problems but it looks like nobody can give me an answer ... I wonder if it is possible at all to build rpm MySQL 3.23.49 binaries for RedHat 6.2. Is it possible? I've not been able to build rpm for my platform on three different machines. I've tried to rpm --rebuild MySQL-3.23.49-1.src.rpm After many lines of compiling log I get the following: [... snip ...] lo dbug.lo -lz -lcrypt -lnsl -lm rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.* .libs/libmysqlclient.* ar cru .libs/libmysqlclient.a libmysql.o net.o violite.o password.o get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o my_create.o my_delete.o mf_tempfile.o my_open.o mf_casecnv.o my_read.o my_write.o errors.o my_error.o my_getwd.o my_div.o mf_pack.o my_messnc.o mf_dirname.o mf_fn_ext.o mf_wcomp.o typelib.o safemalloc.o my_alloc.o mf_format.o mf_path.o mf_unixpath.o my_fopen.o my_symlink.o my_fstream.o mf_loadpath.o my_pthread.o my_thr_init.o thr_mutex.o mulalloc.o string.o default.o my_compress.o array.o my_once.o list.o my_net.o charset.o hash.o mf_iocache.o my_seek.o my_pread.o mf_cache.o getopt.o getopt1.o getvar.o my_lib.o strmov.o strxmov.o strnmov.o strmake.o strend.o strnlen.o strfill.o is_prefix.o int2str.o str2int.o strinstr.o strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o strtoull.o strtoll.o llstr.o ctype.o ctype-big5.o ctype-czech.o ctype-euc_kr.o ctype-gb2312.o ctype-gbk.o ctype-sjis.o ctype-tis620.o ctype-ujis.o dbug.o ranlib .libs/libmysqlclient.a creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3-felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -fpermis sive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:200: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.7029 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.7029 (%build) What's wrong? --- Gabriele Carioli Management Innovative Tools S.p.A. Via Giuditta Tavani Arquati, 6 47100 Forlì (FC) - ITALY (EU) tel. 0039.0543.21834 fax. 0039.0543.379215 http://www.mit.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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
hi, the source rpm for mysql 3.23.49 contains build instructions for gnu compilers 2.95 or newer. redhat 6.2 comes with a compiler that cannot handle the permissive flag (i think its ecgs-2.91). therefore the build fails. one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's (although there had been a rpm-3 version which could _read_ rpm-4 packages - i think it was 3.0.5.) besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... if you dont have very specific reasons to stick with redhat 6.2 in my opinion it could be simpler just to install a later redhat version... not sure if this really helps... bye michael Gabriele Carioli wrote: Hi everybody... I've searched thrugh the lists (IMHO the search engine is slow and the output sucks: what about a date column at the beginning of each row in the post list and in search results?) and the manual. This is the 3rd time I post about this problems but it looks like nobody can give me an answer ... I wonder if it is possible at all to build rpm MySQL 3.23.49 binaries for RedHat 6.2. Is it possible? I've not been able to build rpm for my platform on three different machines. I've tried to rpm --rebuild MySQL-3.23.49-1.src.rpm - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
hi! the source rpm for mysql 3.23.49 contains build instructions for gnu compilers 2.95 or newer. redhat 6.2 comes with a compiler that cannot handle the permissive flag (i think its ecgs-2.91). A-HA!!! Thanks a lot! therefore the build fails. one solution could be to install a more recent compiler version and try to recompile again. I'll try this solution before upgrading my system be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 Yes, but v4 version has been made available. Actually I'm running 4.0.2 besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. Binary rpms released by the mysql team were working on my system till v3.23.48. I Hope I'll be able to compile this new version against glibc 2.1 . if you dont have very specific reasons to stick with redhat 6.2 in my opinion it could be simpler just to install a later redhat version... Unfortunately my server 'lives' in another town but It looks like it will receive a visit soon. :o) not sure if this really helps... It did! Now I know the reason why the build fails! - 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
