Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 10-10-2012, 11:34 AM   #1
LQ Newbie
Registered: Sep 2012
Posts: 2

Rep: Reputation: Disabled
Setting up MySQL database with SugarCRM on Ubuntu Server 12.04 LTS

I am trying to set up a server for my small business. I may have bitten off much more than I can chew here. I have very little experience with Linux but I really want to learn. I built a server and I have installed Ubuntu Server 12.04 LTS, it is up and running fine. Now I just need to get it communicating with my other machines.

Here are my goals for this server:

I want to set up a domain for my business network, using this server as the primary domain controller.

I would also like to set this server up with Samba shared drives for the rest of the network.

I would like to create a MySQL database running SugarCRM CE software, which will also be installed on the client computers.

I don't know how to set up a domain network with my Ubuntu box as the PDC. I have tried several tutorials so far; I have installed Samba, but I can't ever seem to get access to the server from any of the other machines on the network. I have since tried to remove Samba completely and start from scratch but the conf file still has all of the changes I made before removing and re-installing Samba. I also am not sure how to partition off space for shared drives. I have installed the software packages to create my LAMP server already but I am stuck on how to configure everything. I created a MySQL database and got SugarCRM installed and pointed to the database, but I don't know how to configure Apache to go online with everything, right now everything is working but it's working on "localhost" not out on the net for my other computers to access. Any help would be very appreciated, even if it is just pointing me in the right direction of an existing tutorial or something. I just want to make sure that I am doing everything properly and that I am not missing any steps in the set-up. Please help this newbie!!!!
Old 10-10-2012, 02:19 PM   #2
Registered: Apr 2004
Distribution: slackware/FreeBSD/Vector
Posts: 291

Rep: Reputation: 52
It sounds like your trying to fix all your woes and run an entire environment from a single machine. Personally in your position I would consider virtualization and attempt to create several small virtual machines in order to facilitate your needs. I've had great success with Proxmox virtualization , they also provide turn key linux servers to accomplish exactly what your trying to do. It's important to learn how to use linux, but if your wanting to get up and running fast, there is no better way I have found than to just run Proxmox and turnkey linux virtual machines for the applications I need. They have prebuild filesharing servers as well as a PDC server, and a TigerCRM server. Please read up on them and see if that would be a good fit for you.

Here is the link for the proxmox server software, this will install a complete virtualization solution in one disk , keep in mind this will WIPE your hard disk
and install this software

Also you can install directly form Proxmox turnkey linux servers
Here is a link to the turnkey linux distro and how to use their prebuilt canned linux machines.

Keep in mind this is just one route to go, considering the amount of things your wanting to do , its always better to just virtualize and keep seperate servers for seperate tasks.
1 members found this post helpful.
Old 10-10-2012, 03:21 PM   #3
LQ Newbie
Registered: Sep 2012
Posts: 2

Original Poster
Rep: Reputation: Disabled
Thumbs up

Thank you very much for your input and helpful links. I will definitely consider this route, it may be the way to go at this point. I like the idea of minimizing the chance for me to screw everything up, but at the same time, I like to learn and if I just install a pre-built solution, I worry that I won't be able to diagnose and fix any problems I may have as easily as if I set everything up myself and learn as I go. Does that make any sense? Also, could you please elaborate on why it is better to virtualize and run everything on its own VM instead of just using one environment for domain admin, file-share, and database storage? That may be a very stupid question, but I am very new to all of this. Again, thank you very much for your response, any help is VERY appreciated!!!!
Old 10-10-2012, 04:22 PM   #4
Senior Member
Registered: Jun 2002
Location: Eastern PA, USA
Distribution: K/Ubuntu 12.04/14.04, Scientific Linux 6.3/6.4, Android-x86, Pretty much all distros at one point...
Posts: 1,799

Rep: Reputation: 157Reputation: 157
The main attraction of virtualization is that you can isolate certain functions of the server to that virtual machine, and also back those up by cloning the VMs on a regular basis. That way, if something goes wrong, you not only have you backup, but you have the other services running, uninterrupted.

The downside of virtualization is that you will need one relatively powerful machine, versus several smaller, less powerful machines, to do the same jobs. If run headless, that may be just fine. But the server is going to be juggling jobs that are normally split between multiple machines.
1 members found this post helpful.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How to Installing Nginx with PHP5-FastCGI and MySql Support on Ubuntu Server 12.04 LTS LXer Syndicated Linux News 0 06-15-2012 11:20 AM
Problems setting up MySQL Desktop on a LAMP server (Ubuntu 11.10) timnich0 Linux - Server 0 05-03-2012 04:25 PM
LXer: Setting Up An OpenVPN Server With Authentication Against OpenLDAP On Ubuntu 10.04 LTS LXer Syndicated Linux News 0 09-29-2010 01:30 PM
LXer: Ubuntu LAMP Server MySQL Database Configuration LXer Syndicated Linux News 0 11-19-2009 02:30 AM
Internet setting for UBUNTU 8.04.1 LTS shreyu14 Linux - Newbie 1 10-22-2008 05:48 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:13 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration