не запускается mysql-server

Status
Not open for further replies.

subalk

Dabbler
Joined
Jul 23, 2018
Messages
16
пробую установить owncloud на FreeNAS 11.1 по статье https://habr.com/post/255019/

почему-то не запускается mysql-server...

Code:
root@OwnCloud:/usr/local/etc/nginx # /usr/local/etc/rc.d/mysql-server start
Starting mysql.
root@OwnCloud:/usr/local/etc/nginx # /usr/local/etc/rc.d/mysql-server status
mysql is not running.
root@OwnCloud:/usr/local/etc/nginx # tail -n 10 /var/db/mysql/OwnCloud.err
/usr/local/libexec/mysqld: Undefined symbol "fdatasync"
180806 16:39:03 mysqld_safe mysqld from pid file /var/db/mysql/OwnCloud.pid ended
180806 16:51:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
180806 16:51:31 [Note] /usr/local/libexec/mysqld (mysqld 10.0.35-MariaDB) starting as process 53958 ...
/usr/local/libexec/mysqld: Undefined symbol "fdatasync"
180806 16:51:31 mysqld_safe mysqld from pid file /var/db/mysql/OwnCloud.pid ended
180806 17:07:03 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
180806 17:07:03 [Note] /usr/local/libexec/mysqld (mysqld 10.0.35-MariaDB) starting as process 55071 ...
/usr/local/libexec/mysqld: Undefined symbol "fdatasync"
180806 17:07:03 mysqld_safe mysqld from pid file /var/db/mysql/OwnCloud.pid ended
root@OwnCloud:/usr/local/etc/nginx # /usr/local/etc/rc.d/mysql-server rcvar
# mysql
#
mysql_enable="YES"
#   (default: "")


во время запуска он думает секунд 15.

подскажите что подправить чтоб он запустился?


Code:
root@OwnCloud:/usr/home/admin # pkg info
apr-1.6.3.1.6.1_1			  Apache Portability Library
ca_root_nss-3.38			   Root certificate bundle from the Mozilla Project
curl-7.61.0_1				  Command line tool and library for transferring data with URLs
cvsps-2.1_2					Create patchset information from CVS
db5-5.3.28_6				   Oracle Berkeley DB, revision 5.3
dialog4ports-0.1.6			 Console Interface to configure ports
expat-2.2.5					XML 1.0 parser written in C
freetype2-2.9.1				Free and portable TrueType font rendering engine
gdbm-1.13_1					GNU database manager
gettext-runtime-0.19.8.1_1	 GNU gettext runtime libraries and programs
git-2.18.0_1				   Distributed source code management tool
icu-62.1_2,1				   International Components for Unicode (from IBM)
indexinfo-0.3.1				Utility to regenerate the GNU info page index
jpeg-turbo-1.5.3			   SIMD-accelerated JPEG codec which replaces libjpeg
kbproto-1.0.7				  KB extension headers
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
libXdmcp-1.1.2				 X Display Manager Control Protocol library
libXext-1.3.3_1,1			  X11 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
libXt-1.1.5,1				  X Toolkit library
libffi-3.2.1_2				 Foreign Function Interface
libiconv-1.14_11			   Character set conversion library
libltdl-2.4.6				  System independent dlopen wrapper
liblz4-1.8.2,1				 LZ4 compression library, lossless and very fast
libmcrypt-2.5.8_3			  Multi-cipher cryptographic library (used in PHP)
libnghttp2-1.32.0			  HTTP/2.0 C Library
libpthread-stubs-0.4		   This library provides weak aliases for pthread functions
libxcb-1.13					The X protocol C-language Binding (XCB) library
libxml2-2.9.7				  XML parser library for GNOME
libzip-1.5.1				   C library for reading, creating, and modifying ZIP archives
mariadb100-client-10.0.35_1	Multithreaded SQL database (client)
mariadb100-server-10.0.35_1	Multithreaded SQL database (server)
nano-2.9.8					 Nano's ANOther editor, an enhanced free Pico clone
nginx-1.14.0_11,2			  Robust and small WWW server
oniguruma-6.8.2				Regular expressions library compatible with POSIX/GNU/Perl
p5-Authen-SASL-2.16_1		  Perl5 module for SASL authentication
p5-CGI-4.38					Handle Common Gateway Interface requests and responses
p5-Digest-HMAC-1.03_1		  Perl5 interface to HMAC Message-Digest Algorithms
p5-Error-0.17026			   Error/exception handling in object-oriented programming style
p5-GSSAPI-0.28_1			   Perl extension providing access to the GSSAPIv2 library
p5-HTML-Parser-3.72			Perl5 module for parsing HTML documents
p5-HTML-Tagset-3.20_1		  Some useful data table in parsing HTML
pcre-8.42					  Perl Compatible Regular Expressions library
perl5-5.26.2				   Practical Extraction and Report Language
php56-5.6.37				   PHP Scripting Language
php56-pecl-APCu-4.0.11_1	   APC User Caching
php56-pecl-intl-3.0.0_15	   PECL extension to support Internationalization(ICU)
pkg-1.10.5_1				   Package manager
png-1.6.34					 Library for manipulating PNG images
printproto-1.0.5			   Print extension headers
python27-2.7.15				Interpreted object-oriented programming language
readline-7.0.3_1			   Library for editing command lines as they are typed
serf-1.3.9_3				   Serf HTTP client library
sqlite3-3.24.0_1			   SQL database engine in a C library
subversion-1.10.2			  Version control system
t1lib-5.1.2_4,1				Type 1 font rasterization library for Unix/X11
utf8proc-2.1.0				 UTF-8 processing library
xextproto-7.3.0				XExt extension headers
xproto-7.0.31				  X11 protocol headers


Code:
[root@freenas ~]# uname -a																										  
FreeBSD freenas.local 11.1-STABLE FreeBSD 11.1-STABLE #0 r321665+e0c4ca60dfc(freenas/11.1-stable): Wed May 30 14:18:20 EDT 2018	 
root@nemesis.tn.ixsystems.com:/freenas-11-releng/freenas/_BE/objs/freenas-11-releng/freenas/_BE/os/sys/FreeNAS.amd64  amd64		 
[root@freenas ~]# jls																											   
   JID  IP Address	  Hostname					  Path																		  
	 1				  OwnCloud					  /mnt/Raid1/jails/OwnCloud													 
[root@freenas ~]# jexec 1 tcsh																									  
root@OwnCloud:/ # uname -a																										  
FreeBSD OwnCloud 11.1-STABLE FreeBSD 11.1-STABLE #0 r321665+e0c4ca60dfc(freenas/11.1-stable): Wed May 30 14:18:20 EDT 2018	 root@
nemesis.tn.ixsystems.com:/freenas-11-releng/freenas/_BE/objs/freenas-11-releng/freenas/_BE/os/sys/FreeNAS.amd64  amd64
 

subalk

Dabbler
Joined
Jul 23, 2018
Messages
16
да я пробовал уже обновлять пакеты в Jale-е но это не помогло....
 

chs

Guru
Joined
Apr 18, 2017
Messages
500
Ну а если поставить вместо mariadb100 mariadb103 или mysql ?
 

subalk

Dabbler
Joined
Jul 23, 2018
Messages
16
попробовал поставить mariadb103 и mysql и также не запускается
Code:
root@OwnCloud:/usr/ports/databases/mysql80-server # tail -n 30 /var/db/mysql/OwnCloud.err
2018-08-08 14:48:07 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
2018-08-08 14:48:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-08-08 14:48:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-08-08 14:48:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-08-08 14:48:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-08-08 14:48:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-08-08 14:48:08 0 [Note] InnoDB: Waiting for purge to start
2018-08-08 14:48:08 0 [Note] InnoDB: 10.3.8 started; log sequence number 1603183; transaction id 9
2018-08-08 14:48:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2018-08-08 14:48:08 0 [Note] InnoDB: Cannot open '/var/db/mysql/ib_buffer_pool' for reading: No such file or directory
2018-08-08 14:48:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2018-08-08 14:48:08 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-08-08 14:48:08 0 [Note] Recovering after a crash using tc.log
2018-08-08 14:48:08 0 [Note] Starting crash recovery...
2018-08-08 14:48:08 0 [Note] Crash recovery finished.
2018-08-08 14:48:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-08-08 14:48:08 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-08-08T12:14:07.6NZ mysqld_safe Logging to '/var/db/mysql/OwnCloud.err'.
2018-08-08T12:14:07.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-08-08T12:14:07.754258Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-08-08T12:14:07.754389Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-08-08T12:14:07.754445Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-08-08T12:14:07.754470Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2018-08-08T12:14:07.754492Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2018-08-08T12:14:07.755487Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.11) starting as process 47415
2018-08-08T12:14:07.798872Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2018-08-08T12:14:07.799061Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-08-08T12:14:07.799087Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-08-08T12:14:07.801706Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.11)  Source distribution.
2018-08-08T12:14:07.6NZ mysqld_safe mysqld from pid file /var/db/mysql/OwnCloud.pid ended

 

chs

Guru
Joined
Apr 18, 2017
Messages
500
2018-08-08 14:48:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

Проблемы от предыдущей установки mysql.

Что надо -
1. удалить текущую установку mysql (pkg delete)
2. удалить каталоги от предыдущей установки mysql (/var/db/mysql)
3. Установить mysql (поправить, если надо my.cnf)
4. Запустить mysql_install_db
5. Проверить владельца и права на директорию /var/db/mysql ( если надо то выполнить chown -R mysql:mysql /var/db/mysql)
6. Стартовать сервис и посмотреть логи

Если лень то можно выполнить п. с 4 по 6 -по идее должно хватить
 

subalk

Dabbler
Joined
Jul 23, 2018
Messages
16
спасибо за инструкцию.... попробовал разные версии mysql норм запускается mysql56
 
Status
Not open for further replies.
Top