New version of mySQL available and is recommended my www.mysql.com Reproducible: Always Steps to Reproduce: 1.go to www.mysql.com 2.go to downloads section 3.look at latest 4.1.x version Actual Results: I see a new version available Expected Results: used the new version
Please use "New -> Gentoo Linux -> Component: Ebuilds" in future. Infrastructure is not the correct addressee.
additionally the following announcment appered today on mysql mailing list: [post] Innobase Oy declares MySQL/InnoDB-4.1 stable Innobase Oy has decided to declare MySQL/InnoDB-4.1 stable and recommended for all production use, starting from version 4.1.10. MySQL/InnoDB-4.1 has been out for almost two years now, there have been millions of downloads of the software, and it is already in extensive production use at many MySQL sites. That gives us the confidence to recommend it for all production use from now on. The first alpha version of 4.1 was released on April 3, 2003, and the product entered the beta phase on June 28, 2004. The last known serious problem in MySQL/InnoDB-4.1 was the bug http://bugs.mysql.com/bug.php?id=7496 in the my.cnf option innodb_file_per_table. Best regards, Heikki Tuuri Innobase Oy [/post] [spam mode on] Get ebuilds here: http://www.francesco-riosa.com/gentoo/mysql_overlay-latest.tar.gz http://www.francesco-riosa.com/gentoo/ [spam mode off]
Francesco, they just moved procps from the sys-apps category to the sys-process category, so the mysql 4.1.10 ebuild in your overlay tarball is broken. (It requires sys-apps/procps) Aside from that, is there a reason why this isn't in portage yet, other than nobody's gotten around to it? Do the ebuild and other associated files need to be attached before someone will put it in the tree?
I will emerge sync the test box and change the ebuilds. The relase process I'm following require that all ebuilds are tryed before to come out, so expect them for monday 7 morning (maybe before but with no promises). trying answer to your second question, "there a reason why this isn't in portage yet" there are a lot of package that depend on mysql, the real work is there, not in the mysql ebuild, the default charachter set change is a pain, the same for the client libraries version. If at this you add that in these months I'had only few dozen downloads (this reveal lack of interest for me) you can see the whole drawing. These are personal point of view not ever discussed with gentoo devs. btw for the same motivation I'm going to drop the support for bitkeeper builds, adding the nigthly snapshots and left untouched the stable branch.
Well, I for one have been using mysql-4.1 for over a month now. Not seeing downloads of your overlays is not a good indication of lack of interest. Most people who need 4.1 are probably just editing their package.unmask without even being aware that there ARE updated ebuilds somewhere else.
Funny that I should have made my own overlay ebuild just a few days ago... I've been using mysql-4.1 for quite some time, too, without any stability problems, neither in mysql itself nor in any of my dependent packages. (Mostly PHP.) A single revdep-rebuild solved all problems I had.
[MySQL announcement] This MySQL 4.1.10a release just includes the additional patches for recently reported potential security vulnerabilites in the creation of temporary table file names and the handling of User Defined Functions (UDFs). We would like to thank Stefano Di Paola <stefano.dipaola@wisec.it> for finding and reporting these to us. Please note that these changes affect the way in which User Defined Functions (UDF) are loaded. Please refer to the section "User-defined Function Security Precautions" in the manual: http://dev.mysql.com/doc/mysql/en/udf-security.html [/MySQL announcement] trying to compile ebuilds on x86 arch now, there are changed things in berkdb land, this cause problems for x86_64 (working on). ebuilds should be avaiable at links specified in http://bugs.gentoo.org/show_bug.cgi?id=83011#c2 tomorrow 2005-03-12 morning
Another vote for moving the 4.1 ebuilds to ~arch
Created attachment 53446 [details] overlay for mysql-4.1.10a [new ebuild]
Created attachment 53447 [details, diff] diffs from the 4.0.24-r1 for the previous overlay Tested on both x86 and amd64, please verify
bug #85843 "net-misc/gnugk-2.2.1-r2 version bump" may be considered related to this one. Not setting it blocking for this one at the moment.
This is a list of packages that should compile sucessfully against mysql-4.1.10a If you find something missing please report. Algorithm-Diff-1.15.tbz2 Apache-DBI-0.94.tbz2 AppConfig-1.56-r2.tbz2 Archive-Tar-1.23-r1.tbz2 Archive-Zip-1.14.tbz2 Authen-PAM-0.14.tbz2 BerkeleyDB-0.26.tbz2 Bio-Das-0.93.tbz2 Bit-Vector-6.4.tbz2 CGI-3.05.tbz2 Carp-Clan-5.3.tbz2 Class-Accessor-0.19.tbz2 Class-DBI-0.96.tbz2 Class-DBI-mysql-0.23.tbz2 Class-Data-Inheritable-0.02.tbz2 Class-Trigger-0.08.tbz2 Class-WhiteHole-0.04.tbz2 Compress-Zlib-1.33.tbz2 Config-IniFiles-2.38.tbz2 Convert-TNEF-0.17-r2.tbz2 Convert-UUlib-1.03.tbz2 Crypt-Blowfish-2.09-r3.tbz2 Crypt-DES-2.03-r1.tbz2 Crypt-SSLeay-0.51.tbz2 Curses-1.08.tbz2 DBD-SQLite-1.07.tbz2 DBD-mysql-2.9004.tbz2 DBI-1.46.tbz2 DBIx-ContextualFetch-1.01.tbz2 Data-ShowTable-3.3-r2.tbz2 Date-Calc-5.4.tbz2 Digest-MD5-2.33.tbz2 File-Temp-0.14.tbz2 FileHandle-Rollback-1.05.tbz2 GD-2.19.tbz2 GDGraph-1.43.tbz2 GDTextUtil-0.86.tbz2 Geo-IP-1.23.tbz2 Graph-0.20105.tbz2 HTML-Parser-3.36-r1.tbz2 HTML-Tagset-3.04.tbz2 Heap-0.71.tbz2 IO-Socket-SSL-0.96.tbz2 IO-String-1.05.tbz2 IO-Zlib-1.01.tbz2 IO-stringy-2.109.tbz2 Ima-DBI-0.33.tbz2 Lingua-EN-Inflect-1.88.tbz2 MIME-Base64-3.05.tbz2 MIME-Lite-3.01.tbz2 MIME-tools-5.416.tbz2 MailTools-1.65.tbz2 Net-Daemon-0.38.tbz2 Net-Pcap-0.04.tbz2 Net-SSLeay-1.25.tbz2 NetPacket-0.03.tbz2 PlRPC-0.2016-r1.tbz2 Proc-Daemon-0.03.tbz2 Proc-Simple-1.21.tbz2 SOAP-Lite-0.60a-r1.tbz2 Scalar-List-Utils-1.14.tbz2 Storable-2.13.tbz2 Template-Toolkit-2.14.tbz2 Term-ReadLine-Perl-1.0203.tbz2 TermReadKey-2.21.tbz2 Test-Harness-2.42.tbz2 Test-Manifest-1.11.tbz2 Test-Simple-0.54.tbz2 Text-Iconv-1.4.tbz2 Text-Shellwords-1.07.tbz2 Tie-IxHash-1.21-r1.tbz2 Time-HiRes-1.59.tbz2 Time-modules-2003.1126.tbz2 UNIVERSAL-moniker-0.08.tbz2 URI-1.35.tbz2 Unicode-String-2.07.tbz2 Unix-Syslog-0.100-r1.tbz2 XML-DOM-1.43.tbz2 XML-Filter-BufferText-1.01.tbz2 XML-Handler-YAWriter-0.23-r1.tbz2 XML-LibXML-1.58.tbz2 XML-LibXML-Common-0.13.tbz2 XML-NamespaceSupport-1.08.tbz2 XML-RSS-1.04.tbz2 XML-RegExp-0.03-r1.tbz2 XML-SAX-0.12.tbz2 XML-SAX-Base-1.04.tbz2 XML-SAX-Writer-0.44-r1.tbz2 XML-SimpleObject-0.53.tbz2 XML-Twig-3.15-r1.tbz2 XML-Writer-0.510.tbz2 XML-XPath-1.13.tbz2 actionmailer-0.7.1.tbz2 actionpack-1.5.1.tbz2 actionwebservice-0.6.0.tbz2 activerecord-1.8.0.tbz2 activesupport-1.0.1.tbz2 adns-1.1.tbz2 adodb-py-1.10.tbz2 aimsniff-0.9-r1.tbz2 amavisd-new-2.2.1.tbz2 ant-1.6.2-r6.tbz2 ant-core-1.6.2.tbz2 ant-tasks-1.6.2-r5.tbz2 antlr-2.7.4.tbz2 anubis-3.9.95.tbz2 apache-1.3.33-r1.tbz2 apache-2.0.53.tbz2 apr-0.9.6-r1.tbz2 apr-util-0.9.6.tbz2 art-sharp-1.0.6.tbz2 asterisk-1.0.6.tbz2 asterisk-rate_engine-0.5.4.tbz2 avalon-logkit-1.2.tbz2 bacula-1.36.0.tbz2 barnyard-0.2.0.tbz2 bcel-5.1.tbz2 bigloo-2.6a.tbz2 bind-9.2.2-r4.tbz2 bioperl-1.4.tbz2 bioperl-pipeline-0.1.tbz2 bioperl-run-1.4.tbz2 blackdown-jdk-1.4.2.01-r1.tbz2 blackdown-jre-1.4.2.01.tbz2 blt-2.4z.tbz2 bmf-0.9.4.tbz2 bsf-2.3.0-r2.tbz2 bsh-2.0_beta2.tbz2 bwidget-1.7.0.tbz2 cdparanoia-3.9.8-r2.tbz2 cdrtools-2.01.01_alpha01-r1.tbz2 cdw-0.2.3.tbz2 cl-asdf-1.86-r1.tbz2 clamav-0.83.tbz2 cmf-1.3.2.tbz2 common-lisp-controller-4.12.tbz2 commons-beanutils-1.7.0.tbz2 commons-collections-3.1.tbz2 commons-logging-1.0.4-r1.tbz2 commons-net-1.3.0.tbz2 connectorj-3.0.16.tbz2 courier-authlib-0.55.tbz2 courier-imap-4.0.1-r1.tbz2 crypt-cbc-2.11.tbz2 cryptsetup-0.1-r1.tbz2 curl-7.13.1.tbz2 cyrus-sasl-2.1.20-r2.tbz2 datavision-0.8.2.tbz2 datavision-bin-0.8.1-r1.tbz2 dbdesigner-4.0.5.4.tbz2 device-mapper-1.01.00.tbz2 digest-base-1.08.tbz2 digitaldj-0.7.5.tbz2 dotproject-1.0.2.tbz2 dovecot-0.99.14-r1.tbz2 dspam-3.4.0.tbz2 dvmysql-0.4.10.tbz2 dvutil-0.13.13.tbz2 egenix-mx-base-2.0.6.tbz2 eggdrop-1.6.17-r1.tbz2 entropy-0.8.2.415.tbz2 exuserfolder-0.20.0-r1.tbz2 ffmpeg-0.4.9_p20050226-r1.tbz2 findlib-1.0.4-r1.tbz2 flow-tools-0.67.tbz2 formulator-1.6.2.tbz2 freeradius-1.0.2-r1.tbz2 freetype-1.3.1-r4.tbz2 gambas-1.0.4.tbz2 gammu-1.00.04.tbz2 gconf-sharp-1.0.6.tbz2 gd-2.0.32.tbz2 gdal-1.2.5.tbz2 gdk-pixbuf-0.22.0-r3.tbz2 generic-genome-browser-1.58.tbz2 gentoo-webroot-default-0.1.tbz2 geoip-1.3.6.tbz2 ghostscript-7.07.1-r8.tbz2 glade-sharp-1.0.6.tbz2 gmp-4.1.4.tbz2 gmyclient-0.3.tbz2 gnokii-0.6.4.tbz2 gnome-libs-1.4.2.tbz2 gnome-sharp-1.0.6.tbz2 gnu-gs-fonts-std-8.11.tbz2 gnu-regexp-1.1.4.tbz2 gnupg-1.4.0-r2.tbz2 gpgme-1.0.2.tbz2 grip-3.3.0.tbz2 gstreamer-0.8.9-r2.tbz2 gtk-sharp-1.0.6.tbz2 gtkhtml-sharp-1.0.6.tbz2 guile-1.6.7.tbz2 hk_classes-0.7.2-r1.tbz2 icu-3.2.tbz2 id3lib-3.8.3-r3.tbz2 imagemagick-6.2.0.6.tbz2 imlib2-1.2.0.20050220.tbz2 ipaudit-1.0_beta1.tbz2 iptables-1.2.11-r3.tbz2 itext-1.2.3.tbz2 jabberd-1.4.3-r4.tbz2 java-config-1.2.11.tbz2 javacup-0.10k.tbz2 jcalendar-1.2.2.tbz2 jdbc-mysql-3.1.7.tbz2 jdbc2-stdext-2.0-r1.tbz2 jdepend-2.8.1.tbz2 jgoodies-looks-1.2.2.tbz2 johntheripper-1.6.37_p1.tbz2 jruby-0.7.0.tbz2 jsch-0.1.18.tbz2 jta-1.0.1.tbz2 junit-3.8.1-r1.tbz2 jython-2.1-r5.tbz2 jzlib-1.0.5.tbz2 kde-env-3-r3.tbz2 kdelibs-3.3.2-r5.tbz2 koffice-1.3.5-r2.tbz2 krecipes-0.7.1.tbz2 lame-3.96.1.tbz2 lcms-1.13.tbz2 lib-compat-1.4.tbz2 libdbi-0.7.2.tbz2 libdbi-drivers-0.7.1.tbz2 libexif-0.6.10-r1.tbz2 libgda-1.0.4.tbz2 libgeotiff-1.2.1-r1.tbz2 libghttp-1.0.9-r4.tbz2 libglade-0.17-r6.tbz2 libgsf-1.10.0.tbz2 libidn-0.5.13.tbz2 liblockfile-1.03-r2.tbz2 libmcrypt-2.5.7.tbz2 libmng-1.0.8.tbz2 libnet-1.19.tbz2 libnss-mysql-1.3.tbz2 libogg-1.1.2.tbz2 libpcap-0.8.3-r1.tbz2 libprelude-0.8.10.tbz2 libreadline-java-0.8.0-r1.tbz2 libsdl-1.2.8-r1.tbz2 libungif-4.1.3.tbz2 libvorbis-1.1.0.tbz2 libwww-perl-5.800.tbz2 libxml-1.8.17-r2.tbz2 libxml-perl-0.08.tbz2 lighttpd-1.3.13.tbz2 log4j-1.2.9.tbz2 logrotate-3.7.tbz2 maildrop-1.8.0-r3.tbz2 mailx-8.1.2.20040524-r1.tbz2 mailx-support-20030215.tbz2 mhash-0.9.2.tbz2 mime-types-1.0-r1.tbz2 minml2-0.3.tbz2 mm-1.3.0.tbz2 mod_auth_external-2.2.9.tbz2 mod_auth_mysql-2.8.1.tbz2 mod_log_sql-1.100.tbz2 mod_mp3-0.40-r1.tbz2 mod_ssl-2.8.22.tbz2 mod_vdbh-1.0.3-r1.tbz2 modlogan-0.8.13.tbz2 mono-1.0.6.tbz2 moodss-19.6.tbz2 mp3blaster-3.2.0.tbz2 mpg123-0.59s-r9.tbz2 mt-st-0.7-r1.tbz2 mtop-0.6.6.tbz2 mtx-1.2.18.tbz2 musicbrainz-2.1.1.tbz2 mydns-1.0.0.tbz2 mysql++-1.7.26.tbz2 mysql-4.0.25_alpha20050314.tbz2 mysql-4.1.10a.tbz2 mysql-4.1.11_alpha20050310.tbz2 mysql-5.0.3_alpha20050313.tbz2 mysql-administrator-1.0.19-r1.tbz2 mysql-python-1.2.0.tbz2 mysql-query-browser-1.1.6.tbz2 mysql-ruby-2.5.2.tbz2 mysql-super-smack-1.2.tbz2 mysqltcl-2.50.tbz2 mysqltool-0.95-r3.tbz2 ncbi-tools-20041020-r1.tbz2 net-server-0.87.tbz2 net-snmp-5.2.1.tbz2 netcdf-3.6.0-r1.tbz2 netpbm-10.20.tbz2 nettle-1.10.tbz2 newt-0.50.35-r4.tbz2 nntpswitch-0.11.tbz2 note-1.2.5-r1.tbz2 ocaml-3.08.2.tbz2 ocaml-mysql-1.0.3.tbz2 oer-mysql-1.0.43.tbz2 openh323-1.15.2-r1.tbz2 openldap-2.1.30-r4.tbz2 orbit-0.5.17.tbz2 orm-1.0.1.tbz2 oro-2.0.8.tbz2 osiris-1.5.2.tbz2 pam-0.78-r2.tbz2 pam_mysql-0.5.tbz2 pdflib-5.0.4_p1-r1.tbz2 pdns-2.9.17.tbz2 perdition-1.15.tbz2 pike-7.6.24.tbz2 piwi-0.8.0.20031109-r3.tbz2 pmacct-0.8.2.tbz2 proftpd-1.2.10-r3.tbz2 proj-4.4.9.tbz2 pth-2.0.3.tbz2 ptlink-services-2.25.1.tbz2 pure-ftpd-1.0.20-r1.tbz2 pvpgn-1.6.5-r1.tbz2 pwlib-1.8.3-r1.tbz2 qhacc-3.2.3.tbz2 qt-3.3.4-r3.tbz2 quanta-docs-20030405.tbz2 rails-0.10.1.tbz2 rake-0.4.15-r1.tbz2 raptor-1.4.5.tbz2 rasqal-0.9.6.tbz2 realpath-1.9.16.tbz2 redland-1.0.0.tbz2 regexp-1.3-r1.tbz2 rekall-2.2.3-r1.tbz2 rhino-1.5.5-r1.tbz2 rtg-0.7.4-r1.tbz2 ruby-1.8.2.tbz2 ruby-config-0.3.1.tbz2 ruby-dbi-0.0.21-r1.tbz2 rubygems-0.8.6.tbz2 sablotron-1.0.1.tbz2 samba-3.0.11.tbz2 scwoop-4.1.tbz2 sdl-mixer-1.2.6.tbz2 sdl-net-1.2.5.tbz2 selinux-base-policy-20050306.tbz2 selinux-mysql-20050219.tbz2 ser-0.8.14.tbz2 servletapi-2.3-r1.tbz2 servletapi-2.4-r1.tbz2 slang-1.4.9-r1.tbz2 smpeg-0.4.4-r4.tbz2 snmptt-1.0.tbz2 snort-2.3.0-r1.tbz2 sox-12.17.7-r1.tbz2 sqlobject-0.6.1.tbz2 squid-2.5.9-r1.tbz2 squidalyser-0.2.55.tbz2 t1lib-5.0.2.tbz2 taglib-1.3.1.tbz2 tcl-sql-20000114.tbz2 tcldom-2.6.tbz2 tcllib-1.6.1.tbz2 tclxml-2.6.tbz2 tcsh-6.13-r1.tbz2 teamspeak2-server-bin-2.0.20.1-r1.tbz2 teapop-0.3.8-r1.tbz2 text-autoformat-1.12.tbz2 text-reform-1.11.tbz2 tk-8.4.6-r1.tbz2 tkpiechart-6.5.tbz2 tktable-2.9.tbz2 tpop3d-1.5.3-r1.tbz2 tunepimp-0.3.0-r1.tbz2 ulogd-1.02-r1.tbz2 unixODBC-2.2.8.tbz2 usermin-1.110.tbz2 vanessa-adt-0.0.6.tbz2 vanessa-logger-0.0.7.tbz2 vanessa-socket-0.0.7.tbz2 vte-0.11.11-r3.tbz2 vte-sharp-1.0.6.tbz2 webapp-config-1.10-r11.tbz2 wv2-0.2.2.tbz2 wxGTK-2.4.2-r3.tbz2 xalan-2.6.0-r1.tbz2 xerces-2.6.2-r2.tbz2 xforms-1.0.90.tbz2 xjavac-20041208.tbz2 xlc-1.0.6.tbz2 xml-commons-1.0_beta2.tbz2 xml-commons-resolver-1.1.tbz2 zmysqlda-2.0.8-r1.tbz2 zope-2.7.4.tbz2 zprod-manager-0.3.tbz2 nss-mysql-0.43-r1.tbz2 qmail-autoresponder-0.96.1-r1.tbz2 bglibs-1.019.tbz2 ezmlm-idx-0.40-r2.tbz2 mailutils-0.6.tbz2 ezmlm-idx-mysql-0.40-r2.tbz2 queue-fix-1.4-r2.tbz2 qmhandle-1.2.0.tbz2 ezmlm-0.53-r1.tbz2 vpopmail-5.4.6-r1.tbz2 qmail-1.03-r15.tbz2 cmd5checkpw-0.22-r3.tbz2 gnuradius-1.3.tbz2 postfix-2.1.5-r2.tbz2 qmail-mysql-1.03.tbz2 checkpassword-0.90-r1.tbz2 dot-forward-0.71-r1.tbz2 daemontools-0.76-r4.tbz2 ucspi-tcp-0.88-r10.tbz2 exim-4.50-r1.tbz2 gld-1.4.tbz2
Created attachment 54268 [details] mysql-4.1.10a-overlay.tar.gz - this ebuild don't emerge if a version of MySQL < 4.1 is already installed, the upgrade process is not automatizable. - removed mysql.eclass it's not the moment to add one. - changed pkg_config() the function called by "#ebuild mysql-4.1.10a.ebuild config" to use mysql_install_db provided from mysql again. It still require a password and fill time zones tables. All the other, configure, make etcetera is unchanged
test error failed creating table with rtree indexes USE="doc perl readline"
Created attachment 54596 [details] mysql-4.1.10a-overlay.tar.gz what's new: - Correct a failure compiling with FEATURES="maketest" and "geometry" USE flag disabled. thanks to svidyuk@gmail.com comment #14 - This ebuild block itself only if: a) the "minimal" use flag is _not_ enabled b) a previous mysql-4.0 installation exist and the "minimal" use flag was _not_ enabled
the name of the ebuild should be: - mysql-4.1.10_p1.ebuild or - mysql-4.1.10-r1.ebuild (first preferred) not "mysql-4.1.10a.ebuild" as it is now.
Did you create the ebuild for 5.0.3-beta yet? I have one here, but I am not sure its 100% correct if you want it.
@ Jeff Smelser At the moment there is no MySQL 5.0 ebuild, only an overlay I use for nightly snapshots of 4.0, 4.1, 5.0 [1] . There is already a bug (59529) that request mysql-5.0 ebuilds but I think you can put your on this bug. [1] http://www.francesco-riosa.com/gentoo/mysql_overlay_nightly-latest.tar.gz) Funky ebuilds, with hacks that will exclude the from the tree forever ;)
Created attachment 54836 [details] Mysql 5.0.3. beta This is for 5.0.3 beta. (not nightly). The only thing I had to take out was the SSL patch. The patch probably needs to be redone. (if its even needed). Compiles and works fine here.
Hi, Just wanted to give some positive feedback. I upgraded to mysql-4.1.10a using the ebuild provided in this bug report last saturday, and am happy to say that it runs great so far. I encountered one problem: libwww didn't build against the new MySQL. I found a patch for it in bugzilla (libwww-5.4.0-mysql-4.1). Libwww compiled fine with this patch. (I reported this to the libwww folks already) Regards, Toon.
thats a known issue since gentoo isnt officially supporting mysql 4.1.* yet. When that happens, if it ever does, those patches with be apart of libwww..
Created attachment 55452 [details] mysql-4.1.11.ebuild To use this ebuild you need the overlay [mysql-4.1.10a-overlay.tar.gz] http://bugs.gentoo.org/attachment.cgi?id=54596 Changes: - mysql-test-mysqldump.patch not used anymore - configure with big-tables (support for >4GB tables on 32 bit arch)
*** Bug 88133 has been marked as a duplicate of this bug. ***
Hi, is someone still working on this? I'd be happy to see a recent mysql 4.1.x in portage as ~x86.
I would forget seeing that. The gentoo dev's have dropped the ball completely on this issue.. 5.0 is gonna be out in the next couple months, and they wont even put 4.1 in portage.. sorry to see that they simply think mysql is a waste of time.
tradergt: I take strenuous objection to what you have said here. > I would forget seeing that. The gentoo dev's have dropped the ball completely > on this issue.. 5.0 is gonna be out in the next couple months, and they wont > even put 4.1 in portage.. If you ventured further afield (gentoo-dev mailing list, my blog on planet.g.o, bug 78452 - comment #31, and the devaway page), you'd see that I have more pressing real-life concerns at the moment, and that I sanction what Francesco is doing, so that I can put his work into the tree when I am free again. > sorry to see that they simply think mysql is a waste of time. No, it isn't a waste of time. What is a waste of time is having to deal with users that don't consider this is a community distribution, and that we do whatever we can, when we can - if you expect a commercial level of support, be prepared to pay for it (I do have local clients that I provide support for). Instead of complaining that we aren't doing anything, test out the ebuilds posted in bugs, and respond to them with results - both success and failure - the more the developers see that a submission is successful, the more likely it will get positive attension (I see a huge number of new ebuild packages just sitting in bugzilla, because no dev has a direct interest in them, and there does not seem to be sufficent user demand for them).
>tradergt: I take strenuous objection to what you have said here. I am sure you do.. >> If you ventured further afield (gentoo-dev mailing list, my blog on planet.g.o, bug 78452 - comment #31, and the devaway page), you'd see that I have more pressing real-life concerns at the moment, and that I sanction what Francesco is doing, so that I can put his work into the tree when I am free again. << Right, and I have helped Francesco where i can.. He, much more than me, has done the community thing and have ebuilds that work. All you have to do, is put it in portage.. The work is already done. So what your talking about with all this work, I have no idea. >> No, it isn't a waste of time. What is a waste of time is having to deal with users that don't consider this is a community distribution, and that we do whatever we can, when we can - if you expect a commercial level of support, be prepared to pay for it (I do have local clients that I provide support for). Instead of complaining that we aren't doing anything, test out the ebuilds posted in bugs, and respond to them with results - both success and failure - the more the developers see that a submission is successful, the more likely it will get positive attension (I see a huge number of new ebuild packages just sitting in bugzilla, because no dev has a direct interest in them, and there does not seem to be sufficent user demand for them). >> Mysql has about 10 bugs open with new versions. I have a hard time keeping up with all of them, keeping track of the changes.. mysql isnt some little nerdy app that no one uses, its used all the time, people are asking for 4.1, ALL the time.. I know us users seems to bother you devs, and some of your point is valid. This work has been handed to you on a silver platter, and yet your still pissing and moaning about it.. I just dont get what more you want from us in helping. The ebuilds have been well maintained by fransesco.. I have used them, and helped where I can as well in getting keeping them. I submitted 5.0.3-beta to help out as well.. So soon, your gonna have "all this work" and have to deal with 5.0 people. Considering its a major release, you would think you would get most of the "work" out of the way on 4.1, the compile issues and such, now. But you will be creating a lot of REAL work when 5.0 comes out. Then you WILL have a lot of problems since you will be upgrading the portage tree for 2 major release changes.. And the need for 5.0 is gonna be huge considering all the poeple I see wanting SP, Views, the list goes on. I know you have "blessed" this little venture. I am not sure whats "holding up" this entire thing besides devs dont have time.. If there are issues, we would sure like to know so we can assist in it. We are not expecting you to just do this all yourself, we have obviously tried to help as much as we can. If you can help us help you, then all your "no time to do anything" isnt valid. We are trying to make this as easy as possible, your just not doing your job. If you dont have "time", then put fransecso as a dev, if he wants, and let him continue his work. But dont let me take up any more of your precious time. I just dont get it.
@jeff the problem is that there is only one dev looking at mysql (by the way robbat maintain a good number of packages other than mysql). As is I'm not ready to be a developer. For example I've never worked in a team or with cvs. Please respect what devs have done untill now, it's a lot of work, mostly well done. Please avoid to stress a person that is probably already much stressed has he said. Also this will not bring mysql in the tree faster so is a non sense. thanks
I didn't read through all your comments in this Bug, but it seems that you haven't come accross the following issue with the mysql-4.1.11.ebuild. (Or rather with the MySQL package itself, I'd guess.) I am on amd64 using default 2005.0 profile (so multilib is enabled), and emerge =mysql-4.1.11 exits with: | checking for TCP wrappers library -lwrap... yes | checking for atomic operations... atomic_add atomic_sub | checking if we should use pstack... no | checking for int8... no | checking "LinuxThreads"... "Not found" | configure: error: This is a linux system and Linuxthreads was not | found. On linux Linuxthreads should be used. Please install Linuxthreads | (or a new glibc) and try again. See the Installation chapter in the | Reference Manual for more information. | | !!! Please attach the config.log to your bug report: | !!! /usr/portage/tmp/portage/mysql-4.1.11/work/mysql/config.log Enabling gentoo-nptl-4.0.18.diff unconditionally (so it gets applied on my system) seems to fix this. (At least configure gets through, will be doing a full build right now.) The requested config.log will be attached in a minute, in case it might still help you. You might also be interested in http://bugs.mysql.com/bug.php?id=5871 where the same bug is fixed in a slightly different fashion. Regards, Milan PS: Great thanks for the guy who made the 4.1.11 ebuild available :)
Created attachment 55703 [details] config.log of configure failing to detect Linuxthreads (probably because of multilib) config.log of configure failing to detect Linuxthreads (probably because of multilib on amd64)
Or you could just Add "Linuxthreads" to /usr/include/pthread.h... In the comments.. The test current is: grep Linuxthreads /usr/include/pthread.h Its pretty bogus really.. Joerg has not had time to fix it.. Soon though.
Created attachment 55707 [details] mysql-4.1.11.ebuild NO have_NPTL thanks, Just to be sure ... static patch again anyway dev-lang/mono use it, and is ~amd64 masked you may want to to fill a bug about that. The function that fail is "have_NPTL" and belong to "eclass/eutils.eclass"
RECENT VERSION OF GENTOO WILL NOT BE ABLE TO BUILD MYSQL WITH USE="doc" . if emerging fails with: >>>>>>>>>>>>>>>>>>> echo -n "@set defaultport " >> include.texi grep "MYSQL_TCP_PORT_DEFAULT=" ../configure.in | \ sed -e 's;MYSQL_TCP_PORT_DEFAULT=;;' >> include.texi cd . && \ /bin/sh /var/tmp/portage/mysql-4.1.11/work/mysql/missing --run makeinfo -I . --no-headers --no-split --output manual.txt manual.texi manual.texi:71173: warning: @image file `Images/cluster-components-1.txt' (for text) unreadable: No such file or directory. manual.texi:71353: warning: @image file `Images/multi-comp-1.txt' (for text) unreadable: No such file or directory. manual.texi:88758: warning: undefined flag: myodbc3_version. manual.texi:92639: @include `errmsg-table.texi': No such file or directory. manual.texi:92659: @include `cl-errmsg-table.texi': No such file or directory. makeinfo: Removing output file `manual.txt' due to errors; use --force to preserve. make[2]: *** [manual.txt] Error 1 make[2]: Leaving directory `/var/tmp/portage/mysql-4.1.11/work/mysql/Docs' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/var/tmp/portage/mysql-4.1.11/work/mysql' make: *** [all] Error 2 <<<<<<<<<<<<<<<<<<<<< please try to emerge WITHOUT doc useflag. first time reported by James M
Created attachment 55920 [details] mysql-4.1.11-overlay.tar.gz This overlay fix the documentation building problem, well it's more fair say that -hide- it. One of the manual documentation steps is to build "manual.txt", this is created parsing the contents of "manual.texi". manual.texi has two includes: -@include errmsg-table.texi -@include cl-errmsg-table.texi These ones are no satisfied any more. What changed ? only an "emerge -uDv world" . Thanks to the report from James it was an expected failure so there is a log of "emerge -uDv -p world" . Here it is: [ebuild U ] dev-db/hk_classes-0.7.3 [0.7.2-r1] -doc +mysql +odbc -postgres -sqlite -sqlite3 0 kB [ebuild U ] dev-ruby/rake-0.5.0 [0.4.15-r1] 0 kB [ebuild U ] dev-ruby/rubygems-0.8.10 [0.8.6] 0 kB [ebuild U ] dev-ruby/activesupport-1.0.3 [1.0.1] 0 kB [ebuild U ] dev-ruby/activerecord-1.9.1 [1.8.0] 0 kB [ebuild U ] dev-ruby/actionpack-1.7.0 [1.5.1] 0 kB [ebuild U ] dev-ruby/actionmailer-0.8.1 [0.7.1] 0 kB [ebuild U ] dev-ruby/actionwebservice-0.6.2 [0.6.0] 0 kB [ebuild U ] dev-ruby/rails-0.11.1-r1 [0.10.1] -fastcgi +mysql -postgres -sqlite 0 kB [ebuild U ] app-misc/colordiff-1.0.5 [1.0.4] 0 kB [ebuild U ] app-editors/nano-1.3.6 [1.3.5] -build -debug -justify +ncurses +nls -nomac +slang -spell 0 kB [ebuild U ] net-dns/bind-9.2.5 [9.2.2-r4] +berkdb -bind-mysql -caps -dlz -doc -idn -ipv6 +ldap* +mysql +odbc -postgres (-selinux) +ssl 0 kB [ebuild U ] app-vim/gentoo-syntax-20050325 [20050318] -ignore-glep31 0 kB [ebuild U ] app-portage/eix-0.2.2 [0.2.2_beta] -bash-completion -debug 0 kB [ebuild U ] www-client/links-2.1_pre17 [2.1_pre15] -X -directfb -fbcon +gpm -javascript +jpeg +png +ssl -svga +tiff -unicode 0 kB [ebuild U ] net-irc/eggdrop-1.6.17-r2 [1.6.17-r1] -debug +mysql -postgres +ssl -static 0 kB [ebuild U ] dev-db/libdbi-drivers-0.7.1-r1 [0.7.1] +mysql -oci8 -postgres -sqlite 0 kB [ebuild U ] sys-apps/iproute2-2.6.11.20050310-r1 [2.6.11.20050310] -atm +berkdb -minimal 0 kB [ebuild U ] sys-devel/binutils-2.15.92.0.2-r8 [2.15.92.0.2-r7] -debug -multislot -multitarget +nls -test 0 kB [ebuild U ] sys-fs/e2fsprogs-1.37 [1.36-r2] -debug -diet +nls -static (-uclibc) 0 kB [ebuild U ] app-editors/vim-core-6.3.068 [6.3-r4] -acl -bash-completion -debug -livecd +ncurses +nls (-selinux) 0 kB [ebuild U ] app-editors/vim-6.3.068 [6.3-r4] -acl -bash-completion -cscope -debug +gpm -minimal +ncurses +nls -perl -python +ruby (-selinux) -vim-with-x 0 kB [ebuild U ] net-misc/telnet-bsd-1.0-r1 [1.0] +nls 0 kB [ebuild U ] sys-apps/file-4.13 [4.12] -build -debug -python 0 kB [ebuild U ] app-arch/bzip2-1.0.3 [1.0.2-r5] -build -debug -static 0 kB [ebuild U ] net-fs/samba-3.0.13 [3.0.12] -acl -cups -debug -doc -kerberos +ldap -libclamav +mysql -oav -pam -postgres -python -quotas +readline (-selinux) -winbind +xml +xml2 0 kB [ebuild U ] mail-filter/dspam-3.4.2 [3.4.0-r1] -cyrus -debug -exim -large-domain -maildrop +mysql -neural -oci8 -postgres -procmail -sqlite -sqlite3 -virtual-users 0 kB [ebuild U ] dev-util/subversion-1.1.4 [1.1.3-r1] +apache2 -bash-completion +berkdb -debug -emacs +java +nls -perl -python +ssl 0 kB [ebuild U ] net-dns/bind-tools-9.2.5 [9.2.3-r1] -debug -ipv6 0 kB [ebuild U ] sys-boot/grub-0.96-r1 [0.96] -debug -netboot -static 0 kB [ebuild U ] net-misc/rsync-2.6.4 [2.6.3-r1] -acl -build -debug -ipv6 -static 0 kB [ebuild U ] sys-apps/coreutils-5.2.1-r6 [5.2.1-r5] -acl -build -debug +nls (-selinux) -static (-uclibc) 0 kB [ebuild U ] sys-fs/udev-056 [054] (-selinux) -static 0 kB [ebuild U ] app-text/rcs-5.7-r3 [5.7-r2] 0 kB [ebuild U ] net-analyzer/pmacct-0.8.3 [0.8.2] -ipv6 -mmap +mysql -postgres 0 kB I can't see nothing related if u are smarter please tell me (no not that you are smarter, that you know what happened). enjoy
Both the 4.1.x and 5.0.x snapshots fail to compile for the same reason ( set_bit/clear_bit function name clash ) with the latest kernel headers. Details of the bug are at http://bugs.mysql.com/bug.php?id=7971 I can't quite tell from the above bug whether this is fixed yet in anything other than 4.0.x.
Created attachment 56152 [details, diff] mysql-set_bit-4.1.11.patch Speaking of ebuilds of nightly snapshots. This patch should be good for both 4.1 and 5.0 version. There are only two files that contain set_bit & clear_bit : - libmysqld/examples/mysqltest.c - sql/sql_bitmap.h The patch modify only the first because the second define a c++ class with that function inside. The same patch should be applied to -stable- mysql-4.1.11 linux-headers-2.6.11 is keyworded KEYWORDS="-* m68k" (all the others e. are < 2.6.9) . ==> the only arch affected should be ~m68k To effectively the patch on nightly snapshot ebuilds add the lines: >>>>>>>>>> # http://bugs.mysql.com/bug.php?id=7971 epatch "$(find_versioned_file "mysql-set_bit")" <<<<<<<<<< under the line epatch "$(find_versioned_file "my-print-defaults")" before of tomorrow my site will host the patched nightly and maybe the stable ebuilds too.
Created attachment 56166 [details] mysql-4.1.11.ebuild #c33 -> Docs fixed upstream (both 4.0 & 4.1) , it was NOT a gentoo problem. #c36 -> MySQL b.7971 reopened, will be fixed upstream soon in the meantime forgive me and mysql-set_bit-4.1.11.patch . a) it was already fixed in mysql-4.0.24 b) the patch previously attached isn't working. shame on me (but I'm stop smoking theese days ... I'm very nervous)
AMD64 users you may be interested at MySQL bug http://bugs.mysql.com/bug.php?id=9497 "Check for LinuxThreads does not work on Gentoo AMD64 2005.0" reported by Sebastian Bergmann. I want to thank Andreas Wunder that rediscover the bug, and show me that solution.
I am compiling this now after fetching the overlay attachment and most recently attached mysql-4.1.11.ebuild, so far without error. Is this being planned to be added to the portage tree anytime soon? There are many security and bug related improvements in 4.1.11 that make me (and I'm sure others) very eager to deploy it.
Created attachment 56591 [details] mysql-5.0.4_beta-overlay.tar.gz This one compile fine but don't pass the tests ( FEATURES="maketest" emerge "=mysql-5.0.4_beta" ) . At least on my box. I've isolated the problem (long time ago) but *don't* expect patches for this soon. remember that: - Data from 5.0 databases DON'T like to return again in 4.1 ones. - This package can crash your cluster if you only download it Still interested ? Ok, enjoy
The 5.0.4_beta overlay has the wrong URL for the source: SRC_URI="http://downloads.mysql.com/snapshots/${PN}-${SVER}/${NEWP}.tar.gz" should be: SRC_URI="mirror://mysql/Downloads/MySQL-${SVER}/${NEWP}${PLV}.tar.gz" which is the same as in your 4.1 ebuilds (i.e. the standard location). Other than that, I've done no testing yet.
You can avoid the ${PLV} too : SRC_URI="mirror://mysql/Downloads/MySQL-${SVER}/${NEWP}.tar.gz" <jOkeOn> You may thing that I've been aproximative in the last days, never mind that !!! Add a little error in every relase is a subtly trick to make all you learn how to manage an ebuild. <jOkeOfF> CALL FOR TESTERS: people with _non_ x86 ARCH please test the removal of the following line from the ebuilds: --with-lib-ccflags="-fPIC" \ pay attention to not break the chain of "\" , the econf must remain a unique command.
It's all well. But I think mysql ebuild must splitted into mysql-client and mysql-server ebuilds. It's will be better.
#43 @Alexander see Bugzilla Bug 88490 "some packages require mysql, when libmysqlclient would suffice - requesting a split" In my humble opinion the use flag "minimal" is a better option.
Replying to #42: I am on amd64 and successfully compiled mysql-4.1.11.ebuild as of 2005-04-13 without --with-lib-ccflags="-fPIC", using x86_64-pc-linux-gnu-3.4.3-hardened GCC and berkdb, readline, ssl, tcpd, utf8 USE-flags for MySQL.
mysql-4.1.11-overlay.tar.gz when running... ebuild <file> config it ask for your mysql root password, but it is displayed in full text. here is a suggestion to hide it. echo -n "Enter your mysql root password now: " stty -echo read PASS stty echo echo ""
thanks to "Milan Holz
thanks to "Milan Holzäpfel" thanks to "Mathieu Jobin" too . I prefere to analize that question later. The thing involve few check that I can't do here.
*** Bug 89953 has been marked as a duplicate of this bug. ***
Just tested 4.1.11.ebuild (Ebuild from comment #37 in this post) And i get this: >>> Unpacking mysql-4.1.11.tar.gz to /var/tmp/portage/mysql-4.1.11/work * Cannot find $EPATCH_SOURCE! Value for $EPATCH_SOURCE is: * * /usr/portage/dev-db/mysql/files/my-print-defaults-4.0.diff * ( my-print-defaults-4.0.diff ) Not sure what the problem is here. Tested on ~AMD64
@Gabriel Jackson #49 the steps needed to install that ebuild are: #wget http://bugs.gentoo.org/attachment.cgi?id=55920&action=view \ -O mysql-4.1.11-overlay.tar.gz #tar -zxvf mysql-4.1.11-overlay.tar.gz #cd dev-db/mysql #rm mysql-4.1.11.ebuild #wget http://bugs.gentoo.org/attachment.cgi?id=56166&action=view \ -O mysql-4.1.11.ebuild #ebuild mysql-4.1.11.ebuild digest #PORTDIR_OVERLAY="../../" FEATURES="maketest" emerge -av =mysql-4.1.11 FEATURES="maketest" is optional and can require one additional hour of emerge time. anyway it test deeply the newly installed mysql.
put apices around both wget urls, like this: #wget 'http://bugs.gentoo.org/attachment.cgi?id=55920&action=view' \ -O mysql-4.1.11-overlay.tar.gz otherwise you 'll download http://bugs.gentoo.org/attachment.cgi?id=55920 in background :(
Hi, thanks a lot Francesco Riosa, mysql-4.1.11 compiled without problems on ~AMD64 with -berkdb -cluster -debug -doc -extraengine -geometry -minimal -perl +readline (-selinux) +ssl -static -tcpd -utf8 Greetings, Gabe
i will test the current overlay and offer some of my time if testers are needed to bring this in portage.
Using the latest ebuild and overlay, I still can't get mysql 4.1.11 to build with the latest linux-headers in the ~x86 branch. (The 2.6.11 headers were placed in many ~arch branches 10 days ago.) The following lines from the ebuild must be uncommented: #echo ${S}/client/mysqltest.c ${S}/extra/replace.c | xargs -n1 \ #sed -i \ # -e "s/\<set_bit\>/my__set_bit/g" \ # -e "s/\<clear_bit\>/my__clear_bit/g" \ # || die "Failed to fix bitops" The comment above those lines indicate that these changes were made upstream (which they were) but they are not included in the 4.1.11 release, which was released April 1. The changes were committed April 14th (See http://lists.mysql.com/internals/24014 ), so they should be in the next 4.1 release.
I can confirm this. Besides tweaking the ebuild, mysql 4.0.11 is running on my machine very well. If requested, I can test it on amd64 too (at least I can run the testsuite) and as I have an Apple computer, I could try to setup a Gentoo Linux PPC for testing purposes. (I would probably netboot it as it is a notebook and harddisk space is very valuable there)
Created attachment 57207 [details] mysql_overlay-latest.tar.gz Hopefully this: - *can* be compiled with "doc" use flag - rename "[set|clear]_bit" functions - remove "-fPIC" from the library compile (MySQL build process already add it if needed) - should not need digest regeneration It has been on my site for few days without changes, nobody cryed about it. @ b.g.o maintainers my apologies for fullfill their hd space
Created attachment 57445 [details, diff] Fix SRC_URI, add USE python This patch is against the 5.0.4_beta overlay. * Fix the SRC_URI to be the same as the stable versions (no longer in snapshots; source is on at least some of the mirrors) * Add support for USE=python, adds a PDEPEND for mysql-python Note: I am author of mysql-python. I have not yet tested against 5.0, but I have tested thoroughly against 4.1, and the MySQL folks tell me there are no C API changes between 4.1 and 5.0, so I do not expect issues.
Successfully built 5.0.4_beta on x86 (athlon-xp) with USE="-berkdb extraengine cluster geometry utf8". Additionally, my regression tests for mysql-python-1.2.0 work against the running mysql-5.0.4_beta server (using same client libraries).
Regarding mysql_overlay-latest.tar.gz: A statement is made that the digest does NOT have to be rebuilt. This is not true. Emerge complains that the manifest lacks entries for the files digest-mysql-4.1.10a, mysql-4.1.10a.ebuild and mysql-test-mysqldump.patch The first and the second file are obviously mistakes, because this is a mysql-4.1.11 ebuild. But I'm not sure what to do with the third file. (I don't understand the purpose of that patch) Regards, Toon.
@toon sorry for the late answer, was away this week. I've unpacked the overlay and it seem correct, are you using mysql_overlay-latest.tar.gz 2005-04-25 11:30 PST ?
Created attachment 58501 [details] mysql_overlay-latest.tar.gz - [SECURITY] fix for bug 91796 dev-db/mysql mysql_install_db insecure ... - removed all "version_is_at_least" from versionator.eclass - cleared inherit - cleared DEPEND has been a wile from the procps move - IUSE is _not_ conditional anymore - renamed patches that belong to 4.0 series to be the same again - enabled "innodb" in my.cnf - updated /etc/init.d/mysql to be the same as 4.0 series - more use of "useq" and "use_with" - added python to PDEPEND (c#57 Andy Dustman)
Created attachment 58506 [details] mysql_overlay-4.1.11.tar.gz two other changes, this one are important for peopele who care about # ebuild mysql-4.1.11.ebuild config - [SECURITY] bug 91796 remembered me that my pkg_config had a TOCTOU too - a bug similar to the one from # 90471 apply to this function, that prevent the script from populate time_zone* tables
*** Bug 78452 has been marked as a duplicate of this bug. ***
4.1.12 is in the tree now. please test and open new bugs for problems!
4.1.12 builds and all tests pass for me (x86 and USE="+berkdb -cluster -debug -doc -extraengine -geometry -minimal +perl +readline (-selinux) +ssl -static +tcpd +utf8")
Just a note: http://www.francesco-riosa.com/gentoo/ is up again, with an updated overlay. the latest 5.0 beta is missing but the 5.0 nightly version is there. enjoy