How to install and configure Sphider on Windows

Home > Search > How-to
  by

  1. Download the latest version of Sphider from http://www.sphider.eu. This will download a .zip. Extract this zip, and move the Sphider folder to the root of your web server. For example, in IIS there is a website where the root directory is E:/Documents/stage, so we'd move the Sphider folder to E:/Documents/stage.
  2. Create a new database named sphider_bd. In Microsoft SQL Server Management Studio, right click on Databases -> New Database -> sphider_db -> OK.
  3. Create a new database user. In Microsoft SQL Server Management Studio, under database, expand the sphider_db, right click on Security -> New -> User -> SQL user with login -> Create a username -> OK.
  4. Give database user permissions. In Microsoft SQL Server Management Studio, under database, expand the sphider_db -> Security, right click on the username you created -> Properties -> Owned Schemas, and check db_accessadmin and db_owner. Also select Membership, and check db_accessadmin and db_owner.
  5. Create the database tables. Go to E:/Documents/stage/sphider-version/sql, and open the tables.sql file. In Adminer, login to MS SQL with the username you just created, and database sphider_db, and go to SQL Command. We need to make come changes to the tables.sql code, because this code is written for MySQL. Small changes need to be made to get this to work with MS SQL.
    • replace auto_increment with indentity
    • replace bool with tinyint
    • replace key with index
    • replace mediumtext with text
    • remove ENGINE = MYISAM;
    • remove keywords
  6. Now, copy the tables.sql code, paste into Adminer, and execute.
  7. In the Sphider folder, go into the Settings folder, and open database.php in your favorite editor. Change $database, $mysql_user, $mysql_password and $mysql_host to correct values. If you dont know what $mysql_host should be, it should probably stay as it is - 'localhost'.
  8. In your web browser, open yourdomain.com/admin/install.php. This setups up the tables in our MySQL Sphider directory.
  9. In your web browser, open yourdomain.com/admin/admin.php. User admin for both the username and password. Enter your domain name, and select Full Index.
  10. In your web browser, open yourdomain.com/search.php, and test to see if the search engine works


Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments