Archive for the ‘Open Source’ Category
Can’t find Skype on Android Market?
I had this same problem. I reset my phone one day and lost the Skype beta app I had. Fortunately when I logged into the Market it was in my list of downloads and let me download and install it again. I was fortunate to get it back but I never did see it in the market after that.
How to Install Skype on CentOS
I am currently studying for the Linux + certification. I work with Linux alot becuase of my web site work. This is typically all command shell through SSH, Webmin, or WHM. I am forcing myself to use Linux on a daily basis as my workstation so I will learn it even more. The flavor of Linux I am using is CentOS. One of the tools I use is Skype. Skype does not have a RPM package for CentOS. This application has to be installed manually. I had to figure out how to get this installed. Here are the steps I took to install this and configure it.
INSTALL:
Skype only comes in 32 bit so if you have a 64 bit machine you need to run the following to install 32 bit libraries. This is required to run the 32 bit Skype application.
yum install glib2.i386 qt4.i386 zlib.i386 alsa-lib.i386 libX11.i386 \ libXv.i386 libXScrnSaver.i386
Book Review: The 3CX IP PBX Tutorial
I was recently contacted by Packt Publishing and asked if I would review a book about 3CX. I was more than happy to as we use 3CX and I am a supporter of the 3CX product (See my past blog on setting up 3CX).

The 3CX IP PBX Tutorial Cover
The book is titled the 3CX IP PBX Tutorial authored by Matthew M. Landis and Robert Lloyd.
What is this book about? This book is titled “The 3CX IP PBX Tutorial” therefore it is a tutorial and a hands on guide to 3CX for beginners and administrators of software PBX solutions. The book is meant to guide you through setting up 3CX for business or home office use. It brings you from start to finish in a short amount of time.
What I liked:
In this book the authors aim to give a real world approach to setting up 3CX. They did a good job at organizing the steps and order of implementing a 3CX system. This will help someone that has never worked with 3CX or any PBX solution. I like how the authors went into the history of 3CX and background on VOIP/PBX as well.
There are many components that make up 3CX besides the core such as: the soft phone, the 3CX assistant, and reporting tool. In the beginning of the book they covered these components so you would get a good understanding of what 3CX is made of and what it can do.
The section titled “What 3CX is not” is valuable real world knowledge. This would help someone easily identify if 3CX meets their needs or not before getting too involved.
Chapters 1 through 4 covered the basics such as working with extensions, call groups, digital prompts, and install. Most of this was review for me but good information for a beginner.
How to find PHP.ini location
One day I was working on a new Drupal site for client. This was on a new server and I had no clue where anything was. I needed to find out what PHP version was running. I could not find this in Plesk for some reason. On Geeklog they had an article with a cool way to track down your PHP version and other information about PHP on a server.
Automatically backup MySQL database
I needed to backup a couple of MySQL databaes automatically. Here is what I did to accomplish this.
I created a folder called mysqlbackup. I then created a script called ”mysqldbbackup.sh” and put this script file in the mysqlbackup folder.
It contains “rm /mysqlbackup/DBNAME_backup.sql
mysqldump -u USERNAME -pPASSWORD DBNAME > /mysqlbackup/DBNAME_backup.sql”
I used the “rm” command to remove the last database backup before the new backup runs. For one of my old blogs on mysqldump command click here.
You have to make the script executable. To do this use the following command
“chmod +x /mysqlbackup/mysqldbbackup.sh”
Now test your script to make sure it works. CD to the mysqlbackup directory and run the script using by typing “mysqldbbackup.sh”
Ok after it works you need to now schedule it. Use cron to schedule it. I set it to run ever Tuseday at 3am. Use this command to set it via cron “0 3 * * 2 /mysqlbackup/mysqldbbackup.sh”
For more on cron visit ABOUT CRONJOBS . For more about Linux Shell scripst visit LINUX BASH SHELL SCRIPT
Integrate SugarCRM with Active Directory
Here is a quick how to guide on configuring SugarCRM to integrate with your Active Directory.
First thing you need to do is log into your SugarCRM and click on the admin link in the upper right hand corner.
![]()
Scroll down to System Settings and click on this link.

Now scroll down to LDAP Authentication Support and enable it. This will expand out and you will need to configure these settings. Read the rest of this entry »
CP Omitting Linux Command Error
So I was trying to copy one folder to another location and kept getting this error:
cp: omitting directory
and it would not copy the directory over. This is the command I was running
cp FOLDER /root/DRIVE
I am fairly new to Linux so I did not know what I was doing wrong. After looking at the man page and some searching I found that I needed to put a -r after CP. Here is the syntax:
cp -r FOLDER /root/DRIVE
the -r is copying the folder recursively.
Setup 3CX IP PBX/VOIP for Windows
3CX Phone System for Windows is a software-based IP PBX. This is what we decided to use. We thought about setting up a trixbox server but decided to give 3CX a try.
What you will need:
- 3CX software
- Purchased VOIP number
- Win XP computer (you can use Vista we talk about XP in this article)
- IIS 6 on your XP OS
- A router that can do port forwarding or port mapping
- The 3CX soft phone (you can use X-Lite but we like the TS feature in 3CX soft phone)
- A static IP, FQDN (routable on the internet), or a dynamic IP
- Time to install, configure and test
Pre Configuration:
- On your firewall and or router open Ports 5480, 5482, 5483, 5485,
- Setup a static map or forward of ports: 5060-5100 (TCP and UDP), 9000-9015 (TCP and UDP) and 3400-3499 (TCP and UDP) to your PBX server.

NOTE: forwarding ports 5060-5100 covers Port 5090 (TCP) for the 3CX Tunnel. The 3CX Tunnel is so that users can connect to the PBX server remotely to get an extension.
Backup MySQL DB in command line
So you have a website on a dedicated server. You need to backup a database. You tried to backup through PhPMyadmin but it keeps timing out. Here is what you need to do. Backup the database through a terminal session. SSH into your web/MySQL server and run the following commands below.
TO BACKUP:
##Without G Zip Compresssion:
mysqldump -u USERACCOUNT -pYOURPASSWORDGOESHERE YOURDATABASENAMEHERE > latest_backup_061009.sql
##With G Zip Compresssion:
mysqldump -u USERACCOUNT -pYOURPASSWORDGOESHERE YOURDATABASENAMEHERE | gzip -c > latest_backup_061009.sql
TO RESTORE:
##To restore a backup of a database created with mysqldump, you will need to use the mysql command. If your SQL dump file doesn’t contain any “create database” statement use the following command:
mysql -u USERACCOUNTNAME -pYOURPASSWORDGOESHERE YOURDATABASENAMEHERE < latest_backup_061009.sql
##But if it does contain the “create database” statement use the same command without specifying the database name:
mysql -u USERACCOUNTNAME -pYOURPASSWORDGOESHERE < latest_backup_061009.sql
Setup a catch all domain
I needed to setup a catch all for one of my clients domains. This is what I needed to happen:If user typed in an incorrect sub domain for mydomain.com that did not exist I needed it
to redirect them to www.mydomain.com.For example: if they type in notreal.mydomain.com it will send the user
to www.mydomain.com.Here is what I did to accomplish this:

