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.

 

Read more

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 … Read more

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 more

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.

Read more

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: 

Read more

Setup VNC Server on CentOS

I recently had the task of setting up VNC Server on CentOS for a client of mine. VNC is very much like remote desktop in windows. You can even use VNC on Windows servers. I found VNC to be a little bit slower then remote desktop and it kept kicking me out every once in a while. Here are the steps I took to set it up:

First I opened the necessary ports.

Path to access the firewall:

Read more

Backup your SugarCRM

The backup tool in SugarCRM does not work at all when in a shared server environment.

I have a better way to backup your SugarCRM that works. To restore your SugarCRM you need to restore the database first and then restore your SugarCRM files. Here is how it works:

First you need to export your full database. (I use MySQL) You do this from PhpMyAdmin. In order to reach it you have to log in your Cpanel, go to MySql databases and click on the link to PhpMyAdmin.

Read more

Install SugarCRM on a shared server

I am going to give detailed instructions on installing SugarCRM in a shared server environment. For this article we will be using Sugar Community Edition. Note: some things may differ depending on your shared server environment.

My environment consists of:

  • Platform: Linux
  • Web Server: Apache
  • Database: MySQL
  • Language: PHP

First go to http://www.sugarcrm.com/crm/download/sugar-suite.html to download the latest release of SugarCRM.

Create your MYSQL database. We will call our database sugar1.

Create or choose a domain name that will be used to access your SugarCRM once it is installed. We will pretend our domain name is www.sugar1.com .

Copy the SugarCRM files that you just downloaded from your computer onto your web server via FTP. Be sure to copy these files in the root directory for www.sugar1.com .

Check and set platform requirements and configurations before installing. My platform and configuration was already set to go. You can see what these are here: http://www.sugarcrm.com/wiki/index.php?title=Platform_Requirements_and_Configurations .

Now you can install SugarCRM using the sugar setup wizard. To access this type this URL in a web browser: www.sugar1.com/install.php . You will then see the setup wizard pictured below.

Read more