GNet Solutions » FreeBSD Administration

Support #866

Updated by Daniel Curtis about 8 years ago

This is a guide on setting up SEO Tool Suite on FreeBSD 

 h2. Prepare the Environment 

 * Make sure the system is up to date: 
 <pre> 
 pkg update && pkg upgrade 
 </pre> 

 * Install a few dependencies: 
 <pre> 
 pkg install git python py27-pip libxml2 py27-lxml 
 </pre> 

 h2. Install MySQL Server 

 * Start by installing the mariadb100-server and mariadb100-client packages: 
 <pre> 
 pkg install mariadb100-{server,client} 
 </pre> 

 * Copy a base MySQL configuration to use: 
 <pre> 
 cp /usr/local/share/mysql/my-small.cnf /var/db/mysql/my.cnf 
 </pre> 

 * Enable and start mysql at boot: 
 <pre> 
 echo 'mysql_enable="YES"' >> /etc/rc.conf 
 service mysql-server start 
 </pre> 

 * Prepare the database for use by running the secure installation: 
 <pre> 
 mysql_secure_installation 
 </pre> 
 #* *NOTE*: +Choose a strong root password+ and answer +yes+ to all questions. 

 h3. h2. Create Databases and Users 

 * Login to MySQL and create appropriate databases and users. 
 <pre> 
 mysql -u root -p 
 </pre> 
 #* and run the following SQL queries to create the *seosuitedb* database and *seosuiteuser* user: 
 <pre> 
 CREATE DATABASE seosuitedb CHARACTER SET utf8; 

 CREATE USER 'seosuiteuser'@'localhost' IDENTIFIED BY 'SuperSecretPassword'; 

 GRANT ALL PRIVILEGES ON seosuitedb.* TO 'seosuiteuser'@'localhost'; 

 FLUSH PRIVILEGES; 

 quit 
 </pre> 

 h2. Install SEO Tools Suite 

 * Clone the seosuite from GitHub: 
 <pre> 
 git clone https://github.com/saymedia/seosuite.git 
 cd seosuite 
 </pre> 

 * Run the python packager to install seosuites dependencies: 
 <pre> 
 pip install -r requirements.txt 
 </pre> 

 * Import the SQL schema into mysql: 
 <pre> 
 cat schema.sql | mysql -useosuiteuser -useosuite -p seosuitedb 
 </pre> 

 * Create the config files from the examples: 
 <pre> 
 cp testurls.example testurls 
 cp config.yaml.example config.yaml 
 </pre> 

 * Edit the seosuite config: 
 <pre> 
 vi config.yaml 
 </pre> 
 #* And make sure the database settings are correct: 
 <pre> 
 db: 
   host: localhost 
   user: seosuiteuser 
   pass: SuperSecretPassword 
   name: seosuitedb 
 gdata: 
   user: seo@example.com 
   pass: password 
 </pre> 


 * Run seocrawl 
 <pre> 
 ./seocrawler.py http://www.example.com 
 </pre> 

 h2. Resources 

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

Back