Saturday, February 10, 2007

Installation of SugarCRM on cPanel

Recently I was looking at different ERP services for our company, and I came across this open Source CRM program, as many of you know SugarCRM is a powerful Open Source CRM. So I took the chance to try to set it up on public hosting services with cPanel. It is actually quite simple, I am not an internet GURU, but it took me less than an hour to install it. Here are the steps

1. Download SugarCRM from SugarCRM. Make sure to download the full installation package (not the one with the bitRock Installer).

2. Goto your cPanel setup screen. If you want your sugar to be a subdomain (e.g. sugar.yourdomain.com) then you can first add a subdomain. Goto your cPanel login screen, and click on "subdomains" under "Domain". I have one setup under sugar, so I type in
"sugar" in the empty box where you can add subdomains, and select the domain where you want to add this under. Click on the add button and you will see a successful message.

3. When that is done you need to setup a MySQL account, go back to the login screen for cPanel, and goto "MySQL" under "database". goto the empty box where it says "Db:________Add Db" and add the database, for this you might want to use something like sugarCRM. After that you will need to Add user, type in the username and password you want to use for your database, this is the master password for the MySQL database(we call it the Database_username, and Database_password). Hold on, we are not done yet, we need one more step, we need to add that user to that specific database you have just recently created. Look under the under the "Database" label and local "User:_____ Db:_____", select the user and database name that you have just created and click on the "Add user to DB" button. Remember that the way cPanel labels the database is yourdomain.com_yourDBName, in this case it is yourdomain.com_sugarCRM. Now you are ready for installation.

4. The reason we download the SugarOS without the installer is cPanel already has MySQL installed, so we can just create it there. Now we need to upload the Sugar to the FTP server onto cPanel, there is a few ways to do this. You can either setup a user account for the site's FTP and upload with an FTP agent, or you can upload with the built in Java FTP agent. I went with the second option, which was quick and easy. Goto "Ftp Manager" under "Site Management" and choose "UnlimitedFTP". Now you can upload the unpacked content to the FTP server. Adding the subdomain should create a default directory under your "public_html" directory, go there and unload all your content. For my installation, I used sugar.yourdomain.com, so I just uploaded all the content to public_html/sugar/

5. After the long wait of the upload, goto http://yourdomain.com/sugar/. The installation is now more than half way. Skip the default welcome page and The system will perform a system check, if they are all green then you can just click next. On the next page (step:3) you will be quizzed of the recent names that you just made up. Let's first start with the questions:

Host name : localhost
Database Name : yourdomain.com_sugarCRM
Username for SugarCRM: Yourdoma_sugarcr
The user name only takes the first 8 char and the last 7 char for database username. You should always verify the user name and database name in the "MySQL" menu under "Database", make sure to include the full name, a copy and paste can ensure that you got the full name with the _ in between.
Password for SugarCRM: Database_Password

These are nothing more than the names that you have created before. Next is a few clicks on if you needed demo data. I wanted a clean install, so I went with only the privileged user choice.



6. The next page asks you of more question, you need to type the URL of the subdomain to make this work. The URL should be sugar.yourdomain.com. Then you have to decide an administrative password. Type that twice and click on next to goto the confirm page. Make sure everything is typed correctly and you can wrap up the installation with the "finish" button. Installation will start and will only take a mater of seconds. After the installation finish you are asked if you want to register. Answer all questions and you will be redirected to the default login page.

Congratulations! you have just installed SugarCRM on your domain!

12 comments:

Unknown said...

Salesforce is a cloud based CRM software. Today's most of the IT industry use this software for customer relationship management. To get more details about salesforce please refer this site.

Regards..

Salesforce CRM Training in Chennai

Unknown said...

Data are the main part in creating a company's revenue. Managing those data is highly chanllengable in this least secured world. But there are veterans whom we can trust to safeguard our data. Thanks for sharing this wonderful information in here. It helped me a lot.

Salesforce Training in Chennai | Salesforce Certification

Alexander Albert said...

You are a very persuasive writer. I can see this in your article. You have a way of writing compelling information that sparks much interest. design agencies

jacob olivia said...

I am fascinated this informative article. There are so many things mentioned here I had never thought of before. You have made me realize there is more than one way to think about these things. development agencies

Geethan Erajh said...

Average In turn sends provides is the frequent systems that provide the opportunity for one’s how does a person pick-up biological, overdue drivers, what one mechanically increases the business. Search Engine Marketing iphone mockups

Yousufzai said...

The actual challenge to become is normally you can actually SOLE check out that level of your tax discount over the internet by looking at your RATES web-site. macbook template

sdexter said...

I like this site so much, saved to favorites . webflow developers

khanabaaz said...

Be grateful you for spending time to speak about this, I think strongly about that and delight in reading read more about this topic. Whenever possible, just like you become expertise, do you mind updating your web site with a lot more details? It can be highly great for me. Two thumb up in this article! webflow company

sdexter said...

I recently realized your website the other day and that i happen to be following it’s routinely. You’ve got great deal of tips proper here so i delight in your lifestyle of online site likewise. Preserve acknowledge that there are succeed! top web development companies

sdexter said...

hi, your website is really good. I truly do appreciate your good results apple watch psd

Walkeaz said...

This kind of publish appears to get yourself a lot of visitors. How will you acquire traffic to that? It provides a great unique twist upon issues. I guess having something traditional or perhaps substantial to give info on is the central aspect. ui design agency

Anonymous said...

I love your blog! You always have such interesting and thought-provoking content. google workspace plans