Thursday, December 27, 2012

Installing OpenFire on a Mac OSX 10.6 Snow Leopard

Installed OpenFire is a real time collaboration (RTC) server on Mac OS X 10.6 Snow Leopard

Create a new user for OpenFire database, instead of using root in mySQL database on Mac OS X 10.6 Snow Leopard.

Download the tar.gz and unzip the latest JDBC driver for mySQL from

To Installation JDBC driver in Mac OSX 10.6 Snow Leopard:
Copy the file mysql-connector-java-5.1.22-bin.jar to the directory /Library/Java/Extensions/

Login to mysql (if you don't have set a password for database-root account yet, forgot about the "-p" parameter)

shell> mysql -p -u root

create a new database 'openfire':
mysql> CREATE DATABASE openfire;

create a new user 'openfirexxx':
mysql> CREATE USER 'openfirexxx'@'localhost' IDENTIFIED BY 'your-new-password';

Remove permissions if users already exists:
mysql> REVOKE ALL ON *.* FROM openfire;
ERROR 1141 (42000): There is no such gran defined for user 'openfirexxx' on host '%' | this is a good error

Give user 'openfirexxx' only rights for table 'openfire' and important using any IP connection ->@'%'
mysql> GRANT ALL PRIVILGES ON openfire.* TO openfirexxx @'%' WITH GRANT OPTION; 

mysql> exit

import OpenFire mySQL database schema on Mac OS X:
shell> cat /usr/local/openfire/resources/database/openfire_mysql.sql | /usr/local/mysql/bin/mysql -p openfire;

Following  OpenFire installation screens and when you get to page localhost:9090/setup/setup-profile-settings.jsp
I got the following error:


Problem accessing /setup/setup-profile-settings.jsp. Reason:

 at org.jivesoftware.openfire.admin.setup.setup_002dprofile_002dsettings_jsp._jspService(

Trying the following fix: 

On ANY Mac w/ a 64-bit processor, you need to go into Applications --> Utilities --> Java Preferences and once you open the utility console you need to move the 32-bit version to the top of the priority list.

Reboot your machine! This solved the above error.

The errors continued.....

Could not find error.log, warn.log, etc and and Java Error on port 5229 - 

List of All ports on Mac

Port 5229 is free?

So I just created the the logs required error.log, warn.log, info.log and debug.log and change permissions for this file to be writable by current user. 

Changed permission on 
/usr/local/openfire/bin/extra/  to start and stop correctly from non-root account.

One last gotcha, log-in using admin instead of the your email id for admin user!!!!! 

Success ! Server is now working! 

Command line start / stopping of OpenFire

To start service:
sudo launchctl load /Library/LaunchDaemons/org.jivesoftware.openfire.plist

To stop service:
sudo launchctl unload /Library/LaunchDaemons/org.jivesoftware.openfire.plist

Spark Issues
Spark on top of this and make sure to install the plugin for "Search" on the server so you can find other users!

Firewall Ports for IM Client (using Spark) check your firewall: 
1) admin console that runs on port 9090
2) openfire im client must reach im traffic on port 5222
3) port 7777, for file transfers; these are the defaults.
re :

Tuesday, December 25, 2012

Google Web History - Turning it Off

Pause your "Search" Web History

If you're visiting a webpage or performing a search in Google Chrome and online at your search are stored online by default at window
If you don't want stored in your web history online:

2.Click Pause to prevent your future web activity from being saved in Web History and from being used to personalize your search results. To start keeping track of your web activity again, click Resume.
3.There is an option to Remove All Web History - what residuals remain is uncertain.

If you'd like to sign out of Web History altogether, click your name or email address at the top of the page, then select Sign out from the drop-down menu. Note that you'll need to sign back in to your Google Account in order for Web History to begin storing your web activity again.

Turn off Personal Results

Personal results are pages shared with you by your friends, Google+ posts from people you know, and content that's only visible to you (like private photos from Google+ new window and Picasa new window albums). Personal results are part of Search plus Your World new window.
You can see what your results look like without personal content by clicking the globe button on the top right-hand side of your search results page. This setting is session-specific, meaning that if you close your browser, personal results may appear next time you search. You can switch back to seeing personal results by clicking the personal results button.
You can turn off personal results in your search settings new window. This action is account-specific, meaning that personal results will remain disabled as long as you're signed in to your Google Account new window.
·  Click the gear icon gear in the top right corner of the search results page.
·  Click Search settings.
·  In the "Search plus Your World" section, select "Do not use personal results."
If you turn off personal results and stay signed in to your Google Account, you won't see results personalized based on your Google+ circles (or suggested connections), Google products, or your search history.
If you turn off personal results and sign out of your Google Account, you may still see personalized results and results based on the context of your search.