• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

HOWTO: Install Wordpress 3.x + Nginx + MySQL 5.5

olo

New Member


Messages: 13

#27
Hi,

Great tutorial, but wouldn't it be better and more secure to bind MySQL only to 127.0.0.1 and allow the Wordpress db database user and root to log in only via localhost and 127.0.0.1? The web server in this tutorial is the same server as the MySQL one. Even if it is we should use SSH tunnels instead of a public IP. Am I right?
 

nesstyy

New Member


Messages: 5

#28
Ness Mosu sends thanks for this tutorial.
Hi. | have a small problem and | ask for a little help.
| edited this msg becouse | dont want to spam here.
| install nginx, mysql, php-fpm and wordpress. everything is fine. | made may little blog and is good. | am beginner on freebsd and wordpress.
Now the real problem .
Local on my network | have access on my blog to see the page and to made change on him, but on extern the blog is broken.
php-fpm works and php ,nginx is good .| dont know the issue.
help this old man pls ?
PS. Admin.sorry for last 2 post.

Solved. thanks.
 

rname

New Member


Messages: 5

#29
Hi all.
tried to install mysql56-server, but
Code:
===>  mysql56-server-5.6.26 has known vulnerabilities:
mysql56-server-5.6.26 is vulnerable:
MySQL - Multiple vulnerabilities
CVE: CVE-2015-4792
CVE: CVE-2015-4913
CVE: CVE-2015-4870
CVE: CVE-2015-4861
CVE: CVE-2015-4858
CVE: CVE-2015-4836
CVE: CVE-2015-4830
CVE: CVE-2015-4826
CVE: CVE-2015-4815
CVE: CVE-2015-4807
CVE: CVE-2015-4802
WWW: https://vuxml.FreeBSD.org/freebsd/851a0eea-88aa-11e5-90e7-b499baebfeaf.html

1 problem(s) in the installed packages found.
=> Please update your ports tree and try again.
=> Note: Vulnerable ports are marked as such even if there is no update available.
=> If you wish to ignore this vulnerability rebuild with 'make DISABLE_VULNERABILITIES=yes'
*** Error code 1

Stop.
make: stopped in /usr/ports/databases/mysql56-server
then try to install mysql55-server, but the same errors
Code:
===>  mysql55-server-5.5.44 has known vulnerabilities:
mysql55-server-5.5.44 is vulnerable:
MySQL - Multiple vulnerabilities
CVE: CVE-2015-4792
CVE: CVE-2015-4913
CVE: CVE-2015-4870
CVE: CVE-2015-4861
CVE: CVE-2015-4858
CVE: CVE-2015-4836
CVE: CVE-2015-4830
CVE: CVE-2015-4826
CVE: CVE-2015-4815
CVE: CVE-2015-4807
CVE: CVE-2015-4802
WWW: https://vuxml.FreeBSD.org/freebsd/851a0eea-88aa-11e5-90e7-b499baebfeaf.html

1 problem(s) in the installed packages found.
=> Please update your ports tree and try again.
=> Note: Vulnerable ports are marked as such even if there is no update available.
=> If you wish to ignore this vulnerability rebuild with 'make DISABLE_VULNERABILITIES=yes'
*** Error code 1

Stop.
make[1]: stopped in /usr/ports/databases/mysql55-server
*** Error code 1
is it normal? my ports is up to date
Code:
root@freebsd:/usr/ports # portsnap update
Ports tree is already up to date
 

SirDice

Administrator
Staff member
Administrator
Moderator

Thanks: 5,476
Messages: 25,637

#30
I'm afraid the port hasn't been updated yet.

PR 204569
 

SirDice

Administrator
Staff member
Administrator
Moderator

Thanks: 5,476
Messages: 25,637

#32
Several ways to do it. You could subscribe to the bug report and you'll be notified if it's updated. You could try updating your ports tree everyday and just look if the version is updated. Or you could visit www.freshports.org regularly and keep an eye on the ports there.
 

free-and-bsd

Aspiring Daemon

Thanks: 66
Messages: 633

#33
I've also noticed there is mysql80-server there. Are there any objections to using that one along with nginx and php etc., instead of mysql56-server?