-
Posts
173 -
Joined
-
Last visited
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Posts posted by Ahmed Ensar
-
-
Google Translate:
I cannot access the web interface from the local network after the 3.4.1 update.
https://my.keenetic.net ---> the page never opens
http://my.keenetic.net ---> I'm redirecting to domain page https://XXX.keenetic.pro
https://192.168.1.1 ---> the page never opens
http://192.168.1.1 --> the page opens but nothing happens when you press login
https://XXX.keenetic.pro --> opening smoothly
-
4 hours ago, musasimaru said:
~ # opkg update Downloading http://bin.entware.net/mipselsf-k3.4/Packages.gz Updated list of available packages in /opt/var/opkg-lists/entware Downloading http://bin.entware.net/mipselsf-k3.4/keenetic/Packages.gz Updated list of available packages in /opt/var/opkg-lists/keendev ~ # opkg install php7-mod-mysqli php7-mod-pdo-mysql Package php7-mod-mysqli (7.4.3-1) installed in root is up to date. Installing php7-mod-pdo-mysql (7.4.3-1) to root... Downloading http://bin.entware.net/mipselsf-k3.4/php7-mod-pdo-mysql_7.4.3-1_mips el-3.4.ipk Configuring php7-mod-pdo-mysql. ~ # /opt/etc/init.d/S79php7-fpm restart Shutting down php-fpm... done. Starting php-fpm... done.
Fatal error: Uncaught Error: Class 'PDO' not found in /opt/share/www/php_sql_test_pdo.php:3 Stack trace: #0 {main} thrown in /opt/share/www/php_sql_test_pdo.php on line 3
Fatal error: Uncaught Error: Class 'mysqli' not found in /opt/share/www/php_sql_test.php:3 Stack trace: #0 {main} thrown in /opt/share/www/php_sql_test.php on line 3
Как я понимаю плагины по какой-то причине не подключаются.
Mysql Server
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 ~ #
-
php plugin install http://bin.entware.net/mipssf-k3.4/
opkg install php7-mod-mysqli php7-mod-pdo-mysql
-
Mysql Server
SpoilerBusyBox 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 ~ #
-
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
~ #
-
# 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
-
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...
-
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 -
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)
-
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.
-
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."
-
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"
web gui login
in Обмен опытом
Posted
192.168.1.1 ile session çerez vb. silerek girebildim. 👍