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 --host=webapps2-db.miserver.it.umich.edu 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]
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.
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.
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.
December 07, 2012
Connect to the LSA DFS
$ sudo mkdir /dev/umbs
$ sudo /sbin/mount.cifs //lsa.m.storage.umich.edu/lsa-umbs /dev/umbs -o user=UMROOT/kkwaiser sec=krb5i
See the Mainstream Storage docs for more.
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)
November 21, 2011
Convert Date To Text in OpenOffice
This has baffled me many times but not this time. I am revenge.
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.
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 email@example.com 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/CN=umbs.lsa.umich.edu"
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.
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.
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!
January 18, 2011
Logging php errors
$ 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
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.
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
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.
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.
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 :
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.
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):
GMAP 6.x-1.x-dev (2009-Dec-15)
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:
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 servername.umich.edu
commands of note:
ls, cd, lcd, pwd, lpwd, put, get, mv
psftp> put -r LTER_ContentTypes
psftp > ls /Dept/umbs/dept/
I've since gotten sftp via the terminal to work:
$ sftp firstname.lastname@example.org
to specify a port:
$ sftp -oPort=[portnumber] email@example.com
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
IP address shows up und inet addr:
File of concern:
Some delete statements:
$ sudo ufw delete deny from
$ sudo ufw delete allow from
$ sudo ufw delete deny 80
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 openoffice.org
And for whatever reason, my new version of OpenOffice works and will open a dbf file. Unfortunately, that took up a lot of time.
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 (firstname.lastname@example.org) 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 (email@example.com) 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 firstname.lastname@example.org 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 email@example.com 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 firstname.lastname@example.org:
You need the following information in to create a UM uniqname:
Suggested uniqname (optional)
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) http://www.itcs.umich.edu/itcsdocs/r1458/
3)Connecting to the SFTP site
a.See the attached documents for instructions:
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 mail.umich.edu 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 https://accounts.www.umich.edu/kpasswd-bin/kpasswd.cgi
c.To access Frequently Asked Questions for getting started with using LSA Windows Services:
Note, more documentation is available for this process:
Instructions on how to create an SFTP site
These docs are referenced within the former:
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.
This pdf accompanies the preceding doc:
Thanks again for your help.
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 Godaddy.com 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
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
- 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 umbs.lsa.umich.edu website. Also note that the UMOD group is xbs-UMBSAnnArbor.
- Set up a domain name (umbs.lsa.umich.edu):
We also need to set up a domain name, I've emailed email@example.com 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 umbs.lsa.umich.edu.
- 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 umbs.lsa.umich.edu. You will want to read from the bottom up!
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.
From: Kyle Steven Brown-Kwaiser [mailto:firstname.lastname@example.org]
Sent: Tuesday, October 20, 2009 1:08 PM
Subject: Re: UMBS Domain name
I would like to set up a domain name (umbs.lsa.umich.edu) that will allow the University of Michigan Biological Station to use the ITS web hosting services. What steps are necessary to do this?
UMBS Information Manager
On Tue, 20 Oct 2009 12:39:44 -0400,
No special approval is required for umbs.lsa.umich.edu that I'm aware of (email@example.com 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 "umbs.lsa.umich.edu"?
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 www.lsa.umich.edu/umbs on our servers only if the LSA webmaster were willing to configure a reverse proxy on their servers. Has any thought been given to "umbs.lsa.umich.edu" 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
We need to ask the webmasters, so I am forwarding this note.
Bob Harold hostmaster,
Message from firstname.lastname@example.org
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: http://www.lsa.umich.edu/umbs 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 email@example.com. After that, we run it past our management for approval also.
Bob Harold hostmaster,
Message from firstname.lastname@example.org
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 www.umbs.umich.edu. 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,
UMBS Information Manager
----- End message from email@example.com -----
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.
(Right-click > View Image for full size image)
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.
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:
http://learnbythedrop.com/drop/70 - Video tutorial
http://www.stevedivine.com/node/3 - 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:
- Click "Available Updates" and Download
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.
Finally, make sure your website is back online:
Administer > Site maintenance > Online
$ 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.
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
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 drupal.org:
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:
And the next steps finish the installation process.
- Click > Install Drupal in English
- Site name : localhost
- Site e-mail address: firstname.lastname@example.org
- I put my own email as the Administrator email
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 howtoforge.com 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."
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.
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.
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.