November 01, 2013

Copy and import a mySQL database

This is the original source.

Createa backup of the database:
$ mysqldump --opt -u [user] -p [db] -h [host] > [filename].sql
- If dropped -h default to localhost.

Create backup with compression:
$ mysqldump --opt -u [user] -p [db] -h [host] | gzip > [filename].sql.gz

Dump and import:
$ mysqldump --opt -u [user] -p [db] -h [host] | mysql -u [user] -p -h [host] [db]
- The first part dumps database 1 and the second part imports the dump into database 2.

This appears to work on ITS servers:
% mysqldump --opt -u isrdco -p[password] isrdco --host=webapps-db.web.itd | mysql -u isrdcodv -p isrdcodv

Connect to mySQL via command line:

$ mysql -u [dbuser] -h [dbhost] -p


Import a database:

$ mysql -u [dbuser] -p -h [dbhost] [dbname] < [db_toimport.sql]

SFTP into a machine through a non-standard port

$ sftp -oPort=[port] [username]@[host]

Posted by kkwaiser at 04:37 PM | Comments (0)

April 19, 2013

Visual Studio 2008 export to pdf error

I am really beginning to hate this software.

I get this error when trying to save a report to PDF. It doesn't occur when saving to doc.

Error occurred during local report processing. An item with the same key has already been added.

Someone indicated "This is confirmed to be a known issue, and will be fixed" back in 2010 but, of course, I am still seeing the problem.

Posted by kkwaiser at 09:04 AM | Comments (0)

April 09, 2013

Visual Studio and blankpages

Using visual studio to generate metadata codebooks probably isn't the ideal solution but that's what the last person used. Here are some links related to the removal of blank pages.

Stop blank pages after each page by setting the widths correctly.

Stop blank page at the end of the document.

Posted by kkwaiser at 04:21 PM | Comments (0)

February 18, 2013

PDF to Word conversion particularities

I recently needed to convert some fairly complex (i.e. with tables, images) pdfs to word documents. The conversion went OK but a large number of the images held within tables were not visible and the ones that were visible were not selectable.

Upon doing some research, I found out that the unselectable images (vector images perhaps) could be selected if you went to home> select > select objects ( Click on the pic ).

From there it was simply a matter of right-click > Format Object > Layout > In Front of text.

In order to avoid having to select all the objects on each page (you can't select across pages) you can select them all by:

You can make use of the Select Multiple Objects command, which opens a dialog box that easily allows you to select objects. In Word 2007, you can add this command to the Quick Access Toolbar.

Posted by kkwaiser at 03:46 PM | Comments (0)

December 07, 2012

Connect to the LSA DFS

$ sudo mkdir /dev/umbs

$ sudo /sbin/mount.cifs // /dev/umbs -o user=UMROOT/kkwaiser sec=krb5i

See the Mainstream Storage docs for more.

Posted by kkwaiser at 02:01 PM | Comments (0)

September 26, 2012

Convert Igor Pro date/time to Excel data/time

To see supporting documentation in Igor Pro use this command:

DisplayHelpTopic "Excel Date/Time Versus Igor Date/Time"

Excel stores date/time information in units of days since January 1, 1900 or January 1, 1904. 1900 is the default on Windows and 1904 is the default on Macintosh. Igor stores dates in units of seconds since January 1, 1904.

If the Excel file uses 1904 as the base year, the conversion is:
wave *= 24*3600 // Convert days to seconds

If the Excel file uses 1900 as the base year, the conversion is:
wave *= 24*3600 // Convert days to seconds
wave -= 24*3600*365.5*4 // Account for four year difference

This equation will convert to the Excel date/time for Windows systems (1904)

Where H1 is the Igor Exported date/time code. For example, 2954750400
should convert to 35660.5 both of which are 8/18/1997 12:00.

Bonus! Convert the Excel date/time to text string: =TEXT((A2+24*365.5*3600*4)/(24*3600), "yymmddhhmmss")

Once you have a date/time code setup as yymmddhhmmss, how do you take it to an excel date/time?

=INT(DATE(LEFT(B1,2),MID(B1,3,2),MID(B1,5,2))) + MOD(TIME(MID(B1,7,2),MID(B1,9,2),RIGHT(B1,2)),1)

Posted by kkwaiser at 10:34 AM | Comments (0)

November 21, 2011

Convert Date To Text in OpenOffice

This has baffled me many times but not this time. I am revenge.

Melodramatics aside...

This post offers one solution:

1) =TEXT(A1, "YYYY-MM-DD")
2) followed by Paste All -> Text

Except, the output is prepended with an apostrophe. Why?!?!?!?!


I've just managed to do that by pre-formatting the target cell as text and using the dropdown arrow with the Paste icon, selecting "unformatted text".

Paste-special would not work because,

1. if I de-select "date & time", nothing is pasted;
2. if I select "date & time", the number value of the date is pasted.

You need to have the Paste icon on your toolbar. It has a dropdown list with options which vary according to what is on the clipboard.

Thank you, Noranthon. You are my hero.

Posted by kkwaiser at 03:09 PM | Comments (0) | TrackBack

November 16, 2011

Setting an SSL Certificate up on ITS servers

Well, the below post was informative for me but not at all the right way to set up SSL on an ITS server. Just between me and the internet, my efforts may have brought down the ITS servers as I received confirmation of my certificate seconds prior to the linked outage. Awesome.

Future reference, just email to request a NEW certificate. Tell them to disable cosign and to have the https site load content from the same location as the http. Simple as that. Sheesh.

This may morph into a large post or become broken into smaller ones. We'll see.

1. Request an SSL Certificate at the Wasup Portal. Self-explanatory for the most part except...

- Creating the Certificate Signing Request
The Wasup service directs you to Instant SSL Comodo for help, which I found to be not helpful. I recommend going to Digicert to generate the terminal command you need to run to generate your CSR.

Logon to your webserver via ssh. Change to your Private directory and run this command.

% openssl req -new -newkey rsa:2048 -nodes -out umbs_lsa_umich_edu.csr -keyout umbs_lsa_umich_edu.key -subj "/C=US/ST=Michigan/L=Ann Arbor/O=University of Michigan/"

This generates two files:
umbs_lsa_umich_edu.csr - copy and paste everything from this file into the wasup request form
umbs_lsa_umich_edu.key - remove this from the web server and put it somewhere very safe. I committed it to memory and swallowed the file to destroy it. Steel. Trap.

Interesting command to backout a CSR:
% openssl req -in umbs_lsa_umich_edu.csr -noout -text

If you find SSL certificates confusing (as I do) check out this FAQ page for a layman's overview.

Posted by kkwaiser at 02:47 PM | Comments (0) | TrackBack

June 27, 2011

LAMP and Drupal on a Stick

File under: coolprojectsIneverthoughtI'dgetaroundto.

UMBS has a summer computer consultant and he has kindly agreed to help me figure out how to run Linux (and peripheral software) from a USB thumb drive. The Plan right now is to use Ubuntu 10.04 and expand that to include PHP, MySQL, Drupal and Data Turbine.

This page is for links but will hopefully contain notes as well.

Ubuntu forum with pointers

UNetbootin allows you to create bootable Live USB drives for Ubuntu,

Formatting options for USB - I.E., FAT, NTFS

On storage capacity of thumb drives - Looks like minimum is 4 gb, 8GB probably safe?

Apache on a stick (notice link within) - This is a Windows dependent install

Drupal on a stick wiki how-to - again using XAMPP!

Drupal on a stick page with links

Outdated instructions
with pointer to an installer (to good to be true?)

Posted by kkwaiser at 11:27 AM | Comments (0) | TrackBack

January 18, 2011

Logging php errors

Note schmotes...

Configure php.ini

$ sudo nano /etc/php5/apache2/php.ini

log_errors = On
error_log = /var/log/apache2/php_errors.log

$ sudo /etc/init.d/apache2 restart

View the log:
$ less /var/log/apache2/php_errors.log

Posted by kkwaiser at 11:26 AM | Comments (0)

November 02, 2010

Changing MySQL table prefixes

Pretty self-explanatory. Download php file from this site, place in /var/www and browse to the appropriate URL.

Note: This will cause problems if some tables are prefixed and others are not.

Posted by kkwaiser at 03:48 PM | Comments (0)

September 07, 2010

Install Eclipse on Ubuntu 10.4

Here are my notes on installing Eclipse

Mostly followed this page.

Downloaded Eclipse here, note I took the Classic 3.6.0 for 32 bit Linux

Installed the PHPEclipse package following this page. I used this as the source link.

Posted by kkwaiser at 03:33 PM | Comments (0)

August 23, 2010

Vista and viruses

Discovering a virus on my Vista OS has forced me to learn more about the vulnerabilities and poor design choices that microsoft has made. In particular, I had files showing up in these uber-hidden directories (note, you can only view these directories if you know the path a priori):

My virus scan found trojans here:
C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5
C:\Users\Information Manager\AppData\Local\Microsoft\Windows\Temporary Internet Files\Low

This forum was extremely useful, especially a post by M. Ucal Ulutürk which suggested copying the temporary folder to your desktop so that all of the hidden and uber-hidden files become visible. What's the point of hiding files if such a simple work around will reveal everything? Please tell me there is an explanation.

I also found 112mb of stuff here (which I deleted):
C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Word

Finally, this webpage had a few relevant pointers about the .dat file(s) in these directories.

Posted by kkwaiser at 01:23 PM | Comments (0)

May 04, 2010

Removing .Net from Firefox

Not my area, but apparently the newest version of Firefox 3.63 makes previously hidden add-ons appear in your add-ons list. This caused some Microsoft .Net stuff to show up which I promptly removed because 1a) I don't want microsoft installing hidden programs on my open source browser because 1b) their programs are always targeted for hacks/viruses.

I followed this link to remove .Net.

I used these notes to determine if my machine was x64 or x86:

Method 2: View System Information window

1. Click Start button, type system in the Start Search box, and then click System Information in the Programs list.
2. When System Summary is selected in the navigation pane, the operating system is displayed as follows:
* For a 64-bit version operating system: x64-based PC appears for the System type under Item.
* For a 32-bit version operating system: x86-based PC appears for the System type under Item.

Posted by kkwaiser at 08:43 AM | Comments (0)

January 03, 2010

Get Gmaps up and running

Just started messing around with the Google Maps module in Drupal. Here are some resources to get started with :

Late Update:

I've gotten things working pretty well now. I can create maps that specifically plot one type of web content (e.g. study sites) and display information about the content in the Google maps popup marker.

It took longer than expected because of a bug in the GMap code. This post by me outlines the problem and this post has the solution.

I also found this tutorial helpful in creating my first map.

Another Late update:

After updating modules, I am currently using this configuration without the above patch (not necessary):
Views 6.x-2.8
GMAP 6.x-1.x-dev (2009-Dec-15)

Posted by kkwaiser at 10:31 AM | Comments (0)

December 06, 2009

sftp in Ubuntu 9.10

For whatever reason, I have not been able to sftp to the LSA servers using FileZilla, the Nautilus browser (it crashes) or the terminal command:

$ s

So I installed putty and putty-tools

$ sudo apt-get install putty

And have been able to get it working from the command line:

$ psftp

commands of note:
ls, cd, lcd, pwd, lpwd, put, get, mv
psftp> ls
psftp> put -r LTER_ContentTypes
psftp > ls /Dept/umbs/dept/


I've since gotten sftp via the terminal to work:

$ sftp

to specify a port:
$ sftp -oPort=[portnumber]

Posted by kkwaiser at 12:15 PM | Comments (0)

December 02, 2009

Work the Firewall in Ubuntu

Quick notes on how to firewall apache and open ports if needed:

This Ubuntu documentation is helpful.

This How To is the best.

$ sudo ufw enable
$ sudo ufw allow 22
$ sudo ufw deny 22
$ sudo ufw disable
$ sudo ufw status verbose

$ sudo /usr/sbin/apache2ctl restart
Allow an IP address through the firewall

$ sudo ufw allow from to any port

IP address shows up und inet addr:
$ ifconfig

File of concern:


Some delete statements:
$ sudo ufw delete deny from
$ sudo ufw delete allow from to any port 80
$ sudo ufw delete deny 80

Posted by kkwaiser at 11:01 AM | Comments (0)

December 01, 2009

Re-install Open Office on Ubuntu

For whatever reason, I could not open a dbf file with the Open Office Calc program. This is how I fixed it (not that I understand why this worked):

1. Started following this tutorial.

2. I was then getting a document recovery error so I install Java Runtime Environment following this tutorial. I also tried comment 1 out.

3. I still had a document recovery error so I tried this.

4. That still didn't do it so I tried this command:

$ sudo aptitude remove --purge

And for whatever reason, my new version of OpenOffice works and will open a dbf file. Unfortunately, that took up a lot of time.

Posted by kkwaiser at 04:53 PM | Comments (0)

October 22, 2009

Create an SFTP site through UM LSAIT

How to create an SFTP Site for sharing data among UM and Non-UM researchers.
Drafted by K. Kwaiser

1) LSAIT can set up some filespace on LSA's Windows servers (LSA-F4\Group) - the 'Group' share is typically for collaboration. You can SFTP to the DFS servers and then access your data there.

The rest of this document documents the implementation of this option!

Cost: Free for “small” amounts of storage space

One thing to note is that on the LSA-Fileservers there is no videostream (open AVI) but it doesn't sound like you need that.

The important part of this is that All users must have UM-accounts and we can create them using the Mcommunity webapp. Hopefully reading the link will help.

Gloria Love ( is the contact person for this option.

2) You can purchase Windows space - this if you were expecting to increase the space you needed substantially and you wanted a bit more exclusive access. I believe access would then be the same (SFTP).

Cost: ~ $2.23/GB/Year, minimum of 250 GB, includes DR backups. Accessible via CIFS, WebDAV & SFTP

See attached documents for more:

Timothy Rolston ( was the contact for this information.

3) This can be done with C-Tools as well. Not sure about SFTP there but certainly could get HTTPS (SSL protected HTTP) access.

4) The LSA-RSG group could even setup a virtual server for you as I understand it from Karen Pachla - similar to the VaaS group you spoke to (ITS folks, yes?).


1)How to create a SFTP site through LSA IT
a.Contact to request an SFTP site on the LSA-F4 Group drive
i.Include as estimate of how much file space you will need
ii.The default drive space is 10 Gb, additional space available in 10 Gb increments
b.To set up access for researchers sent a list of UM uniqnames that will need access
i.You can specify (sub)-directory permissions types when you send in the uniqnames
2)If you need to create uniqnames, send the following information to

You need the following information in to create a UM uniqname:

Suggested uniqname (optional)
Full name
Valid address
Valid non-UM email address (IMPORTANT!!)
Contact telephone number
Date of Birth

a.This site lists details about uniqnames (e.g. expiration dates, changing passwords, etc.):

MCommunity Sponsor System Overview (R1458)

3)Connecting to the SFTP site
a.See the attached documents for instructions:

- ConnectInstructionsForAccessToUMBSGroupSharedSpace.docx
- UMBS_SFTP_Manual.doc

b.If a researcher is not able to login:
i.Make sure the server name is spelled correctly
ii.Synchronize UMICH.EDU Kerberos password and Windows Active Directory password. The Kerberos password is the one you use to access or Wolverine Access:

On the LSA Windows Workstations for logon and accessing file space to work correctly the user must synchronize their Kerberos and Windows passwords. To synchronize these passwords please open the following website address

c.To access Frequently Asked Questions for getting started with using LSA Windows Services:

Note, more documentation is available for this process:

- Create_SFTP_through_LSAIT.doc
Instructions on how to create an SFTP site

These docs are referenced within the former:
- Recharge_FileService_User_Agreement.doc
- Recharge_FileService.doc
- UMBS_SFTP_Manual.doc
- ConnectInstructionsForAccessToUMBSGroupSharedSpace.docx

During the process, I became certified to create unique names. The following is an email from Gloria on how to become certified to create uniqnames.

- Become_certified_to_create_UM_Uniqnames.doc

This pdf accompanies the preceding doc:
- Mcommunity_Authorization_Form.pdf

Thanks again for your help.


Posted by kkwaiser at 11:02 AM | Comments (0)

October 20, 2009

Set up a Virtual Web Server at UM


1) Go through LSA for virtual server.
- Doesn't work. They suggested VaaS.

2) VaaS - Essentially blank server space. ~$500/year

3) UMWeb - virtual webserver. This is the step I'm going with and the rest of this post documents the process.

- Post-hoc Cost Estimate: $30/year (IFS Group Space) + $50/year (UMWeb server space) = $80/year. We have 5Gb on the IFS drive and around 10Gb (I believe!) of database space. For comparison purposes, web hosting from runs from $50 - $150/year.

- Question to Mark Montague of ITCS regarding how much space we may need on the IFS group directory:

Hi Mark, I think I'm going to set up a virtual server with MySQL and PHP but I had a question about table space. I'm pretty sure I am going to need to create an IFS group directory. When setting the storage space on this directory, do I need to account for the MySQL tablespace? Or will that IFS directory only be for photos and other webcontent we want to add? Hope this makes sense. Thanks, Kyle

Mark's reply:
The database resides on a dedicated database server, not in IFS. So you only need IFS space for files (PHP, HTML, CSS, media files, and other
Mark Montague
Webmaster team

- CREATE IFS group directory (needed in order to set up a virtual server):

Talking to ITS Account Office about whether we can use a "Course Home Directory" for our IFS space or if the UMBS needs to pay for its own space... Turns out we will need to create our own IFS group space. Cost for UMBS group directory = $0.50/Gb/month

Pam and I set it up at this website and started with 5 Gb. Note that Alicia, Karie, Pam and I are administrators on this drive space. It is called "umbsweb" and should probably only be used for data hosted on the website. Also note that the UMOD group is xbs-UMBSAnnArbor.

- Set up a domain name (

We also need to set up a domain name, I've emailed to inquire about this. See "UMBS Domain Name" below the fold for documentation (email correspondence) on this step. The long/short is that our domain name will be

- Request a Virtual Host

Pam and I did so by going to this website. It took maybe 5 minutes to request (although I do not have the site yet!)

UMBS Domain Name:

The following is an email string that charts how we came to settle on You will want to read from the bottom up!

Hi Kyle,

There isn't any particular setup for it, We just create an entry in UMBS' DNS tables for the hostname. ITS just needs to provide us a destination address to plug into the table when they are done setting things up.


-----Original Message-----
From: Kyle Steven Brown-Kwaiser []
Sent: Tuesday, October 20, 2009 1:08 PM
Subject: Re: UMBS Domain name

Hello Hostmaster,

I would like to set up a domain name ( that will allow the University of Michigan Biological Station to use the ITS web hosting services. What steps are necessary to do this?


Kyle Kwaiser
UMBS Information Manager


On Tue, 20 Oct 2009 12:39:44 -0400,

No special approval is required for that I'm aware of ( would have the authoritative word, though). But I know the LSA hostmaster has previously set up such names so LSA units can use our hosting services.

--- Tony Winkler ITS Web Production Team

Quoting Kyle Steven Brown-Kwaiser :

Hi Tony and Bob, Thanks for the speedy turn around. Would I need an OK from the LSA Dean's office to get ""?


NOTE to Karie and Phil: The DNS policy guides the creation of new web domain names on campus. See attached for the policy.


On Tue, 20 Oct 2009 12:24:25 -0400,

We could host content for on our servers only if the LSA webmaster were willing to configure a reverse proxy on their servers. Has any thought been given to "" for this site? That name meets the DNS policy, and has the advantage of being a distinct hostname that could be pointed directly to one of our servers. It also has fewer points of failure than a reverse proxy, since it doesn't require an intermediary webserver.

--- Tony Winkler ITS Web Production Team


Quoting :

We need to ask the webmasters, so I am forwarding this note.

Bob Harold hostmaster,


Message from
Date: Tue, 20 Oct 2009 12:09:35 -0400
Subject: Re: UMBS Domain name

Hi Bob, I did not know I would need to approach the Dean's office. To be clear, if we are to use the UMWeb servers do we need to create a new domain name? For example, can we somehow use our current name: and still use ITCS server space?

BTW, I've talked to LSA IT and it is not an option to use their server space.

Thank you, kbk

On Tue, 20 Oct 2009 11:45:11 -0400,

Looks like this falls under LS&A. In that case the dean appears to be T. McDonald. Please ask the dean to send an email containing the request (your wording is good) to After that, we run it past our management for approval also.

Bob Harold hostmaster,


Message from
Date: Tue, 20 Oct 2009 11:24:02 -0400
Subject: UMBS Domain name

Hi there, I am in the process of requesting virtual server space through UMWeb and I would like to secure a domain name for the University of Michigan Biological Station. Preferably, the domain name would be To do so, should I have our Director write a letter (phrased as above) with the request? What other information should be included?

Thanks in advance for you help,
Kyle Kwaiser
UMBS Information Manager

----- End message from -----

Posted by kkwaiser at 10:51 AM | Comments (0)

September 30, 2009

Alter style.css of a Drupal theme

This small detail just cost me an hour's time. If you are using a Drupal theme (Garland in my case) and you alter the color scheme, a new directory is created to hold the non-default settings. If you want to tweak the new layout, you then need to go to the style sheet in the new directory (not the default directory.) Now that I think of it, this makes sense but for a newbie this is the kind of detail that is a killer.

Here is an example:

For me, the style.css sheet for Garland is found here:
$ ls -al /usr/share/drupal6/themes/garland/

But when I change the default color scheme a new directory is created:

"The directory sites/default/files/color/garland-b1c6958e has been created."

For the record, that puts me in the following directory:
$ ls /etc/drupal/6/sites/default/files/color/garland-blahblahblah/

If you navigate to this folder you will find a style.css sheet that you can edit to adjust your theme. Now that I see the screen cap it is completely obvious but this help forum is actually what tipped me off.

leaf graphic

(Right-click > View Image for full size image)

Posted by kkwaiser at 09:58 AM | Comments (0)

September 29, 2009

Adding a module to Drupal 6.x

I am going to go over how to add a module to the Drupal core installation. These directions are for development site that is hosted locally.

Note that I am loosely following this website.

1. At your Drupal site, go to Administer > Site Building > Modules to view the modules you currently have access to and if they are enabled.

2. Next, go get the Views module. This is the file I get: views-6.x-2.6.tar.gz

3. Create a folder within etc/drupal/6/sites/ to contain non-core modules.

$ sudo mkdir /etc/drupal/6/sites/all/
$ sudo mkdir /etc/drupal/6/sites/all/modules/

Note: You may not need the /6/ or the "sudo" to accomplish this.

4. Extract the views tar file

$ cd /etc/drupal/6/sites/all/modules/
$ sudo tar xvzf /home/data/Desktop/views-6.x-2.6.tar.gz

5. I then return to the drupal site Administer > Site Building > Modules and refresh the page. Check the modules you want to add and click Save Configuration.

leaf graphic

Posted by kkwaiser at 05:08 AM | Comments (0)

September 25, 2009

Update to Drupal 6.14

My Drupal version is out of date so I am going to track how to update it.

*Note* These instructions are not complete, see usr/share/drupal6/UPGRADE.txt for complete instructions!!

These websites also proved useful: - Video tutorial - good command line help
The UPGRADE.txt file should be within the tar file you download later.

How do I know it is out of date? Because when I login and click "Administer" I see the following:

leaf graphic

- Click "Available Updates" and Download

leaf graphic

This gives me "drupal-6.14.tar.gz"

And, my Drupal files (the ones I am going to replace with the v6.14 files) are located here:

So I navigated to usr/share:
$ cd usr/share

and created a copy of drupal6:

$ sudo cp -r drupal6/ drupal6-backup/

Next, I unpack the Drupal 6.14 to the usr/share directory:

$ sudo tar xvzf /home/data/Desktop/drupal-6.14.tar.gz

This creates a Drupal 6.14 directory in usr/share. Now delete the drupal6/ folder (don't worry, you have a backup.)

$ sudo rm -R drupal6/

Replace the old drupal6 directory with the updated files:
$ sudo mv drupal-6.14/ drupal6/

NOTE: Somewhere in here one of the tutorials uses chmod to change permissions. I followed this step but do not know how important it was. I also do not know the full consequences of said change. Should probably inquire about that when I move outside of a development environment!

Now. If you refresh the drupal homepage it should fail to load. This is because the symbolic links to the /sites and /profiles folders has been lost. Next, recreate the links but first delete the 'hard' directory:

$ sudo rm -rf drupal6/sites/
$ sudo ln -s /etc/drupal/6/sites/ drupal6/

$ sudo rm -rf drupal6/profiles/
$ sudo ln -s /etc/drupal/6/profiles/ drupal6/

Drupal should now work. BTW, this took me forever to figure out. I cannot wait until there is a database to backup as well...

Now go back to Drupal : http://localhost/drupal6/update.php
and select the defaults to run the update script.

leaf graphic

leaf graphic

Finally, make sure your website is back online:
Administer > Site maintenance > Online

Clean up:

$ sudo rm /home/data/Desktop/drupal-6.14.tar.gz
$ sudo rm -rf drupal6-backup/

Go to Administer>Reports>Status report to verify you are running the latest version.

leaf graphic

Please note that these instructions are not comprehensive because I did not back up the MySQL databases. I skipped this step because I haven't built a website and felt I had very little to lose.

Other good tidbits:

This terminal command gives you a program manager GUI that can be useful for determining where your program files are located. It's a bit confusing to me how distributed they are in Linux.

$ sudo synaptic

Posted by kkwaiser at 01:38 PM | Comments (0)

September 24, 2009

Install Drupal on Ubuntu 9.04

After installing the LAMP components, I am now going to install Drupal.

Following a thread on

In the last year the Drupal package was not in Debian/Ubuntu, now it is back. So after a fresh install of Jaunty, just type:
sudo apt-get install drupal6

and then you have to restart the webserver:
sudo /etc/init.d/apache2 restart

And you will see the Drupal install pages here:


You should now be at this page:

leaf graphic

And the next steps finish the installation process.

Here goes:

- Click > Install Drupal in English

Configure Site

- Site name : localhost
- Site e-mail address:
- I put my own email as the Administrator email

leaf graphic

Posted by kkwaiser at 02:09 PM | Comments (0)

Install LAMP on Ubuntu 9.04

The following are notes on how to install the LAMP package (Linux, Apache, MySQL and PhP) onto Ubuntu 9.04. The overall goal is to get Drupal installed but that is step #X.

1. Google around: "Install LAMP on Ubuntu"

This one looks like a decent step-by-step. I've become hesitant of the one-stop installer. Seems it is better to work through the process and become familiar with the individual programs:

Setup LAMP in one command. Yeah right, nothing is that easy.

2. Pick a set of directions and go. Going to follow the tutorial. Because I do not like taking credit for the work of others I'm only going to record my departures from the howtoforge tutorial.

3. Install Apache2 and check http://localhost/ in a browser window
- Wow, that was way too easy. It took me several hours to install Apache into Vista. Install time here was around 30 seconds! Now I just need to be sure Apache is firewalled (or whatever the Linux term is for "not allowing your computer to broadcast to the cloud."

leaf graphic

This website has information on how to block Apache from the outside world. It also tells you how to stop and restart Apache.

leaf graphic

So, assuming I've done everything correctly Apache is up and running and is working locally only!!

Here are some helpful commands for Apache:

$ sudo /usr/sbin/apache2ctl start
$ sudo /usr/sbin/apache2ctl stop
$ sudo /usr/sbin/apache2ctl restart

4. Install PHP
- Done. 1 minute 45 seconds.

leaf graphic

leaf graphic

5. Install MySQL -
"Out of Apache and PHP, MySQL is the most difficult to set up"

- Again, disturbingly easy. Although I skipped the Step 2 (optional) and Step 3, where you setup the password for root was part of the install process.

leaf graphic

leaf graphic

leaf graphic

leaf graphic

One small addition to the tutorial is enter this command (from the comments section):
sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin

This tells apache where phpMyAdmin is.

leaf graphic

Posted by kkwaiser at 08:41 AM | Comments (0)