https://github.com/MacMiniVault/Mac-Scripts/tree/master/sshport

All you have to do is enter the following single line of code into terminal.

bash <(curl -Ls http://git.io/_9fF7g)

After that, you just enter the port number you want to use and you are done. The script takes care of restarting the SSH service. It is super easy, and saves you the time of having to manually edit system files.

This tutorial is going to walk you through how to install the latest version of Sphinx, configure it for a basic usage, and use the PHP API to run search queries in PHP on a LAMP (Linux, Apache, MySQL, PHP) stack server. This tutorial is based on Ubuntu 12.04 64bit and assumes you have a LAMP stack server setup and SSH access to your server. If you get stuck at any point, browse on over to the Sphinx documentation for additional explination.

In recent months, I have switched all of my website hosting to DigitalOcean. While this is not an ad or a post about DigitalOcean, I will say that their cloud based servers are perfect for playing around with new technologies, like Sphinx. If you set up a new droplet (cloud server) you can destroy it 1 hour later and only pay pennies for the time you used it.

Example MySQL Database

In this example, we are going to search through a database of movies based on title and synopsis. Below is the example MySQL structure to go along with this example.

CREATE TABLE `movies` (
  `movie_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `synopsis` text,
  `timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`movie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Installing Sphinx

We are going to start by downloading the Sphinx (latest release version at the time of writing this is 2.0.9) DEB file to our server.

sudo wget http://sphinxsearch.com/files/sphinxsearch_2.0.9-release-0ubuntu11~precise_amd64.deb

Now that we have the DEB file downloaded we need to install it. Before we can do that, we need to install the libpq5 package.

sudo apt-get install libpq5

Extract/Install Sphinx

sudo dpkg -i sphinxsearch_2.0.9-release-0ubuntu11~precise_amd64.deb

Remove the original download.

sudo rm -r sphinxsearch_2.0.9-release-0ubuntu11~precise_amd64.deb

Congratulations, Sphinx is now installed. Wasn’t that easy?

Setup & Configure Sphinx

Now that Sphinx is installed, we are going to configure it to work with an imaginary site, yoursite.com, which is located at /var/www/yoursitecom/public_html/ in this example. All of the commands below will need to be adjusted to reflect your sites paths and name.

Lets start by creating a folder structure for Sphinx inside our sites existing folder structure.

sudo mkdir -p /var/www/yoursitecom/sphinx/data /var/www/yoursitecom/sphinx/etc /var/www/yoursitecom/sphinx/logs

We just setup 3 folders inside the yoursitecom directory. Notice that we put everything in the parent folder, not the public facing folder. This is important for security reasons. The data folder is going to house the generated indexes for this site. The etc folder is going to contain our site specific config file, and the logs folder is going to house some Sphinx specific logs.

Now, lets create a couple of empty files which will recieve data in the future.

sudo touch /var/www/yoursitecom/sphinx/etc/sphinx.conf /var/www/yoursitecom/sphinx/logs/query.log /var/www/yoursitecom/sphinx/logs/searchd.log /var/www/yoursitecom/sphinx/logs/searchd.pid

Now that we have our file and folder structure setup, lets start configuring Sphinx.

sudo vim /var/www/yoursitecom/sphinx/etc/sphinx.conf

/* Define the source that will be used to index your database. */
source yoursitemovies {

	/* Configure your MySQL details. */
	type = mysql
	sql_host = localhost
	sql_user = mysql_user
	sql_pass = mysql_pass
	sql_db = mysql_db

	/* Ranged queries are useful to avoid notorious MyISAM table lockup when indexing lots of data. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-sql-query-range */
	sql_query_range = SELECT MIN(movie_id), MAX(movie_id) FROM movies
	
	/* Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-sql-range-step */
	sql_range_step = 1000
	
	/* This is the query that will be indexed by Sphinx. In this example title and synopsis will be indexed and movie_id will identify the record. */
	sql_query = SELECT movie_id, title, synopsis FROM movies WHERE movie_id>=$start AND movie_id<=$end
	
}

/* Configure an index based of the source above. */
index yoursitemovies {

	/* Define your source from above. )
	source = yoursitemovies
	
	/* This is the path to store the index data/cache. Provide a filename without an extension. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-path */
	path = /var/www/yoursitecom/sphinx/data/movies
	
	/* This is the minimum word length to index. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-min-word-len */
	min_word_len = 3
	
	/* This allows searching of partial words. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-min-infix-len */
	min_infix_len = 3
	
}

/* Configure your searchd service. */
searchd {

	/* Ignore compatibility mode. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-compat-sphinxql-magics */
	compat_sphinxql_magics = 0
	
	/* Define your log file paths. */
	log = /var/www/yoursitecom/sphinx/logs/searchd.log
	query_log = /var/www/yoursitecom/sphinx/logs/query.log
	pid_file = /var/www/yoursitecom/sphinx/logs/searchd.pid
	
 	/* Configure the searchd listening port. Port 9312 is the recommended/default port. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#conf-listen */
	listen = localhost:9312
	
}

Now that we have our Sphinx settings all setup, we are going to build our first index.

sudo /usr/bin/indexer --config /var/www/yoursitecom/sphinx/etc/sphinx.conf --all

Now that our index has been built, we can manually start our searchd service. This is the service that actually searches the index we just built.

sudo /usr/bin/searchd --config /var/www/yoursitecom/sphinx/etc/sphinx.conf

Now that everything is setup, configured and indexed, we can search our newly created index.

sudo /usr/bin/search -c /var/www/yoursitecom/sphinx/etc/sphinx.conf searchterm

You should see out that resembles the output below.

Sphinx 2.0.9-id64-release (rel20-r4115)
Copyright (c) 2001-2013, Andrew Aksyonoff
Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/var/www/filmfedcom/sphinx/etc/sphinx.conf'...
index 'filmfedmovies': query 'first ': returned 54 matches of 54 total in 0.000 sec

displaying matches:
1. document=40, weight=2621
2. document=257, weight=2621
3. document=554, weight=2621
4. document=43, weight=1588
5. document=45, weight=1588
6. document=50, weight=1588
7. document=51, weight=1588
8. document=52, weight=1588
9. document=61, weight=1588
10. document=95, weight=1588
11. document=130, weight=1588
12. document=139, weight=1588
13. document=143, weight=1588
14. document=157, weight=1588
15. document=164, weight=1588
16. document=168, weight=1588
17. document=181, weight=1588
18. document=198, weight=1588
19. document=215, weight=1588
20. document=218, weight=1588

words:
1. 'first': 54 documents, 57 hits

index 'filmfedpeople': query 'first ': returned 0 matches of 0 total in 0.000 sec

words:
1. 'first': 0 documents, 0 hits

In the matched section you will see the document, this is the movie_id from the DB. You can use this number to pull the record from your DB to display search results. The weight number listed is the relevance of the search term. The higher the number, the stronger the relevance that record is to your search term.

Now that everything is working, lets configure some basic server settings to make the searchd service start on server startup as well as create a crontab to update our index every few hours.

By default, your would have to start the searchd service manually after server reboot. That is no fun. Let configure it to start automatically. Start by adding a the searchd start command to the servers rc.local file.

sudo vim /etc/rc.local

Paste the following code just above the exit 0 line.

/usr/bin/searchd --config /var/www/yoursitecom/sphinx/etc/sphinx.conf

Now that we have everything setup and running, we need to make sure our index stays up-to-date with our database. We are going to accomplish this by running a crontab to rotate (rebuild) our index every 6 hours.

sudo crontab -e

Add the following line to the bottom of the document.

0 */6 * * * /usr/bin/indexer --rotate --config /var/www/yoursitecom/sphinx/etc/sphinx.conf --all

That is it. We now have everything configured, running, and automated. Next, we are going to learn how to run search queries in PHP agains our Sphinx index.

Accessing Sphinx inside PHP

Sphinx has an amazing API that allows PHP to run search queries against the Sphinx index. The following code is an example PHP script which will explain a basic level PHP integration.

<?PHP

/* Include the Sphinx PHP API */
require_once('/usr/share/sphinxsearch/api/sphinxapi.php');

/* Start the SphinxClient class. */
$cl = new SphinxClient();

/* Match all words or any word? Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#api-func-setmatchmode */
$cl->SetMatchMode(SPH_MATCH_ALL);

/* Set your field weights manually. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#api-func-setfieldweights */
$cl->SetFieldWeights(array('title' => 50, 'synopsis' => 10));


/* Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#api-func-setsortmode */
$cl->SetSortMode(SPH_SORT_RELEVANCE);

/* Works like MySQL LIMIT. This is how you can paginate search results. */
$cl->setLimits(0,10);

/* The Query method will search the search term against the selected index. Learn More: http://sphinxsearch.com/docs/manual-2.0.9.html#api-func-query */
$res = $cl->Query('searchterm', 'yoursitemovies');


/* Now that we have the matches and weight, we are going to make a comma separated list of movie_id's to pull attentional details out of our DB. */
$c = 1;
foreach ($res['matches'] AS $key => $value) {
	if ($c == 1) {
		$movie_ids = $key;
	}
	else {
		$movie_ids .= ',' . $key;
	}

	$c++;
}

/* Here, we are using a MySQL IN clause to pull the movie_id, title, and synopsis from the DB for display. */
$sql = $pdo->prepare('SELECT movie_id, title, synopsis FROM movies WHERE movie_id IN (' . $movie_ids . ')');
$sql->execute();

/* Next, we are going to combine the pulled data with the Sphinx data so we can display everything based on the Sphinx weight integer. */
while ($qresult = $sql->fetchObject()) {
	$results['matches'][$qresult->movie_id]['data'] = $qresult;
}

foreach ($results['matches'] AS $result) {
	echo $result['data']->title;
	echo $result['data']->synopsis;
}

/* Now, lets dump everything on the screen. */
echo '<pre>';
var_dump($result);
echo '</pre>';

Well, that is it. You have learned how to install, configure, and control Sphinx via PHP and command line. Please share your experience in the comments below. Were you successful with your Sphinx endeavor? Do you have a questions? Did you encounter an issue? I am here to help.

After the jump, you will find a short multi-step process that describes in detail how you can add the Tapiture bookmarklet to Safari on the iPad. If you have any feedback, or comments, please share them in comments.

If you are not reading this on an iPad, please browse to this article in Safari on the iPad. You will need to copy and paste code from the article to Safari on the iPad. Here is a short link you use to quickly find your way back to this article: bit.ly/tapipad

Step 1: Bookmark This Page

No, I am not trying to get you to bookmark my website. I just need you to bookmark this page so we have a bookmark to edit. In the next step, we are going to edit the bookmark you create in this step.

To create a bookmark in Safari on the iPad, click the box with an arrow icon in the top left corner. Then click the icon labeled “Bookmark” from the drop-down. When you get to the “Add Bookmark” menu, click “Save” to bookmark this page.

Step 2: Copy The Bookmarklet Code

Now that you have created a bookmark, it is time to edit it to associate with Tapiture instead of ATLChris.com. To get started, copy the code in the textbox below into the iPad clipboard for use later.

javascript: var e = document.createElement(‘script’);e.setAttribute(‘id’, ‘tapiture_js’);e.setAttribute(‘charset’, ‘UTF-8’);e.setAttribute(‘src’, ‘//static.tapcdn.com/mosaic/tap_browser.js?ver=’ + Math.random());document.body.appendChild(e);

* To select all on the iPad, click once in the textarea, then click a second time and then click “Select All” from the menu that appears.

Step 3: Edit The Bookmark

Start by clicking the icon that looks like a book in the top left corner of the page. When presented with the “Bookmarks” drop-down, click “Edit” in the top right corner of the drop-down. Now, click on the name of the bookmark you created in step 1. You should find yourself on the “Edit Bookmark” menu.

The top text field is the name of the bookmark, I would suggest you edit this to say “Tap on Tapiture”. The second field is the url that is loaded when the bookmark is clicked. Instead of a url, this is where we are going to paste the code that we copied in step 2. Click on the second field and then click the “X” that appears to clear the field. Once the field is clear, click on it again. You should see a button appear to “Paste” the contents of you clipboard. Click “Paste” and you should see the code you copied earlier appear in the field. That is it, you are all done. Click the “Bookmark” button at the top left to go back and then click “Done”.

Step 4: Enjoy

Now that you have the bookmark setup correctly, when you want to Tap an image, click the “Bookmark” icon in the top left corner of Safari on iPad and click the “Tap on Tapiture” bookmark to bring up the Tapiture overlay.

Note: This is not an officially supported feature of Tapiture, the overlay that appears may not work prefectly and you may not be able to tap everything you normally can, but it works great for images.

So, what is Tapiture? Well, Tapiture is Pinterest clone that is more geared towards men, and the things men like. I have been a huge fan of it since it was in beta a few months ago. New in January 2013, Tapiture launched a whole new branding and design initiative to take the site to the new level. They also announce that they now have over 1.2 million unique vistors each month and it is growing at an alarming rate.

Tapiture offers a bookmarklet that allows you to “Tap” multiple images on a page. While this bookmarklet is good, I found it difficult to “Tap” a single image on a page with main images. After realizing this was a problem I could fix very easily on my own, I decided to take a shot at making a Google Chrome Tapiture extension. This was my first attempt at a Google Chrome extension, but I very pleased with how it turned out. The Tapiture extension allows the bookmarklet to live in the info bar instead of the bookmark bar. Best of all, it adds the ability to right-click an image and tap that single image.

Download link and screenshots available after the jump.

Below are a couple of screenshots that show how the extension works:

I would love to hear what you think, and if you have any feature requests for bugs to report.

function hideURLbar() {
	window.scrollTo(0, 1);
}

if (navigator.userAgent.indexOf('iPhone') != -1 || navigator.userAgent.indexOf('Android') != -1) {
    addEventListener("load", function() {
            setTimeout(hideURLbar, 0);
    }, false);
}

This code hides the browser address bar in iOS and Android if the length of the pages content is long enough. This is a very common function and is excellent if you would like to increase the mobile browsers content viewable area. I have one small problem with it, it doesn’t take into account page anchors (http://www.example.com/#comments). When the page loads with a page anchor, it cancels out this anchor and scrolls to the top on load.

I propose an improvement to this code javascript snippet that will add a page anchor check statement prior to the window.scrollTo(0, 1); function.

function hideURLbar() {
	if (window.location.hash.indexOf('#') == -1) {
		window.scrollTo(0, 1);
	}
}

if (navigator.userAgent.indexOf('iPhone') != -1 || navigator.userAgent.indexOf('Android') != -1) {
    addEventListener("load", function() {
            setTimeout(hideURLbar, 0);
    }, false);
}

Today, I have officially released version 2.0 of my popular premium business WordPress theme, Simply Business. Simply Business WordPress v2.0 brings a ton of new features, bug fixes, and full WordPress 3.3 support! This theme can be purchased on ThemeForest.net for only $30.00.

Features

• Complex cms functionality
• Ajax contact form
• Full widget support
• Shortcodes
• Custom widgets & shortcodes
• Testimonial custom post type
• Portfolio custom port type
• Redesigned theme options panel
• Unlimited color combination’s w/ color picking tool
• Custom jQuery powered image slider
• Search engine optimized (SEO) design and code to help you increase search engine rankings.
• Support for WordPress menus
• Lightbox functionality
• Pagination support
• Much much more…

Theme Screenshots

Theme Options Panel Screenshots

Changelog

• v2.0 – 1/20/2012:
  • [ADD] added the ability to upload a logo and favicon directly from the theme options panel.
  • [ADD] added portfolio custom post type with custom backend and 3 template options.
  • [ADD] pagination navigation added across the site.
  • [ADD] added footer navigation.
  • [ADD] added a color picker to all color select options in the theme options panel.
  • [ADD] added lightbox functionality throughout the site with Slimbox 2.
  • [ADD] added 8 highly customizable and well written shortcodes.
  • [ADD] added 6 highly customizable and well written widgets.
  • [CHANGE] theme completely rewritten to take full advantage of WordPress v3.3.
  • [CHANGE] fully redesigned theme options panel.
  • [CHANGE] homepage slider now uses custom/optimized jQuery.
  • [CHANGE] homepage content box 1 can now be driven by either the blog or a page. (Highly Requested Feature!)
  • [CHANGE] testimonials are now handled via custom post type for optimal integration.
  • [CHANGE] header and footer navigation is now controlled via the WordPress menus manager.

When you get to the site, enter the address you grew up in then click search. An HTML5 video like you have never seen before will begin playing.

Just trust me, browse over to http://thewildernessdowntown.com in an HTML 5 browser and be amazed!

My theory is that the new mystery iLife application is going to be iTV. They just released a Mac Mini with HDMI out, they have an iMac large enough to use as a TV, and they have a new input device, the Magic Trackpad. I think they are going to scrap Apple TV as a hardware device and introduce a new couch/remote friendly application called iTV to the iLife suite. Yes, I know they already have Front Row, but seriously, who uses that, it is total crap.

I personally am all for this, I currently have a Mac Mini hooked up to my 50″ Plasma and am currently running Plex, a great Media Center application. Apple has hinted that streaming movies would hit the cloud before streaming music, so could the new mystery data center and the mystery iLife application be connected to allow us to download and stream TV Shows and Movies in a whole new way?

What are your thoughts? Would you use this?

Well, as promised Apple has activated the iPhone 4 FREE case program. If you already purchased a bumper from Apple, you will automatically get your refund. Emails concerning this have already been floating around.

How about those that didn’t buy a bump? It looks like Apple is going to be handling this through an iPhone app. The application you have to download is called “iPhone 4 Case Program” and it is currently available in the app store. Pretty much, you just open the app, login with your iTunes credentials, then you are presented with a list of cases. Pick which one you want, and vola, it will show up in the mail soon.

iPhone 4 Case Program Details

UPDATE 1: The iPhone application currently lists all cases as “Ships 3-5 weeks”.

UPDATE 2: In app pictures below:

UPDATE 3: I ordered the InCase Snap (Smoke) case. It seemed like a pretty solid pick out of the group. I was impressed though with the selection they had. I will do a full review on the case when it is received.

Stay tuned, I will post further details about shipping times and the overall ordering process.

• Access via many new devices including: iPhone, iPad, iPod, Internet Connected TV’s, Playstation 3, Xbox 360, and more…
• Current season tickets to popular current TV shows including: Glee, The Office, Modern Family, Grey’s Anatomy, Family Guy, and more…
• Full series back cateloges of current and past TV Series including: Heroes, Buffy the Vampire Slayer, Arrest and Development, and more…

There is no word yet whether this premium service will be ad free or not ad-supported. I would hope that paying would remove the ads completely. Currently the service is in private beta. You can request an invite at http://www.hulu.com/plus. There is no ETA on when the service will launch publicly or when “Requested Invites” will beging to roll out. Check out the introduction video below which showcases all the new content the service has to offer.

I personally will sign up for the service, in fact it might be the final nail-in-the-coffin for my cable services I currently have will Charter Communications. One thing I would love to see, is the addition of premium cable series, i.e. Entourage, True Blood, … I would be willing to add another $5.00 a month if I could get some of those shows. I am also curious to whether they will be beefing up their movie catelog offerings.

Would you be willing to pay $9.99 for this service?