mariadb 10.x

Vadim-85 · 18 июня, 2018

Здравствуйте. Поставил

ext-ui-lighttpd-7

Всё хорошо, пытаюсь прикрутить mysql. Ставлю

mariadb-server, mariadb-client

Запускаю S70mysqld и не чего не происходит, не запускается.

Vadim-85 · 19 июня, 2018

9 часов назад, Mamay сказал:

И вас никто разу не смутило что ставите mariadb, а вызываете mysql??? Однако...

Вообще без понятия почему так, установил пакеты mariadb, но заместо S70mariadbd появилось S70mysqld

Скрытый текст

#!/bin/sh

PATH=/opt/bin:/opt/sbin:/sbin:/bin:/usr/sbin:/usr/bin

PIDFILE="/opt/var/run/mysqld.pid"
MYSQLD="/opt/bin/mysqld"

mysql_status ()
{
[ -f $PIDFILE ] && [ -d /proc/`cat $PIDFILE` ]
}

start()
{
$MYSQLD --pid-file=$PIDFILE > /dev/null 2>&1 &
}

stop()
{
   kill `cat $PIDFILE` > /dev/null 2>&1
}
case "$1" in
   start)
       if mysql_status
       then
           echo mysqld is already running
       else
           start
       fi
       ;;
   stop)
       if mysql_status
       then
           stop
       else
           echo mysqld is not running
       fi
       ;;
   status)
       if mysql_status
       then
           echo mysqld is already running
       else
           echo mysqld is not running
       fi
       ;;

   restart)
       stop
       sleep 3
       start
       ;;
   *)
       echo "Usage: $0 {start|stop|restart|status}"
       ;;
esac

Сносил всё, ставил mariadb + lighttpd + php. Всё запустилось, только кроме mariadb, всё так же как описано выше.

Lordmaster · 19 июня, 2018

4 минуты назад, Vadim-85 сказал:

Вообще без понятия почему так, установил пакеты mariadb, но заместо S70mariadbd появилось S70mysqld

Показать содержимое

#!/bin/sh

PATH=/opt/bin:/opt/sbin:/sbin:/bin:/usr/sbin:/usr/bin

PIDFILE="/opt/var/run/mysqld.pid"
MYSQLD="/opt/bin/mysqld"

mysql_status ()
{
   [ -f $PIDFILE ] && [ -d /proc/`cat $PIDFILE` ]
}

start()
{
   $MYSQLD --pid-file=$PIDFILE > /dev/null 2>&1 &
}

stop()
{
   kill `cat $PIDFILE` > /dev/null 2>&1
}
case "$1" in
   start)
       if mysql_status
       then
           echo mysqld is already running
       else
           start
       fi
       ;;
   stop)
       if mysql_status
       then
           stop
       else
           echo mysqld is not running
       fi
       ;;
   status)
       if mysql_status
       then
           echo mysqld is already running
       else
           echo mysqld is not running
       fi
       ;;

   restart)
       stop
       sleep 3
       start
       ;;
   *)
       echo "Usage: $0 {start|stop|restart|status}"
       ;;
esac

Сносил всё, ставил mariadb + lighttpd + php. Всё запустилось, только кроме mariadb, всё так же как описано выше.

Посмотрите как в других примерах ставится mariadb/mysql:

Как я понимаю вам сначала надо создать базу данных командой

mysql_install_db

И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы

Vadim-85 · 19 июня, 2018

2 часа назад, Lordmaster сказал:
Посмотрите как в других примерах ставится mariadb/mysql:

Как я понимаю вам сначала надо создать базу данных командой
mysql_install_db
И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы

Ага спасибо, читал уже, не выходит.

Скрытый текст

~ # mysql_install_db
~ # /opt/etc/init.d/S70mariadbd start
~ # mysqladmin -u root password "Passw0rd"
Warning: World-writable config file '/opt/etc/mysql/my.cnf' is ignored
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/var/run/mysqld.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/opt/var/run/mysqld.sock' exists!
~ #

my.cnf

Скрытый текст

[client]
port = 3306
socket = /opt/var/run/mysqld.sock

[mysqld]
user       = root
socket       = /opt/var/run/mysqld.sock
port       = 3306
basedir       = /opt

############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir = /opt/var/mysql/

######### This should also not go on the NAND #######
tmpdir = /opt/tmp/

skip-external-locking

bind-address = 127.0.0.1

# Fine Tuning
key_buffer       = 20M
max_allowed_packet   = 20M
thread_stack       = 192K
thread_cache_size = 8

# Here you can see queries with especially long duration
#log_slow_queries = /opt/var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

# The following can be used as easy to replay backup logs or for replication.
#server-id       = 1
#log_bin           = /opt/var/log/mysql/mysql-bin.log
#expire_logs_days   = 10
#max_binlog_size = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name

[mysqldump]
quick
quote-names
max_allowed_packet = 20M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 20M

Lordmaster · 19 июня, 2018

6 минут назад, Vadim-85 сказал:

Ага спасибо, читал уже, не выходит.

Показать содержимое

~ # mysql_install_db
~ # /opt/etc/init.d/S70mariadbd start
~ # mysqladmin -u root password "Passw0rd"
Warning: World-writable config file '/opt/etc/mysql/my.cnf' is ignored
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/var/run/mysqld.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/opt/var/run/mysqld.sock' exists!
~ #

my.cnf

Показать содержимое

[client]
port       = 3306
socket       = /opt/var/run/mysqld.sock

[mysqld]
user       = root
socket       = /opt/var/run/mysqld.sock
port       = 3306
basedir       = /opt

############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir       = /opt/var/mysql/

######### This should also not go on the NAND #######
tmpdir       = /opt/tmp/

skip-external-locking

bind-address       = 127.0.0.1

# Fine Tuning
key_buffer       = 20M
max_allowed_packet   = 20M
thread_stack       = 192K
thread_cache_size = 8

# Here you can see queries with especially long duration
#log_slow_queries   = /opt/var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

# The following can be used as easy to replay backup logs or for replication.
#server-id       = 1
#log_bin           = /opt/var/log/mysql/mysql-bin.log
#expire_logs_days   = 10
#max_binlog_size = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name

[mysqldump]
quick
quote-names
max_allowed_packet   = 20M

[mysql]
#no-auto-rehash   # faster start of mysql but no tab completition

[isamchk]
key_buffer       = 20M

Вот мой конфиг, вставьте его, попробуйте:

Скрытый текст

[client-server]
port = 3306
socket = /opt/var/run/mysqld.sock

# https://mariadb.com/kb/en/mariadb/server-system-variables/

[mysqld]
user       = root
pid-file   = /opt/var/run/mariadb.pid
basedir       = /opt
lc_messages_dir   = /opt/share/mysql
lc_messages   = en_US

############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir = /opt/var/mysql/

######### This should also not go on the NAND #######
tmpdir = /opt/tmp/

skip-external-locking

# this must be overridden, if replication is to be used
bind-address = 127.0.0.1

#
# * Fine Tuning
#
max_connections = 25
connect_timeout = 5
wait_timeout = 600
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
myisam_sort_buffer_size = 64K
thread_cache_size = 8
thread_stack = 128K
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

#
# * Query Cache Configuration
#
# Cache only tiny result sets, so we can fit more in the query cache.
query_cache_limit = 128K
query_cache_size = 2M
# for more write intensive setups, set to DEMAND or OFF
#query_cache_type = DEMAND

#
# * InnoDB
#
# Currently only InnoDB storage engine is supported by wsrep
default-storage-engine=innodb
# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2
#innodb_data_home_dir = /opt/var/mysql
innodb_data_file_path = ibdata1:10M:autoextend
# path to redo log files (can be put on separate file system)
#innodb_log_group_home_dir = /opt/var/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

#
# * Logging
#
# Be aware that this log type is a performance killer and that
# you can enable the log at runtime!
#general_log_file = /opt/var/log/mariadb.log
#general_log = 1
#
# Error logging goes to syslog due to /opt/etc/mariadb/conf.d/mysqld_safe_syslog.cnf.
#
# we do want to know about network errors and such
log_warnings = 2
#
# Enable the slow query log to see queries with especially long duration
slow_query_log=1
slow_query_log_file = /opt/var/log/mariadb-slow.log
long_query_time = 10
log_slow_rate_limit = 20
log_slow_verbosity = query_plan
log-queries-not-using-indexes
log_slow_admin_statements

#
# * Replication
#
# The following can be used as easy to replay backup logs or for replication.
# Replication Master Server (default)
#
#
# Replication Master
#
# required unique id between 1 and 2^32 - 1 defaults to 1 if
# master-host is not set but will not function as a master if omitted
server-id = 1
# binary logging is required for replication
log_bin = /opt/var/log/mariadb/mysql-bin.log
expire_logs_days   = 10
max_binlog_size = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name
#
#
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended
binlog_format=mixed

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /opt/etc/mysql/conf.d/

# * Plugins
ignore_builtin_innodb
plugin-load=innodb=ha_innodb.so;innodb_trx=ha_innodb.so;innodb_locks=ha_innodb.so;innodb_lock_waits=ha_innodb.so;
innodb_cmp=ha_innodb.so;innodb_cmp_reset=ha_innodb.so;innodb_cmpmem=ha_innodb.so;innodb_cmpmem_reset=ha_innodb.so

Vadim-85 · 19 июня, 2018

32 минуты назад, Lordmaster сказал:

Вот мой конфиг, вставьте его, попробуйте:

Показать содержимое

[client-server]
port       = 3306
socket       = /opt/var/run/mysqld.sock

# https://mariadb.com/kb/en/mariadb/server-system-variables/

[mysqld]
user       = root
pid-file   = /opt/var/run/mariadb.pid
basedir       = /opt
lc_messages_dir   = /opt/share/mysql
lc_messages   = en_US

############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir       = /opt/var/mysql/

######### This should also not go on the NAND #######
tmpdir       = /opt/tmp/

skip-external-locking

# this must be overridden, if replication is to be used
bind-address       = 127.0.0.1

#
# * Fine Tuning
#
max_connections   = 25
connect_timeout   = 5
wait_timeout = 600
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
myisam_sort_buffer_size = 64K
thread_cache_size = 8
thread_stack = 128K
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

#
# * Query Cache Configuration
#
# Cache only tiny result sets, so we can fit more in the query cache.
query_cache_limit = 128K
query_cache_size = 2M
# for more write intensive setups, set to DEMAND or OFF
#query_cache_type       = DEMAND

#
# * InnoDB
#
# Currently only InnoDB storage engine is supported by wsrep
default-storage-engine=innodb
# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2
#innodb_data_home_dir = /opt/var/mysql
innodb_data_file_path = ibdata1:10M:autoextend
# path to redo log files (can be put on separate file system)
#innodb_log_group_home_dir = /opt/var/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

#
# * Logging
#
# Be aware that this log type is a performance killer and that
# you can enable the log at runtime!
#general_log_file = /opt/var/log/mariadb.log
#general_log = 1
#
# Error logging goes to syslog due to /opt/etc/mariadb/conf.d/mysqld_safe_syslog.cnf.
#
# we do want to know about network errors and such
log_warnings = 2
#
# Enable the slow query log to see queries with especially long duration
slow_query_log=1
slow_query_log_file = /opt/var/log/mariadb-slow.log
long_query_time = 10
log_slow_rate_limit = 20
log_slow_verbosity = query_plan
log-queries-not-using-indexes
log_slow_admin_statements

#
# * Replication
#
# The following can be used as easy to replay backup logs or for replication.
# Replication Master Server (default)
#
#
# Replication Master
#
# required unique id between 1 and 2^32 - 1 defaults to 1 if
# master-host is not set but will not function as a master if omitted
server-id = 1
# binary logging is required for replication
log_bin = /opt/var/log/mariadb/mysql-bin.log
expire_logs_days   = 10
max_binlog_size = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name
#
#
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended
binlog_format=mixed

[mysqldump]
quick
max_allowed_packet   = 16M

[mysql]
#no-auto-rehash   # faster start of mysql but no tab completition

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /opt/etc/mysql/conf.d/

# * Plugins
ignore_builtin_innodb
plugin-load=innodb=ha_innodb.so;innodb_trx=ha_innodb.so;innodb_locks=ha_innodb.so;innodb_lock_waits=ha_innodb.so;
innodb_cmp=ha_innodb.so;innodb_cmp_reset=ha_innodb.so;innodb_cmpmem=ha_innodb.so;innodb_cmpmem_reset=ha_innodb.so

Скрытый текст

mysqladmin: Can't read dir of '/opt/etc/mysql/conf.d/' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted

создаю conf.d, получаю

Скрытый текст

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/var/run/mysqld.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/opt/var/run/mysqld.sock' exists!

TheBB · 21 июня, 2018

В 19.06.2018 в 14:06, Lordmaster сказал:

Вот мой конфиг...

конфиг бесполезен без установки плагинов, т.к. "в лучших традициях owrt борьбы за каждый свободный бит", пакеты раздробили на ещё более мелкие:

Скрытый текст


~ # opkg list | grep mariadb | awk '{print $1}'
libmariadbclient
mariadb-client
mariadb-client-extra
mariadb-extra-charsets
mariadb-server
mariadb-server-extra
mariadb-server-plugin-adt-null
mariadb-server-plugin-auth-0x0100
mariadb-server-plugin-auth-ed25519
mariadb-server-plugin-auth-socket
mariadb-server-plugin-auth-test-plugin
mariadb-server-plugin-client-ed25519
mariadb-server-plugin-debug-key-management
mariadb-server-plugin-dialog-examples
mariadb-server-plugin-disks
mariadb-server-plugin-example-key-management
mariadb-server-plugin-feedback
mariadb-server-plugin-file-key-management
mariadb-server-plugin-ha-archive
mariadb-server-plugin-ha-blackhole
mariadb-server-plugin-ha-connect
mariadb-server-plugin-ha-federated
mariadb-server-plugin-ha-federatedx
mariadb-server-plugin-ha-innodb
mariadb-server-plugin-ha-spider
mariadb-server-plugin-ha-test-sql-discovery
mariadb-server-plugin-handlersocket
mariadb-server-plugin-libdaemon-example
mariadb-server-plugin-locales
mariadb-server-plugin-metadata-lock-info
mariadb-server-plugin-mypluglib
mariadb-server-plugin-qa-auth-client
mariadb-server-plugin-qa-auth-interface
mariadb-server-plugin-qa-auth-server
mariadb-server-plugin-query-cache-info
mariadb-server-plugin-query-response-time
mariadb-server-plugin-semisync-master
mariadb-server-plugin-semisync-slave
mariadb-server-plugin-server-audit
mariadb-server-plugin-simple-password-check
mariadb-server-plugin-sql-errlog
mariadb-server-plugin-wsrep-info
~ #

TheBB · 21 июня, 2018

@Vadim-85 , т.к. написано и испробовано Вами много, напишите, на каком этапе отваливается?

1 установка БД `mysql_install_db`

Скрытый текст


~ # mysql_install_db 
WARNING: The host 'Keenetic_Giga' could not be looked up with /opt/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-06-21 12:28:32 2004998736 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:28:32 2004998736 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20721 ...
2018-06-21 12:28:32 2004998736 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:28:32 2004998736 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:28:32 2004998736 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:28:34 2004998736 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-06-21 12:28:34 2004998736 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-06-21 12:28:38 2004998736 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-06-21 12:28:49 2004998736 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-06-21 12:28:59 2004998736 [Warning] InnoDB: New log files created, LSN=45781
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Doublewrite buffer created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:00 2004998736 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Foreign key constraint system tables created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Tablespace and datafile system tables created.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:00 2004998736 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 0
2018-06-21 12:29:02 1494160512 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Filling help tables...
2018-06-21 12:29:05 2010380880 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:05 2010380880 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20753 ...
2018-06-21 12:29:05 2010380880 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:05 2010380880 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:05 2010380880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:05 2010380880 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616697
2018-06-21 12:29:05 1500578944 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2018-06-21 12:29:10 1998781008 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:10 1998781008 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20783 ...
2018-06-21 12:29:10 1998781008 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:10 1998781008 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:10 1998781008 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:10 1998781008 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616707
2018-06-21 12:29:10 1489044608 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/opt/bin/mysqladmin' -u root password 'new-password'
'/opt/bin/mysqladmin' -u root -h Keenetic_Giga password 'new-password'

Alternatively you can run:
'/opt/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/opt' ; /opt/bin/mysqld_safe --datadir='/opt/var/mysql/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

~ #

2 запуск сервисов/демонов `/opt/etc/init.d/S70mysqld start`

Скрытый текст


~ # ps | grep mysql | grep -v grep
15190 root      520m S    /opt/bin/mysqld --pid-file=/opt/var/run/mysqld.pid
~ #

3 задание пароля к БД `mysqladmin -u root password 'Your_Password'`

4 подключение к БД `mysql -u root -p`

Скрытый текст


~ # mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.33-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \q
Bye
~ #

+ hint

~ # mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
~ # echo "nameserver Keenetic_Giga" >> /etc/resolv.conf 
~ #

Изменено 21 июня, 2018 пользователем TheBB
+ "финт ушами"

Vadim-85 · 23 июня, 2018

В 21.06.2018 в 14:34, TheBB сказал:

@Vadim-85 , т.к. написано и испробовано Вами много, напишите, на каком этапе отваливается?

1 установка БД `mysql_install_db`

Показать содержимое



~ # mysql_install_db 
WARNING: The host 'Keenetic_Giga' could not be looked up with /opt/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-06-21 12:28:32 2004998736 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:28:32 2004998736 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20721 ...
2018-06-21 12:28:32 2004998736 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:28:32 2004998736 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:28:32 2004998736 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:28:34 2004998736 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-06-21 12:28:34 2004998736 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-06-21 12:28:38 2004998736 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-06-21 12:28:49 2004998736 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-06-21 12:28:59 2004998736 [Warning] InnoDB: New log files created, LSN=45781
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Doublewrite buffer created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:00 2004998736 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Foreign key constraint system tables created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Tablespace and datafile system tables created.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:00 2004998736 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 0
2018-06-21 12:29:02 1494160512 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Filling help tables...
2018-06-21 12:29:05 2010380880 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:05 2010380880 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20753 ...
2018-06-21 12:29:05 2010380880 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:05 2010380880 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:05 2010380880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:05 2010380880 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616697
2018-06-21 12:29:05 1500578944 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2018-06-21 12:29:10 1998781008 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:10 1998781008 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20783 ...
2018-06-21 12:29:10 1998781008 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:10 1998781008 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:10 1998781008 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:10 1998781008 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616707
2018-06-21 12:29:10 1489044608 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/opt/bin/mysqladmin' -u root password 'new-password'
'/opt/bin/mysqladmin' -u root -h Keenetic_Giga password 'new-password'

Alternatively you can run:
'/opt/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/opt' ; /opt/bin/mysqld_safe --datadir='/opt/var/mysql/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

~ #

2 запуск сервисов/демонов `/opt/etc/init.d/S70mysqld start`

Показать содержимое



~ # ps | grep mysql | grep -v grep
15190 root      520m S    /opt/bin/mysqld --pid-file=/opt/var/run/mysqld.pid
~ #

3 задание пароля к БД `mysqladmin -u root password 'Your_Password'`

4 подключение к БД `mysql -u root -p`

Показать содержимое



~ # mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.33-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \q
Bye
~ #

+ hint


~ # mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
~ # echo "nameserver Keenetic_Giga" >> /etc/resolv.conf 
~ #

На этом этапе

Скрытый текст

~ # mysql_install_db
WARNING: The host 'DESKTOP-N4MH2GT' could not be looked up with /opt/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-06-23 18:46:59 1997032016 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-23 18:46:59 1997032016 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 17800 ...
2018-06-23 18:46:59 1997032016 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2018-06-23 18:46:59 1997032016 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2018-06-23 18:46:59 1997032016 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-23 18:46:59 1997032016 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-23 18:46:59 1997032016 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-23 18:46:59 1997032016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-23 18:46:59 1997032016 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-23 18:46:59 1997032016 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-23 18:46:59 1997032016 [Note] InnoDB: Using generic crc32 instructions
2018-06-23 18:46:59 1997032016 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(138543104 bytes) failed; errno 12
2018-06-23 18:46:59 1997032016 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-06-23 18:46:59 1997032016 [ERROR] Plugin 'InnoDB' init function returned error.
2018-06-23 18:46:59 1997032016 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-06-23 18:46:59 1997032016 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-06-23 18:46:59 1997032016 [ERROR] Aborting

Installation of system tables failed! Examine the logs in
/opt/var/mysql/ for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /opt/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /opt/bin/mysqld --skip-grant-tables --general-log &

and use the command line tool /opt/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /opt/bin/mysql -u root mysql
mysql> show tables;

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /opt/var/mysql/ that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

~ #

Vadim-85 · 23 июня, 2018

Я так понял мне нужно реализовать swap + zram, как это сделать?

(config)> system zram это понятно, а файл swap как добавить?

Sergey Zozulya · 24 июня, 2018

@Vadim-85 создать swap раздел на носителе, он будет использоваться автоматически.

Vadim-85 · 10 июля, 2018

В 24.06.2018 в 11:49, Sergey Zozulya сказал:

@Vadim-85 создать swap раздел на носителе, он будет использоваться автоматически.

По мануалу пытаюсь создать swap

Скрытый текст

123.jpg.8f49982752c4ed7ed7bd917ea8b8ba23.jpg

Скрытый текст

(config)> system
Core::Configurator: Done.
(system)> swap 9430B54530B52EDC:swaparea 512
Swap::Manager: Pending swap area 9430B54530B52EDC:swaparea.
(system)> system configuration save
Core::ConfigurationSaver: Saving configuration...

Правильно делаю? И как проверить?

zyxmon · 11 июля, 2018

7 часов назад, Vadim-85 сказал:

Правильно делаю? И как проверить?

Вы темой ошиблись - тут обсуждают mariadb. В Entware используйте mkswap, swapon, swapoff. Вопросы по прошивке задавайте в другом месте!

евгений трофимов · 23 октября, 2018

Вопрос к знатокам.

При установке базы застрял на этапе задания пароля посредством mysqladmin

База крутится,PID-есть,но, файла mysqladmin - нету, как не шерстил систему...

Установленные пакеты mariadb-client - 10.2.17-1 mariadb-server - 10.2.17-1 lighttpd-mod-authn_mysql - 1.4.49-2

php7-mod-mysqli - 7.2.9-1 php7-mod-mysqlnd - 7.2.9-1 php7-mod-pdo-mysql - 7.2.9-1

Ошибок(вроде) небыло , конфиги не трогал, рестартовал-бесполезно....

Куда копать? Подскажите!!!

zyxmon · 23 октября, 2018

пакет mariadb в стиле openwrt разбит на почти 50 подпакетов. Нужный Вам бинарник в mariadb-client-extra

евгений трофимов · 23 октября, 2018

Все получилось!!! Спасибо за оперативность.Удачи....

SoTKoM · 3 декабря, 2018

В 21.06.2018 в 16:34, TheBB сказал:

@Vadim-85 , т.к. написано и испробовано Вами много, напишите, на каком этапе отваливается?

1 установка БД `mysql_install_db`

Показать содержимое



~ # mysql_install_db 
WARNING: The host 'Keenetic_Giga' could not be looked up with /opt/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-06-21 12:28:32 2004998736 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:28:32 2004998736 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20721 ...
2018-06-21 12:28:32 2004998736 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:28:32 2004998736 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:28:32 2004998736 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:28:32 2004998736 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:28:34 2004998736 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2018-06-21 12:28:34 2004998736 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2018-06-21 12:28:38 2004998736 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-06-21 12:28:49 2004998736 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-06-21 12:28:59 2004998736 [Warning] InnoDB: New log files created, LSN=45781
2018-06-21 12:28:59 2004998736 [Note] InnoDB: Doublewrite buffer not found: creating new
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Doublewrite buffer created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:00 2004998736 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Foreign key constraint system tables created
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Tablespace and datafile system tables created.
2018-06-21 12:29:00 2004998736 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:00 2004998736 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 0
2018-06-21 12:29:02 1494160512 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Filling help tables...
2018-06-21 12:29:05 2010380880 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:05 2010380880 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20753 ...
2018-06-21 12:29:05 2010380880 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:05 2010380880 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:05 2010380880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:05 2010380880 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:05 2010380880 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616697
2018-06-21 12:29:05 1500578944 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2018-06-21 12:29:10 1998781008 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2018-06-21 12:29:10 1998781008 [Note] /opt/bin/mysqld (mysqld 10.1.33-MariaDB) starting as process 20783 ...
2018-06-21 12:29:10 1998781008 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-06-21 12:29:10 1998781008 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-21 12:29:10 1998781008 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Using generic crc32 instructions
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Completed initialization of buffer pool
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: 128 rollback segment(s) are active.
2018-06-21 12:29:10 1998781008 [Note] InnoDB: Waiting for purge to start
2018-06-21 12:29:10 1998781008 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616707
2018-06-21 12:29:10 1489044608 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/opt/bin/mysqladmin' -u root password 'new-password'
'/opt/bin/mysqladmin' -u root -h Keenetic_Giga password 'new-password'

Alternatively you can run:
'/opt/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/opt' ; /opt/bin/mysqld_safe --datadir='/opt/var/mysql/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

~ #

2 запуск сервисов/демонов `/opt/etc/init.d/S70mysqld start`

Показать содержимое



~ # ps | grep mysql | grep -v grep
15190 root      520m S    /opt/bin/mysqld --pid-file=/opt/var/run/mysqld.pid
~ #

3 задание пароля к БД `mysqladmin -u root password 'Your_Password'`

4 подключение к БД `mysql -u root -p`

Показать содержимое



~ # mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.33-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \q
Bye
~ #

+ hint


~ # mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
~ # echo "nameserver Keenetic_Giga" >> /etc/resolv.conf 
~ #

У меня отваливается на 1 этапе (установка БД `mysql_install_db`)

Скрытый текст

~ # mysql_install_db
WARNING: The host 'Keenetic_Extra' could not be looked up with /opt/bin/resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-12-03 12:07:33 2010531360 [ERROR] InnoDB: mmap(136249344 bytes) failed; errno 12
2018-12-03 12:07:33 2010531360 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-12-03 12:07:33 2010531360 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-12-03 12:07:33 2010531360 [ERROR] Plugin 'InnoDB' init function returned error.
2018-12-03 12:07:33 2010531360 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-12-03 12:07:33 2010531360 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2018-12-03 12:07:33 2010531360 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2018-12-03 12:07:33 2010531360 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-12-03 12:07:33 2010531360 [ERROR] Aborting

Installation of system tables failed! Examine the logs in
/opt/var/mysql/ for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /opt/bin/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /opt/bin/mysqld --skip-grant-tables --general-log &

and use the command line tool /opt/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /opt/bin/mysql -u root mysql
mysql> show tables;

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /opt/var/mysql/ that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

Все устанавливал по примерам, результат одинаковый...

В 19.06.2018 в 14:42, Lordmaster сказал:
Посмотрите как в других примерах ставится mariadb/mysql:

Как я понимаю вам сначала надо создать базу данных командой
mysql_install_db
И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы

Помогите, плз, запустить бд...

zyxmon · 3 декабря, 2018

@SoTKoM (1) a вы не слышали про избыточное цитирование (overquoting) - это когда ваше сообщение меньше цитируемого текста. За это наказывают, например, лишают права писать на форуме. (2) в ggogle не пробовали поискать причину ошибки? ответ будет сразу, решение есть в этой теме.

Entware для тех, кто способен сам искать решения, использовать поиск. Тупое следование инструкциям не работает. Инструкция верна в момент написания - через месяц-другой уже могут быть уточнения, изменения, которые легко гуглятся.

SoTKoM · 3 декабря, 2018

(1) - извиняюсь, не слышал...

(2) - искал и в google и по форумам, ничего более-менее понятного по теме не нашел, к сожалению...

2 часа назад, zyxmon сказал:

решение есть в этой теме

а можно "носом тыкнуть" где?

или новичкам не место в этом форуме?

"Спасибо" за ответ.

Изменено 3 декабря, 2018 пользователем SoTKoM

zyxmon · 3 декабря, 2018

4 часа назад, SoTKoM сказал:

или новичкам не место в этом форуме?

Формулировка неверная. Тем, кто не умеет пользоваться google и yandex не стоит устанавливать Entware.

Войти

mariadb 10.x

Рекомендуемые сообщения

Vadim-85

Vadim-85

Lordmaster

Vadim-85

Lordmaster

Vadim-85

TheBB

TheBB

Vadim-85

Vadim-85

Sergey Zozulya

Vadim-85

zyxmon

евгений трофимов

zyxmon

евгений трофимов

SoTKoM

zyxmon

SoTKoM

zyxmon

Присоединяйтесь к обсуждению

Последние посетители 0 пользователей онлайн

Обзор

Активность

Магазин

My Details

Важная информация