Monthly Archives: April 2008

SugarCRM Error “IMAP won’t work without c-client”

This error will cripple Sugar’s email functionality, which is a major development in version 5.0, previous versions of SugarCRM Community Edition (free) did not handle emails at all. This error happens when the php5-imap extension hasn’t been installed. After searching for sometime I found a reference to php5-imap and decided to give it a try. Here is how you install it under Debian (ubuntu), very simple.

1- as root #apt-get install php5-imap (a blue screen will ask if you want to install it without maildir support – if all you need it for is SugarCRM click yes)

2 – restart Apache – #/etc/init.d/apache2 restart

See painless! For other distributions, just search for php imap on your Package Manager like Yast or Synaptic.

SugarCRM Upgrade Error

Upgrading SugarCRM Community Edition from 4.5 to 5.0 is supposed to be a walk in the park, and if you do have the right settings it will be. As in IT everything depends on the little details, SugarCRm wouldn’t be different. Don’t get me wrong I really like SugarCRM that’s why I post errors and “workarounds” here.

While upgrading from version 4.5 to 5.o, using the option to upload from local file,after clicking the upload upgrade button the page would hang for a while and then take me back to the home page without any error message. I checked the installation, checked my PHP.ini and the upload size limit was set to 40M as instructed during the installation. Then I look in more detail at my PHP.ini and noticed that post_limit = 8M… mmm …. stupid detail overlooked and I’m sure I’m not the only one. I increased it to 40M and the upgrade moved very smoothly.

Here is how you do it:

Under Linux (do it as Root or use sudo if applicable)

1 – Open PHP.ini # vi /etc/php5/apache2/php.ini

2 – Scroll down until you see the line post_size_limit = 8M (change 8 to 40)

3 – restart Apache #/etc/init.d/apache2 restart

(the vi editor opens as read-only, to enable editing press “i”, to disable editing press “esc”, to save (write) press “:w” (editing needs to be disabled for this) and to exit “:q” )

SugarCRM installation error “MySQL not available”

While moving a SugarCRM installation to a different server I found this problem – “MySQL not available”. Firstly I had a blank page and then decide to re-run the installation script. During the system check it listed MySQL as not available, so I checked for the status of the mysql server and it was running. (as root – /etc/init.d/mysql status)

This problem is caused by PHP not being able to talk to the MySQL server. Here are some simple steps that can help you resolve this.

1 – add the line extension=mysql.so to the end of your php.ini ( found under /etc/php5/apache2)

2 – restart the apache server – /etc/init.d/apache2 restart

This should resolve your problem but if it does not, like in my case, the php-mysql extension is missing so you need to install it.

3 – in a Debian based distro (Like Ubuntu) just use apt-get install php-mysql to install it (as root or use sudo before the command)

4 – restart the apache server – /etc/init.d/apache2 restart

This is it! 🙂

Technorati Tags: , ,

You do not have permission to access Ubuntu

I installed Ubuntu on several Dell Latitude C510/C610 that had been properly wiped and were used but empty. Once I figured out an installation CD that worked the installation went smoothly. After rebooting the computer and typing in the user name and password nothing loaded except a message saying ‘you do not have rights to access’, and at this point by adventure into Ubuntu stalled.

It occured to me that the bios date on the laptop was wrong so I thought if I altered that it would be work. Once I got into the bios and changed the date and after a compulsory system check happened (because the computer thought it had not been booted for 2200 days), I was able to log in.

I can only guess that because the installation date will have been in 2008 – but the bios was in 2002, Ubuntu looked at the bios upon booting and did not recognise the creation of a user at a date 6 years in the future.
If anyone has any fact about why this would be the case – please let me know!

Find your Mac Address in Ubuntu

Having just starting using Ubuntu I have been needing to do some basic setup options to put my laptop on the network at the office. We use Mac Address based security and so I needed to find mine for the ethernet card.

Looking through all the administration options to find it was unsuccessful and it was definately not as obvious to find as I hoped. After trawling through the Ubuntu Forums and reading about 9 threads I found you simply need to go to Terminal (which is located under Applications>Accessories) and then type in ifconfig and press enter, and you will get a list of your hardware address for your network card.

Saving default as .doc in Openoffice

I have always thought OpenOffice was a great tool to use – but have been continually frustrated at it saving in the open office format by default, so after some searching and tinkering I found a way to make all the openoffice applications default save into their microsoft equivilent. The best resource I found was here, but to summarize it simply:

1) Open up one of the OpenOffice programs (i.e. Writer)

2)Go to Tools and then Options

3) Under the Load/Save section – expand it and click on general

4)In the section titled Default File Format there is a section called Automatically save as and you just want to select ‘Microsoft Word 97/2000/XP’.

For me – those simple instructions put OpenOffice as a more serious contender for those who do not understand file types!!