Spam - why?
I don't understand why I'm getting so much spam from the mysql list... - 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
connect by clause...
Hi. It's Christmas and I'm sending my wish list to Santa Claus... ;o) 1. hierarchical queries I've seen an interesting patch to PostgreSQL to implement hierarchical queries similar to those available with Oracle (http://gppl.terminal.ru/readme.html). This kind of query makes handling trees an easy job. In a typical table representing a tree like, like this: ++-+-+ | id | pnt |data | ++-+-+ | 0 | 0 | root| | 1 | 0 | (1 leaf l1) | | 2 | 0 | (2 leaf l1) | | 3 | 0 | (3 leaf l1) | | 4 | 1 | (11 leaf l2)| | 5 | 1 | (12 leaf l2)| | 6 | 1 | (13 leaf l2)| | 7 | 6 | (31 leaf l2)| | 8 | 6 | (32 leaf l2)| ++-+-+ it is possible to execute a query like: SELECT * FROM data CONNECT BY id PRIOR pnt START WITH id=0; whose output would be something like: id | pnt |data | _level_ +-+-+- 0 | 0 | root| 1 1 | 0 | (1 leaf l1) | 2 4 | 1 | (11 leaf l2)| 3 5 | 1 | (12 leaf l2)| 3 6 | 1 | (13 leaf l2)| 3 2 | 0 | (2 leaf l1) | 2 3 | 0 | (3 leaf l1) | 2 7 | 6 | (31 leaf l2)| 3 Yes, I know, of course handling a tree is possible also without this kind of statements, but I think that this would be a nice feature to implement into MySQL (It would be nice to have something to select the path from the root to a leaf or a segment of this path, it would be nice to have something selecting a subtree down just to a certain level, etc.) 2. php serialized objects Since PHP and MySQL are so often used together, wouldn't it be nice to handle serialized objects directly with MySQL (create, search, modify and index them) ? (Merry XMas to everybody!) - 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: Error rebuilding 3.23.54 source rpm, glibc 2.1?
Hi I've got an older redhat 6.2 box that has glibc 2.1.3-28 on it. The binary rpm's won't install (needs glibc 2.2), and rebuilding the source rpm gives: [...] error: Bad exit status from /var/tmp/rpm-tmp.94268 (%build) You don't need a newer glibc version but a newer compiler. RedHat 6.2 comes with the egcs compiler. You need gcc 2.95. I'm using gcc-2.95.4-4h (but gcc-2.95.2-1i works, too). You can find all you need at www.rpmfind.net. Look for YellowDog linux SOURCE packages. YellowDog is for PowerPC, but it's fully RedHat compatible and rebuilding source packages works perfectly. 1. download gcc-2.95.4-4h.src.rpm from http://rpmfind.net/ (gcc-2.95.2-1i.src.rpm works, too) 2. built rpms for gcc-2.95-4 on your RH62 box executing: # rpm --rebuild gcc-2.95.4-4h.src.rpm(*) You will find rebuilded packages in /usr/src/redhat/RPMS/i386/ 3. Remove old egcs and install the gcc-2.95-4 rpms you've built. You will need to install gperf-2.7-6.i386.rpm if it is not already installed (it's on your RedHat CD-ROM). # 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.4-4h.i386.rpm # rpm -ivh gcc-2.95.4-4h.i386.rpm # rpm -ivh libstdc++-2.10.0-4h.i386.rpm # rpm -ivh gcc-c++-2.95.4-4h.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm 4. Optional: at this time you may want to rerebuild your gcc 2.95.4 with itself. 5. Rebuild MySQL (*): # rpm --rebuild MySQL-3.23.xx-1.src.rpm 6. Finally install MySQL binaries (*) To rebuild MySQL-2.23.54-1 you also need to upgrade a few packages. Look at the Compiling 3.23.54-1 - new tools installed ! thread. - 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
3.23.54 compile error
I've tried to build mysql-3.23.54 from rpm sources. My system is a RedHat 6.2 with glibc-2.1.3-28 and the compiler is gcc-2.95.4-4h. Had no problems at all building mysql until mysql-3.23.53, but now I get this error: [...] Making distclean in . make[1]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.54' test -z linked_client_sources linked_server_sources linked_libmysql_sources linked_libmysql_r_sources linked_include_sources || rm -f linked_client_sources linked_server_sources linked_libmysql_sources linked_libmysql_r_sources linked_include_sources rm -rf .libs _libs rm -f *.lo rm -f Makefile bdb/Makefile stamp-h stamp-h[0-9]* rm -f config.h rm -f libtool rm -f TAGS ID GTAGS GRTAGS GSYMS GPATH make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.54' rm -f config.status config.cache config.log + mv Docs/manual.ps.save Docs/manual.ps + automake aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? - 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: 3.23.54 compile error
I reply to myself... I've tried to build mysql-3.23.54 from rpm sources. [...] error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? Got a clean compile with libtool-1.4-8 and automake-1.5-1. Now I'll test 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: 3.23.54 compile error
Maybe I'm paranoid I reply to myself... I've tried to build mysql-3.23.54 from rpm sources. [...] error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? Got a clean compile with libtool-1.4-8 and automake-1.5-1. Now I'll test it. When I start mysql with service mysql start I get this error: /usr/bin/safe_mysqld: 5: command not found What's that? By the way mysql seems up and running... - 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
Spam
-- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. Regards - 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: MySQL-Front Discontinued
Hi. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. The support forum is still active: http://mysqlfront.venturemedia.de/ According to the moderator, Ansgar is neither going to make it commercial nor willing to make it open source. I wonder why. - 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: rpms for redhat 6.2
Hi! Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2 with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+ I had the same problem. There are four possible solutions: a) The obvious but annoying one: upgrade to RH72... b) The less likely one. Upgrade RH62 to GLIBC22, but this is *STRONGLY DISCOURAGED* by Redhat... c) Trust Sinisa Milivojevic (who is one of MySQL developers). He told me to ignore warnings and force installation of MySQL binaries, since they're statically linked with GLIBC22 d) The difficult way: rebuild binaries. This was my choice (thank to James C. McDonald). In order to rebuild binaries you've to upgrade the gcc compiler, too. Follow these steps: 1. downloaded the gcc-2.95.4-4h.src.rpm from http://rpmfind.net/ (it's from a PPC distro but its RedHat based) 2. built rpms for gcc-2.95-4 on your RH62 box executing: # rpm --rebuild gcc-2.95.4-4h.src.rpm(*) You will find rebuilded packages in /usr/src/redhat/RPMS/i386/ 3. Remove old egcs and install the gcc-2.95-4 rpms you've built. You will need to install gperf-2.7-6.i386.rpm if it is not already installed (it's on your RedHat CD-ROM). # 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.4-4h.i386.rpm # rpm -ivh gcc-2.95.4-4h.i386.rpm # rpm -ivh libstdc++-2.10.0-4h.i386.rpm # rpm -ivh gcc-c++-2.95.4-4h.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm 4. Rebuild MySQL: # rpm --rebuild MySQL-3.23.49-1.src.rpm 5. Finally install MySQL binaries Regards Gabriele Carioli (*) Actually I'm not sure if you can build directly this version. Infact I formerly built gcc 2.95.2-1i. With this one I built gcc 2.96 (and had to rebuild binutils-2.11 and upgrade to, too), but then it was pointed out that this version of gcc does not work well with mysql. So I finally built gcc-2.95-4 and down-graded to this one. - 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: mysql 3.23.49-1.src.rpm and RPM 4.0.2 on RH 6.2
I want rebuild source rpm: MySQL-3.23.49-1.src.rpm with rpm 4.0.2 But it fails. You need the rpm-build-4.0.2-6x.i386.rpm package to use the --rebuild option. You need gcc = 2.95 to build MySQL (look at the Why v3.23.49 does not build on RedHat 6.2 ? thread) --- 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. 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 ?????
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
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). 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
MySQL-3.23.49-1.src.rpm does not build under RedHat Linux 6.2
I see binaries are now shipping with vwesrion 3.23.49a. Have sources been changed since 3.23.49? I'm asking since I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails like this: [..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) Is there anything missing or wrong in my system. What can I do? Thanks a lot - 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
Error in --rebuild MySQL-3.23.49-1.src.rpm on RedHat 6.2
I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20). The MySQL-shared-3.23.49-1.i386.rpm package does not install since it's compiled using GLIBC 2.2. I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails: [..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) Is there anything missing or wrong in my system. What can I do? Thanks a lot - 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
MySQL-3.23.49-1.src.rpm does not build on RedHat 6.2
I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20). The MySQL-shared-3.23.49-1.i386.rpm package does not install since it's compiled using GLIBC 2.2. I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails: 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) Is there anything missing or wrong in my system. What can I do? Thanks a lot - 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