Wordpress на entware

[Villi]

18 минут назад, gexweb сказал:

Подскажите, я хочу сделать импорт бд + нужно выполнить несколько SQL команд. На хостинге все понятно php my admin, как провернуть это на кинетике?

Я использую Navicat для импорта/экспорта

[gexweb]

Я буду дико благодарен если мне кто-нибудь разжует установку phpmyadmin, также как установку вп выше. Ссылка выше на какое-то бетта-тестирование, ломать то что уже установлено жалко как-то ) Может есть гуманный способ доустановки пакетиков?

[zyxmon]

1 час назад, gexweb сказал:

Ссылка выше на какое-то бетта-тестирование

Тестирование закончено. Инфа осталась. Взяли дистрибутив phpmyadmin, распаковали, подправили конфиг и пользуйтесь. Вот и вся инструкция.

[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

Edited November 26, 2018 by SoTKoM

[Scavi]

В 26.11.2018 в 11:52, 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

 Аналогичная ситуация

[TheBB]

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

 Аналогичная ситуация

памяти маловато, swap подключайте.

---

2-й пост темы обновился

[Scavi]

Все получилось сделать по обновленной инструкции. TheBB, спасибо за поддержку.

 

[ALALNIK]

Подскажите из-за чего могут быть ошибки?

Collected errors:
 * opkg_install_cmd: Cannot install package php.
 * opkg_install_cmd: Cannot install package 7-mod-pdo-mysql.
 

[TheBB]

17 минут назад, ALALNIK сказал:

Подскажите из-за чего могут быть ошибки?

пробел затесался (уже исправлено)

В 14.11.2016 в 20:58, TheBB сказал:

php 7-mod-pdo-mysql => php7-mod-pdo-mysql

 

[ALALNIK]

Дошел до этого шага. Какой-то ERROR.

 

 

~ # mysql_install_db --force
Installing MariaDB/MySQL system tables in '/opt/var/mysql' ...
2019-03-28 23:08:09 1997152272 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2019-03-28 23:08:09 1997152272 [Warning] InnoDB: Linux Native AIO disabled.
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/

[ALALNIK]

При запуске сервиса должно выводиться что он стартанул? У меня чот не выводится.

 

 

/opt/etc/init.d/S70mysqld start
/opt # mysqladmin -u root password "123"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/opt/var/run/mysqld/mysqld.sock' exists!
 

[ALALNIK]

Поправил через notepad++  строки зайдя через smb на флешку.

Ругается на файл, может быть из-а того , что его нужно как-то из busybox править?

 

~ # mysql_install_db --force
Warning: World-writable config file '/opt/etc/mysql/conf.d/50-server.cnf' is ignored
Installing MariaDB/MySQL system tables in '/opt/data' ...
Warning: World-writable config file '/opt/etc/mysql/conf.d/50-server.cnf' is ignored
2019-03-29  7:32:58 1996738576 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.

[TheBB]

В 28.03.2019 в 23:14, ALALNIK сказал:

При запуске сервиса должно выводиться что он стартанул? У меня чот не выводится.

Теперь должен запускаться, пакеты обновлены...

[Villi]

В 28.03.2019 в 23:11, ALALNIK сказал:

Дошел до этого шага. Какой-то ERROR.

 

 

~ # mysql_install_db --force
Installing MariaDB/MySQL system tables in '/opt/var/mysql' ...
2019-03-28 23:08:09 1997152272 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2019-03-28 23:08:09 1997152272 [Warning] InnoDB: Linux Native AIO disabled.
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/

В /opt/etc/mysql/conf.d/50-server.cnf Добавить строку:

innodb_use_native_aio = 0

 

[vladi5700]

On 11/14/2016 at 8:58 PM, TheBB said:

создаём БД

mysql_install_db --force

запускаем сервис

/opt/etc/init.d/S70mysqld start

задаем пароль для доступа к БД (в примере ниже - Passw0rd)

mysqladmin -u root password "Passw0rd"

Застрял на этом этапе.... 

Была ошибка 

2019-03-28 23:08:09 1997152272 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2019-03-28 23:08:09 1997152272 [Warning] InnoDB: Linux Native AIO disabled.

но ее поборол советом из поста выше

 

Также сначала были ошибки при ~ # mysql_install_db --force

InnoDB: mmap(136249344 bytes) failed; errno 12
InnoDB: Cannot allocate memory for the buffer pool
InnoDB: Plugin initialization aborted with error Generic error
Plugin 'InnoDB' init function returned error.
Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysqld: Out of memory (Needed 130760704 bytes)
Out of memory (Needed 98058240 bytes)
Out of memory (Needed 73531392 bytes)
mysqld: Out of memory (Needed 55148544 bytes)
nknown/unsupported storage engine: InnoDB
Aborting

я так понял мало памяти и по совету из интернета я уменишил до 20 кол-во max_connections в конфигурационном файле /etc/my.cnf, теперь просто

 

~ # mysql_install_db --force
~ # /opt/etc/init.d/S70mysqld start
~ # mysqladmin -u root password "Passw0rd"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/var/run/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/opt/var/run/mysqld.sock' exists!
~ #
 

Вроде как не запущен получается, но при ~ # /opt/etc/init.d/S70mysqld start никаких ошибок нет, но 

~ # /opt/etc/init.d/S70mysqld status
mysqld is not running
 

т е ~ # mysql_install_db --force вроде ошибку не вызывает, но и ничего не происходит.... Может я что не так сделал? Или это вообще гиблое дело и просто физически мало памяти у Viva первого поколения? Мне в принципе и одного двух одновременных подключений хватило бы. Как накопитель у меня подключен USB SSD, попробую swap файл создать

 

UPD Все заработало со swap файлом на 512Мб (Хотя используется только 20) 

Edited April 26, 2019 by vladi5700

[ALALNIK]

Collected errors:
 * opkg_install_cmd: Cannot install package php7-fastcgi.
 * opkg_install_cmd: Cannot install package php7-mod-exif.
 * opkg_install_cmd: Cannot install package php7-mod-json.
 * opkg_install_cmd: Cannot install package php7-pecl-mcrypt.
 

 

Это так и должно быть? После 1го шага?

[ALALNIK]

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.2.24-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)]> create database wp
    -> \q
Bye
~ # cd /opt/etc/init.d
/opt/etc/init.d # ./S70mysqld restart && ./S79php7-fcgi start && ./S80nginx start
 Starting php-fcgi...              failed.
 

[ALALNIK]

В общем php7 все пакеты встали.

Не надо было делать upgrade. Entware

MariaDB тоже без ошибок встала.

Теперь засада вот в чем.

~ # cd /opt/etc/init.d
/opt/etc/init.d # ./S70mysqld restart && ./S79php7-fcgi start && ./S80nginx star
t
./S79php7-fcgi: .: line 12: can't open '/opt/etc/init.d/rc.func': No such file or directory
/opt/etc/init.d #
 

ругается на rc.func на который ссылается S79php7-fcgi

В чем может быть проблема? Я вроде делал его S79php7-fcgi исполняемым. Так как по инструкции сказано.

 

Вот содержание S79php7-fcgi как по инструкции 

#!/bin/sh

export PHP_FCGI_CHILDREN=''

ENABLED=yes
PROCS=php-fcgi
ARGS="-b /opt/var/run/php-fcgi.sock"
PREARGS=""
DESC=$PROCS
PATH=/opt/bin:/opt/sbin:/opt/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

. /opt/etc/init.d/rc.func

 

А вот rc.func

#!/bin/sh

ACTION=$1
CALLER=$2

ansi_red="\033[1;31m";
ansi_white="\033[1;37m";
ansi_green="\033[1;32m";
ansi_yellow="\033[1;33m";
ansi_blue="\033[1;34m";
ansi_bell="\007";
ansi_blink="\033[5m";
ansi_std="\033[m";
ansi_rev="\033[7m";
ansi_ul="\033[4m";

start() {
    [ "$CRITICAL" != "yes" -a "$CALLER" = "cron" ] && return 7
        [ "$ENABLED" != "yes" ] && return 8
    echo -e -n "$ansi_white Starting $DESC... $ansi_std"
    if [ -n "`pidof $PROC`" ]; then
        echo -e "            $ansi_yellow already running. $ansi_std"
        return 0
    fi
    $PRECMD > /dev/null 2>&1
    $PREARGS $PROC $ARGS > /dev/null 2>&1 &
    #echo $PREARGS $PROC $ARGS 
    COUNTER=0
    LIMIT=10
    while [ -z "`pidof $PROC`" -a "$COUNTER" -le "$LIMIT" ]; do
        sleep 1;
        COUNTER=`expr $COUNTER + 1`
    done
    $POSTCMD > /dev/null 2>&1

    if [ -z "`pidof $PROC`" ]; then
        echo -e "            $ansi_red failed. $ansi_std"
        logger "Failed to start $DESC from $CALLER."
        return 255
    else
        echo -e "            $ansi_green done. $ansi_std"
        logger "Started $DESC from $CALLER."
        return 0
    fi
}

stop() {
    case "$ACTION" in
        stop | restart)
            echo -e -n "$ansi_white Shutting down $PROC... $ansi_std"
            killall $PROC 2>/dev/null
            COUNTER=0
            LIMIT=10
            while [ -n "`pidof $PROC`" -a "$COUNTER" -le "$LIMIT" ]; do
                sleep 1;
                COUNTER=`expr $COUNTER + 1`
            done
            ;;
        kill)
            echo -e -n "$ansi_white Killing $PROC... $ansi_std"
            killall -9 $PROC 2>/dev/null
            ;;
    esac

    if [ -n "`pidof $PROC`" ]; then
        echo -e "            $ansi_red failed. $ansi_std"
        return 255
    else
        echo -e "            $ansi_green done. $ansi_std"
        return 0
    fi
}

check() {
    echo -e -n "$ansi_white Checking $DESC... "
    if [ -n "`pidof $PROC`" ]; then
        echo -e "            $ansi_green alive. $ansi_std";
        return 0
    else
        echo -e "            $ansi_red dead. $ansi_std";
        return 1
    fi
}

reconfigure() {
    SIGNAL=SIGHUP
    echo -e "$ansi_white Sending $SIGNAL to $PROC... $ansi_std"
    killall -$SIGNAL $PROC 2>/dev/null
}

for PROC in $PROCS; do
    case $ACTION in
        start)
            start
            ;;
        stop | kill )
            check && stop
            ;;
        restart)
            check > /dev/null && stop
            start
            ;;
        check)
            check
            ;;
        reconfigure)
            reconfigure
            ;;
        *)
            echo -e "$ansi_white Usage: $0 (start|stop|restart|check|kill|reconfigure)$ansi_std"
            exit 1
            ;;
    esac
done

#logger "Leaving ${0##*/}."
 

И кстати у меня почему-то папка из под putty не создавалась

mkdir /opt/share/www

tar xzvf worldpress* -C /opt/share/www/

, приходилось все через smb и notepad++ править.

[SKREBYSHI SKR]

Подскажите что нужно править

Добавляем путь до `mysqld.sock` в следующие файлы:

echo "pdo_mysql.default_socket=/opt/var/run/mysqld.sock" >> /opt/etc/php7/20_pdo_mysql.ini
echo "mysqli.default_socket=/opt/var/run/mysqld.sock" >> /opt/etc/php7/30_mysqli.ini

[SKREBYSHI SKR]

Поскажите, как можно сделать вход на вордпресс по доменному имени без :88/wordpress/ 

[SKREBYSHI SKR]

При установке 

mysql_install_db --force

выдает ошибку

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

/opt/etc/init.d # mysql_install_db --force
Installing MariaDB/MySQL system tables in '/opt/var/mysql' ...
2020-01-21 15:25:06 1998831632 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-01-21 15:25:06 1998831632 [Warning] InnoDB: Linux Native AIO disabled.
2020-01-21 15:25:06 1998831632 [ERROR] InnoDB: mmap(136183808 bytes) failed; errno 12
2020-01-21 15:25:06 1998831632 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-01-21 15:25:06 1998831632 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-01-21 15:25:06 1998831632 [ERROR] Plugin 'InnoDB' init function returned error.
2020-01-21 15:25:06 1998831632 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-01-21 15:25:06 1998831632 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2020-01-21 15:25:06 1998831632 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2020-01-21 15:25:06 1998831632 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
2020-01-21 15:25:06 1998831632 [ERROR] mysqld: Out of memory (Needed 55148544 bytes)
2020-01-21 15:25:06 1998831632 [ERROR] mysqld: Out of memory (Needed 41361408 bytes)
2020-01-21 15:25:08 1998831632 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-01-21 15:25:08 1998831632 [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

/opt/etc/init.d #
 

 

[TheBB]

swap?

KN-1410:

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

~ # mysql_install_db 
WARNING: The host 'Keenetic_Omni' 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' ...
2020-01-21 16:57:22 1996877840 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-01-21 16:57:22 1996877840 [Warning] InnoDB: Linux Native AIO disabled.
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_Omni 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/

~ #

 

 

[RVP]

Делал по инструкции, уперся в mysql, изучив выше написанное сделал: swap, nnodb_use_native_aio = 0 в конфигурации

получаю:

Spoiler

mysql_install_db --force
Could not find plugin directory.
Will continue with "/opt/lib/mariadb/plugin".
Installing MariaDB/MySQL system tables in '/opt/var/lib/mysql' ...
OK

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

Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is root@localhost, it has no password either, but
you need to be the system 'root' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

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/lib/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/

 

 

 

[Melandr]

Доброй ночи! Пытаюсь установить mysql. Делал по инструкции https://hqt.ro/how-to-install-mysql-server-phpmyadmin-through-entware-ng/

Не пошло. Далее из этой темы пробовал создавать базу данных разными командами, ниже листинг из консоли:

Spoiler

admin@RT-AC66U_B1:/tmp/home/root# /opt/bin/mysql_install_db

Could not find plugin directory.

Will continue with "/opt/lib/mariadb/plugin".

WARNING: The host 'RT-AC66U_B1' 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/lib/mysql' ...

2020-02-06 20:01:39 0 [ERROR] mysqld: File '/opt/var/log/mysql/mysql-bin.index' not found (Errcode: 2 "No such file or directory")

2020-02-06 20:01:39 0 [ERROR] Aborting

Installation of system tables failed!  Examine the logs in

/opt/var/lib/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/lib/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

 

Spoiler

admin@RT-AC66U_B1:/tmp/home/root# mysql_install_db --force

Could not find plugin directory.

Will continue with "/opt/lib/mariadb/plugin".

Installing MariaDB/MySQL system tables in '/opt/var/lib/mysql' ...

2020-02-06 20:05:04 0 [ERROR] mysqld: File '/opt/var/log/mysql/mysql-bin.index' not found (Errcode: 2 "No such file or directory")

2020-02-06 20:05:04 0 [ERROR] Aborting

Installation of system tables failed!  Examine the logs in

/opt/var/lib/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/lib/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

 

Spoiler

admin@RT-AC66U_B1:/tmp/home/root# /opt/bin/mysql_install_db --defaults-file=~/.m

y.cnf

Could not open required defaults file: /root/.my.cnf

Fatal error in defaults handling. Program aborted

WARNING: The host 'RT-AC66U_B1' 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/data' ...

Could not open required defaults file: /root/.my.cnf

Fatal error in defaults handling. Program aborted

 

Installation of system tables failed!  Examine the logs in

/opt/data 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/data 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

 

Spoiler

admin@RT-AC66U_B1:/tmp/home/root# opkg install mariadb-server mariadb-client-ext

ra

Package mariadb-server (10.4.10-1) installed in root is up to date.

Installing mariadb-client-extra (10.4.10-1) to root...

Downloading http://bin.entware.net/armv7sf-k2.6/mariadb-client-extra_10.4.10-1_armv7-2.6.ipk

Installing libncurses (6.1-5) to root...

Downloading http://bin.entware.net/armv7sf-k2.6/libncurses_6.1-5_armv7-2.6.ipk

Installing libedit (20191025-3.1-1) to root...

Downloading http://bin.entware.net/armv7sf-k2.6/libedit_20191025-3.1-1_armv7-2.6.ipk

Installing mariadb-client-base (10.4.10-1) to root...

Downloading http://bin.entware.net/armv7sf-k2.6/mariadb-client-base_10.4.10-1_armv7-2.6.ipk

Installing mariadb-client (10.4.10-1) to root...

Downloading http://bin.entware.net/armv7sf-k2.6/mariadb-client_10.4.10-1_armv7-2.6.ipk

Configuring libncurses.

Configuring libedit.

Configuring mariadb-client-base.

Configuring mariadb-client.

Configuring mariadb-client-extra.

admin@RT-AC66U_B1:/tmp/home/root# mysql_install_db

Could not find plugin directory.

Will continue with "/opt/lib/mariadb/plugin".

WARNING: The host 'RT-AC66U_B1' 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/lib/mysql' ...

2020-02-06 21:39:27 0 [ERROR] mysqld: File '/opt/var/log/mysql/mysql-bin.index' not found (Errcode: 2 "No such file or directory")

2020-02-06 21:39:27 0 [ERROR] Aborting

 

Installation of system tables failed!  Examine the logs in

/opt/var/lib/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/lib/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

MySQL не запускается. Не подскажите, в какую сторону копать?

Edited February 6, 2020 by Melandr

[zyxmon]

@Melandr может Вам сюда перебраться - https://forum.asus.ru/

Это форум по кинеткам.

[Melandr]

Извините, намек понял. 

Я конечно там очень много найду

[TheBB]

16 часов назад, RVP сказал:

Делал по инструкции, уперся в mysql, изучив выше написанное сделал: swap, nnodb_use_native_aio = 0 в конфигурации

В чем суть вопроса?

---

"маньяки-расчленители" в очередной раз по глумились на трупом бедной "Машки", распилив её останки на ещё более мелкие части (привет owrt`шникам) )))

бага(?): забыл вкорячить каталог для pid`a & socket`a `mkdir /opt/var/run/mysqld`

[TheBB]

16 часов назад, Melandr сказал:

MySQL не запускается. Не подскажите, в какую сторону копать?

"отсюда и до вечера" ))) А, если сурьёзно, надо иметь на руках такую железяку, чтоб видеть работу. Теоретически: места мало для бинарных логов ("Машка любит вкусно поесть")

Цитата

[ERROR] mysqld: File '/opt/var/log/mysql/mysql-bin.index' not found (Errcode: 2 "No such file or directory")

 

[RVP]

не стартовал сервис, 

бага(?): забыл вкорячить каталог для pid`a & socket`a `mkdir /opt/var/run/mysqld`

после этого все стартануло, спасибо! 

я расчитывал что по mysql_install_db создает все что нужно для старта, может стоит добавить в инструкцию?

[Melandr]

TheBB, доброй ночи! Если не трудно посмотреть вывод консоли и лог mysql. Как Вы выше упомянули, подозрение на недостаток памяти

Это лог ошибок mysql - /opt/var/log/mysql/error.log

Spoiler

2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 55148544 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 41361408 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 31014912 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 23248896 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 17424384 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 2031616 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Out of memory (Needed 262144 bytes)
2020-02-07 12:55:34 0 [ERROR] mysqld: Aria engine: log initialization failed
2020-02-07 12:55:34 0 [ERROR] Plugin 'Aria' init function returned error.
2020-02-07 12:55:34 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
200207 12:55:34 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 10.4.10-MariaDB
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 351726 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x30000
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /tmp/mnt/FLASH/var/lib/mysql
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            2088960              unlimited            bytes     
Max core file size        0                    0                    bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             1996                 1996                 processes 
Max open files            4184                 4184                 files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       1996                 1996                 signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us        
Core pattern: core

2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 55148544 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 41361408 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 31014912 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 23248896 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 17424384 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 2031616 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Out of memory (Needed 1523712 bytes)
2020-02-07 19:30:17 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2020-02-07 19:30:17 0 [ERROR] Plugin 'Aria' init function returned error.
2020-02-07 19:30:17 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
200207 19:30:17 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 10.4.10-MariaDB
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 351726 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x30000
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /tmp/mnt/FLASH/var/lib/mysql
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            2088960              unlimited            bytes     
Max core file size        0                    0                    bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             1996                 1996                 processes 
Max open files            4184                 4184                 files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       1996                 1996                 signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us        
Core pattern: core

2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 55148544 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 41361408 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 31014912 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 23248896 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 17424384 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 2031616 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 1523712 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 1130496 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Out of memory (Needed 262144 bytes)
2020-02-07 19:38:24 0 [ERROR] mysqld: Aria engine: log initialization failed
2020-02-07 19:38:24 0 [ERROR] Plugin 'Aria' init function returned error.
2020-02-07 19:38:24 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
200207 19:38:25 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 10.4.10-MariaDB
key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 351726 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x30000
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /tmp/mnt/FLASH/var/lib/mysql
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            2088960              unlimited            bytes     
Max core file size        0                    0                    bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             1996                 1996                 processes 
Max open files            4184                 4184                 files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       1996                 1996                 signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us        
Core pattern: core
 

А это вывод консоли при создании базы данных

Spoiler

admin@RT-AC66U_B1:/tmp/home/root# /opt/bin/mysql_install_db
Could not find plugin directory.
Will continue with "/opt/lib/mariadb/plugin".
WARNING: The host 'RT-AC66U_B1' 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/lib/mysql' ...
Segmentation fault

Installation of system tables failed!  Examine the logs in
/opt/var/lib/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/lib/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

admin@RT-AC66U_B1:/tmp/home/root#
 

Вопрос по swap файлу. На форуме нашел инструкции по созданию swap -файла. Но хотел уточнить пару моментов:

1. Его необходимо создать как файл на примонтированной флешке, или как отдельный раздел на этой же флешке?

2. Смущает момент подключения и отключения swap файла при перезагрузке роутера. Я так понимаю нужно  сделать два скрипта на подключение файла при загрузке и отключение файла при перезагрузке (отключении). Вроде бы нашел скрипт на 

To enable swap file when router booting, add this lines to /jffs/scripts/post-mount script

echo "" >>/jffs/scripts/post-mount
echo "swapon /opt/swap" >>/jffs/scripts/post-mount

To unmount swap add this lines to /jffs/scripts/services-stop script

echo "" >>/jffs/scripts/services-stop
echo "swapoff /opt/swap" >>/jffs/scripts/services-stop

Но у меня для автозапуска используются скрипты из папки /opt/etc/init.d/

3. Также еще вопрос монтирования и размонтирования флешки, используемой для Entware, Тоже необходимы скрипты для корректного отключения и подключения swap-файла?