Installing Bugzilla 3.0.2 on Lunarpages shared hosting

Reference: Bugzilla Guide 3.0.2

1. Using FTP client, upload bugzilla tarball to LP (placed in the parent folder to where you want bugzilla to be homed. I put mine in the root www folder public_html so it will expand to a subfolder and run from http://mydomain.com/bugzilla.

2. Using LP’s Cpanel File Manager, navigate to uploaded tarball, select the filename and extract (see file operations on right)

3. Noticing the new folder created, select this folder name, and rename to bugzilla.

4. For this same folder, select Permissions and change to 775.

5. The install script ./checksetup.pl must be run using cron jobs since we do not have shell access on this box. In Cpanel, go to cron jobs and enter a job to run once:

cd '/home/youracct/public_html/bugzilla' ; ./checksetup.pl

Also specify your email that you want the output to be sent to. Schedule it to run a few minutes from current time, and make sure it runs only once.

6. Wait for email, the script will have checked for required perl modules.

7. If required or desired modules are missing, email support.lunarpages.com or open a ticket with them and ask them to install the modules on your server.

8. Once all modules are present that you need, edit the localconfig file per the installation instructions. Also, using the Cpanel Mysql tool you will need to create a database and a database user for this application. I created a db called bugs and of course it was renamed to account-id_bugs. The same with the username. These database values are needed in the localconfig file. I edited my localconfig file with the Cpanel file manager.

ISSUE RAISED TO LP TECH SUPPORT: apache is not running under the group ‘apache’ or ‘www-data’. Last resort will be to use “” as the $webservergroup value in localconfig.

Once resolved, the remaining steps will be completed.

LP ANSWER: You must run the install script with $webservergroup = “”

9. Additional steps required since we’re in a shared environment and the install script doesn’t always complete:

• edit the .htaccess file in the root bugzilla folder to include these two lines:

DirectoryIndex index.cgi
Options FollowSymLinks ExecCGI

10. Edit the cronjob to run checksetup.pl non-interactively since we don’t have a shell. This is done by using an answer file (see here). You’ll have to create this answers file and put it in the same directory as checksetup.pl.

cd '/home/youracct/public_html/bugzilla' ; ./checksetup.pl answersfile.txt --verbose


11. Rerun the cron job, same script, it will detect the edited localconfig file and run the installation script. You should get db tables created. Inspect the email results for errors.

Now you can login as the admin user and start configuration!!

Note: The script did not like my answers file and I always got a “bad file descriptor” error. Here’s my workaround:

Run the cron job without the answers file, it will create the db tables, etc and wait for user input for the admin user. At some point it will die or you can kill it with another cron job.  At this point the bugzilla site is accessible but there are no users defined. Go to main page and create a new user that you will use as the admin. Once created, submit this cron job that will make the new user admin and then it will complete the remaining installation steps of the script:

cd '/home/youracct/public_html/bugzilla' ; ./checksetup.pl --make-admin=newuser@domain.com

Enjoy!!

Hello Google Apps … Goodbye Scalix virtual machine

This is probably old news to many, but I just discovered domain name hosting with Google Apps. (Actually my brother Mark found it on google’s site and we discovered it together…turns out it was a perfect solution to our problem)

We had a Scalix email server running for some time in a Windows Virtual Server virtual machine (SUSE 10.1 and Scalix 11.1) which was not bad…sort of a learning experience for me, but it became a hassle to maintain. Our dedicated server with godaddy ended up crashing every other day, and down goes our email. So, we considered the replacement solution, and that’s when we happened on Google Apps.

Since our domain name is registered through godaddy, and they have a nice domain control center app with complete dns control, the switch to Google Apps was painless. I can’t say the same about godaddy about their dedicated server product, but at least I will keep registering domain names with them with the ease and control the provide for managing those domains.

Anyway, the setup for Google Apps was simple, intuitive, with clear instructions to make the change-over painless and fast! Within 15 minutes I had it setup, and 15 minutes later I had the domain pointing to google servers. As the dns entries propogated to the internet I soon began to see email on my domain come trickling in to the gmail mailbox. Awesome!! Google has done it again.

The added bonus is that we get google docs, personalized start page, and google calendars all available through our hosted domain, so you type calendar.yourdomain.com and it goes to Google Calendar with sharing among your domain accounts an option.

If you sign up for the premium account (30 day free trial), Google provides an IMAP migration tool, which worked flawlessly and brought all of the existing mailbox content over to the new Google Apps email account.

All in all, it was a painless, fast switch over and I happily retired the Scalix virtual machine. What a great feeling to turn that baby off knowing I’ll never have to deal with it again.

Funambol: Synchronize Contacts Between Outlook-Palm-Gmail

I while back I downloaded and played with Funambol, now there is a free online Funambol server that provides the glue to many synchronization needs. For me it is:

Palm Treo650 < – > Outlook contacts/calendar < – > Gmail contacts/calendar

So I am basing my procedure on this great article.

Step 1. Sign up for an account on scheduleworld.com.

Step 2. Download funambol outlook client. Install per the instructions and configure per the information provided by scheduleworld.

Step 3. Synchronize Outlook with Palm Treo (already configured, using software that came with the Treo). This step just makes sure we have synchronized data in Outlook before proceeding.

Step 4. Run funambol plugin for Outlook.

Step 5. Log into scheduleworld and confirm you can now see the synchronized data.

Step 6. In scheduleworld.com site, click on Google Sync and setup google account info. There are also several google calendar sync options in the Preferences page that I have set so that it will sync the google calendar with each syncML session.

NOTE: so far, I’ve only been able to sync contacts with regular gmail account and not my google apps domain services account.  So I’ve done a google export of contacts from scheduleworld that I loaded to my domain google apps account.  I don’t suspect scheduleworld will be able to add contacts sync to google apps because of the google apps APIs, they contacts APIs seem to be available only to premium users at $50/yr.