Project

General

Profile

Support #867

Install SEO-Panel on FreeBSD

Added by Daniel Curtis over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Web Server
Target version:
Start date:
11/09/2016
Due date:
% Done:

100%

Estimated time:
1.00 h
Spent time:

Description

This is a guide on setting up SEO-Panel with Nginx on FreeBSD 10.

Prepare the Environment

  • Before installation of the components, make sure everything is up to date using the following command:
    pkg update -f && pkg upgrade
    
  • Install the dependencies:
    pkg install git
    
  • Create the seopanel user:
    pw user add -n seopanel -s /sbin/nologin -c "SEO Panel" 
    

Install MySQL Server

  • Start by installing the mariadb100-server and mariadb100-client packages:
    pkg install mariadb100-{server,client}
    
  • Copy a base MySQL configuration to use:
    cp /usr/local/share/mysql/my-small.cnf /var/db/mysql/my.cnf
    
  • Enable and start mysql at boot:
    echo 'mysql_enable="YES"' >> /etc/rc.conf
    service mysql-server start
    
  • Prepare the database for use by running the secure installation:
    mysql_secure_installation
    
    • NOTE: Choose a strong root password and answer yes to all questions.

Create Databases and Users

  • Login to MySQL and create appropriate databases and users.
    mysql -u root -p
    
    • and run the following SQL queries to create the seopaneldb database and seopaneluser user:
      CREATE DATABASE seopaneldb CHARACTER SET utf8;
      
      CREATE USER 'seopaneluser'@'localhost' IDENTIFIED BY 'SuperSecretPassword';
      
      GRANT ALL PRIVILEGES ON seopaneldb.* TO 'seopaneluser'@'localhost';
      
      FLUSH PRIVILEGES;
      
      quit
      

Install Nginx

  • Install Nginx
    pkg install nginx
    
  • Start and enable nginx at boot:
    echo 'nginx_enable="YES"' >> /etc/rc.conf
    service nginx start
    
  • Create a configuration directory to make managing individual server blocks easier
    mkdir /usr/local/etc/nginx/conf.d
    
  • Edit the main nginx config file:
    vi /usr/local/etc/nginx/nginx.conf
    
    • And strip down the config file and add the include statement at the end to make it easier to handle various server blocks:
      load_module /usr/local/libexec/nginx/ngx_mail_module.so;
      load_module /usr/local/libexec/nginx/ngx_stream_module.so;
      
      worker_processes  1;
      error_log  /var/log/nginx-error.log;
      
      events {
          worker_connections  1024;
      }
      
      http {
          include       mime.types;
          default_type  application/octet-stream;
          sendfile        on;
          keepalive_timeout  65;
      
          # Load config files from the /etc/nginx/conf.d directory
          include /usr/local/etc/nginx/conf.d/*.conf;
      }
      

Install PHP

  • Install PHP 5.6 and a few extensions:
    pkg install php56 php56-{curl,gd,mysqli,pdo_mysql,session}
    
  • Configure the default PHP settings
    cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
    
  • Edit the php config file:
    vi /usr/local/etc/php.ini
    
    • And make sure the following values are set:
      date.timezone = "America/Los_Angeles" 
      short_open_tag = On
      
  • Create a directory for the php-fpm configs:
    mkdir /usr/local/etc/php-fpm.d
    
  • Edit the php-fpm config file:
    vi /usr/local/etc/php-fpm.conf
    
    • Make the following changes:
      include=/usr/local/etc/php-fpm.d/*.conf
      
  • Enable PHP-FPM at boot:
    echo 'php_fpm_enable="YES"' >> /etc/rc.conf
    
  • Restart nginx:
    service nginx restart
    

Install SEO-Panel

  • Download the lastest version of SEO-Panel from GitHub:
    cd /usr/local/www
    git clone https://github.com/sendtogeo/Seo-Panel.git
    
  • Create an seopanel.example.com server block config file:
    vi /usr/local/etc/nginx/conf.d/seopanel.example.com.conf
    
    • Add the following:
      upstream seopanel-handler {
        server unix:/var/run/seopanel.example.com-php-fpm.sock;
      }
      
      server {
        listen 80;
        server_name seopanel.example.com;
        root /usr/local/www/Seo-Panel;
        index index.html index.php;
      
        # Set size for max uploaded content
        client_max_body_size 0;
        client_header_timeout 30m;
        client_body_timeout 30m;
      
        location = /robots.txt {
          allow all;
          log_not_found off;
          access_log off;
        }
      
        location ~ ^/(?:CHANGELOG\.md|config|README.md|.git){
          deny all;
        }
      
        location / {
          try_files $uri $uri/ =404;
        }
      
        location ~ \.php(?:$|/) {
          fastcgi_split_path_info ^(.+\.php)(/.+)$;
          fastcgi_index index.php;
          include fastcgi_params;
          fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
          fastcgi_param PATH_INFO $fastcgi_path_info;
          fastcgi_pass seopanel-handler;
          fastcgi_intercept_errors on;
        }
      }
      
  • Create the seopanel php-fpm pool config file:
    vi /usr/local/etc/php-fpm.d/seopanel.example.com.conf
    
    • And add the following:
      [seopanel.example.com]
      user = seopanel
      group = www
      listen = /var/run/seopanel.example.com-php-fpm.sock
      listen.owner = seopanel
      listen.group = www
      pm = dynamic
      pm.max_children = 5
      pm.start_servers = 2
      pm.min_spare_servers = 1
      pm.max_spare_servers = 3
      
  • Change the ownership of the seopanel directory:
    chown -R seopanel:www /usr/local/www/Seo-Panel
    
  • Restart nginx and start php-fpm:
    service nginx restart
    service php-fpm start
    
  • Secure the installation:
    rm -rf /usr/local/www/Seo-Panel/install
    chmod -w /usr/local/www/Seo-Panel/config/sp-config.php
    

Cron job

  • Edit the cron table for the seopanel user:
    crontab -eu seopanel
    
    • And add the following:
      */15 * * * * php /usr/local/www/Seo-Panel/cron.php
      

Resources

#1

Updated by Daniel Curtis over 7 years ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • % Done changed from 0 to 100
#2

Updated by Daniel Curtis over 7 years ago

  • Description updated (diff)
#3

Updated by Daniel Curtis over 7 years ago

  • Description updated (diff)
#4

Updated by Daniel Curtis over 7 years ago

  • Description updated (diff)
#5

Updated by Daniel Curtis over 7 years ago

  • Description updated (diff)
#6

Updated by Daniel Curtis over 7 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF