Hi All
I running the following
I have the following installed
I recently did a
However when I try to do
I went to check the error logs located here
The postal.brendhanhorne.com.err does not really show anything.
All of which is from the last reboot that I can tell.
Also here is the my.cnf
So basically I am trying to find out why MySQL is not starting.
Thank you in advance.
I running the following
Code:
#uname -a
FreeBSD postal.brendhanhorne.com 11.1-RELEASE-p4 FreeBSD 11.1-RELEASE-p4 #0: Tue Nov 14 06:05:10 UTC 2017 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC i386
Code:
# pkg info
ImageMagick-6.9.9.28,1 Image processing tools (legacy version)
apache24-2.4.29 Version 2.4.x of Apache web server
apr-1.6.3.1.6.1 Apache Portability Library
avahi-app-0.6.31_5 Service discovery on a local network
ca_root_nss-3.34.1 Root certificate bundle from the Mozilla Project
cairo-1.14.8_1,2 Vector graphics library with cross-device output support
cups-2.2.6 Common UNIX Printing System
curl-7.57.0 Command line tool and library for transferring data with URLs
cyrus-sasl-2.1.26_12 RFC 2222 SASL (Simple Authentication and Security Layer)
damageproto-1.2.1 Damage extension headers
db5-5.3.28_6 Oracle Berkeley DB, revision 5.3
dbus-1.10.16_1 Message bus system for inter-application communication
dbus-glib-0.108 GLib bindings for the D-BUS messaging system
dejavu-2.37 Bitstream Vera Fonts clone with a wider range of characters
dri2proto-2.8 DRI2 prototype headers
encodings-1.0.4_3,1 X.Org Encoding fonts
expat-2.2.5 XML 1.0 parser written in C
fftw3-3.3.6.p2_2 Fast C routines to compute the Discrete Fourier Transform
fixesproto-5.0 Fixes extension headers
font-bh-ttf-1.0.3_3 X.Org Bigelow & Holmes TTF font
font-misc-ethiopic-1.0.3_3 X.Org miscellaneous Ethiopic font
font-misc-meltho-1.0.3_3 X.Org miscellaneous Meltho font
font-util-1.3.1 Create an index of X font files in a directory
fontconfig-2.12.1,1 XML-based font configuration API for X Windows
freetype2-2.8_1 Free and portable TrueType font rendering engine
gdbm-1.13_1 GNU database manager
gdk-pixbuf2-2.36.9 Graphic library for GTK+
gettext-runtime-0.19.8.1_1 GNU gettext runtime libraries and programs
ghostscript9-agpl-base-9.16_5 Ghostscript 9.x PostScript interpreter, base part
ghostscript9-agpl-x11-9.16_2 Ghostscript 9.x PostScript interpreter, X11 support
giflib-5.1.4 Tools and library routines for working with GIF images
glib-2.50.2_7,1 Some useful routines of C programming (current stable version)
glproto-1.4.17 GLX extension headers
gmp-6.1.2 Free library for arbitrary precision arithmetic
gnome_subr-1.0 Common startup and shutdown subroutines used by GNOME scripts
gnutls-3.5.16 GNU Transport Layer Security library
gobject-introspection-1.50.0,1 Generate interface introspection data for GObject libraries
graphite2-1.3.10 Rendering capabilities for complex non-Roman writing systems
gsfonts-8.11_8 Standard Fonts for Ghostscript
harfbuzz-1.7.4 OpenType text shaping engine
indexinfo-0.3.1 Utility to regenerate the GNU info page index
inputproto-2.3.2 Input extension headers
jasper-1.900.1_17 Implementation of the codec specified in the JPEG-2000 standard
jbig2dec-0.14 Decoder implementation of the JBIG2 image compression format
jbigkit-2.1_1 Lossless compression for bi-level images such as scanned pages, faxes
jpeg-turbo-1.5.3 SIMD-accelerated JPEG codec which replaces libjpeg
kbproto-1.0.7 KB extension headers
lcms2-2.9 Accurate, fast, and small-footprint color management engine
libICE-1.0.9_1,1 Inter Client Exchange library for X11
libSM-1.2.2_3,1 Session Management library for X11
libX11-1.6.5,1 X11 library
libXau-1.0.8_3 Authentication Protocol library for X11
libXaw-1.0.13,2 X Athena Widgets library
libXdamage-1.1.4_3 X Damage extension library
libXdmcp-1.1.2 X Display Manager Control Protocol library
libXext-1.3.3_1,1 X11 Extension library
libXfixes-5.0.3 X Fixes extension library
libXft-2.3.2_1 Client-sided font API for X applications
libXi-1.7.9,1 X Input extension library
libXmu-1.1.2_3,1 X Miscellaneous Utilities libraries
libXp-1.0.3,1 X print library
libXpm-3.5.12 X Pixmap library
libXrender-0.9.10 X Render extension library
libXt-1.1.5,1 X Toolkit library
libXxf86vm-1.1.4_1 X Vidmode Extension
libcroco-0.6.11 CSS2 parsing library
libdaemon-0.14_1 Lightweight C library that eases the writing of UNIX daemons
libdrm-2.4.89,1 Userspace interface to kernel Direct Rendering Module services
libedit-3.1.20170329_2,1 Command line editor library
libevent-2.1.8_1 API for executing callback functions on events or timeouts
libffi-3.2.1_2 Foreign Function Interface
libfontenc-1.1.3_1 The fontenc Library
libgsf-1.14.41 Extensible I/O abstraction for dealing with structured file formats
libiconv-1.14_11 Character set conversion library
libidn-1.33_1 Internationalized Domain Names command line tool
libidn2-2.0.4 Implementation of IDNA2008 internationalized domain names
liblqr-1-0.4.2 Easy to use C/C++ seam carving library
libltdl-2.4.6 System independent dlopen wrapper
liblz4-1.8.0,1 LZ4 compression library, lossless and very fast
libmcrypt-2.5.8_3 Multi-cipher cryptographic library (used in PHP)
libnghttp2-1.29.0 HTTP/2.0 C Library
libpaper-1.1.24.4 Library providing routines for paper size management
libpciaccess-0.13.5 Generic PCI access library
libpthread-stubs-0.4 This library provides weak aliases for pthread functions
libraw-0.18.5 Library for manipulating raw images
librsvg2-2.40.17 Library for parsing and rendering SVG vector-graphic files
libtasn1-4.12 ASN.1 structure parser library
libunistring-0.9.8 Unicode string library
libunwind-20170113_1 Generic stack unwinding library
libwmf-0.2.8.4_15 Tools and library for converting Microsoft WMF (windows metafile)
libxcb-1.12_2 The X protocol C-language Binding (XCB) library
libxml2-2.9.7 XML parser library for GNOME
libxshmfence-1.2_2 Shared memory 'SyncFence' synchronization primitive
libzip-1.3.2 C library for reading, creating, and modifying ZIP archives
mesa-libs-17.3.1 OpenGL libraries that support GLX and EGL clients
mkfontdir-1.0.7 Create an index of X font files in a directory
mkfontscale-1.1.2 Creates an index of scalable font files for X
mod_php56-5.6.32_1 PHP Scripting Language
mysql57-client-5.7.21 Multithreaded SQL database (client)
mysql57-server-5.7.21 Multithreaded SQL database (server)
nettle-3.4 Low-level cryptographic library
oniguruma6-6.6.1 BSDL Regular Expressions library compatible with POSIX/GNU/Perl
openjpeg-2.3.0 Open-source JPEG 2000 codec
p11-kit-0.23.9 Library for loading and enumerating of PKCS#11 modules
pango-1.40.6 Open-source framework for the layout and rendering of i18n text
pciids-20171206 Database of all known IDs used in PCI devices
pcre-8.40_1 Perl Compatible Regular Expressions library
perl5-5.24.3 Practical Extraction and Report Language
php56-5.6.32_1 PHP Scripting Language
php56-bz2-5.6.32_1 The bz2 shared extension for php
php56-ctype-5.6.32_1 The ctype shared extension for php
php56-filter-5.6.32_1 The filter shared extension for php
php56-gd-5.6.32_1 The gd shared extension for php
php56-json-5.6.32_1 The json shared extension for php
php56-mbstring-5.6.32_1 The mbstring shared extension for php
php56-mcrypt-5.6.32_1 The mcrypt shared extension for php
php56-mysqli-5.6.32_1 The mysqli shared extension for php
php56-openssl-5.6.32_1 The openssl shared extension for php
php56-session-5.6.32_1 The session shared extension for php
php56-xml-5.6.32_1 The xml shared extension for php
php56-zip-5.6.32_1 The zip shared extension for php
php56-zlib-5.6.32_1 The zlib shared extension for php
phpMyAdmin-4.7.7 Set of PHP-scripts to manage MySQL over the web
pixman-0.34.0 Low-level pixel manipulation library
pkg-1.10.3_1 Package manager
pkgconf-1.3.10,1 Utility to help to configure compiler and linker flags
png-1.6.34 Library for manipulating PNG images
portmaster-3.18_4 Manage your ports without external databases or languages
printproto-1.0.5 Print extension headers
protobuf-3.5.1 Data interchange format library
python2-2_3 The "meta-port" for version 2 of the Python interpreter
python27-2.7.14_1 Interpreted object-oriented programming language
readline-7.0.3_1 Library for editing command lines as they are typed
renderproto-0.11.1 RenderProto protocol headers
shared-mime-info-1.8 MIME types database from the freedesktop.org project
svgalib-1.4.3_7 Low level console graphics library
t1lib-5.1.2_4,1 Type 1 font rasterization library for Unix/X11
tiff-4.0.9 Tools and library routines for working with TIFF images
tpm-emulator-0.7.4_2 Trusted Platform Module (TPM) emulator
trousers-0.3.14_2 Open-source TCG Software Stack
webp-0.6.1 Google WebP image format conversion tool
xcb-util-0.4.0_2,1 Module with libxcb/libX11 extension/replacement libraries
xcb-util-renderutil-0.3.9_1 Convenience functions for the Render extension
xextproto-7.3.0 XExt extension headers
xf86vidmodeproto-2.3.1 XFree86-VidModeExtension extension headers
xorg-fonts-truetype-7.7_1 X.Org TrueType fonts
xproto-7.0.31 X11 protocol headersI recently did a
freebsd-update -r 11.1-RELEASE upgrade and followed all the steps listed in the handbook. to complete that. However when I try to do
service mysql-server start I get the starting myql message but it never actually starts. I went to check the error logs located here
Code:
# cd /var/db/mysql
root@postal:/var/db/mysql # ls -a
. mysql
.. mysql-bin.000001
auto.cnf mysql-bin.000002
onedb mysql-bin.index
twodb performance_schema
threedb fourdb
ca-key.pem postal-slow.log
ca.pem postal.brendhanhorne.com.err
client-cert.pem private_key.pem
client-key.pem public_key.pem
ib_buffer_pool server-cert.pem
ib_logfile0 server-key.pem
ib_logfile1 sys
ibdata1 test
Code:
2018-01-24T19:17:01.245928Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete
2018-01-24T19:17:01.6NZ mysqld_safe mysqld from pid file /var/db/mysql/postal.brendhanhorne.com.pid endedAll of which is from the last reboot that I can tell.
Also here is the my.cnf
Code:
# $FreeBSD: branches/2018Q1/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $
[client]
port = 3306
socket = /tmp/mysql.sock
[mysql]
prompt = \u@\h [\d]>\_
no_auto_rehash
[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql.sock
bind-address = 127.0.0.1
basedir = /usr/local
datadir = /var/db/mysql
tmpdir = /var/db/mysql_tmpdir
slave-load-tmpdir = /var/db/mysql_tmpdir
secure-file-priv = /var/db/mysql_secure
log-bin = mysql-bin
log-output = TABLE
master-info-repository = TABLE
relay-log-info-repository = TABLE
relay-log-recovery = 1
slow-query-log = 1
server-id = 1
sync_binlog = 1
sync_relay_log = 1
binlog_cache_size = 16M
expire_logs_days = 30
default_password_lifetime = 0
enforce-gtid-consistency = 1
gtid-mode = ON
safe-user-create = 1
lower_case_table_names = 1
explicit-defaults-for-timestamp = 1
myisam-recover-options = BACKUP,FORCE
open_files_limit = 32768
table_open_cache = 16384
table_definition_cache = 8192
net_retry_count = 16384
key_buffer_size = 256M
max_allowed_packet = 64M
query_cache_type = 0
query_cache_size = 0
long_query_time = 0.5
innodb_buffer_pool_size = 1G
innodb_data_home_dir = /var/db/mysql
innodb_log_group_home_dir = /var/db/mysql
innodb_data_file_path = ibdata1:128M:autoextend
innodb_temp_data_file_path = ibtmp1:128M:autoextend
innodb_flush_method = O_DIRECT
innodb_log_file_size = 256M
innodb_log_buffer_size = 16M
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_autoinc_lock_mode = 2
skip-symbolic-links
[mysqldump]
max_allowed_packet = 256M
quote_names
quickSo basically I am trying to find out why MySQL is not starting.
Thank you in advance.
