Jump to content

SoTKoM

Forum Members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by SoTKoM

    mariadb 10.x

    in Вопросы по сборке и настройке Opkg

    Posted · Edited by SoTKoM

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

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

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

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

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

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

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

    mariadb 10.x

    in Вопросы по сборке и настройке Opkg

    Posted

    В 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

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

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

    Wordpress на entware

    in Вопросы по сборке и настройке Opkg

    Posted · Edited by SoTKoM

    Здравствуйте.

    Пытаюсь запустить 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
×
×
  • Create New...