The WordPress on CentOS LEMP Challenge

JaredBusch

If you don't use nginx the whole thing gets way easier. It's only Nginx that makes it hard. Should be mostly just installing the necessary packages.

I like the idea of a one liner I can save though, so I am editing yours for Apache. I am stuck on the sed replacements for the local directory and such. It is my fault is not knowing Apache well enough.
I have a new Hyper-V VM running CentOS 7 Minimal. I am now needing to go manually dig though this and change things in the Apache conf files instead.

sed -i -e s’/index index.html index.htm/index index.php index.html/’ /etc/nginx/conf.d/default.conf;
sed -i -e s’//usr/share/nginx/html//opt/wordpress/’ /etc/nginx/conf.d/default.conf;
sed -i -e 0,/#loca/{s’/#loca/loca/’} /etc/nginx/conf.d/default.conf;
sed -i -e s’/# root html/ root /opt/wordpress/’ /etc/nginx/conf.d/default.conf;
sed -i -e s’/# fastcgi_pass/ fastcgi_pass/’ /etc/nginx/conf.d/default.conf;
sed -i -e s’/# fastcgi_index/ fastcgi_index/’ /etc/nginx/conf.d/default.conf;
sed -i -e s’/# fastcgi_param SCRIPT_FILENAME /scripts$fastcgi/ fastcgi_param SCRIPT_FILENAME /opt/wordpress$fastcgi/’ /etc/nginx/conf.d/default.conf;
sed -i -e s’/# include fastcgi_params/ include fastcgi_params/’ /etc/nginx/conf.d/default.conf;
echo ‘}’ >> /etc/nginx/conf.d/default.conf;

Will probably be late before I can get back to it.

scottalanmiller

The Apache setup will be extremely different. Just needs an echo to append the VirtualHost to the httpd.conf file.

Bill Kindle

I remember that guy. They've even had problems with it on IIS 8.5 now as well. Couldn't even get something working that was hosted.

scottalanmiller

@Bill-Kindle said:

I remember that guy. They've even had problems with it on IIS 8.5 now as well. Couldn't even get something working that was hosted.

LOL. He never responded to the thread where I clearly got the best answer. I've never more clearly earned a BA and he just ignored that he looked like an idiot.

Bill Kindle

@scottalanmiller said:

@Bill-Kindle said:

I remember that guy. They've even had problems with it on IIS 8.5 now as well. Couldn't even get something working that was hosted.

LOL. He never responded to the thread where I clearly got the best answer. I've never more clearly earned a BA and he just ignored that he looked like an idiot.

Oh and he won't. He hits and runs. I think I lost count on about 5 posts where it was a similar question than the last. When you call him on his BS, he cries sleep deprivation and life as a MSP as being hard.

scottalanmiller

People hire that guy as an MSP? Damn. SMBs are just not discriminating at all.

JaredBusch

@scottalanmiller A lot of difference for CentOS7 by the way.

yum install mysql installs mariadb automatically instead. I'm fine with that, but annoyed me at first.
service NAME start is depreciated in favor of systemctl start NAME
iptables is basically completely gone in its old form (you can manually add it with yum install iptables-services apparently). You now have to use firewall-cmd and it is systemctl reload firewalld

JaredBusch

This is what I have at the moment. need to update the virtual host and then it should function I think. I can see the default apache page now, so i know that the basics are working.

yum -y install httpd; chkconfig httpd on;
yum -y install mariadb mariadb-server;
chkconfig mariadb on;
setenforce permissive;
#rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm;
rpm -Uvh http://mirror.1000mbps.com/fedora-epel/beta/7/x86_64/epel-release-7-0.2.noarch.rpm;
#rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm;
rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm;
yum -y -–enablerepo=remi install php-fpm php-mysql;
chkconfig php-fpm on;
cd /opt;
wget https://wordpress.org/latest.tar.gz;
tar -xzvf latest.tar.gz;
systemctl start mariadb;
echo “CREATE DATABASE wp” | mysql;
echo “CREATE USER ‘wp’@’localhost’ IDENTIFIED BY ‘password’;” | mysql;
echo “GRANT ALL PRIVILEGES ON *.* TO ‘wp’@’localhost’;” | mysql;
echo “FLUSH PRIVILEGES;” | mysql;
chown -R apache:apache /opt/wordpress/;
firewall-cmd --zone=public --add-port=http/tcp;
firewall-cmd --zone=public --add-port=http/tcp --permanent;
systemctl reload firewalld;
systemctl start httpd;
systemctl start php-fpm;

Bill Kindle

@scottalanmiller said:

People hire that guy as an MSP? Damn. SMBs are just not discriminating at all.

The way the guy would talk about it, it would seem he was stretched thin to begin with, but possibly having money troubles too which made him work ridiculous hours spinning his wheels instead of hiring it out. OR he over promised and was under delivering.

scottalanmiller

I checked some other threads. That guy is a Curtis. I commented on a few. Caught him giving himself BAs to make himself look good and reported him. I can see the mods looking at the threads now.

Man this guy. http://community.spiceworks.com/topic/545282-can-you-make-many-machines-behave-as-one-in-windows How is storage spaces or sharing harddrives anything like cluster which requires custom written applications... fail.

Reid Cooper

It is amazing. Every single thread that he starts is something ridiculous. It is like s kid who has no idea how computers work or what they would be used for.

@Reid-Cooper Well, this has been my experience with about 85% of MSPs, they have no clue what they are doing and take on jobs and try to learn what they are doing. And usually don't very well.

scottalanmiller

That guy is especially bad. He's not even trying. He is going significantly out of his way to be obtuse and only do completely inappropriate things. You can't be that bad on accident.

As someone who has worked in MSPs for a long time, I have some pity for MSPs as customers often drive them to this. You'd be amazed how little customers tend to care if they MSP is good and often favour the incompetent ones because they charge less and pander to whatever the customer wants to hear. Customers make it more lucrative to be incompetent than to help them.

JaredBusch

@scottalanmiller said:

That guy is especially bad. He's not even trying. He is going significantly out of his way to be obtuse and only do completely inappropriate things. You can't be that bad on accident.

As someone who has worked in MSPs for a long time, I have some pity for MSPs as customers often drive them to this. You'd be amazed how little customers tend to care if they MSP is good and often favour the incompetent ones because they charge less and pander to whatever the customer wants to hear. Customers make it more lucrative to be incompetent than to help them.

+1 so much this! Luckily we have a few solid clients that understand what IT really means and see how we are saving them over the long run. We intentionally dump any client that does not see how IT is important to their business.

StrongBad

@thecreativeone91 said:

Man this guy. http://community.spiceworks.com/topic/545282-can-you-make-many-machines-behave-as-one-in-windows How is storage spaces or sharing harddrives anything like cluster which requires custom written applications... fail.

My head aspoded.

scottalanmiller

I think this guy and Curtis can be summed up thusly....

JaredBusch

My friend's website http://wolf-peak.com is up and running on WordPress on CentOS7.

scottalanmiller

How To Forge has details now too...

http://www.howtoforge.com/how-to-install-nginx-with-php-and-mysql-lemp-stack-on-centos-7

JaredBusch

Here is my process for Apache on CentOS7 minimal

# install packages needed to run wordpress
yum -y install httpd;
yum -y install mariadb mariadb-server;
yum -y install php php-mysql wget nano;
systemctl enable httpd.service;
systemctl enable mariadb.service;
setenforce permissive;
systemctl start mariadb;
firewall-cmd --zone=public --add-port=http/tcp;
firewall-cmd --zone=public --add-port=http/tcp --permanent;
systemctl reload firewalld;
systemctl start httpd;

# create database and user for this website/domain
echo "CREATE DATABASE wp_yourdomain;" | mysql;
echo "CREATE USER 'wp_yourdomain'@'localhost' IDENTIFIED BY 'somerandompassword';" | mysql;
echo "GRANT ALL PRIVILEGES ON *.* TO 'wp_yourdomain'@'localhost';" | mysql;
echo "FLUSH PRIVILEGES;" | mysql;

# download wordpress
cd /opt;
wget https://wordpress.org/latest.tar.gz;
tar -xzvf latest.tar.gz;
chown -R apache:apache /opt/wordpress/;

# copy the wordpress directory to the domain folder desired
cp -R /opt/wordpress/ /opt/yourdomain/

# create the wp-config.php file and set the database information
cp /opt/yourdomain/wp-config-sample.php /opt/yourdomain/wp-config.php;
sed -i -e 's/database_name_here/wp_yourdomain/' /opt/yourdomain/wp-config.php;
sed -i -e 's/username_here/wp_yourdomain/' /opt/yourdomain/wp-config.php;
sed -i -e 's/password_here/somerandompassword/' /opt/yourdomain/wp-config.php;

# go to https://api.wordpress.org/secret-key/1.1/salt/ and copy paste a unique salt into your wp-config.php file
# no idea how to use sed to find/replace this. This data goes at the end of the wp-config.php file.
define('AUTH_KEY',         'P/u!4L<`Ia+2e=^w&KBgDs[f)r:vcM~=ylK-E:Hq|B`HGv%cZtAN*Toy@b],6g!b');
define('SECURE_AUTH_KEY',  'qJV7.|d>:N$61J*_<wyX +K<P(Xz_TId+uJQ+3V/~h_L8}k_l4t,i[^Ss^3}(1j*');
define('LOGGED_IN_KEY',    'dfJ;0JEt?u&r[T%Vn|@|y3AXx&CO~bjmfy{9gIPi2i|ouwmv99*(a`-i(*F}L{g+');
define('NONCE_KEY',        'Qy{%n+h,rt66ILfR[;xO2kCMrjMY&vppiU X+cq*OXeS44hyP.At3K3Eb3r~zOH-');
define('AUTH_SALT',        '3qH|kzJYd.*JmV%()x8yyl1a;^SC3}]D}7koA%|W*z(GRA/wF=p!(9xT~;+0A>>D');
define('SECURE_AUTH_SALT', '1$LIVd(W 3X~.L$Or YbUtUBL%&}JNxF6o`tw.WVJ3b|v]Ik3c0afEy0j =D2R5<');
define('LOGGED_IN_SALT',   '[-Rf2*n&U]D&KWZ 5IR{63D^$g~oGq</!Pi(&8kEQ*J2Ui?cHo!h4(1~<Qj?g ah');
define('NONCE_SALT',       'xRL!G|/Xe&f|WfCp(v(6H.?-OwY2uxp^HJYYhMWx8KJca0s<J_2%E[cr:ZZ9t`1k');

# edit the apache config to change the default document root to point to your wordpress folder
# by default it is located: /etc/httpd/conf/httpd.conf
# Change the following two lines
DocumentRoot "/opt/yourdomain"		# was "/var/www/html"
<Directory "/opt/yourdomain">		# was "/var/www/html"

# If you are going to have multiple domains pointing to this server eventually,
# you need to create a virtual host entry in apache config
# by default it is located: /etc/httpd/conf/httpd.conf
# just need to be at the end of the file.
# you will have one of these for each domain name pointing to this host.
<VirtualHost *:80>
	ServerAdmin [email protected]
	DirectoryIndex index.php index.html index.htm
	DocumentRoot /opt/yourdomain
	ServerName yourdomain.com
	ServerAlias *.yourdomain.com
	LogLevel warn
	ErrorLog logs/yourdomain-error_log
	CustomLog logs/yourdomain-access_log common
		<Directory />
			Require all granted
			Options Indexes FollowSymLinks Includes ExecCGI
			AllowOverride All
			Order allow,deny
			Allow from all
		</Directory>
</VirtualHost>

# restart the webserver then browse to your site.
systemctl reload httpd;