How to install wordpress server through entware?

[Levente]

Hi all!
I'm trying to install wordpress, but I'm stucked.
There are few guides (older (lighttpd instruction old), newer, mysql). The problem comes at opkg install php5-mod-mysql, because there is no package like that in the repository. A found out I need opkg install php7-mod-mysqli package, but after that I got errors.

"mysql_install_db --force
chown: unknown user root
Cannot change ownership of the database directories to the 'root'
user. Check that you have the necessary permissions and try again."
(someone said to solve this way:https://pastebin.com/LJs1bEvs
The essence for me to change user from root to admin, at /opt/etc/mysql

I can't restart (or start) mysql (/opt/etc/init.d/S70mysqld restart).
"cat: can't open '/opt/var/run/mysqld.pid': No such file or directory
*** Error in `/opt/bin/mysqld': double free or corruption (out): 0x015affa8 ***"
I dont have pid, and sock files.
How I understand I have problem with mysql server. Maybe with the old repo I would have more success.

Please help me, I kindly give you more information!

 

[sfx2000]

Don't run wordpress on AsusWRT - between PHP, mysql/mariadb, and everything else - just not enough resources...

just because one "can" doesn't mean one "should"...

Wordpress on LAMP stack on RPi3 is a stretch there - again, resources are a bit of a problem, and that's on a current Linux OS and userland...

 

[Levente]

Don't run wordpress on AsusWRT - between PHP, mysql/mariadb, and everything else - just not enough resources...

just because one "can" doesn't mean one "should"...

Wordpress on LAMP stack on RPi3 is a stretch there - again, resources are a bit of a problem, and that's on a current Linux OS and userland...

I just would like a test page at home, it would be only for family, I don't need a strong hardware.

 

[loveleeyoungae]

Hi all!
I'm trying to install wordpress, but I'm stucked.
There are few guides (older (lighttpd instruction old), newer, mysql). The problem comes at opkg install php5-mod-mysql, because there is no package like that in the repository. A found out I need opkg install php7-mod-mysqli package, but after that I got errors.

"mysql_install_db --force
chown: unknown user root
Cannot change ownership of the database directories to the 'root'
user. Check that you have the necessary permissions and try again."
(someone said to solve this way:https://pastebin.com/LJs1bEvs
The essence for me to change user from root to admin, at /opt/etc/mysql

I can't restart (or start) mysql (/opt/etc/init.d/S70mysqld restart).
"cat: can't open '/opt/var/run/mysqld.pid': No such file or directory
*** Error in `/opt/bin/mysqld': double free or corruption (out): 0x015affa8 ***"
I dont have pid, and sock files.
How I understand I have problem with mysql server. Maybe with the old repo I would have more success.

Please help me, I kindly give you more information!

I'm the author of that pastebin. Follow my guide from the start and you should have mysql running. However, I dont know if you could use the guide to fix a bad installation.

After editing the my.cnf, have you retried running the mysql_install_db --force ?

Maybe you would need to remove your current mysql installation and perform a fresh installation per my pastebin guide.

 

[Levente]

New formatted hdd.
Then I installed entware (entware-setup.sh), and lighttpd with php.
Then your instruction:
opkg install mariadb-server mariadb-server-extra mariadb-client mariadb-client-extra php7-mod-mysqli php7-mod-mbstring php7-mod-json php7-mod-session php7-mod-ctype
After that edit 2 lines (root->admin, 127.0.0.1->0.0.0.0).

mysql_install_db --force
Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2018-11-12 16:21:24 1074900992 [ERROR] InnoDB: mmap(136249344 bytes) failed; errno 12
2018-11-12 16:21:24 1074900992 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-11-12 16:21:24 1074900992 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
*** Error in `/opt/bin/mysqld': double free or corruption (out): 0x015b01a8 ***
181112 16:21:24 [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.2.17-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 = 351406 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.
Aborted

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

Of course
/opt/etc/init.d/S70mysqld restart not working after that:

cat: can't open '/opt/var/run/mysqld.pid': No such file or directory
admin@RT-AC68U-CC10:/tmp/home/root# *** Error in `/opt/bin/mysqld': double free or corruption (out): 0x015affa8 ***

 

[TeHashX]

"InnoDB: Cannot allocate memory for the buffer pool"
Did you created a swap file at least 2GB of memory?

 

[Levente]

Thank you very much, you saved me!!!
The small swap was the main problem. Now everything works.

Your article is good, but instead mysql server I had to use mariadb-server mariadb-server-extra mariadb-client mariadb-client-extra packages, and I had to change in my.conf file root to admin to install mysql_install_db --force.