UNeedStuff

01 Feb

Glad to see February 2008!

Although it is blowing in with gusto and about 8″ of snow, I am happy to see the last of January. January was a month of feeling like I was slugging through the slush. Weather was odd, and I never quite felt that I was on top of things, but more that I was always rushing to catch up. I lost my beloved computer, and now have a new one. I’ll have to wait and see how our relationship progresses. Vista has been giving me a time of it.

Mercury went Rx on the 28th, which is a good thing for me, as I seem to have the trouble before it appears Rx, maybe because Mercury is Rx in may chart? I have had two really good days working, so hopefully that will continue, I did run into some trouble, but Mercury may be playing the part in my clients life ;-)

On to a fabulous February!

18 Jan

Importing Live WP into a Local setting

After exporting the db from the live site, goto your local phpMyAdmin
Select your local wp database on the left, and then Import
Browse to your file, and then select Go
After the import you need to change two entries in the DB both are in wp_options
siteurl needs to be changed to your local site url &
home also needs to be changed to your local url

Also you will need to login with the live site user name and password, not the one you may have set up originally for the local site.

Technorati Tags: ,

18 Jan

Delete key in Calc for OpenOffice.org

It’s taken me forever to find this so I thought I’d share. Want to just delete, and not have to deal with the window in OOo? Just hit the Backspace key.

Technorati Tags: , ,

14 Jan

Back to work

Today was a much more normal day. Still have a few things to do but overall I’m back in action. Still not sure how I feel about Vista but I’m picking it up. I was able to get through most of my email today. Did some work for Dawn. Still have quite a bit to get caught up. I’ll be doing some of the easy stuff 1st. Isn’t that the best way to go? Quick stuff 1st right?

14 Jan

Installing XAMPP for Drupal & WordPress to run locally

I did the zipped install to c:/xampp
Stared up Apache, MySql, and Mercury entered 127.0.0.1 in my browse got in everything running, Selected Security and did everything listed to secure XAMPP, MySQL, PhpMyAdmin, and Mecury Mail. I left PHP as is.

The following steps I’ve either picked up at the sites I’ll list at the end, or figured out myself during my last install. After making a change to each file stop and start your services, so you can find any typo’s or errors file by file. If you want until the end you’ll have to recheck everything.

I will be putting all my site files in c:/localsites and not the default c:/xampp/htdocs because I like to keep the site files separate from my XAMPP files. All the files from the htdocs folder must be copied into the folder your running your sites from. I’m putting those steps in blue so where you see the blue you either need to change my localsites to whatever folder your using, or skip the steps if your leaving it at the default, also anywhere I have localsites in my steps you’ll need to adjust the path to folder name you are using.

\xampp\Apache22\conf\httpd.conf

  • change ‘Listen 80′ to ‘Listen 127.0.0.1:80′
  • make sure Include cont/extra/httpd-vhosts.conf was unmasked (no# before the line)
  • add install.php to the line DirectoryIndex inside the <IfModule dir_module> tag
  • changed DocumentRoot to “/localsites” (XAMPP defaults to htdocs)
  • <Directory “/xampp/htdocs”> to <Directory “/localsites“>
  • Unmask LoadModule rewrite_module modules/mod_rewrite.so to allow for clean urls

stopped and started services everything shiny!

\xampp\Apache22\conf\extra\httpd-ssl.conf

  • change ‘Listen 443′ to ‘Listen 127.0.0.1:443′

stopped and started services everything shiny!

\xampp\phpMyAdmin\config.inc.php

  • make sure $cfg[’Servers’][$i][’auth_type’] = ‘cookie’;

Shiny!

xampp\apache\bin\php.ini

  • removed the ; from the mcrypt.dll line

Shiny!

xampp\appache\conf\extra\httpd-vhosts.conf add the follow to the end of this file

  • NameVirtualHost 127.0.0.1:80
  • (for xampp)
    <VirtualHost 127.0.0.1:80>
    ServerName localhost
    DocumentRoot /localsites
    </VirtualHost>
  • (for drupal)
    <VirtualHost sitenameyourusing:80>
    ServerName sitenameyourusing
    DocumentRoot /localsites/drupal-5/ you only need one folder for drupal, no matter how many sites you run
    </VirtualHost>
  • (for wordpress)
    <VirtualHost sitenameyourusing:80>
    ServerName sitenameyourusing
    DocumentRoot /localsites/folderyouputwordpressin/ each wordpress installation needs it’s own folder
    </VirtualHost>
    each site needs it’s own virtual host

windows\system32\drivers\ect\hosts
add the following lines to the end of the file

  • If it isn’t already there add 127.0.0.1 localhost
  • 127.0.0.1 sitenameyourusing
    you one line for each site your running locally

That’s it for the XAMPP part, or at least for tonight, I’ll pick this up tomorrow when I run the installs. I’m going to try having a sync’d site following the steps from Urban Giraffe again… tomorrow.

XAMPP
WAMP
Drupal help
Clearpoint Systems
TextBook
WordPress @ T2
Geeks are Sexy

Technorati Tags: , , , ,

© 2008 UNeedStuff | Entries (RSS) and Comments (RSS)

Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette