Project

General

Profile

Support #866

Install SEO Tool Suite on FreeBSD

Added by Daniel Curtis almost 4 years ago. Updated almost 4 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 Tool Suite on FreeBSD

Prepare the Environment

  • Make sure the system is up to date:
    pkg update && pkg upgrade
    
  • Install a few dependencies:
    pkg install git python py27-pip libxml2 py27-lxml
    

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 seosuitedb database and seosuiteuser user:
      CREATE DATABASE seosuitedb CHARACTER SET utf8;
      
      CREATE USER 'seosuiteuser'@'localhost' IDENTIFIED BY 'SuperSecretPassword';
      
      GRANT ALL PRIVILEGES ON seosuitedb.* TO 'seosuiteuser'@'localhost';
      
      FLUSH PRIVILEGES;
      
      quit
      

Install SEO Tools Suite

  • Clone the seosuite from GitHub:
    git clone https://github.com/saymedia/seosuite.git
    cd seosuite
    
  • Run the python packager to install seosuites dependencies:
    pip install -r requirements.txt
    
  • Import the SQL schema into mysql:
    cat schema.sql | mysql -useosuiteuser -p seosuitedb
    
  • Create the config files from the examples:
    cp testurls.example testurls
    cp config.yaml.example config.yaml
    
  • Edit the seosuite config:
    vi config.yaml
    
    • And make sure the database settings are correct:
      db:
        host: localhost
        user: seosuiteuser
        pass: SuperSecretPassword
        name: seosuitedb
      gdata:
        user: seo@example.com
        pass: password
      
  • Run seocrawl
    ./seocrawler.py http://www.example.com
    

Resources

History

#1 Updated by Daniel Curtis almost 4 years ago

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

#2 Updated by Daniel Curtis almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF