MYSQL Server

[Ahmed Ensar]

Google Translate:

How can I install mysql server opkg version: http://bin.entware.net/mipssf-k3.4/  

this is not working "opkg install mysql-server"

[TheBB]

mysql was replaced with mariadb

~ # opkg list | grep mariadb | grep mysql
mariadb-client - 10.4.10-1a - MariaDB is a very fast and robust SQL database server.  This package includes the following core client binaries:  mysql mysqlcheck
mariadb-client-extra - 10.4.10-1a - MariaDB is a very fast and robust SQL database server.  This package includes the following extra client binaries:  mysql_find_rows mysql_waitpid mysqlaccess mysqladmin mysqldump mysqlimport mysqlshow mysqlslap mytop
mariadb-common - 1.0-1 - MariaDB is a very fast and robust SQL database server.  This package includes shared files, for example /opt/etc/mysql/my.cnf.
mariadb-server - 10.4.10-1a - MariaDB is a very fast and robust SQL database server.  This package includes the following core server binaries:  innochecksum my_print_defaults mysql_install_db mysql_upgrade mysqld
mariadb-server-extra - 10.4.10-1a - MariaDB is a very fast and robust SQL database server.  This package includes the following extra server binaries:  aria_chk aria_dump_log aria_ftdump aria_pack aria_read_log mariabackup msql2mysql myisam_ftdump myisamchk myisamlog myisampack mysql_convert_table_format mysql_fix_extensions mysql_plugin mysql_secure_installation mysql_setpermission mysql_tzinfo_to_sql mysqlbinlog mysqld_multi mysqldumpslow mysqlhotcopy perror replace resolve_stack_dump wsrep_sst_mariabackup wsrep_sst_mysqldump wsrep_sst_rsync wsrep_sst_rsync_wan
~ # 

command to get full list the packages

opkg list | grep mariadb

 

[Ahmed Ensar]

Google Translate:

opkg install mariadb-server-extra mariadb-client-extra 

~ # mysqld
2020-03-24 23:19:02 0 [Note] mysqld (mysqld 10.4.10-MariaDB) starting as process 4748 ...
2020-03-24 23:19:02 0 [ERROR] Can't find messagefile '/opt/share/mariadb/errmsg.sys'
2020-03-24 23:19:02 0 [ERROR] Aborting
 

no such file was created "/opt/etc/mysql/my.cnf."

[TheBB]

did you install "mariadb-server-base'?

[Ahmed Ensar]

Google Translate:

~ # opkg install mariadb-server-base
Package mariadb-server-base (10.4.10-1a) installed in root is up to date.
 

pre-loaded

 

~ # opkg remove mariadb-server-base
No packages removed.
Collected errors:
 * print_dependents_warning: Package mariadb-server-base is depended upon by packages:
 * print_dependents_warning:    mariadb-server
 * print_dependents_warning: These might cease to work if package mariadb-server-base is removed.

 * print_dependents_warning: Force removal of this package with --force-depends.
 * print_dependents_warning: Force removal of this package and its dependents
 * print_dependents_warning: with --force-removal-of-dependent-packages.
 

[Ahmed Ensar]

Google Translate:

I did a clean install worked. But this time there are no socket files in the folder it specified.

~ # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/var/run/mysqld/mysqld.sock' (2)
 

[TheBB]

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

~ # opkg install mariadb-server-extra mariadb-client-extra
Installing mariadb-server-extra (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-server-extra_10.4.10-1a_mipsel-3.4.ipk
Installing mariadb-common (1.0-1) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-common_1.0-1_mipsel-3.4.ipk
Installing libatomic (8.3.0-9) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/libatomic_8.3.0-9_mipsel-3.4.ipk
Installing libaio (0.3.112-1) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/libaio_0.3.112-1_mipsel-3.4.ipk
Installing liblzma (5.2.4-5) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/liblzma_5.2.4-5_mipsel-3.4.ipk
Installing resolveip (2) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/resolveip_2_mipsel-3.4.ipk
Installing mariadb-server-base (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-server-base_10.4.10-1a_mipsel-3.4.ipk
Installing mariadb-server (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-server_10.4.10-1a_mipsel-3.4.ipk
Installing mariadb-client-extra (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-client-extra_10.4.10-1a_mipsel-3.4.ipk
Installing libedit (20191025-3.1-1) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/libedit_20191025-3.1-1_mipsel-3.4.ipk
Installing mariadb-client-base (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-client-base_10.4.10-1a_mipsel-3.4.ipk
Installing mariadb-client (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipselsf-k3.4/mariadb-client_10.4.10-1a_mipsel-3.4.ipk
Configuring libatomic.
Configuring liblzma.
Configuring mariadb-common.
Configuring libedit.
Configuring mariadb-client-base.
Configuring mariadb-client.
Configuring resolveip.
Configuring libaio.
Configuring mariadb-server-base.
Configuring mariadb-server.
Configuring mariadb-server-extra.
Configuring mariadb-client-extra.
~ #
~ #
~ # mysql_install_db 
Could not find plugin directory.
Will continue with "/opt/lib/mariadb/plugin".
WARNING: The host 'KUII' 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-03-25  8:51:45 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-03-25  8:51:45 0 [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


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/

~ # /opt/etc/init.d/S70mysqld start
~ #
~ #
~ # ps | grep mysql
11734 root      594m S    /opt/bin/mysqld --pid-file=/opt/var/run/mysqld/mysqld.pid
11831 root      6232 S    grep mysql
~ #
~ #
~ # ping -c 3 127.0.0.1
PING 127.0.0.1 (127.0.0.1): 56 data bytes
64 bytes from 127.0.0.1: seq=0 ttl=64 time=0.559 ms
64 bytes from 127.0.0.1: seq=1 ttl=64 time=0.399 ms
64 bytes from 127.0.0.1: seq=2 ttl=64 time=0.434 ms

--- 127.0.0.1 ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max = 0.399/0.464/0.559 ms
~ # 
~ #
~ # echo $HOSTNAME
KUII
~ #
~ #
~ # ping -c 3 KUII
ping: bad address 'KUII'
~ # 
~ #
~ # cat /etc/hosts 
127.0.0.1 localhost
::1 localhost
~ #
~ #
~ # echo "192.168.2.1 KUII" >> /etc/hosts
~ #
~ #
~ # ping -c 3 KUII
PING KUII (192.168.2.1): 56 data bytes
64 bytes from 192.168.2.1: seq=0 ttl=64 time=0.502 ms
64 bytes from 192.168.2.1: seq=1 ttl=64 time=0.437 ms
64 bytes from 192.168.2.1: seq=2 ttl=64 time=0.412 ms

--- KUII ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max = 0.412/0.450/0.502 ms
~ #
~ #
~ # mysqladmin -u root password "passwd123"
~ #
~ #
~ # mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.10-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
~ # 
~ #

 

 

[Ahmed Ensar]

Google Translate:

 I installed it the way you showed, but again it gave error. I am using mipssf and it gives socket error in this version.  the version you described is different (mipsel) 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/var/run/mysqld/mysqld.sock' (2)

Is there a opkg package to install mysql server omni dsl device without any problem 

[TheBB]

KN-2010 is an analog of Omni DSL (KN-2011)

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

BusyBox v1.31.1 () built-in shell (ash)

~ # opkg update
Downloading http://bin.entware.net/mipssf-k3.4/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Downloading http://bin.entware.net/mipssf-k3.4/keenetic/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/keendev
~ # opkg install mariadb-client-extra mariadb-server-extra
Installing mariadb-client-extra (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-client-extra_10.4.10-1a_mips-3.4.ipk
Installing mariadb-common (1.0-1) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-common_1.0-1_mips-3.4.ipk
Installing libiconv-full (1.11.1-4) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libiconv-full_1.11.1-4_mips-3.4.ipk
Installing libatomic (8.3.0-9) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libatomic_8.3.0-9_mips-3.4.ipk
Installing zlib (1.2.11-3) to root...
Downloading http://bin.entware.net/mipssf-k3.4/zlib_1.2.11-3_mips-3.4.ipk
Installing libopenssl (1.1.1d-2) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libopenssl_1.1.1d-2_mips-3.4.ipk
Installing libncursesw (6.1-5) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libncursesw_6.1-5_mips-3.4.ipk
Installing libncurses (6.1-5) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libncurses_6.1-5_mips-3.4.ipk
Installing libedit (20191025-3.1-1) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libedit_20191025-3.1-1_mips-3.4.ipk
Installing mariadb-client-base (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-client-base_10.4.10-1a_mips-3.4.ipk
Installing mariadb-client (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-client_10.4.10-1a_mips-3.4.ipk
Installing mariadb-server-extra (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-server-extra_10.4.10-1a_mips-3.4.ipk
Installing libaio (0.3.112-1) to root...
Downloading http://bin.entware.net/mipssf-k3.4/libaio_0.3.112-1_mips-3.4.ipk
Installing liblzma (5.2.4-5) to root...
Downloading http://bin.entware.net/mipssf-k3.4/liblzma_5.2.4-5_mips-3.4.ipk
Installing resolveip (2) to root...
Downloading http://bin.entware.net/mipssf-k3.4/resolveip_2_mips-3.4.ipk
Installing mariadb-server-base (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-server-base_10.4.10-1a_mips-3.4.ipk
Installing mariadb-server (10.4.10-1a) to root...
Downloading http://bin.entware.net/mipssf-k3.4/mariadb-server_10.4.10-1a_mips-3.4.ipk
Configuring libatomic.
Configuring liblzma.
Configuring mariadb-common.
Configuring libiconv-full.
Configuring zlib.
Configuring libopenssl.
Configuring libncursesw.
Configuring libncurses.
Configuring libedit.
Configuring mariadb-client-base.
Configuring mariadb-client.
Configuring resolveip.
Configuring libaio.
Configuring mariadb-server-base.
Configuring mariadb-server.
Configuring mariadb-server-extra.
Configuring mariadb-client-extra.
~ # 
~ # 
~ # ndmq -p "show version" -P device
DSL
~ # 
~ # 
~ # echo $HOSTNAME
KN-2010
~ # 
~ # 
~ # cat /etc/hosts
127.0.0.1 localhost
::1 localhost
~ # 
~ # ping -c3 127.0.0.1
PING 127.0.0.1 (127.0.0.1): 56 data bytes
64 bytes from 127.0.0.1: seq=0 ttl=64 time=0.748 ms
64 bytes from 127.0.0.1: seq=1 ttl=64 time=0.716 ms
64 bytes from 127.0.0.1: seq=2 ttl=64 time=0.461 ms

--- 127.0.0.1 ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max = 0.461/0.641/0.748 ms
~ # 
~ # 
~ # ping -c3 KN-2010
ping: bad address 'KN-2010'
~ # 
~ # 
~ # echo "192.168.3.1 KN-2010" >> /etc/hosts 
~ # 
~ # 
~ # ping -c3 KN-2010
PING KN-2010 (192.168.3.1): 56 data bytes
64 bytes from 192.168.3.1: seq=0 ttl=64 time=0.685 ms
64 bytes from 192.168.3.1: seq=1 ttl=64 time=0.424 ms
64 bytes from 192.168.3.1: seq=2 ttl=64 time=0.455 ms

--- KN-2010 ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max = 0.424/0.521/0.685 ms
~ # 
~ # 
~ # mysql_install_db 
Could not find plugin directory.
Will continue with "/opt/lib/mariadb/plugin".
Installing MariaDB/MySQL system tables in '/opt/var/lib/mysql' ...
2020-03-25 11:13:16 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-03-25 11:13:16 0 [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


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/

~ # 
~ # 
~ # /opt/etc/init.d/S70mysqld start
~ # 
~ # 
~ # ps | grep mysql
 5495 root      590m S    /opt/bin/mysqld --pid-file=/opt/var/run/mysqld/mysqld.pid
 5567 root      6196 S    grep mysql
~ # 
~ # 
~ # mysqladmin -u root password "passwd123"
~ # 
~ # 
~ # mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.10-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)]> 
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.009 sec)

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

 

 

[Ahmed Ensar]

Spoiler

~ # mysql_install_db
Could not find plugin directory.
Will continue with "/opt/lib/mariadb/plugin".
Installing MariaDB/MySQL system tables in '/opt/var/lib/mysql' ...
2020-03-25 11:41:46 0 [ERROR] mysqld: Can't lock aria control file '/opt/var/lib/mysql/aria_log_control' for exclusive use, error:                                                                                                            11. Will retry for 30 seconds
2020-03-25 11:42:17 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/opt/var/lib/mysql/aria_log_control'
2020-03-25 11:42:17 0 [ERROR] Plugin 'Aria' init function returned error.
2020-03-25 11:42:17 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-03-25 11:42:17 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-03-25 11:42:17 0 [Warning] InnoDB: Linux Native AIO disabled.
2020-03-25 11:42:18 0 [ERROR] InnoDB: mmap(134217728 bytes) failed; errno 12
2020-03-25 11:42:18 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-03-25 11:42:18 0 [ERROR] InnoDB: Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
double free or corruption (out)
200325 11:42:18 [ERROR] mysqld got signal 6 ;
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...

 

 

Изменено 25 марта, 2020 пользователем Ahmet

[TheBB]

did you enabled swap? it`s strongly recommended.

[Ahmed Ensar]

# free -m
              total        used        free      shared  buff/cache   available
Mem:         120564       55252       25272         128       40040       54568
Swap:        524284       50880      473404

I installed swap, I get the same error

[TheBB]

what about disk space?

~ # df -h | grep opt
/dev/sda2                26.1G    782.7M     24.0G   3% /opt
~ #

 

[Ahmed Ensar]

16 hours ago, TheBB said:

what about disk space?

~ # df -h | grep opt
/dev/sda2                26.1G    782.7M     24.0G   3% /opt
~ #

 

~ # df -h | grep opt
/dev/sda1                27.9G    791.6M     25.7G   3% /opt
~ #