Archive for September, 2008

Business Tools and Resources

No GoodNeed ImprovementOKGoodExcellent (No Ratings Yet)
Loading ... Loading ...

1, IVR: www.angel.com

2, Ring Central: www.ringcentral.com

3, Call Center: www.west.com, www.liveops.com

4, CRM: www.convergys.com.

Popularity: 2%

Comments

Outsourcing, Virtual Assistants,Personal Assistants, Freelance Programming

No GoodNeed ImprovementOKGoodExcellent (No Ratings Yet)
Loading ... Loading ...

Popularity: 2%

Comments

Install and configure Sphinx search engine for WordPress on CentOS RedHat

No GoodNeed ImprovementOKGoodExcellent (1 votes, average: 4 out of 5)
Loading ... Loading ...

1, Download Sphinx search engine from Sphinx

wget http://www.sphinxsearch.com/downloads/sphinx-0.9.8.tar.gz

tar xzvf sphinx-0.9.7.tar.gz

2, Install MySQL mysql-devel

yum install mysql-devel

3, Configure Sphinx

cd sphinx-0.9.8
./configure –prefix /home/sphinx/sphinxsearch –with-mysql
make
make install

4, Create a configuration file

cd /home/sphinx/sphinxsearch/etc
cp sphinx.conf.dist sphinx.conf

5, Edit sphix.conf

vi sphinx.conf

Configuration file sphinx.conf for wordpress

source mywhiteboard
{
type = mysql
sql_host = localhost
sql_user = mywhiteboard
sql_pass = a1b2c3z4y5×6
sql_db = ivdb
sql_port = 3306
sql_query = SELECT id, post_title, post_content FROM wp_posts
sql_query_info = SELECT * FROM wp_posts WHERE id =$id
}

index mywhiteboard
{
source = mywhiteboard
path = /home/sphinx/sphinxsearch/var/data/mywhiteboard
docinfo = extern
mlock = 0
morphology = stem_en

enable_star=1

stopwords = /home/sphinx/sphinxsearch/var/data/stopwords.txt
min_word_len = 3
charset_type = sbcs
min_prefix_len = 0
min_infix_len = 3
html_strip = 1
html_remove_elements = style, script
}

indexer
{
mem_limit = 256M
}
searchd
{
port = 3312
log = /home/sphinx/sphinxsearch/var/log/searchd.log
query_log = /home/sphinx/sphinxsearch/var/log/query.log
read_timeout = 5
max_children = 30
pid_file = /home/sphinx/sphinxsearch/var/log/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
}

6, make a directory for indexes

mkdir
/home/sphinx/sphinxsearch/var/data/mywhiteboard

7,  Start indexer:

/home/sphinx/sphinxsearch/bin/indexer
--config  /home/sphinx/sphinxsearch/etc/sphinx.conf --all

Sphinx 0.9.8-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file ‘/home/sphinx/sphinxsearch/etc/sphinx.conf’…
indexing index ‘mywhiteboard’…
collected 1104407 docs, 1938.9 MB
sorted 6551.8 Mhits, 98.5% donedone
total 1104407 docs, 1938867135 bytes
total 5126.826 sec, 378180.78 bytes/sec, 215.42 docs/sec

8, To test if it is working:

/home/sphinx/sphinxsearch/bin/search
--config /home/sphinx/sphinxsearch/etc/sphinx.conf insulin

….
20. document=9345, weight=3
    id=9345
….
words:
1. ‘insulin’: 30601 documents, 109926 hits

9, See how much disk space the indexer used:

ls -la
/home/sphinx/sphinxsearch/var/data/mywhiteboard
drwxr-xr-x 3 root root 4096 Oct 21 16:20 .
drwxr-xr-x 4 root root 4096 Sep 11 20:08 ..
-rw-r–r– 1 root root 0 Oct 21 15:32 mywhiteboard.spa
-rw-r–r– 1 root root 14925566596 Oct 21 16:20 mywhiteboard.spd
-rw-r–r– 1 root root 237 Oct 21 16:20 mywhiteboard.sph
-rw-r–r– 1 root root 57254921 Oct 21 16:20 mywhiteboard.spi
-rw-r–r– 1 root root 0 Oct 21 15:32 mywhiteboard.spm
-rw-r–r– 1 root root 22721504506 Oct 21 16:20 mywhiteboard.spp

Popularity: 3%

Comments