SoTKoM
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Posts posted by SoTKoM
-
-
В 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-discussPlease 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
И после этого уже стартуйте сервис. Если нет, то выкладывайте лог, в нем будет описание проблемы
Помогите, плз, запустить бд...
-
Здравствуйте.
Пытаюсь запустить web server.
Делал все по инструкции в теме.
После инсталляции необходимых пакетов были ошибки:
Collected errors: * opkg_install_cmd: Cannot install package php7-mod-mcrypt. * opkg_install_cmd: Cannot install package maria-client-extra.
С этим справился )))):
Выяснил, что в php7.2 модуль php7-mod-mcrypt удален, вместо maria-client-extra установил mariadb-client-extra.
Внес изменения в файлы конфигурации путем полного изменения соответствующих файлов.
Проблемы начались на первом этапе подготавливаем базу данных:
после
создаём БД
mysql_install_db --force
в терминал высыпались ошибки:
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ... 2018-11-26 14:57:27 1999042080 [ERROR] InnoDB: mmap(136249344 bytes) failed; errno 12 2018-11-26 14:57:27 1999042080 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2018-11-26 14:57:27 1999042080 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2018-11-26 14:57:27 1999042080 [ERROR] Plugin 'InnoDB' init function returned error. 2018-11-26 14:57:27 1999042080 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2018-11-26 14:57:27 1999042080 [ERROR] mysqld: Out of memory (Needed 130760704 bytes) 2018-11-26 14:57:27 1999042080 [ERROR] mysqld: Out of memory (Needed 98058240 bytes) 2018-11-26 14:57:27 1999042080 [ERROR] mysqld: Out of memory (Needed 73531392 bytes) 2018-11-26 14:57:27 1999042080 [ERROR] mysqld: Out of memory (Needed 55148544 bytes) 2018-11-26 14:57:27 1999042080 [ERROR] Unknown/unsupported storage engine: InnoDB 2018-11-26 14:57:27 1999042080 [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
Подскажите, пожалуйста, в чем проблема и как ее решить.
Спасибо.
P.S.:
/opt/etc/init.d/S70mariadbd - нет, но есть /opt/etc/init.d/S70mysqld
mariadb 10.x
in Вопросы по сборке и настройке Opkg
Posted · Edited by SoTKoM
(1) - извиняюсь, не слышал...
(2) - искал и в google и по форумам, ничего более-менее понятного по теме не нашел, к сожалению...
а можно "носом тыкнуть" где?
или новичкам не место в этом форуме?
"Спасибо" за ответ.