Fix error bind() fail on sphinx

We should try 2 command before this below guide :

the 'init: ... main process ended, respawning' suggests there is something in the init script that sets a watchdog to make sure sphinx doesnt die.

Perhaps you need to shutdown sphinx via the init script itself

/etc/init.d/sphinxsearch stop

or

By default, it seems like the debian package will start Sphinx with an additional keepalive process. I was able to stop it successfully with this;

sudo service sphinxsearch stop

If 2 way above is not success, you should try.
using config file '/sphinx/conf/sphinx.conf'...
listening on all interfaces, port=9312
bind() failed on 0.0.0.0, retrying...
bind() failed on 0.0.0.0, retrying...
bind() failed on 0.0.0.0, retrying...
bind() failed on 0.0.0.0, retrying...
bind() failed on 0.0.0.0, retrying...
bind() failed on 0.0.0.0, retrying...

If happend error like this, the best way , you should change port in config file
Change 9312 to some other port.


listen = 9312
listen = 9306:mysql41

To 

listen = 9314
listen = 9308:mysql41

Simple blog using mongoDb

This is simple blog allow display post , add new post and add comment for post using MongoDb for storage.
Note: Download mongDb for php at this link http://www.mongodb.org/display/DOCS/PHP+Language+Center

And install mongDb before demotrastion.

I pushed source to gitHub att this link https://github.com/bvtuan/blog_mongodb
Hope it useful for who learning mongoDb.

Install jdk 7 for ubuntu 12.04

Just use some terminal code below :

sudo rm /var/lib/dpkg/info/oracle-java7-installer*
sudo apt-get purge oracle-java7-installer*
sudo rm /etc/apt/sources.list.d/*java*
sudo apt-get update
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

Installing Sphinx 2.0.4 on Ubuntu 10.04 - Lucid

Description: “Sphinx  is a full-text search engine, distributed under GPL version 2. Commercial license is also available for embedded use. Generally, it’s a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes). As for the name, Sphinx is an acronym which is officially decoded as SQL Phrase Index. Yes, I know about CMU’s Sphinx project“.

Installation:

• Install the packages needed: apt-get install gcc make libmysqlclient15-dev libmysql++-dev
• Download Sphinx from here .
• Decompress it: tar xvfz sphinx-*.tar.gz
• Enter its directory: cd sphinx-*
• Run configure: ./configure --prefix=/usr/local/sphinx --with-mysql
• Compile Sphinx: make
• Install Sphinx (as root): make install

Configuration:

• Enter Sphinx’s directory: cd /usr/local/sphinx/etc
• Make a copy of its default configuration: cp sphinx.conf.dist sphinx.conf
• Modify it to fit you database schema and preferences (I recommend reading Sphinx’s official documentation   and this tutorial by IBM  first).
• Create all indexes: /usr/local/sphinx/bin/indexer --all
• Something like this will be shown:
  
Sphinx 0.9.9-rc2 (r1785)
Copyright (c) 2001-2009, Andrew Aksyonoff
  using config file '/usr/local/sphinx/etc/sphinx.conf'...
indexing index 'software'...
collected 10 docs, 0.0 MB
sorted 0.0 Mhits, 100.0% done
total 10 docs, 649 bytes
total 0.013 sec, 48970 bytes/sec, 754.54 docs/sec
total 2 reads, 0.000 sec, 16.3 kb/call avg, 0.0 msec/call avg
total 5 writes, 0.000 sec, 0.4 kb/call avg, 0.0 msec/call avg

Use:

• You can perform a basic search using: /usr/local/sphinx/bin/search desired_word . It matches all words by default, but you can change this behaviour. Run/usr/local/sphinx/bin/search without arguments to show the available options.
• Example: /usr/local/sphinx/bin/search samba
  Sphinx 0.9.9-rc2 (r1785)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/usr/local/sphinx/etc/sphinx.conf'...
index 'software': query 'samba ': returned 1 matches of 1 total in 0.000 sec

displaying matches:
1. document=10, weight=2
id=10
url=http://www.samba.org/
name=Samba
description=Samba is a SMB/CIFS file, print, and login server. It seamlessly integrates Linux/Unix Servers and Desktops into Active Directory environments using the Winbind daemon.
stable_version=3.4.3
stable_date=2009-10-29
download=http://www.samba.org/samba/ftp/stable/samba-3.4.3.tar.gz

words:
1. 'samba': 1 documents, 2 hits

The use of /usr/local/sphinx/bin/search is just for test and debugging purposes. There are native API ports for PHP, Python, Java, Perl, and Ruby. I will explain the integration between PHP  and Sphinx on another post.

Source :http://acidborg.wordpress.com/2009/11/22/how-to-install-and-configure-sphinx-in-ubuntu-9-10-with-mysql-support/

Note :use searchd --config "config file first";
then sudo indexer --config "config file" --all --rotate