summaryrefslogtreecommitdiff
path: root/databases/mysql-server/Makefile
AgeCommit message (Collapse)AuthorFilesLines
2006-01-07Remove mysql-server and mysql-client (versions 4.0.26), becauseghen1-56/+0
1) they will not be maintained anymore 2) their package directory names where confusing (mysql4-* have a more recent version) These package directories may be used for meta-pkgs in the future (pulling in the latest mysql?-* packages).
2005-12-29Remove USE_PKGINSTALL from pkgsrc now that mk/install/pkginstall.mkjlam1-2/+1
automatically detects whether we want the pkginstall machinery to be used by the package Makefile.
2005-12-05Ran "pkglint --autofix", which corrected some of the quoting issues inrillig1-2/+2
CONFIGURE_ARGS.
2005-12-05Fixed pkglint warnings. The warnings are mostly quoting issues, forrillig1-5/+5
example MAKE_ENV+=FOO=${BAR} is changed to MAKE_ENV+=FOO=${BAR:Q}. Some other changes are outlined in http://mail-index.netbsd.org/tech-pkg/2005/12/02/0034.html
2005-10-03Apply patch from David A. Holland in PR pkg/31435 to honor rc.confxtraeme1-1/+2
values for mysql_user, mysql_group and mysql_datadir options. Bump PKGREVISION.
2005-08-23The real user name in PKG_USERS does not need to be escaped with doublerillig1-2/+2
backslashes anymore. A single backslash is enough. Changed the definition in all affected packages. For those that are not caught, an additional check is placed into bsd.pkginstall.mk.
2005-04-11Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.tv1-2/+1
2005-01-20Update mysql-{client,server} to 4.0.23a (bugfix release).xtraeme1-2/+1
See http://dev.mysql.com/doc/mysql/en/News-4.0.23.html for the full list of changes. This update applies the fix for the mysqlaccess script symlink vulnerability, bump BUILDLINK_RECOMMENDED.
2005-01-01Bump PKGREVISION because old binary packages may contain a wrong pathminskim1-2/+2
to the perl executable.
2004-12-28The default location of the pkgsrc-installed rc.d scripts is nowreed1-1/+2
under share/examples/rc.d. The variable name already was named RCD_SCRIPTS_EXAMPLEDIR. This is from ideas from Greg Woods and others. Also bumped PKGREVISION for all packages using RCD_SCRIPTS mechanism (as requested by wiz).
2004-11-09Install the script mysql_secure_installation, missed in previous.xtraeme1-1/+3
2004-11-09Update mysql-{client,server} to 4.0.22.xtraeme1-9/+1
Functionality added or changed: * The --with-openssl option for configure now accepts a path prefix as an argument. --with-openssl-includes and --with-openssl-libs are still supported, but are needed only to override the default values. (Bug #5494) * Added new --without-man option to configure to suppress building/installing the manual pages. (Bug #5379) * InnoDB: New mysqld option --innodb-table-locks and session variable innodb_table_locks (on by default). In applications using AUTOCOMMIT=1, InnoDB's internal table locks can cause deadlocks. You can set innodb_table_locks=0 in `my.cnf' to remove that problem. See section 16.17 Restrictions on InnoDB Tables. (Bug #3299, Bug #5998) * InnoDB: Added the startup option and settable global variable innodb_max_purge_lag for delaying INSERT, UPDATE and DELETE operations when the purge operations are lagging. The default value of this parameter is zero, meaning that there will not be any delays. See section 16.13 Implementation of Multi-Versioning. * InnoDB: Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent table because it is referenced by a FOREIGN KEY constraint. And a lot of bugfixes: http://dev.mysql.com/doc/mysql/en/News-4.0.22.html
2004-10-29Include makefile fragments from "../../databases/mysql-client" andtron1-3/+3
not ""../../databases/mysql4-client" because the later is a newer version.
2004-10-28Update mysql-{client,server} to 4.0.21 (previously mysql4-*).xtraeme1-34/+32
2004-10-03Libtool fix for PR pkg/26633, and other issues. Update libtool to 1.5.10tv1-1/+2
in the process. (More information on tech-pkg.) Bump PKGREVISION and BUILDLINK_DEPENDS of all packages using libtool and installing .la files. Bump PKGREVISION (only) of all packages depending directly on the above via a buildlink3 include.
2004-05-14disable TCP wrapper support on Linux and Solaris to work aroundgrant1-3/+9
mysql bug #599, http://bugs.mysql.com/bug.php?id=599.
2004-05-14distinguish between mysql 3 and 4 in COMMENT.grant1-2/+2
2004-04-03USE_BUILTIN.zlib wasn't being set, resulting in missing symbolsschmonz1-5/+5
for "compress" and "uncompress". Convert to bl3 to fix build.
2004-01-22replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.grant1-2/+2
2003-10-05Updated mysql-server to 3.23.58martti1-21/+11
A lot of bug and security fixes since 3.23.51...
2003-09-28Update mysql-client and mysql-server to 3.23.51nb1 - pkg revision keptjdolecek1-2/+2
set, the packages contain extra security fixes, which are not part of 3.23.51 distribution NOTE: this is the last 3.23.x version with bundled mit-pthreads package; any further upgrade would need some additional efford to keep the package usable on NetBSD 1.6.x and older Highlights of changes: * Add missing <row> tags for mysqldump XML output. * SHOW VARIABLES LIKE 'xxx' is now case-insensitive * InnoDB now allows foreign key constraints to be added through the ALTER TABLE syntax. * InnoDB tables can now be set to automatically grow in size (autoextend). * Changed name of server variables Com_show_master_stat to Com_show_master_status and Com_show_slave_stat to Com_show_slave_status. * Changed handling of gethostbyname() to make the client library thread-safe even if gethostbyname_r doesn't exist. * If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED columns, we will just drop the sign. * many bugfixes Full list of changes: 3.23.50: * Fixed buffer overflow problem if someone specified a too long datadir parameter to mysqld * Add missing <row> tags for mysqldump XML output. * Fixed problem with crash-me and gcc 3.0.4. * Fixed that @@unknown_variable doesn't hang server. * Added @@VERSION as a synonym for VERSION(). * SHOW VARIABLES LIKE 'xxx' is now case-insensitive. * Fixed timeout for GET_LOCK() on HP-UX with DCE threads. * Fixed memory allocation bug in the glibc library used to build Linux binaries, which caused mysqld to die in 'free()'. * Fixed SIGINT and SIGQUIT problems in mysql. * Fixed bug in character table converts when used with big ( > 64K) strings. * InnoDB now retains foreign key constraints through ALTER TABLE and CREATE/DROP INDEX. * InnoDB now allows foreign key constraints to be added through the ALTER TABLE syntax. * InnoDB tables can now be set to automatically grow in size (autoextend). * Our Linux RPMS and binaries are now compiled with gcc 3.0.4, which should make them a bit faster. * Fixed some buffer overflow problems when reading startup parameters. * Because of problems on shutdown we have now disabled named pipes on Windows by default. One can enable named pipes by starting mysqld with --enable-named-pipe. * Fixed bug when using WHERE key_column = 'J' or key_column='j'. * Fixed core-dump bug when using --log-bin with LOAD DATA INFILE without an active database. * Fixed bug in RENAME TABLE when used with lower_case_table_names=1 (default on Windows). * Fixed unlikely core-dump bug when using DROP TABLE on a table that was in use by a thread that also used queries on only temporary tables. * Fixed problem with SHOW CREATE TABLE and PRIMARY KEY when using 32 indexes. * Fixed that one can use SET PASSWORD for the anonymous user. * Fixed core dump bug when reading client groups from option files using mysql_options(). * Memory leak (16 bytes per every corrupted table) closed. * Fixed binary builds to use --enable-local-infile. * Update source to work with new version of bison. * Updated shell scripts to now agree with new POSIX standard. * Fixed bug where DATE_FORMAT() returned empty string when used with GROUP BY. 3.23.51: * Fix bug with closing tags missing slash for mysqldump XML output. * Remove end space from ENUM values. (This fixed a problem with SHOW CREATE TABLE.) * Fixed bug in CONCAT_WS() that cut the result. * Changed name of server variables Com_show_master_stat to Com_show_master_status and Com_show_slave_stat to Com_show_slave_status. * Changed handling of gethostbyname() to make the client library thread-safe even if gethostbyname_r doesn't exist. * Fixed core-dump problem when giving a wrong password string to GRANT. * Fixed bug in DROP DATABASE with symlinked directory. * Fixed optimisation problem with DATETIME and value outside DATETIME range. * Removed Sleepycat's BDB doc files from the source tree, as they're not needed (MySQL covers BDB in its own documentation). * Fixed MIT-pthreads to compile with glibc 2.2 (needed for make dist). * Fixed the FLOAT(X+1,X) is not converted to FLOAT(X+2,X). (This also affected DECIMAL, DOUBLE and REAL types) * Fixed the result from IF() is case in-sensitive if the second and third arguments are case sensitive. * Fixed core dump problem on OSF/1 in gethostbyname_r. * Fixed that underflowed decimal fields are not zero filled. * If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED columns, we will just drop the sign. * Fixed optimisation bug with ISNULL(expression_which_cannot_be_null) and ISNULL(constant_expression). * Fixed host lookup bug in the glibc library that we used with the 3.23.50 Linux-x86 binaries.
2003-09-19Bumping once is enough, oops.wiz1-2/+2
2003-09-19Do the chown of MYSQL_DATADIR to MYSQL_USER:MYSQL_GROUP automatically inwiz1-2/+2
the install file instead of only mentioning it in MESSAGE. Closes PR 22197. tron says ok.
2003-09-19Do the chown of MYSQL_DATADIR to MYSQL_USER:MYSQL_GROUP automatically inwiz1-2/+4
the install file instead of only mentioning it in MESSAGE. Closes PR 22197. tron says ok. Bump PKGREVISION.
2003-09-18Add missing ../ in path to included file.wiz1-2/+2
2003-09-18Specify the category when including other files and when depending on otherjmmv1-2/+2
packages. From PR pkg/21864 by ccatrian at eml.cc.
2003-09-17Update to nb5: Add patch fromwiz1-2/+2
http://lists.netsys.com/pipermail/full-disclosure/2003-September/009819.html against a vulnerability.
2003-09-01DEINSTALL script was removed.seb1-2/+1
2003-08-30Add definitions for DEINSTALL_EXTRA_TMPL and INSTALL_EXTRA_TMPL ifjlam1-2/+5
USE_PKGINSTALL is "YES". bsd.pkg.install.mk will no longer automatically pick up a INSTALL/DEINSTALL script in the package directory and assume that you want it for the corresponding *_EXTRA_TMPL variable.
2003-08-30Use the potential of bsd.pkg.install.mk:seb1-10/+2
- Remove extraneous bits in the INSTALL script snippet and let the framework execute the script at post-install time. - Use OWN_DIRS_PERMS instead of MAKE_DIRS_PERMS for ${MYSQL_DATADIR} thus save a DEINSTALL script snippet and its handling.
2003-08-24Bump package revision of mysql-client and mysql-server withtaca1-2/+2
introducing MYSQL_CHARSET and MYSQL_EXTRA_CHARSET.
2003-06-13Fix typo in ONLY_FOR_PLATFORM: s/NetBSD-arm/NetBSD-*-arm/abs1-2/+2
2003-06-11Update for the fact that 'arm' ports have been called NetBSD-*-arm for a whileabs1-3/+4
now and not NetBSD-*-arm32. Changes include one or more of: - Change MACHINE_ARCH == arm32 to also match arm - Where ONLY_FOR_PLATFORM includes NetBSD-*-arm32, add NetBSD-*-arm - Where BROKEN or worked around for arm gcc bugs, set USE_GCC3 The last may shake out a few more broken packages the next bulk build.
2003-03-24remove unnecessary parens and indent some conditionals forgrant1-7/+5
readability purposes. whitespace police.
2003-01-29add explicit reminder about ${MYSQL_DATADIR} ownershiplukem1-1/+3
2003-01-28Instead of including bsd.pkg.install.mk directly in a package Makefile,jlam1-2/+3
have it be automatically included by bsd.pkg.mk if USE_PKGINSTALL is set to "YES". This enforces the requirement that bsd.pkg.install.mk be included at the end of a package Makefile. Idea suggested by Julio M. Merino Vidal <jmmv at menta.net>.
2003-01-21install bin/mysql.server for people who won't or can't use etc/rc.d/mysqld.lukem1-2/+3
fixes rest of [pkg/19936].
2003-01-21- add rc.d script; based on [pkg/19055], with rework by me.lukem1-3/+14
- add support for MYSQL_USER and MYSQL_GROUP (user & group to run database as) - change ownership of $MYSQL_DATADIR to ${MYSQL_USER}:${MYSQL_GROUP} 700 - fix safe_mysqld to send all output to the error log and to NOT output random messages to the tty it was started on. - display a MESSAGE reminding people to change the password of the mysql 'root' user. - bump PKGREVISION (to 3.23.49nb2)
2003-01-20use native pthreads on NetBSD, if availablejdolecek1-9/+19
the explicit exits(/usr/include/pthread.h) here is not ideal, but this pkg didn't use pthread.buildlink2.mk before
2003-01-03this needs gmake to build...lukem1-1/+2
2002-12-13Fix security problem in MySQL client library and server which weretron1-4/+4
recently discovered by e-matters.
2002-09-20buildlink1 -> buildlink2 and move the USE_BUILDLINK2 definition to thejlam1-6/+4
common Makefile.
2002-08-23databases/myslq-server appears to work fine on Linux as well, so addjschauma1-2/+2
Linux-*-* to the list of ONLY_FOR_PLATFORMs.
2002-06-16Depend on mysql-client>=3.23.49.wiz1-2/+2
2001-11-02Strongly buildlinkify. Note dependency on tcp_wrappers for platformsjlam1-2/+8
without -lwrap. Also prevent finding any existing Berkeley DB 3.x in /usr/local.
2001-11-01Oops, back out previous. This locally modified file wasn't supposedzuntum1-2/+2
to be checked in.
2001-11-01Move pkg/ files into package's toplevel directoryzuntum1-2/+2
2001-10-18SVR4 packages have a limit of 9 chars for a package name.veego1-1/+2
The automatic truncation in gensolpkg doesn't work for packages which have the same package name for the first 5-6 chars. e.g. amanda-server and amanda-client would be named amanda and amanda. Now, we add a SVR4_PKGNAME and use amacl for amanda-client and amase for amanda-server. All svr4 packages also have a vendor tag, so we have to reserve some chars for this tag, which is normaly 3 or 4 chars. Thats why we can only use 6 or 5 chars for SVR4_PKGNAME. I used 5 for all the packages, to give the vendor tag enough room. All p5-* packages and a few other packages have now a SVR4_PKGNAME.
2001-07-08Update mysql to 3.23.39.bad1-2/+2
Disable the mysql-test stuff entirely. Sync mysql-client's patch-af with mysql-server's. Changes in release 3.23.39 -------------------------- * If one dropped and added an `AUTO_INCREMENT' column, the `AUTO_INCREMENT' sequence wasn't reset. * `CREATE .. SELECT' now creates not unique indexes delayed. * Fixed problem where `LOCK TABLES table_name READ' followed by `FLUSH TABLES' put a exclusive lock on the table. * `REAL' @variables with was represented with 2 digits when converted to strings. * Fixed problem that client 'hung' when `LOAD TABLE FROM MASTER' failed. * Running `myisamchk --fast --force' will no longer repair tables that only had the open count wrong. * Added functions to handle symbolic links to make life easier in 4.0. * We are now using the `-lcma' thread library on HP-UX 10.20 to get *MySQL* more stable on HP-UX. * Fixed problem with `IF()' and number of decimals in the result. * Fixed date-part extraction functions to work with dates where day and/or month is 0. * Extended argument length in option files from 256 to 512 chars. * Fixed problem with shutdown when `INSERT DELAYED' was waiting for a `LOCK TABLE'. * Fixed coredump bug in InnoDB when tablespace was full. * Fixed problem with `MERGE' tables and big tables (> 4G) when using `ORDER BY'. Changes in release 3.23.38 -------------------------- * Fixed a bug when `SELECT' from `MERGE' table sometimes results in incorrectly ordered rows. * Fixed a bug in `REPLACE()' when using the ujis character set. * Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2. * Added option `--skip-stack-trace' to `mysqld'. * `CREATE TEMPORARY' now works with `InnoDB' tables. * `InnoDB' now promotes sub keys to whole keys. * Added option `CONCURRENT' to `LOAD DATA'. * Better error message when slave `max_allowed_packet' is too low to read a very long log event from the master. * Fixed bug when too many rows where removed when using `SELECT DISTINCT ... HAVING'. * `SHOW CREATE TABLE' now returns `TEMPORARY' for temporary tables. * Added `Rows_examined' to slow query log. * Fixed problems with function returning empty string when using together with a group functions and a `WHERE' that didn't match any rows. * New program `mysqlcheck'. * Added database name to output for administrative commands like `CHECK', `REPAIR', `OPTIMIZE'. * Lots of portability fixes for InnoDB. * Changed optimizer so that queries like `SELECT * FROM table_name,table_name2 ... ORDER BY key_part1 LIMIT #' will use index on `key_part1' instead of `filesort'. * Fixed bug when doing `LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ...' when `to_table' was empty. * Fixed bug with `LOCK TABLE' and BDB tables. Changes in release 3.23.37 -------------------------- * Fixed a bug when using `MATCH' in `HAVING' clause. * Fixed a bug when using `HEAP' tables with `LIKE'. * Added `--mysql-version' to `safe_mysqld' * Changed `INNOBASE' to `InnoDB' (because the `INNOBASE' name was already used). All `configure' options and `mysqld' start options are now using `innodb' instead of `innobase'. This means that you have to change any configuration files where you have used `innobase' options before upgrading to this version! * Fixed bug when using indexes on `CHAR(255) NULL' columns. * Slave thread will now be started even if `master-host' is not set, as long as `server-id' is set and valid `master.info' is present * Partial updates (terminated with kill) are now logged with a special error code to the binary log. Slave will refuse to execute them if the error code indicates the update was terminated abnormally, and will have to be recovered with `SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START' after a manual sanity check/correction of data integrity. * Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log - bug affected replication. * Fixed a bug in `REGEXP()' on 64-bit machines. * `UPDATE' and `DELETE' with `WHERE unique_key_part IS NULL' didn't update/delete all rows. * Disabled `INSERT DELAYED' for tables that support transactions. * Fixed bug when using date functions on `TEXT'/`BLOB' column with wrong date format. * UDFs now also work on Windows. (Patch by Ralph Mason) * Fixed bug in `ALTER TABLE' and `LOAD DATA INFILE' that disabled key-sorting. These commands should now be faster in most cases. * Fixed performance bug where reopened tables (tables that had been waiting for `FLUSH' or `REPAIR') would not use indexes for the next query. * Fixed problem with `ALTER TABLE' to Innobase tables on FreeBSD. * Added `mysqld' variables `myisam_max_sort_file_size' and `myisam_max_extra_sort_file_size'. * Initialize signals early to avoid problem with signals in Innobase. * Applied patch for the `tis620' character set to make comparisons case-independent and to fix a bug in `LIKE' for this character set. *NOTE*: All tables that uses the `tis620' character set must be fixed with `myisamchk -r' or `REPAIR TABLE' ! * Added `--skip-safemalloc' option to `mysqld'. Changes in release 3.23.36 -------------------------- * Fixed a bug that allowed you to use database names containing a `.' character. This fixes a serious security issue when `mysqld' is run as root. * Fixed bug when thread creation failed (could happen when doing a LOT of connections in a short time). * Fixed some problems with `FLUSH TABLES' and `TEMPORARY' tables. (Problem with freeing the key cache and error `Can't reopen table...'). * Fixed a problem in Innobase with other character sets than `latin1' and another problem when using many columns. * Fixed bug that caused a core dump when using a very complex query involving `DISTINCT' and summary functions. * Added `SET TRANSACTION ISOLATION LEVEL ...' * Added `SELECT ... FOR UPDATE'. * Fixed bug where the number of affected rows was not returned when `MySQL' was compiled without transaction support. * Fixed a bug in `UPDATE' where keys weren't always used to find the rows to be updated. * Fixed a bug in `CONCAT_WS()' where it returned wrong results. * Changed `CREATE ... INSERT' and `INSERT ... SELECT' to not allow concurrent inserts as this could make the binary log hard to repeat. (Concurrent inserts are enabled if you are not using the binary or update log). * Changed some macros to be able to use fast mutex with glibc 2.2.
2001-05-02* Rearrange MySQL build structure by providing a Makefile.common that isjlam1-45/+21
included by both mysql-server/Makefile and mysql-client/Makefile. * Remove some unnecessary patches from mysql-client. * Remove build dependency on autoconf as we don't really need to use it. * Improve detection of native readline library. * Provide INSTALL/DEINSTALL scripts to perform initial database setup and to remind the package administrator to remove unnecessary directories upon package removal. * Use complete path to chown in various installed scripts. Fixes pkg/12725. * Install server manpages with the server package. Fixes pkg/12724.