NCS Sugar Files

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

SugarCRM NCS Virtual Machine instructions

To unpack the archive, a program that can unpack 7-zip archives is required.

On Windows, this can be had from http://7-zip.org/
On Linux, look for a "p7zip" or "p7zip-full" package. On Ubuntu, this is as easy as running "apt-get install p7zip p7zip-full"

For Macs (or others): http://www.7-zip.org/download.html

To boot the VM, open it with a virtual machine playing product, such as VMware Player or Virtual Box (be sure to set the networking type to either host-only or NAT in order to prevent external access; the VM is not configured to be secure). If using Virtual Box, you'll need to create a new virtual machine and attach the VMDK file in the 7z file as the disk.

Once booted, hit enter on the console a few times until you see an IP address. Then enter this address into your browser (if using VMware and the latest version of the Sugar VM, you may be able to click "Open Browser")

When done, be sure to shut the appliance down by going to VM->Power->Shut down (in VMware Workstation)

Usernames for the VM are (password is always "ncs"):
  * "user" for Unix use
  * "admin" for Sugar
  * "root" for mysql and phpmyadmin

VERSION HISTORY

v1.0 Initial release
V1.1 Added Sugar cron job; increased /etc/network/interfaces to handle up to eth12 (interface name gets bumped every time the MAC changes)
v1.2 Included beta testing modules
v1.3 Upgrade to Sugar 6.1.1; Switched back to basic model (no included modules). Included links to NCS Sugar sourceforge page on VM landing page.
v1.4 Upgrade to Sugar 6.1.2
v1.5 Upgrade to Sugar 6.1.4; install phpmyadmin
v1.6 Add packages for ldap authentication, git and the perl extraction program. Enable 	
     remote mysql access (remote user still needs to be added to use)

v6.1.7 Switch to VM version numbers based on SugarCRM release. Upgrade to 6.1.7.
     Upgrade packages.

SHA256 sums:

e98cfbd8067935d2efb5527a4ea4934d1e26c1886b9bcc57b14ac9b9d39329c2  Snapshot_10.21.2010.7z
d3fa6640e00aaafa28992d619ef0421addfdb17b40bc10c3f96510be73b5ae67  snapshot_2010_10_14.zip
f6acabe574deca4d77f3cde6e44f866176c07d93a513062e29274e82fbe9d2ed  Sugar 6 VM v1.1.7z
f2155c3b69371d39725a961a2a62896dd9f8cbb6dda26a2c73b4f669c4cecb72  Sugar v1.2.7z
af06a543ffae79e622bdb0c6cd619a29497e9ef692159c1fb669bca8268210a4  SugarVM v1.3.7z
ca1ff4e4d023661e36e81795450637830d4fe0841f1c0917042bc81d5fce5f13  Sugar VM v1.4.7z
2b96b46b722129f1ff11b0de34a72286425e10d08c37b5c63f7b749c708666f7  Sugar VM v1.5.7z
bdfc80c9079d30db05666bd064961554d1baf08cf20e1710eb33e1c7dcf2ce06  Sugar VM v1.6.7z
ea6a2b93c8d3ec4c790e47c34f2971b380c91cee4192e8464265e876cdab35df  Sugar VM v6.2.2.7z (buggy)
65504fbaf264a746b4af88234b86acdbeb6afa451a00a7810a06e59149371dd4  Sugar VM v6.1.7.7z

VM CREATION INSTRUCTIONS

To Create the VM:

 -Select new VM in VMware Workstation (or Player). Choose custom install, remove extra unnecessary devices (printer, sound, floppy). Network should be NAT
 -Install Ubuntu server i386, at boot screen press F4 and select "Minimal Virtual Machine" to create a JEOS install
 -Go through the regular install. At the screen asking about additional software to install, select LAMP
 -After first boot, install open source VM tools as root ("aptitude install ethtool zerofree open-vm-tools --without-recommends"). First user should be "user"; mysql and "user" passwords are "ncs"
 -Install editors ("aptitude install nano vim --without-recommends")
 -Install openssh ("aptitude install openssh-server --without-recommends")
 -Install unzip ("aptitude install unzip --without-recommends")

You can now continue by sshing to the VM

For displaying the IP address on the console (you can paste this):
#Create the get-ip-address script

cat > /usr/local/bin/get-ip-address <<"EOF"
#!/bin/bash

/sbin/ifconfig | grep "inet addr" | grep -v "127.0.0.1" | awk '{ print $2 }' | awk -F: '{ print $2 }'
EOF

chmod 755 /usr/local/bin/get-ip-address

# Create if-up script
cat > /etc/network/if-up.d/console-ip-display <<"EOF"
#!/bin/sh
if [ "$METHOD" = loopback ]; then
    exit 0
fi

# Only run from ifup.
if [ "$MODE" != start ]; then
    exit 0
fi

cp /etc/issue-standard /etc/issue
/usr/local/bin/get-ip-address >> /etc/issue
echo "" >> /etc/issue
EOF

chmod 755 /etc/network/if-up.d/console-ip-display

# Backup /etc/issue
cp /etc/issue /etc/issue-standard

# Add some extra network interfaces in case they change
cat >> /etc/network/interfaces <<"EOF"
auto eth1
iface eth1 inet dhcp

auto eth2
iface eth2 inet dhcp

auto eth3
iface eth3 inet dhcp

auto eth4
iface eth4 inet dhcp

auto eth5
iface eth5 inet dhcp

auto eth6
iface eth6 inet dhcp

auto eth7
iface eth7 inet dhcp

auto eth8
iface eth8 inet dhcp

auto eth9
iface eth9 inet dhcp
EOF

 - (optional) Tidy up ("aptitude clean") and shrink the disk before branching ("vmware-toolbox-cmd disk shrink /")

 - Create a snapshot

 - Create a linked clone from that snapshot (called SugarCRM)

*** After machine cloned to web server

 - Change hostname on new clone by modifying /etc/hostname and /etc/hosts, then reboot (otherwise, errors ensue)

 - Install wget/curl ("aptitude install wget curl")

 - Install php cli and php5-curl ("aptitude install php5-curl php5-cli")

 - Update php's config to accept larger uploads by changing post_max_size and upload_max_filesize to 128M (file is /etc/php5/apache/php.ini) and output debug-helping data

 - As root, download SugarCRM package (find URL on http://www.sugarcrm.com/crm/download/sugar-suite.html) into /var/www

 - unzip it ("unzip SugarCE...")

 - remove zip file; move directory to "sugar"

 - Change owner to the www user so that it can manipulate files ("chown -R www-data:www-data sugar")


 - Follow instructions for install SugarCRM from http://developers.sugarcrm.com/  (note that security items are not followed due to this being a development install that should be protected by NAT)
     - Essentially, access http://<server-ip-address>/sugar
     - To add crontab, run: "crontab -u www-data -e" and paste the line from the installer:
       *    *    *    *    *     cd /var/www/sugar; php -f cron.php > /dev/null 2>&1 

 - Edit /var/www/index.html to point to Sugar and website with modules:
<html><title>NCS development SugarCRM!</title>
<body><h1>Developer SugarCRM</h1>
<ul>
<li> Click <a href="/sugar">here</a> to access local SugarCRM
	<ul>
		<li>Local Sugar user is "admin", password is "ncs"</li>
		<li>Local username on linux is "user" password is "ncs"</li>

		<li>Local mysql username is "root", password is "ncs"</li>
	</ul>
</li>

<li> NCS Sugar Sourceforge resources:
	<ul>
		<li><a href="http://sourceforge.net/projects/ncs-sugar/">Main page</a></li>
		<li><a href="http://sourceforge.net/projects/ncs-sugar/files/">Module download</a></li>
		<li> <a href="http://ncs-sugar.git.sourceforge.net/git/gitweb.cgi?p=ncs-sugar/ncs-sugar;a=summary">Browse source code</a></li>

	</ul>

</li>
</ul>
</body></html>

 - Install LDAP, git and perl packages ("aptitude install liblog-log4perl-perl git-core libsoap-lite-perl php5-ldap")

 - Enable remote access for mysql (will still need to create a remote user to use) by commenting out the "bind" line in /etc/mysql/my.cnf

 - After finishing installation, halt machine. Take snapshot (Sugar 6.x base)
	- Optional: shrink the disk by running "vmware-toolbox-cmd shrink /"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (MingW32)

iQEcBAEBCgAGBQJPRE0yAAoJENTnPZmIllsEv20H/RHDH0uEPmrSwPsZn7pH84u0
fegVVq8ph4RzmNhP/l6H52P8sXyoharK2Gj9WoeYaxr4m8ZQWHIG/OTESVb9SY7x
70DtIgUzvwhklj8CDKFG18Yg80Gx2sLSt1tidcLdh6V9frALZLts8yPcsrf+qCa9
GK57apIGjxcO8OEPRH717ZbWcCvoEVY+ohL8gRaSJIPBhybmWXeCDSn2a3owbhnc
bEpEfx/ZCOLIkNyg4MwuSgJONPneFagCMw8jzOHGZNHwQhS9duMNfsw2xacGtMwj
MADMX4ia/rZDDW05KcSL4wW6bTHS6wYc14qmPRDZusVjIizlq6uD9ogmbahOz8o=
=955d
-----END PGP SIGNATURE-----