Vadim-85 Posted June 18, 2018 Share Posted June 18, 2018 Здравствуйте. Поставил ext-ui-lighttpd-7 Всё хорошо, пытаюсь прикрутить mysql. Ставлю mariadb-server, mariadb-client Запускаю S70mysqld и не чего не происходит, не запускается. 1 Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted June 19, 2018 Author Share Posted June 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, всё так же как описано выше. Quote Link to comment Share on other sites More sharing options...
Lordmaster Posted June 19, 2018 Share Posted June 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 И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted June 19, 2018 Author Share Posted June 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 Quote Link to comment Share on other sites More sharing options...
Lordmaster Posted June 19, 2018 Share Posted June 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 Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted June 19, 2018 Author Share Posted June 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! Quote Link to comment Share on other sites More sharing options...
TheBB Posted June 21, 2018 Share Posted June 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 ~ # Quote Link to comment Share on other sites More sharing options...
TheBB Posted June 21, 2018 Share Posted June 21, 2018 (edited) @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 ~ # Edited June 21, 2018 by TheBB + "финт ушами" Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted June 23, 2018 Author Share Posted June 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 athttps://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 ~ # Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted June 23, 2018 Author Share Posted June 23, 2018 Я так понял мне нужно реализовать swap + zram, как это сделать? (config)> system zram это понятно, а файл swap как добавить? Quote Link to comment Share on other sites More sharing options...
Sergey Zozulya Posted June 24, 2018 Share Posted June 24, 2018 @Vadim-85 создать swap раздел на носителе, он будет использоваться автоматически. Quote Link to comment Share on other sites More sharing options...
Vadim-85 Posted July 10, 2018 Author Share Posted July 10, 2018 В 24.06.2018 в 11:49, Sergey Zozulya сказал: @Vadim-85 создать swap раздел на носителе, он будет использоваться автоматически. По мануалу пытаюсь создать swap Скрытый текст Скрытый текст (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... Правильно делаю? И как проверить? Quote Link to comment Share on other sites More sharing options...
zyxmon Posted July 11, 2018 Share Posted July 11, 2018 7 часов назад, Vadim-85 сказал: Правильно делаю? И как проверить? Вы темой ошиблись - тут обсуждают mariadb. В Entware используйте mkswap, swapon, swapoff. Вопросы по прошивке задавайте в другом месте! Quote Link to comment Share on other sites More sharing options...
евгений трофимов Posted October 23, 2018 Share Posted October 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 Ошибок(вроде) небыло , конфиги не трогал, рестартовал-бесполезно.... Куда копать? Подскажите!!! Quote Link to comment Share on other sites More sharing options...
zyxmon Posted October 23, 2018 Share Posted October 23, 2018 пакет mariadb в стиле openwrt разбит на почти 50 подпакетов. Нужный Вам бинарник в mariadb-client-extra Quote Link to comment Share on other sites More sharing options...
евгений трофимов Posted October 23, 2018 Share Posted October 23, 2018 Все получилось!!! Спасибо за оперативность.Удачи.... Quote Link to comment Share on other sites More sharing options...
SoTKoM Posted December 3, 2018 Share Posted December 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 athttps://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 И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы Помогите, плз, запустить бд... Quote Link to comment Share on other sites More sharing options...
zyxmon Posted December 3, 2018 Share Posted December 3, 2018 @SoTKoM (1) a вы не слышали про избыточное цитирование (overquoting) - это когда ваше сообщение меньше цитируемого текста. За это наказывают, например, лишают права писать на форуме. (2) в ggogle не пробовали поискать причину ошибки? ответ будет сразу, решение есть в этой теме. Entware для тех, кто способен сам искать решения, использовать поиск. Тупое следование инструкциям не работает. Инструкция верна в момент написания - через месяц-другой уже могут быть уточнения, изменения, которые легко гуглятся. Quote Link to comment Share on other sites More sharing options...
SoTKoM Posted December 3, 2018 Share Posted December 3, 2018 (edited) (1) - извиняюсь, не слышал... (2) - искал и в google и по форумам, ничего более-менее понятного по теме не нашел, к сожалению... 2 часа назад, zyxmon сказал: решение есть в этой теме а можно "носом тыкнуть" где? или новичкам не место в этом форуме? "Спасибо" за ответ. Edited December 3, 2018 by SoTKoM Quote Link to comment Share on other sites More sharing options...
zyxmon Posted December 3, 2018 Share Posted December 3, 2018 4 часа назад, SoTKoM сказал: или новичкам не место в этом форуме? Формулировка неверная. Тем, кто не умеет пользоваться google и yandex не стоит устанавливать Entware. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.