GNet Solutions » FreeBSD Administration

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¶

• https://github.com/saymedia/seosuite