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