Ravenports generated: 28 Apr 2019 12:54
[ravenports.git] / bucket_68 / mysql57
1 # Buildsheet autogenerated by ravenadm tool -- Do not edit.
2
3 NAMEBASE=               mysql57
4 VERSION=                5.7.26
5 KEYWORDS=               databases
6 VARIANTS=               standard
7 SDESC[standard]=        Multithreaded SQL database (server)
8 HOMEPAGE=               https://www.mysql.com/
9 CONTACT=                nobody
10
11 DOWNLOAD_GROUPS=        main
12 SITES[main]=            MYSQL/MySQL-5.7
13 DISTFILE[1]=            mysql-boost-5.7.26.tar.gz:main
14 DF_INDEX=               1
15 SPKGS[standard]=        complete
16                         server
17                         client
18
19 OPTIONS_AVAILABLE=      ARCHIVE BLACKHOLE EXAMPLE FEDERATED INNOBASE
20                         PARTITION PERFSCHEMA PERFORMANCE ALTSSL
21 OPTIONS_STANDARD=       ARCHIVE BLACKHOLE EXAMPLE FEDERATED INNOBASE
22                         PARTITION PERFSCHEMA PERFORMANCE ALTSSL
23 OPTGROUP_UNLIMITED=     STORAGE
24 OPTDESCR[STORAGE]=      Storage engines statically compiled into server
25 OPTGROUP[STORAGE]=      ARCHIVE BLACKHOLE EXAMPLE FEDERATED INNOBASE
26                         PARTITION PERFSCHEMA
27 OPT_ON[sunos]=          ALTSSL
28 OPT_ON[all]=            PERFORMANCE
29
30 BUILD_DEPENDS=          rpcgen:single:standard
31                         libedit:single:standard
32 BUILDRUN_DEPENDS=       libevent:single:standard
33                         lz4:complete:standard
34 EXRUN[client]=          libedit:single:standard
35                         zlib:complete:standard
36
37 USERS=                  mysql
38 GROUPS=                 mysql
39 USERGROUP_SPKG=         server
40
41 USES=                   bison cmake perl:run shebangfix execinfo
42                         c++:server,client cclibs:server,client
43
44 DISTNAME=               mysql-5.7.26
45
46 LICENSE=                GPLv2:server
47 LICENSE_TERMS=          server:{{WRKDIR}}/TERMS
48 LICENSE_FILE=           GPLv2:{{WRKSRC}}/README
49 LICENSE_AWK=            TERMS:"^\/\*$$"
50 LICENSE_SOURCE=         TERMS:{{WRKSRC}}/include/mysql.h
51 LICENSE_SCHEME=         solo
52
53 CMAKE_BUILD_TYPE=       Release
54 FPC_EQUIVALENT=         databases/mysql57-server
55 SHEBANG_FILES=          scripts/*.pl
56
57 INSTALL_REQ_TOOLCHAIN=  yes
58 PLIST_SUB=              MY_DBDIR=/var/db/mysql
59                         MY_SECDIR=/var/db/mysql_secure
60                         MY_TMPDIR=/var/db/mysql_tmpdir
61 RC_SUBR=                mysql-server:server
62 SUB_FILES=              my.cnf.sample
63 SUB_LIST=               MY_DBDIR=/var/db/mysql
64                         MY_SECDIR=/var/db/mysql_secure
65                         MY_TMPDIR=/var/db/mysql_tmpdir
66
67 CFLAGS=                 -Wno-deprecated-declarations
68 CMAKE_ARGS=             -DINSTALL_PKGCONFIGDIR="{{LOCALBASE}}/lib/pkgconfig"
69                         -DINSTALL_DOCDIR="share/doc/mysql"
70                         -DINSTALL_DOCREADMEDIR="share/doc/mysql"
71                         -DINSTALL_INCLUDEDIR="include/mysql"
72                         -DINSTALL_INFODIR="share/info"
73                         -DINSTALL_LIBDIR="lib/mysql"
74                         -DINSTALL_MANDIR="share/man"
75                         -DINSTALL_MYSQLDATADIR="/var/db/mysql"
76                         -DINSTALL_MYSQLKEYRINGDIR="etc/mysql/keyring"
77                         -DINSTALL_MYSQLSHAREDIR="share/mysql"
78                         -DINSTALL_MYSQLTESTDIR="share/mysql/tests"
79                         -DINSTALL_PLUGINDIR="lib/mysql/plugin"
80                         -DINSTALL_SBINDIR="libexec"
81                         -DINSTALL_SCRIPTDIR="bin"
82                         -DINSTALL_SECURE_FILE_PRIVDIR="/var/db/mysql_secure"
83                         -DINSTALL_SHAREDIR="share"
84                         -DINSTALL_SUPPORTFILESDIR="share/mysql"
85                         -DMYSQL_KEYRINGDIR="etc/mysql/keyring"
86                         -DWITH_BOOST="{{WRKSRC}}/boost"
87                         -DWITH_EDITLINE=system
88                         -DWITH_LIBEVENT=system
89                         -DWITH_LZ4=system
90                         -DWITH_ZLIB=system
91                         -DWITH_SSL={{OPENSSLBASE}}
92                         -DWITH_EMBEDDED_SERVER="ON"
93                         -DINSTALL_MYSQLTESTDIR=0
94
95 [PERFSCHEMA].DESCRIPTION=               Provide "Performance Schema Storage" engine
96 [PERFSCHEMA].CMAKE_ARGS_ON=             -DWITH_PERFSCHEMA_STORAGE_ENGINE=1
97
98 [EXAMPLE].DESCRIPTION=                  Provide "Example Storage" engine
99 [EXAMPLE].CMAKE_ARGS_ON=                -DWITH_EXAMPLE_STORAGE_ENGINE=1
100
101 [PARTITION].DESCRIPTION=                Provide "Partitioning support Storage" engine
102 [PARTITION].CMAKE_ARGS_ON=              -DWITH_PARTITION_STORAGE_ENGINE=1
103
104 [ALTSSL].DESCRIPTION=                   Use OpenSSL 1.1 instead of default SSL variant
105 [ALTSSL].USES_OFF=                      ssl:build
106 [ALTSSL].USES_ON=                       ssl:openssl-devel,build
107
108 [BLACKHOLE].DESCRIPTION=                Provide "Blackhole Storage" engine
109 [BLACKHOLE].CMAKE_ARGS_ON=              -DWITH_BLACKHOLE_STORAGE_ENGINE=1
110
111 [PERFORMANCE].DESCRIPTION=              Enable "Performance Schema" (High RAM usage)
112 [PERFORMANCE].SUB_LIST_OFF=             PERFSCHEMRC="--skip-performance-schema"
113 [PERFORMANCE].SUB_LIST_ON=              PERFSCHEMRC=""
114
115 [ARCHIVE].DESCRIPTION=                  Provide "Archive Storage" engine
116 [ARCHIVE].CMAKE_ARGS_ON=                -DWITH_ARCHIVE_STORAGE_ENGINE=1
117
118 [FEDERATED].DESCRIPTION=                Provide "Federated Storage" engine
119 [FEDERATED].CMAKE_ARGS_ON=              -DWITH_FEDERATED_STORAGE_ENGINE=1
120 [FEDERATED].SUB_LIST_OFF=               FEDER=""
121 [FEDERATED].SUB_LIST_ON=                FEDER="--federated"
122
123 [INNOBASE].DESCRIPTION=                 Provide "InnoDB Storage" engine
124 [INNOBASE].CMAKE_ARGS_ON=               -DWITH_INNOBASE_STORAGE_ENGINE=1
125
126 post-patch:
127         ${REINPLACE_CMD} -e 's|/usr/bin/perl|${PREFIX}/bin/perl|' \
128                 -e 's|/usr/local/bin/perl|${PREFIX}/bin/perl|' \
129                 ${WRKSRC}/scripts/CMakeLists.txt
130         # don't build authentication ldap on any platform (yet)
131         ${REINPLACE_CMD} -e '/authentication_ldap/d' \
132                 ${WRKSRC}/libmysql/CMakeLists.txt
133
134 post-install:
135         ${MKDIR} ${STAGEDIR}${PREFIX}/etc/mysql/keyring \
136                 ${STAGEDIR}/var/db/mysql_secure \
137                 ${STAGEDIR}/var/db/mysql_tmpdir
138         ${INSTALL_DATA} ${WRKDIR}/my.cnf.sample \
139                 ${STAGEDIR}${ETCDIR}/my.cnf.sample
140         ${RM} ${STAGEDIR}${MANPREFIX}/man/man1/zlib_decompress.1 \
141                 ${STAGEDIR}${MANPREFIX}/man/man1/lz4_decompress.1
142         ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/mysql/lib*.so
143         ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/mysql/plugin/*.so
144         ${STRIP_CMD} ${STAGEDIR}${PREFIX}/libexec/mysqld
145         # Linux doesn't like -R flags
146         ${SED} -i'' -e 's| -R| -Wl,-rpath,|g' \
147                 ${STAGEDIR}${PREFIX}/bin/mysql_config
148         list=$$(cd ${STAGEDIR}${PREFIX}/bin && ${LS} * | ${AWK} \
149                 '{ if ($$1 != "mysql_config" && $$1 != "mysqld_mult" && \
150                 $$1 != "mysqld_safe" && $$1 != "mysqldumpslow" && \
151                 $$1 != "mysqld_multi") print}'); \
152         (cd ${STAGEDIR}${PREFIX}/bin && ${STRIP_CMD} $$list)
153
154 post-extract:
155         ${RM} -rv ${WRKSRC}/sql/sql_hints.yy.cc ${WRKSRC}/sql/sql_hints.yy.h
156
157 post-patch-freebsd:
158         ${RM} ${WRKSRC}/cmake/os/FreeBSD.cmake
159
160 [FILE:294:descriptions/desc.server]
161 MySQL is a very fast, multi-threaded, multi-user and robust SQL
162 (Structured Query Language) database server.
163
164 MySQL, the most popular Open Source SQL database management system, is
165 developed, distributed, and supported by Oracle Corporation.
166
167 This package contains the MySQL server components.
168
169
170 [FILE:150:descriptions/desc.client]
171 MySQL is a very fast, multi-threaded, multi-user and robust SQL
172 (Structured Query Language) database server.
173
174 This package contains the MySQL client.
175
176
177 [FILE:104:distinfo]
178 effca6d3aceebc286a9fb046257330d125cc2f4def87081c286bfc4df3d974d1     51098338 mysql-boost-5.7.26.tar.gz
179
180
181 [FILE:3543:manifests/plist.server]
182 %%ONLY-LINUX%%lib/mysql/plugin/auth_socket.so
183 bin/
184  innochecksum
185  lz4_decompress
186  my_print_defaults
187  myisam_ftdump
188  myisamchk
189  myisamlog
190  myisampack
191  mysql_install_db
192  mysql_plugin
193  mysql_secure_installation
194  mysql_tzinfo_to_sql
195  mysql_upgrade
196  mysqld_multi
197  mysqld_safe
198  mysqldumpslow
199  mysqltest
200  mysqlxtest
201  perror
202  replace
203  resolve_stack_dump
204  resolveip
205  zlib_decompress
206 lib/mysql/libmysqld.a
207 lib/mysql/plugin/
208  adt_null.so
209  auth.so
210  auth_test_plugin.so
211  connection_control.so
212  daemon_example.ini
213  group_replication.so
214  ha_example.so
215  keyring_file.so
216  keyring_udf.so
217  libdaemon_example.so
218  libtest_framework.so
219  libtest_services.so
220  libtest_services_threaded.so
221  libtest_session_detach.so
222  libtest_session_in_thd.so
223  libtest_session_info.so
224  libtest_sql_2_sessions.so
225  libtest_sql_all_col_types.so
226  libtest_sql_cmds_1.so
227  libtest_sql_commit.so
228  libtest_sql_complex.so
229  libtest_sql_errors.so
230  libtest_sql_lock.so
231  libtest_sql_processlist.so
232  libtest_sql_replication.so
233  libtest_sql_shutdown.so
234  libtest_sql_sqlmode.so
235  libtest_sql_stored_procedures_functions.so
236  libtest_sql_views_triggers.so
237  libtest_x_sessions_deinit.so
238  libtest_x_sessions_init.so
239  locking_service.so
240  mypluglib.so
241  mysql_no_login.so
242  mysqlx.so
243  qa_auth_client.so
244  qa_auth_interface.so
245  qa_auth_server.so
246  replication_observers_example_plugin.so
247  rewrite_example.so
248  rewriter.so
249  semisync_master.so
250  semisync_slave.so
251  test_security_context.so
252  test_udf_services.so
253  udf_example.so
254  validate_password.so
255  version_token.so
256 libexec/mysqld
257 share/man/man1/
258  innochecksum.1.gz
259  my_print_defaults.1.gz
260  myisam_ftdump.1.gz
261  myisamchk.1.gz
262  myisamlog.1.gz
263  myisampack.1.gz
264  mysql.server.1.gz
265  mysql_install_db.1.gz
266  mysql_plugin.1.gz
267  mysql_secure_installation.1.gz
268  mysql_ssl_rsa_setup.1.gz
269  mysql_tzinfo_to_sql.1.gz
270  mysql_upgrade.1.gz
271  mysqld_multi.1.gz
272  mysqld_safe.1.gz
273  mysqldumpslow.1.gz
274  mysqlman.1.gz
275  perror.1.gz
276  replace.1.gz
277  resolve_stack_dump.1.gz
278  resolveip.1.gz
279 share/man/man8/mysqld.8.gz
280 share/mysql/
281  dictionary.txt
282  errmsg-utf8.txt
283  fill_help_tables.sql
284  innodb_memcached_config.sql
285  install_rewriter.sql
286  magic
287  mysql-log-rotate
288  mysql.server
289  mysql_security_commands.sql
290  mysql_sys_schema.sql
291  mysql_system_tables.sql
292  mysql_system_tables_data.sql
293  mysql_test_data_timezone.sql
294  mysqld_multi.server
295  uninstall_rewriter.sql
296 share/mysql/bulgarian/errmsg.sys
297 share/mysql/charsets/
298  Index.xml
299  README
300  armscii8.xml
301  ascii.xml
302  cp1250.xml
303  cp1251.xml
304  cp1256.xml
305  cp1257.xml
306  cp850.xml
307  cp852.xml
308  cp866.xml
309  dec8.xml
310  geostd8.xml
311  greek.xml
312  hebrew.xml
313  hp8.xml
314  keybcs2.xml
315  koi8r.xml
316  koi8u.xml
317  latin1.xml
318  latin2.xml
319  latin5.xml
320  latin7.xml
321  macce.xml
322  macroman.xml
323  swe7.xml
324 share/mysql/czech/errmsg.sys
325 share/mysql/danish/errmsg.sys
326 share/mysql/dutch/errmsg.sys
327 share/mysql/english/errmsg.sys
328 share/mysql/estonian/errmsg.sys
329 share/mysql/french/errmsg.sys
330 share/mysql/german/errmsg.sys
331 share/mysql/greek/errmsg.sys
332 share/mysql/hungarian/errmsg.sys
333 share/mysql/italian/errmsg.sys
334 share/mysql/japanese/errmsg.sys
335 share/mysql/korean/errmsg.sys
336 share/mysql/norwegian/errmsg.sys
337 share/mysql/norwegian-ny/errmsg.sys
338 share/mysql/polish/errmsg.sys
339 share/mysql/portuguese/errmsg.sys
340 share/mysql/romanian/errmsg.sys
341 share/mysql/russian/errmsg.sys
342 share/mysql/serbian/errmsg.sys
343 share/mysql/slovak/errmsg.sys
344 share/mysql/spanish/errmsg.sys
345 share/mysql/swedish/errmsg.sys
346 share/mysql/ukrainian/errmsg.sys
347 @dir(mysql,mysql,0750) %%MY_SECDIR%%
348 @dir(mysql,mysql,0750) %%MY_TMPDIR%%
349 @dir(mysql,mysql,0750) etc/mysql/keyring
350 @sample(root,wheel,0644) etc/mysql/my.cnf.sample
351
352
353 [FILE:2466:manifests/plist.client]
354 bin/
355  mysql
356  mysql_client_test
357  mysql_config
358  mysql_config_editor
359  mysql_ssl_rsa_setup
360  mysqladmin
361  mysqlbinlog
362  mysqlcheck
363  mysqldump
364  mysqlimport
365  mysqlpump
366  mysqlshow
367  mysqlslap
368 include/mysql/
369  big_endian.h
370  binary_log_types.h
371  byte_order_generic.h
372  byte_order_generic_x86.h
373  decimal.h
374  errmsg.h
375  keycache.h
376  little_endian.h
377  m_ctype.h
378  m_string.h
379  my_alloc.h
380  my_byteorder.h
381  my_command.h
382  my_compiler.h
383  my_config.h
384  my_dbug.h
385  my_dir.h
386  my_getopt.h
387  my_global.h
388  my_list.h
389  my_sys.h
390  my_thread.h
391  my_thread_local.h
392  my_xml.h
393  mysql.h
394  mysql_com.h
395  mysql_com_server.h
396  mysql_embed.h
397  mysql_time.h
398  mysql_version.h
399  mysqld_ername.h
400  mysqld_error.h
401  plugin.h
402  plugin_audit.h
403  plugin_ftparser.h
404  plugin_group_replication.h
405  plugin_keyring.h
406  plugin_validate_password.h
407  sql_common.h
408  sql_state.h
409  sslopt-case.h
410  sslopt-longopts.h
411  sslopt-vars.h
412  thr_cond.h
413  thr_mutex.h
414  thr_rwlock.h
415  typelib.h
416 include/mysql/mysql/
417  client_authentication.h
418  client_plugin.h
419  client_plugin.h.pp
420  com_data.h
421  get_password.h
422  group_replication_priv.h
423  innodb_priv.h
424  mysql_lex_string.h
425  plugin.h
426  plugin_audit.h
427  plugin_audit.h.pp
428  plugin_auth.h
429  plugin_auth.h.pp
430  plugin_auth_common.h
431  plugin_ftparser.h
432  plugin_ftparser.h.pp
433  plugin_group_replication.h
434  plugin_keyring.h
435  plugin_keyring.h.pp
436  plugin_trace.h
437  plugin_validate_password.h
438  service_command.h
439  service_locking.h
440  service_my_plugin_log.h
441  service_my_snprintf.h
442  service_mysql_alloc.h
443  service_mysql_keyring.h
444  service_mysql_password_policy.h
445  service_mysql_string.h
446  service_parser.h
447  service_rpl_transaction_ctx.h
448  service_rpl_transaction_write_set.h
449  service_rules_table.h
450  service_security_context.h
451  service_srv_session.h
452  service_srv_session_info.h
453  service_ssl_wrapper.h
454  service_thd_alloc.h
455  service_thd_engine_lock.h
456  service_thd_wait.h
457  service_thread_scheduler.h
458  services.h
459  services.h.pp
460  thread_pool_priv.h
461  thread_type.h
462 include/mysql/mysql/psi/
463  mysql_file.h
464  mysql_idle.h
465  mysql_mdl.h
466  mysql_memory.h
467  mysql_ps.h
468  mysql_socket.h
469  mysql_sp.h
470  mysql_stage.h
471  mysql_statement.h
472  mysql_table.h
473  mysql_thread.h
474  mysql_transaction.h
475  psi.h
476  psi_base.h
477  psi_memory.h
478 lib/mysql/
479  libmysqlclient.a
480  libmysqlclient.so
481  libmysqlclient.so.20
482 lib/pkgconfig/mysqlclient.pc
483 share/aclocal/mysql.m4
484 share/man/man1/
485  comp_err.1.gz
486  mysql.1.gz
487  mysql_config.1.gz
488  mysql_config_editor.1.gz
489  mysqladmin.1.gz
490  mysqlbinlog.1.gz
491  mysqlcheck.1.gz
492  mysqldump.1.gz
493  mysqlimport.1.gz
494  mysqlpump.1.gz
495  mysqlshow.1.gz
496  mysqlslap.1.gz
497
498
499 [FILE:1384:patches/patch-CMakeLists.txt]
500 --- CMakeLists.txt.orig 2019-04-13 13:32:15 UTC
501 +++ CMakeLists.txt
502 @@ -591,6 +591,7 @@ IF(CMAKE_SYSTEM_NAME MATCHES "Linux")
503  ENDIF()
504  
505  # Check for pthread_getthreadid_np()
506 +set(CMAKE_REQUIRED_LIBRARIES pthread)
507  CHECK_C_SOURCE_COMPILES("
508  #include <pthread_np.h>
509  int main(int ac, char **av)
510 @@ -599,6 +600,7 @@ int main(int ac, char **av)
511    return (tid != 0 ? 0 : 1);
512  }"
513  HAVE_PTHREAD_GETTHREADID_NP)
514 +set(CMAKE_REQUIRED_LIBRARIES "")
515  
516  # Check for pthread_self() returning an integer type
517  CHECK_C_SOURCE_COMPILES("
518 @@ -685,7 +687,6 @@ IF(NOT WITHOUT_SERVER)
519    OPTION (WITH_EMBEDDED_SERVER "Compile MySQL with embedded server" OFF)
520    IF(WITH_EMBEDDED_SERVER) 
521     ADD_SUBDIRECTORY(libmysqld)
522 -   ADD_SUBDIRECTORY(libmysqld/examples)
523    ENDIF(WITH_EMBEDDED_SERVER)
524  ENDIF()
525  
526 @@ -746,7 +747,6 @@ ELSE()
527    SET(CPACK_GENERATOR "TGZ")
528  ENDIF() 
529  ADD_SUBDIRECTORY(packaging/WiX)
530 -ADD_SUBDIRECTORY(packaging/solaris)
531  
532  IF(UNIX)
533    INSTALL(FILES Docs/mysql.info DESTINATION ${INSTALL_INFODIR} OPTIONAL COMPONENT Info)
534 @@ -754,6 +754,7 @@ ENDIF()
535  #
536  # RPM installs documentation directly from the source tree
537  #
538 +IF(FALSE)
539  IF(NOT INSTALL_LAYOUT MATCHES "RPM")
540    INSTALL(FILES COPYING LICENSE.mysql 
541    DESTINATION ${INSTALL_DOCREADMEDIR} 
542 @@ -776,6 +777,7 @@ IF(NOT INSTALL_LAYOUT MATCHES "RPM")
543      PATTERN "sp-imp-spec.txt" EXCLUDE
544    )
545  ENDIF()
546 +ENDIF()
547  
548  INCLUDE(CPack)
549  
550
551
552 [FILE:584:patches/patch-cmake_plugin.cmake]
553 --- cmake/plugin.cmake.orig     2019-04-13 13:32:15 UTC
554 +++ cmake/plugin.cmake
555 @@ -271,9 +271,6 @@ MACRO(MYSQL_ADD_PLUGIN)
556        MYSQL_INSTALL_TARGETS(${target}
557          DESTINATION ${INSTALL_PLUGINDIR}
558          COMPONENT ${INSTALL_COMPONENT})
559 -      INSTALL_DEBUG_TARGET(${target}
560 -        DESTINATION ${INSTALL_PLUGINDIR}/debug
561 -        COMPONENT ${INSTALL_COMPONENT})
562        # Add installed files to list for RPMs
563        FILE(APPEND ${CMAKE_BINARY_DIR}/support-files/plugins.files
564                "%attr(755, root, root) %{_prefix}/${INSTALL_PLUGINDIR}/${ARG_MODULE_OUTPUT_NAME}.so\n"
565
566
567 [FILE:435:patches/patch-cmake_ssl.cmake]
568 --- cmake/ssl.cmake.orig        2019-04-13 13:32:15 UTC
569 +++ cmake/ssl.cmake
570 @@ -180,6 +180,12 @@ MACRO (MYSQL_CHECK_SSL)
571         OPENSSL_MAJOR_VERSION STREQUAL "1"
572        )
573        SET(OPENSSL_FOUND TRUE)
574 +    ELSEIF(OPENSSL_INCLUDE_DIR AND
575 +       OPENSSL_LIBRARY   AND
576 +       CRYPTO_LIBRARY      AND
577 +       OPENSSL_MAJOR_VERSION STREQUAL "2"
578 +      )
579 +      SET(OPENSSL_FOUND TRUE)
580      ELSE()
581        SET(OPENSSL_FOUND FALSE)
582      ENDIF()
583
584
585 [FILE:491:patches/patch-include_my__compare.h]
586 --- include/my_compare.h.orig   2019-04-13 13:32:15 UTC
587 +++ include/my_compare.h
588 @@ -40,7 +40,7 @@ extern "C" {
589    But beware the dependency of MI_MAX_POSSIBLE_KEY_BUFF and HA_MAX_KEY_LENGTH.
590  */
591  
592 -#define HA_MAX_KEY_LENGTH           1000        /* Max length in bytes */
593 +#define HA_MAX_KEY_LENGTH           4000        /* Max length in bytes */
594  #define HA_MAX_KEY_SEG              16          /* Max segments for key */
595  
596  #define HA_MAX_POSSIBLE_KEY_BUFF    (HA_MAX_KEY_LENGTH + 24+ 6+6)
597
598
599 [FILE:419:patches/patch-include_my__thread__os__id.h]
600 --- include/my_thread_os_id.h.orig      2019-04-13 13:32:15 UTC
601 +++ include/my_thread_os_id.h
602 @@ -81,8 +81,12 @@ static inline my_thread_os_id_t my_threa
603    return pthread_getthreadid_np();
604  #else
605  #ifdef HAVE_INTEGER_PTHREAD_SELF
606 +#  ifdef __DragonFly__
607 +  return syscall(SYS_lwp_gettid);
608 +#  else
609    /* Unknown platform, fallback. */
610    return pthread_self();
611 +#  endif
612  #else
613    /* Feature not available. */
614    return 0;
615
616
617 [FILE:549:patches/patch-include_myisam.h]
618 --- include/myisam.h.orig       2019-04-13 13:32:15 UTC
619 +++ include/myisam.h
620 @@ -45,7 +45,7 @@ extern "C" {
621    The following defines can be increased if necessary.
622    But beware the dependency of MI_MAX_POSSIBLE_KEY_BUFF and MI_MAX_KEY_LENGTH.
623  */
624 -#define MI_MAX_KEY_LENGTH           1000            /* Max length in bytes */
625 +#define MI_MAX_KEY_LENGTH           4000            /* Max length in bytes */
626  #define MI_MAX_KEY_SEG              16              /* Max segments for key */
627  
628  #define MI_MAX_KEY_BUFF  (MI_MAX_KEY_LENGTH+MI_MAX_KEY_SEG*6+8+8)
629
630
631 [FILE:440:patches/patch-libmysql_CMakeLists.txt]
632 --- libmysql/CMakeLists.txt.orig        2019-04-13 13:32:15 UTC
633 +++ libmysql/CMakeLists.txt
634 @@ -287,7 +287,7 @@ IF(NOT DISABLE_SHARED)
635      COMPONENT SharedLibraries)
636    IF(UNIX)
637      # libtool compatability
638 -    IF(CMAKE_SYSTEM_NAME MATCHES "FreeBSD" OR APPLE)
639 +    IF(CMAKE_SYSTEM_NAME MATCHES "FreeBSD|DragonFly|Linux|SunOS" OR APPLE)
640        SET(OS_SHARED_LIB_VERSION "${SHARED_LIB_MAJOR_VERSION}")
641      ELSE()
642        SET(OS_SHARED_LIB_VERSION
643
644
645 [FILE:334:patches/patch-libservices_CMakeLists.txt]
646 --- libservices/CMakeLists.txt.orig     2019-04-13 13:32:15 UTC
647 +++ libservices/CMakeLists.txt
648 @@ -40,4 +40,6 @@ SET(MYSQLSERVICES_SOURCES
649    mysql_keyring_service.c)
650  
651  ADD_CONVENIENCE_LIBRARY(mysqlservices ${MYSQLSERVICES_SOURCES})
652 +IF(FALSE)
653  INSTALL(TARGETS mysqlservices DESTINATION ${INSTALL_LIBDIR} COMPONENT Development)
654 +ENDIF()
655
656
657 [FILE:1910:patches/patch-mysys__ssl_my__default.cc]
658 --- mysys_ssl/my_default.cc.orig        2019-04-13 13:32:15 UTC
659 +++ mysys_ssl/my_default.cc
660 @@ -114,7 +114,7 @@ static my_bool defaults_already_read= FA
661  
662  /* Which directories are searched for options (and in which order) */
663  
664 -#define MAX_DEFAULT_DIRS 6
665 +#define MAX_DEFAULT_DIRS 7
666  #define DEFAULT_DIRS_SIZE (MAX_DEFAULT_DIRS + 1)  /* Terminate with NULL */
667  static const char **default_directories = NULL;
668  
669 @@ -918,6 +918,14 @@ static int search_default_file_with_ext(
670        return 1;                                 /* Ignore wrong files */
671    }
672  
673 +  if (strstr(name, "/etc") == name)
674 +  {
675 +    fprintf(stderr,
676 +             "error: Config file %s in invalid location, please move to or merge with /usr/local%s\n",
677 +             name,name);
678 +      goto err;
679 +  }
680 +
681    while (mysql_file_getline(buff, sizeof(buff) - 1, fp, is_login_file))
682    {
683      line++;
684 @@ -1256,7 +1264,8 @@ void my_print_default_files(const char *
685              end[(strlen(end)-1)] = ' ';
686            else
687              strxmov(end, conf_file, *ext , " ",  NullS);
688 -          fputs(name, stdout);
689 +          if (strstr(name, "/etc") != name)
690 +            fputs(name, stdout);
691          }
692        }
693      }
694 @@ -1415,13 +1424,8 @@ static const char **init_default_directo
695  
696  #else
697  
698 -  errors += add_directory(alloc, "/etc/", dirs);
699 -  errors += add_directory(alloc, "/etc/mysql/", dirs);
700 -
701 -#if defined(DEFAULT_SYSCONFDIR)
702 -  if (DEFAULT_SYSCONFDIR[0])
703 -    errors += add_directory(alloc, DEFAULT_SYSCONFDIR, dirs);
704 -#endif /* DEFAULT_SYSCONFDIR */
705 +  errors += add_directory(alloc, "/usr/local/etc/", dirs);
706 +  errors += add_directory(alloc, "/usr/local/etc/mysql/", dirs);
707  
708  #endif
709  
710 @@ -1492,7 +1496,7 @@ int check_file_permissions(const char *f
711    MY_STAT stat_info;
712  
713    if (!my_stat(file_name,&stat_info,MYF(0)))
714 -    return 1;
715 +    return 0;
716    /*
717      Ignore .mylogin.cnf file if not exclusively readable/writable
718      by current user.
719
720
721 [FILE:430:patches/patch-plugin_password__validation_validate__password.cc]
722 --- plugin/password_validation/validate_password.cc.orig        2019-04-13 13:32:15 UTC
723 +++ plugin/password_validation/validate_password.cc
724 @@ -18,6 +18,8 @@
725  #include <mysql/plugin_validate_password.h>
726  #include <mysql/service_my_plugin_log.h>
727  #include <mysql/service_mysql_string.h>
728 +/* solve clash between libc++ bitset::test() and test macro from my_global.h */
729 +#undef test
730  #include <set>
731  #include <iostream>
732  #include <fstream>
733
734
735 [FILE:678:patches/patch-rapid_plugin_x_mysqlx__configure.cmake]
736 --- rapid/plugin/x/mysqlx_configure.cmake.orig  2019-04-13 13:32:15 UTC
737 +++ rapid/plugin/x/mysqlx_configure.cmake
738 @@ -35,6 +35,7 @@ CONFIGURE_FILE(${MYSQLX_PROJECT_DIR}/src
739  CONFIGURE_FILE(${MYSQLX_PROJECT_DIR}/src/mysqlx_version.h.in
740                 ${CMAKE_CURRENT_BINARY_DIR}/generated/mysqlx_version.h )
741  
742 +IF(FALSE)
743  INSTALL(FILES ${CMAKE_CURRENT_BINARY_DIR}/generated/mysqlx_error.h
744          DESTINATION ${INSTALL_INCLUDEDIR}
745          COMPONENT Developement)
746 @@ -46,3 +47,4 @@ INSTALL(FILES ${CMAKE_CURRENT_BINARY_DIR
747  INSTALL(FILES ${CMAKE_CURRENT_BINARY_DIR}/generated/mysqlx_version.h
748          DESTINATION ${INSTALL_INCLUDEDIR}
749          COMPONENT Developement)
750 +ENDIF()
751
752
753 [FILE:547:patches/patch-rapid_unittest_gunit_xplugin_CMakeLists.txt]
754 --- rapid/unittest/gunit/xplugin/CMakeLists.txt.orig    2019-04-13 13:32:15 UTC
755 +++ rapid/unittest/gunit/xplugin/CMakeLists.txt
756 @@ -71,7 +71,6 @@ ADD_DEFINITIONS(
757  )
758  
759  INCLUDE_DIRECTORIES(SYSTEM
760 -    ${BOOST_INCLUDE_DIR}
761      ${PROTOBUF_INCLUDE_DIRS}
762      ${SSL_INCLUDE_DIRS}
763      ${LIBEVENT_INCLUDE_DIRS}
764 @@ -81,6 +80,7 @@ INCLUDE_DIRECTORIES(SYSTEM
765  )
766  
767  INCLUDE_DIRECTORIES(
768 +  ${BOOST_INCLUDE_DIR}
769    ${CMAKE_SOURCE_DIR}/testing/include
770    ${PROJECT_SOURCE_DIR}/rapid/plugin/x/ngs/include
771    ${PROJECT_SOURCE_DIR}/rapid/plugin/x/ngs/include/ngs
772
773
774 [FILE:342:patches/patch-regex_CMakeLists.txt]
775 --- regex/CMakeLists.txt.orig   2019-04-13 13:32:15 UTC
776 +++ regex/CMakeLists.txt
777 @@ -14,6 +14,7 @@
778  # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
779  
780  INCLUDE_DIRECTORIES(${CMAKE_SOURCE_DIR}/include)
781 +INCLUDE(${MYSQL_CMAKE_SCRIPT_DIR}/compile_flags.cmake)
782  
783  INCLUDE(${MYSQL_CMAKE_SCRIPT_DIR}/compile_flags.cmake)
784  
785
786
787 [FILE:1683:patches/patch-scripts_CMakeLists.txt]
788 --- scripts/CMakeLists.txt.orig 2019-04-13 13:32:15 UTC
789 +++ scripts/CMakeLists.txt
790 @@ -239,13 +239,9 @@ IF(NOT FIND_PROC AND CMAKE_SYSTEM_NAME M
791      "ps -p $PID | grep -v mysqld_safe | grep -- $MYSQLD > /dev/null")
792  ENDIF()
793  
794 -IF(NOT FIND_PROC)
795 -  # BSD styl
796 -  EXECUTE_PROCESS(COMMAND ps -uaxww OUTPUT_QUIET ERROR_QUIET RESULT_VARIABLE result)
797 -  IF(result MATCHES 0) 
798 +IF(NOT FIND_PROC AND CMAKE_SYSTEM_NAME MATCHES "DragonFly|FreeBSD")
799       SET( FIND_PROC
800         "ps -uaxww | grep -v mysqld_safe | grep -- $MYSQLD | grep $PID > /dev/null")
801 -  ENDIF()
802  ENDIF()
803  
804  IF(NOT FIND_PROC)
805 @@ -292,7 +288,7 @@ SET(pkglibdir ${prefix}/${INSTALL_LIBDIR
806  SET(pkgplugindir ${prefix}/${INSTALL_PLUGINDIR})
807  SET(localstatedir ${MYSQL_DATADIR})
808  
809 -IF(CMAKE_SYSTEM_NAME STREQUAL "SunOS")
810 +IF(TRUE)
811    SET(RPATH_OPTION " -R$pkglibdir")
812  ENDIF()
813  
814 @@ -324,6 +320,8 @@ MACRO(EXTRACT_LINK_LIBRARIES target var)
815            GET_FILENAME_COMPONENT(lib "${lib}" NAME_WE)
816            STRING(REGEX REPLACE "^lib" "" lib "${lib}")
817            SET(${var} "${${var}}-l${lib} " ) 
818 +        ELSEIF(lib STREQUAL "-pthread")
819 +          SET(${var} "${${var}}-pthread " ) 
820          ELSE()
821            SET(${var} "${${var}}-l${lib} " ) 
822          ENDIF()
823 @@ -450,7 +448,7 @@ ELSE()
824    FOREACH(file ${BIN_SCRIPTS})
825      IF(EXISTS ${CMAKE_CURRENT_SOURCE_DIR}/${file}.sh)
826        CONFIGURE_FILE(${CMAKE_CURRENT_SOURCE_DIR}/${file}.sh
827 -        ${CMAKE_CURRENT_BINARY_DIR}/${file} ESCAPE_QUOTES @ONLY)
828 +        ${CMAKE_CURRENT_BINARY_DIR}/${file} @ONLY)
829      ELSEIF(EXISTS ${CMAKE_CURRENT_SOURCE_DIR}/${file})
830        CONFIGURE_FILE(${CMAKE_CURRENT_SOURCE_DIR}/${file}
831           ${CMAKE_CURRENT_BINARY_DIR}/${file} COPYONLY)
832
833
834 [FILE:275:patches/patch-sql_CMakeLists.txt]
835 --- sql/CMakeLists.txt.orig     2019-04-13 13:32:15 UTC
836 +++ sql/CMakeLists.txt
837 @@ -23,6 +23,8 @@ INCLUDE_DIRECTORIES(
838    ${CMAKE_SOURCE_DIR}/regex 
839    ${SSL_INCLUDE_DIRS}
840    ${CMAKE_BINARY_DIR}/sql
841 +  ${CMAKE_BINARY_DIR}/include
842 +  ${CMAKE_BINARY_DIR}
843    ${LZ4_INCLUDE_DIR}
844  )
845  
846
847
848 [FILE:1264:patches/patch-sql_conn__handler_socket__connection.cc]
849 --- sql/conn_handler/socket_connection.cc.orig  2019-04-13 13:32:15 UTC
850 +++ sql/conn_handler/socket_connection.cc
851 @@ -943,22 +943,25 @@ Channel_info* Mysqld_socket_listener::li
852      signal(SIGCHLD, SIG_DFL);
853      request_init(&req, RQ_DAEMON, m_libwrap_name, RQ_FILE,
854                   mysql_socket_getfd(connect_sock), NULL);
855 -    fromhost(&req);
856 +    void (*my_fromhost) (void *) = (void (*)(void *)) fromhost;
857 +    my_fromhost(&req);
858  
859 -    if (!hosts_access(&req))
860 +    int (*my_hosts_access) (void *) = (int (*) (void *)) hosts_access;
861 +    if (!my_hosts_access(&req))
862      {
863        /*
864          This may be stupid but refuse() includes an exit(0)
865          which we surely don't want...
866          clean_exit() - same stupid thing ...
867        */
868 +      char *(*my_eval_client) (void *) = (char *(*) (void *)) eval_client;
869        syslog(LOG_AUTH | m_deny_severity,
870 -             "refused connect from %s", eval_client(&req));
871 +             "refused connect from %s", my_eval_client(&req));
872  
873  #ifdef HAVE_LIBWRAP_PROTOTYPES
874        // Some distros have patched tcpd.h to have proper prototypes
875        if (req.sink)
876 -        (req.sink)(req.fd);
877 +        ((void (*)(int)) (req.sink))(req.fd);
878  #else
879        // Some distros have not patched tcpd.h
880        if (req.sink)
881
882
883 [FILE:374:patches/patch-sql_mysqld.cc]
884 --- sql/mysqld.cc.orig  2019-04-13 13:32:15 UTC
885 +++ sql/mysqld.cc
886 @@ -3415,7 +3415,7 @@ static int init_ssl()
887  {
888  #ifdef HAVE_OPENSSL
889  #ifndef HAVE_YASSL
890 -#if OPENSSL_VERSION_NUMBER < 0x10100000L
891 +#if OPENSSL_VERSION_NUMBER < 0x10100000L || defined(LIBRESSL_VERSION_NUMBER)
892    CRYPTO_malloc_init();
893  #else /* OPENSSL_VERSION_NUMBER < 0x10100000L */
894    OPENSSL_malloc_init();
895
896
897 [FILE:2575:patches/patch-sql_sql__view.cc]
898 --- sql/sql_view.cc.orig        2019-04-13 13:32:15 UTC
899 +++ sql/sql_view.cc
900 @@ -778,46 +778,46 @@ static const int required_view_parameter
901  */
902  static File_option view_parameters[]=
903  {{{ C_STRING_WITH_LEN("query")},
904 -  my_offsetof(TABLE_LIST, select_stmt),
905 +  static_cast<int>(my_offsetof(TABLE_LIST, select_stmt)),
906    FILE_OPTIONS_ESTRING},
907   {{ C_STRING_WITH_LEN("md5")},
908 -  my_offsetof(TABLE_LIST, md5),
909 +  static_cast<int>(my_offsetof(TABLE_LIST, md5)),
910    FILE_OPTIONS_STRING},
911   {{ C_STRING_WITH_LEN("updatable")},
912 -  my_offsetof(TABLE_LIST, updatable_view),
913 +  static_cast<int>(my_offsetof(TABLE_LIST, updatable_view)),
914    FILE_OPTIONS_ULONGLONG},
915   {{ C_STRING_WITH_LEN("algorithm")},
916 -  my_offsetof(TABLE_LIST, algorithm),
917 +  static_cast<int>(my_offsetof(TABLE_LIST, algorithm)),
918    FILE_OPTIONS_ULONGLONG},
919   {{ C_STRING_WITH_LEN("definer_user")},
920 -  my_offsetof(TABLE_LIST, definer.user),
921 +  static_cast<int>(my_offsetof(TABLE_LIST, definer.user)),
922    FILE_OPTIONS_STRING},
923   {{ C_STRING_WITH_LEN("definer_host")},
924 -  my_offsetof(TABLE_LIST, definer.host),
925 +  static_cast<int>(my_offsetof(TABLE_LIST, definer.host)),
926    FILE_OPTIONS_STRING},
927   {{ C_STRING_WITH_LEN("suid")},
928 -  my_offsetof(TABLE_LIST, view_suid),
929 +  static_cast<int>(my_offsetof(TABLE_LIST, view_suid)),
930    FILE_OPTIONS_ULONGLONG},
931   {{ C_STRING_WITH_LEN("with_check_option")},
932 -  my_offsetof(TABLE_LIST, with_check),
933 +  static_cast<int>(my_offsetof(TABLE_LIST, with_check)),
934    FILE_OPTIONS_ULONGLONG},
935   {{ C_STRING_WITH_LEN("timestamp")},
936 -  my_offsetof(TABLE_LIST, timestamp),
937 +  static_cast<int>(my_offsetof(TABLE_LIST, timestamp)),
938    FILE_OPTIONS_TIMESTAMP},
939   {{ C_STRING_WITH_LEN("create-version")},
940 -  my_offsetof(TABLE_LIST, file_version),
941 +  static_cast<int>(my_offsetof(TABLE_LIST, file_version)),
942    FILE_OPTIONS_ULONGLONG},
943   {{ C_STRING_WITH_LEN("source")},
944 -  my_offsetof(TABLE_LIST, source),
945 +  static_cast<int>(my_offsetof(TABLE_LIST, source)),
946    FILE_OPTIONS_ESTRING},
947   {{(char*) STRING_WITH_LEN("client_cs_name")},
948 -  my_offsetof(TABLE_LIST, view_client_cs_name),
949 +  static_cast<int>(my_offsetof(TABLE_LIST, view_client_cs_name)),
950    FILE_OPTIONS_STRING},
951   {{(char*) STRING_WITH_LEN("connection_cl_name")},
952 -  my_offsetof(TABLE_LIST, view_connection_cl_name),
953 +  static_cast<int>(my_offsetof(TABLE_LIST, view_connection_cl_name)),
954    FILE_OPTIONS_STRING},
955   {{(char*) STRING_WITH_LEN("view_body_utf8")},
956 -  my_offsetof(TABLE_LIST, view_body_utf8),
957 +  static_cast<int>(my_offsetof(TABLE_LIST, view_body_utf8)),
958    FILE_OPTIONS_ESTRING},
959   {{NullS, 0},                  0,
960    FILE_OPTIONS_STRING}
961
962
963 [FILE:1921:patches/patch-sql_sys__vars.cc]
964 --- sql/sys_vars.cc.orig        2019-04-13 13:32:15 UTC
965 +++ sql/sys_vars.cc
966 @@ -1741,7 +1741,7 @@ static Sys_var_ulong Sys_interactive_tim
967         "connection before closing it",
968         SESSION_VAR(net_interactive_timeout),
969         CMD_LINE(REQUIRED_ARG),
970 -       VALID_RANGE(1, LONG_TIMEOUT), DEFAULT(NET_WAIT_TIMEOUT), BLOCK_SIZE(1));
971 +       VALID_RANGE(1, INT_MAX32/1000), DEFAULT(NET_WAIT_TIMEOUT), BLOCK_SIZE(1));
972  
973  static Sys_var_ulong Sys_join_buffer_size(
974         "join_buffer_size",
975 @@ -2621,7 +2621,7 @@ static Sys_var_ulong Sys_net_read_timeou
976         "Number of seconds to wait for more data from a connection before "
977         "aborting the read",
978         SESSION_VAR(net_read_timeout), CMD_LINE(REQUIRED_ARG),
979 -       VALID_RANGE(1, LONG_TIMEOUT), DEFAULT(NET_READ_TIMEOUT), BLOCK_SIZE(1),
980 +       VALID_RANGE(1, INT_MAX32/1000), DEFAULT(NET_READ_TIMEOUT), BLOCK_SIZE(1),
981         NO_MUTEX_GUARD, NOT_IN_BINLOG, ON_CHECK(0),
982         ON_UPDATE(fix_net_read_timeout));
983  
984 @@ -2645,7 +2645,7 @@ static Sys_var_ulong Sys_net_write_timeo
985         "Number of seconds to wait for a block to be written to a connection "
986         "before aborting the write",
987         SESSION_VAR(net_write_timeout), CMD_LINE(REQUIRED_ARG),
988 -       VALID_RANGE(1, LONG_TIMEOUT), DEFAULT(NET_WRITE_TIMEOUT), BLOCK_SIZE(1),
989 +       VALID_RANGE(1, INT_MAX32/1000), DEFAULT(NET_WRITE_TIMEOUT), BLOCK_SIZE(1),
990         NO_MUTEX_GUARD, NOT_IN_BINLOG, ON_CHECK(0),
991         ON_UPDATE(fix_net_write_timeout));
992  
993 @@ -4369,7 +4369,7 @@ static Sys_var_ulong Sys_net_wait_timeou
994         "The number of seconds the server waits for activity on a "
995         "connection before closing it",
996         SESSION_VAR(net_wait_timeout), CMD_LINE(REQUIRED_ARG),
997 -       VALID_RANGE(1, IF_WIN(INT_MAX32/1000, LONG_TIMEOUT)),
998 +       VALID_RANGE(1, INT_MAX32/1000),
999         DEFAULT(NET_WAIT_TIMEOUT), BLOCK_SIZE(1));
1000  
1001  static Sys_var_plugin Sys_default_storage_engine(
1002
1003
1004 [FILE:440:patches/patch-storage_innobase_include_srv0mon.h]
1005 --- storage/innobase/include/srv0mon.h.orig     2019-04-13 13:32:15 UTC
1006 +++ storage/innobase/include/srv0mon.h
1007 @@ -34,6 +34,10 @@ Created 12/15/2009   Jimmy Yang
1008  /* Required for FreeBSD so that INT64_MAX is defined. */
1009  #define __STDC_LIMIT_MACROS
1010  #endif /* __STDC_LIMIT_MACROS */
1011 +#ifdef __DragonFly__
1012 +/* The hack above doen't work for dragonfly, stdint.h already imported */
1013 +#include <machine/int_limits.h>
1014 +#endif
1015  
1016  #include <stdint.h>
1017  
1018
1019
1020 [FILE:985:patches/patch-storage_myisam_mi__dynrec.c]
1021 --- storage/myisam/mi_dynrec.c.orig     2019-04-13 13:32:15 UTC
1022 +++ storage/myisam/mi_dynrec.c
1023 @@ -65,18 +65,13 @@ my_bool mi_dynmap_file(MI_INFO *info, my
1024      DBUG_RETURN(1);
1025    }
1026    /*
1027 -    I wonder if it is good to use MAP_NORESERVE. From the Linux man page:
1028 -    MAP_NORESERVE
1029 -      Do not reserve swap space for this mapping. When swap space is
1030 -      reserved, one has the guarantee that it is possible to modify the
1031 -      mapping. When swap space is not reserved one might get SIGSEGV
1032 -      upon a write if no physical memory is available.
1033 +    MAP_NORESERVE is unimplemented in FreeBSD
1034    */
1035    info->s->file_map= (uchar*)
1036                    my_mmap(0, (size_t) size,
1037                            info->s->mode==O_RDONLY ? PROT_READ :
1038                            PROT_READ | PROT_WRITE,
1039 -                          MAP_SHARED | MAP_NORESERVE,
1040 +                          MAP_SHARED,
1041                            info->dfile, 0L);
1042    if (info->s->file_map == (uchar*) MAP_FAILED)
1043    {
1044
1045
1046 [FILE:2182:files/my.cnf.sample.in]
1047 [client]
1048 port                            = 3306
1049 socket                          = /tmp/mysql.sock
1050
1051 [mysql]
1052 prompt                          = \u@\h [\d]>\_
1053 no_auto_rehash
1054
1055 [mysqld]
1056 user                            = mysql
1057 port                            = 3306
1058 socket                          = /tmp/mysql.sock
1059 bind-address                    = 127.0.0.1
1060 basedir                         = %%PREFIX%%
1061 datadir                         = %%MY_DBDIR%%
1062 tmpdir                          = %%MY_TMPDIR%%
1063 slave-load-tmpdir               = %%MY_TMPDIR%%
1064 secure-file-priv                = %%MY_SECDIR%%
1065 log-bin                         = mysql-bin
1066 log-output                      = TABLE
1067 master-info-repository          = TABLE
1068 relay-log-info-repository       = TABLE
1069 relay-log-recovery              = 1
1070 slow-query-log                  = 1
1071 server-id                       = 1
1072 sync_binlog                     = 1
1073 sync_relay_log                  = 1
1074 binlog_cache_size               = 16M
1075 expire_logs_days                = 30
1076 default_password_lifetime       = 0
1077 enforce-gtid-consistency        = 1
1078 gtid-mode                       = ON
1079 safe-user-create                = 1
1080 lower_case_table_names          = 1
1081 explicit-defaults-for-timestamp = 1
1082 myisam-recover-options          = BACKUP,FORCE
1083 open_files_limit                = 32768
1084 table_open_cache                = 16384
1085 table_definition_cache          = 8192
1086 net_retry_count                 = 16384
1087 key_buffer_size                 = 256M
1088 max_allowed_packet              = 64M
1089 query_cache_type                = 0
1090 query_cache_size                = 0
1091 long_query_time                 = 0.5
1092 innodb_buffer_pool_size         = 1G
1093 innodb_data_home_dir            = %%MY_DBDIR%%
1094 innodb_log_group_home_dir       = %%MY_DBDIR%%
1095 innodb_data_file_path           = ibdata1:128M:autoextend
1096 innodb_temp_data_file_path      = ibtmp1:128M:autoextend
1097 innodb_flush_method             = O_DIRECT
1098 innodb_log_file_size            = 256M
1099 innodb_log_buffer_size          = 16M
1100 innodb_write_io_threads         = 8
1101 innodb_read_io_threads          = 8
1102 innodb_autoinc_lock_mode        = 2
1103 skip-symbolic-links
1104
1105 [mysqldump]
1106 max_allowed_packet              = 256M
1107 quote_names
1108 quick
1109
1110
1111 [FILE:2478:files/mysql-server.in]
1112 #!/bin/sh
1113 #
1114 # PROVIDE: mysql
1115 # REQUIRE: LOGIN
1116 # KEYWORD: shutdown
1117
1118 #
1119 # Add the following line to /etc/rc.conf to enable mysql:
1120 # mysql_enable (bool):  Set to "NO" by default.
1121 #                       Set it to "YES" to enable MySQL.
1122 # mysql_limits (bool):  Set to "NO" by default.
1123 #                       Set it to yes to run `limits -e -U mysql`
1124 #                       just before mysql starts.
1125 # mysql_dbdir (str):    Default to "%%MY_DBDIR%%"
1126 #                       Base database directory.
1127 # mysql_confdir (str):  Default to "%%ETCDIR%%"
1128 #                       Base configuration directory.
1129 # mysql_optfile (str):  Server-specific option file.
1130 #                       Set it in the rc.conf or default behaviour of
1131 #                       `mysqld_safe` itself, will be picking
1132 #                       ${mysql_confdir}/my.cnf if it exists.
1133 # mysql_pidfile (str):  Custum PID file path and name.
1134 #                       Default to "${mysql_dbdir}/${hostname}.pid".
1135 # mysql_args (str):     Custom additional arguments to be passed
1136 #                       to mysqld_safe (default empty).
1137 #
1138
1139 . /etc/rc.subr
1140
1141 name="mysql"
1142 rcvar=mysql_enable
1143
1144 load_rc_config $name
1145
1146 : ${mysql_enable="NO"}
1147 : ${mysql_limits="NO"}
1148 : ${mysql_dbdir="%%MY_DBDIR%%"}
1149 : ${mysql_confdir="%%ETCDIR%%"}
1150 if [ -f "${mysql_confdir}/my.cnf" ]; then
1151 : ${mysql_optfile="${mysql_confdir}/my.cnf"}
1152 elif [ -f "${mysql_dbdir}/my.cnf" ]; then
1153 : ${mysql_optfile="${mysql_dbdir}/my.cnf"}
1154 fi
1155 if [ ! -z "${mysql_optfile}" ]; then
1156 mysql_extra="--defaults-extra-file=${mysql_optfile}"
1157 fi
1158
1159 mysql_user="mysql"
1160 mysql_limits_args="-e -U ${mysql_user}"
1161 : ${hostname:=`/bin/hostname`}
1162 pidfile=${mysql_pidfile:-"${mysql_dbdir}/${hostname}.pid"}
1163 command="/usr/sbin/daemon"
1164 command_args="-c -f %%PREFIX%%/bin/mysqld_safe ${mysql_extra} --basedir=%%PREFIX%% --datadir=${mysql_dbdir} --pid-file=${pidfile} --user=${mysql_user} ${mysql_args} %%FEDER%% %%PERFSCHEMRC%%"
1165 procname="%%PREFIX%%/libexec/mysqld"
1166 start_precmd="${name}_prestart"
1167 start_postcmd="${name}_poststart"
1168 mysql_install_db="%%PREFIX%%/bin/mysql_install_db"
1169 mysql_install_db_args="${mysql_extra} --basedir=%%PREFIX%% --datadir=${mysql_dbdir} --mysqld-file=${procname} --user=${mysql_user}"
1170
1171 mysql_create_auth_tables()
1172 {
1173         eval $mysql_install_db $mysql_install_db_args >/dev/null 2>/dev/null
1174 }
1175
1176 mysql_prestart()
1177 {
1178         if [ ! -d "${mysql_dbdir}/mysql/." ]; then
1179                 mysql_create_auth_tables || return 1
1180         fi
1181         if checkyesno mysql_limits; then
1182                 eval `/usr/bin/limits ${mysql_limits_args}` 2>/dev/null
1183         else
1184                 return 0
1185         fi
1186 }
1187
1188 mysql_poststart()
1189 {
1190         local timeout=15
1191         while [ ! -f "${pidfile}" -a ${timeout} -gt 0 ]; do
1192                 timeout=$(( timeout - 1 ))
1193                 sleep 1
1194         done
1195         return 0
1196 }
1197
1198 run_rc_command "$1"
1199
1200
1201 [FILE:576:files/pkg-message-server.in]
1202 *****************************************************************************
1203
1204 Remember to run mysql_upgrade the first time you start the MySQL server
1205 after an upgrade from an earlier version.
1206
1207 Initial password for first time use of MySQL is saved in $HOME/.mysql_secret
1208 ie. when you want to use "mysql -u root -p" first you should see password
1209 in /root/.mysql_secret
1210
1211 MySQL57 has a default %%ETCDIR%%/my.cnf,
1212 remember to replace it wit your own
1213 or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
1214
1215 *****************************************************************************
1216
1217
1218 [FILE:28:files/special.mk]
1219 ETCDIR= ${PREFIX}/etc/mysql
1220