Ahmed Ensar Posted March 24, 2020 Share Posted March 24, 2020 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" Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 24, 2020 Share Posted March 24, 2020 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 Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 24, 2020 Author Share Posted March 24, 2020 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." Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 24, 2020 Share Posted March 24, 2020 did you install "mariadb-server-base'? Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 24, 2020 Author Share Posted March 24, 2020 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. Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 24, 2020 Author Share Posted March 24, 2020 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) Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 25, 2020 Share Posted March 25, 2020 Скрытый текст ~ # 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 ~ # ~ # Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 25, 2020 Author Share Posted March 25, 2020 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 Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 25, 2020 Share Posted March 25, 2020 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 ~ # Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 25, 2020 Author Share Posted March 25, 2020 (edited) 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... Edited March 25, 2020 by Ahmet Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 25, 2020 Share Posted March 25, 2020 did you enabled swap? it`s strongly recommended. Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 25, 2020 Author Share Posted March 25, 2020 # 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 Quote Link to comment Share on other sites More sharing options...
TheBB Posted March 25, 2020 Share Posted March 25, 2020 what about disk space? ~ # df -h | grep opt /dev/sda2 26.1G 782.7M 24.0G 3% /opt ~ # Quote Link to comment Share on other sites More sharing options...
Ahmed Ensar Posted March 26, 2020 Author Share Posted March 26, 2020 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 ~ # Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.