[TUTORIAL] WordPress Blog Server through Entware

TeHashX · #1 01-12-2013, 12:55 PM

Today, I'm gonna show you how to setup Wordpress free blog server on your asuswrt router.
REQUIREMENTS:
1) Merlin's firmware from here
2) Entware must be setup from here
3) Lighttpd web server from this guide

If you meet all the requirements, login to router with putty terminal and enter:

Quote:

# opkg install mysql-server
# opkg install php5-mod-mysql
# mysql_install_db --force
# /opt/etc/init.d/S70mysqld restart
# mysql -u root

Choose a username and a password for your database and replace those in red color

Quote:

mysql> create database wordpress;
mysql> grant all privileges on wordpress.* to user_name@localhost identified by 'db_password' ;

Exit with Ctrl-C

Quote:

# /opt/etc/init.d/S80lighttpd restart
# cd /opt/share/www
# wget http://wordpress.org/latest.tar.gz && tar -zxvf latest.tar.gz && rm latest.tar.gz
# chown -R admin: wordpress

Go to 192.168.1.1:81/wordpress/wp-admin/install.php
Click on "Create a Configuration File"
On the next page click on "Let's go!"
Now fill in with user_name and db_password created earlier with mysql commands.
Change Database Host from localhost to 127.0.0.1
Press "Submit"
On the next page, click on "Run the install"
Now choose a Site Title, username, password (don't have to be the same as for mysql), enter your email adress, and press "Install WordPress"
Log in
Customize appearance, add widgets, menus, plugins...
Now access your blog on 192.168.1.1:81/wordpress to see how it looks.
Create an asus, no-ip or dyndns dynamic dns account and the blog can be accessed from your_dns_account/wordpress or your_wan_ip_adress/wordpress
__________________________________________________ _______
It's better to create a backup of your blog and mysql database with:

Quote:

# cd /mnt/sda1
# tar -zcvf wordpress.tar.gz /mnt/sda1/entware/share/www/wordpress/
# tar -zcvf wordpress_db.tar.gz /mnt/sda1/entware/etc/mysql/wordpress

If something goes wrong, just restore with:

Quote:

# cd /
# tar -zxvf /mnt/sda1/wordpress.tar.gz
# tar -zxvf /mnt/sda1/wordpress_db.tar.gz

I hope everything goes smoothly for you, if not, don't hesitate to ask here in forum.

See HERE a terminal recording

Youtube video HERE

Enter here and say HALLO on my test blog just to see if someone is reading this tutorial, THX!
http://tehashx.dyndns.org/wordpress/

TeHashX · #2 01-15-2013, 02:22 PM

We need a smtp email account for sending automatically email notifications every time a new user register, a post is awaiting moderation, password recovery...
If you don't have one, we can use JangoSmtp, it offers 200 free emails per month, just signup for a new account, go to Settings / Advanced / From Addresses and add a "from address" like blog@wordpress.com or wordpress@blog.com, anythink you wish.

Login to your wordpress server
Go to Plugins / Add New / Search for "WP-Mail-SMTP" and install it
Edit WP-Mail-SMTP settings and input
From Email - your-jangosmtp-fromaddress
Mailer - Send all WordPress emails via SMTP
SMTP Host - relay.jangosmtp.net
SMTP Port - 587 or 25
Encryption - No encryption
Authentication - Yes: Use SMTP authentication
Username - your-jangosmtp-username
Password - your-jangosmtp-password
Save changes and press "send test" email, soon you should receive a email with this text: This is a test email generated by the WP Mail SMTP WordPress plugin.