Download Verve Meta Boxes

Verve Meta Boxes used to be available from avenueverve.com at their website – http://www.avenueverve.com/verve-meta-boxes/

The plugin has disappeared from that site as well as from the WordPress plugin repository.

The latest version of the plugin, I believe, was `Version: 1.2.9`

You can download this version from my blog at verve-meta-boxes.zip.

Happy WordPressing!

Verve Meta Boxes Screenshots

Posted in Tech Tips, Web Development | Tagged , , , | Leave a comment

Does Git change file permissions?

Yes it does. Don’t go working away, for instance, putting you `/etc` directory in git and then switching branches.

Git may change your directories to `755` and your files to `644` which will cause the system problems with security, and may even prevent booting.

look at etckeeper or this tutorial for more information about keeping `/etc` in a git repo, but the answer to “Does Git change file permissions?” is a definitive “Yes”

Posted in Security, Server Admin, Web Development | Tagged | Leave a comment

Google Girl with Glasses in the Inbox

When I open my inbox google is encouraging me to upgrade so I can video chat with up to 9 people. No thanks, I’m ok. But there is a video with Google Girl explaining how to do Hangouts and how to get things done.

###Video chat with up to nine people
Upgrade to Google+ to get more out of Hangouts and go beyond one-to-one video chat. You’ll be able to chat with up to nine people at once, collaborate on Google Docs together and more – just like Google Girl does.

Google Girl with Glasses in the Inbox

Google Girl with Glasses in the Inbox

Google Girl with Glasses in the Inbox

###Google Girl Images

Here are a few more images of Google Girl from the video:

Google Girl with Glasses in the Inbox

Google Girl with Glasses in the Inbox

Google Girl with Glasses in the Inbox

Posted in Marketing, Social Media, Tech Tips | Tagged , , | 5 Comments

nmap scans ips and ports

A useful linux/unix tool, `nmap` scans ips and ports of given hosts:

Nmap Scans Ips And Ports

Nmap 5.21 ( http://nmap.org )
Usage: nmap [Scan Type(s)] [Options] {target specification}
TARGET SPECIFICATION:
Can pass hostnames, IP addresses, networks, etc.
Ex: scanme.nmap.org, 192.168.0.1; 10.0.0-255.1-254
-iL : Input from list of hosts/networks
-iR : Choose random targets
–exclude : Exclude hosts/networks
–excludefile : Exclude list from file
HOST DISCOVERY:
-sL: List Scan – simply list targets to scan
-sP: Ping Scan – go no further than determining if host is online
-PN: Treat all hosts as online — skip host discovery
-PS/PA/PU/PY[portlist]: TCP SYN/ACK, UDP or SCTP discovery to given ports
-PE/PP/PM: ICMP echo, timestamp, and netmask request discovery probes
-PO[protocol list]: IP Protocol Ping
-n/-R: Never do DNS resolution/Always resolve [default: sometimes]
–dns-servers : Specify custom DNS servers
–system-dns: Use OS’s DNS resolver
–traceroute: Trace hop path to each host
SCAN TECHNIQUES:
-sS/sT/sA/sW/sM: TCP SYN/Connect()/ACK/Window/Maimon scans
-sU: UDP Scan
-sN/sF/sX: TCP Null, FIN, and Xmas scans
–scanflags : Customize TCP scan flags
-sI : Idle scan
-sY/sZ: SCTP INIT/COOKIE-ECHO scans
-sO: IP protocol scan
-b : FTP bounce scan
PORT SPECIFICATION AND SCAN ORDER:
-p : Only scan specified ports
Ex: -p22; -p1-65535; -p U:53,111,137,T:21-25,80,139,8080
-F: Fast mode – Scan fewer ports than the default scan
-r: Scan ports consecutively – don’t randomize
–top-ports : Scan most common ports
–port-ratio : Scan ports more common than
SERVICE/VERSION DETECTION:
-sV: Probe open ports to determine service/version info
–version-intensity : Set from 0 (light) to 9 (try all probes)
–version-light: Limit to most likely probes (intensity 2)
–version-all: Try every single probe (intensity 9)
–version-trace: Show detailed version scan activity (for debugging)
SCRIPT SCAN:
-sC: equivalent to –script=default
–script=: is a comma separated list of
directories, script-files or script-categories
–script-args=: provide arguments to scripts
–script-trace: Show all data sent and received
–script-updatedb: Update the script database.
OS DETECTION:
-O: Enable OS detection
–osscan-limit: Limit OS detection to promising targets
–osscan-guess: Guess OS more aggressively
TIMING AND PERFORMANCE:
Options which take

Posted in Security, Server Admin, Tech Tips | Tagged , , , | Leave a comment

25 Most Popular Shared Web Hosting Companies

1. 1and1
1. AN Hosting
1. Aruba.it
1. A Small Orange
1. BlueHost
1. DreamHost
1. GoDaddy
1. HostGator
1. HostICan
1. ICDSoft
1. IPower
1. LaughingSquid
1. MediaTemple GridServer
1. MediaTemple (dv)
1. MegnaHost
1. NearlyFreeSpeech.Net
1. NetworkSolutions
1. one.com
1. pair Networks
1. Rackspace Cloud
1. SysFix.eu Power Hosting
1. Yahoo
1. Tophost.it

Posted in Tech Tips, Web Development | Tagged , | 1 Comment

WordPress.org is down – July 2012

WordPress.org is down on July 25, 2012 with a “502 Bad Gateway” error message.

This site is so reliably up that it is strange to see WordPress.org be offline. I noticed it when I was using a `wget` command to download the latest version.

wget http://wordpress.org/latest.tar.gz
–2012-07-25 11:31:20– http://wordpress.org/latest.tar.gz
Resolving wordpress.org (wordpress.org)… 72.233.56.138, 72.233.56.139
Connecting to wordpress.org (wordpress.org)|72.233.56.138|:80… connected.
HTTP request sent, awaiting response… 502 Bad Gateway
2012-07-25 11:31:20 ERROR 502: Bad Gateway.

Wordpress Org Is Down July 2012

Posted in Software, Tech Tips, Web Development | Tagged , | Leave a comment

WordPress: Convert All Tables To Utf8

Wordpress Convert All Tables To Utf8Are your WordPress MySQL Tables of mixed charsets? The ideal or standard character set is utf-8 as it supports multiple languages and special characters – so people from all over the world can post comments, register, and interact with your blog without having characters from their name, languages, etc converted into weird or strange symbols.

I read the WordPress article on Converrting your Tables but wasn’t so sure which direction to go. The article states:

> In most cases if a collation is not defined MySQL will assume the default collation for the CHARSET which is specified. For UTF8 the default is utf8_general_ci, which is usually the right choice.

After a little research I got it working.

The following code is from the supplemental code page from that article and I found that the code below (second code block on that page) worked well for WordPress 3.4.1

I would not recommend using the bash script at the bottom of that page because while it converts the tables it doesn’t convert the fields. When connecting from the command line you may need to specify `–protocol=TCP` if you get an error like

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

But again, I would not really recommend that script, because while it will run, it will basically only run the following commands:

ALTER TABLE wp_commentmeta CHARACTER SET utf8;
ALTER TABLE wp_comments CHARACTER SET utf8;
ALTER TABLE wp_links CHARACTER SET utf8;
ALTER TABLE wp_options CHARACTER SET utf8;
ALTER TABLE wp_postmeta CHARACTER SET utf8;
ALTER TABLE wp_posts CHARACTER SET utf8;
ALTER TABLE wp_term_relationships CHARACTER SET utf8;
ALTER TABLE wp_term_taxonomy CHARACTER SET utf8;
ALTER TABLE wp_terms CHARACTER SET utf8;
ALTER TABLE wp_usermeta CHARACTER SET utf8;
ALTER TABLE wp_users CHARACTER SET utf8;

And the thing that is missing is converting the individual fields as well.

BACK UP YOUR DATABASE before running these SQL statements

## SQL To convert a site from latin1 to UTF8
In this case all columns were previously set to latin1 and the data inside them was latin1

## SQL To convert a site from latin1 to UTF8
In this case all columns were previously set to latin1 and the data inside them was latin1

### post\_content
alter table wp_posts change post_content post_content LONGBLOB;
alter table wp_posts change post_content post_content LONGTEXT CHARACTER SET utf8 not null;
### post\_title
alter table wp_posts change post_title post_title BLOB;
alter table wp_posts change post_title post_title TEXT CHARACTER SET utf8 not null;
### post\_excerpt
alter table wp_posts change post_excerpt post_excerpt BLOB;
alter table wp_posts change post_excerpt post_excerpt TEXT CHARACTER SET utf8 not null;
### post\_status
alter table wp_posts change post_status post_status VARBINARY(20);
alter table wp_posts change post_status post_status VARCHAR(20) character set utf8 not null default ‘publish’;
### wp\_posts comment\_status
alter table wp_posts change comment_status comment_status VARBINARY(20);
alter table wp_posts change comment_status comment_status VARCHAR(20) character set utf8 not null default ‘open’;
### ping\_status
alter table wp_posts change ping_status ping_status VARBINARY(20);
alter table wp_posts change ping_status ping_status VARCHAR(20) character set utf8 not null default ‘open’;
### post\_password
alter table wp_posts change post_password post_password VARBINARY(20);
alter table wp_posts change post_password post_password VARCHAR(20) character set utf8 not null default ”;
### post\_name
alter table wp_posts change post_name post_name VARBINARY(200);
alter table wp_posts change post_name post_name VARCHAR(200) character set utf8 not null default ”;
### wp\_posts to\_ping
alter table wp_posts change to_ping to_ping BLOB;
alter table wp_posts change to_ping to_ping TEXT CHARACTER SET utf8 not null;
### wp\_posts pinged
alter table wp_posts change pinged pinged BLOB;
alter table wp_posts change pinged pinged TEXT CHARACTER SET utf8 not null;
### post\_content\_filtered
alter table wp_posts change post_content_filtered post_content_filtered BLOB not null;
alter table wp_posts change post_content_filtered post_content_filtered TEXT CHARACTER SET utf8 not null;
### guid
alter table wp\_posts change guid guid VARBINARY(255);
alter table wp_posts change guid guid VARCHAR(255) character set utf8 not null default ”;
### post\_type
alter table wp_posts change post_type post_type VARBINARY(20);
alter table wp_posts change post_type post_type VARCHAR(20) character set utf8 not null default ‘post’;
### post\_mime\_type
alter table wp_posts change post_mime_type post_mime_type VARBINARY(100);
alter table wp_posts change post_mime_type post_mime_type VARCHAR(100) character set utf8 not null default ”;

ALTER TABLE wp_posts CHARACTER SET utf8;

### comment\_author
alter table wp_comments change comment_author comment_author TINYBLOB;
alter table wp_comments change comment_author comment_author TINYTEXT character set utf8 not null;
### comment\_author\_email
alter table wp_comments change comment_author_email comment_author_email VARBINARY(100);
alter table wp_comments change comment_author_email comment_author_email VARCHAR(100) character set utf8 not null default ”;
### comment\_author\_url
alter table wp_comments change comment_author_url comment_author_url VARBINARY(200);
alter table wp_comments change comment_author_url comment_author_url VARCHAR(200) character set utf8 not null default ”;
### comment\_author\_ip
alter table wp_comments change comment_author_IP comment_author_IP VARBINARY(100);
alter table wp_comments change comment_author_IP comment_author_IP VARCHAR(100) character set utf8 not null default ”;
### comment\_content
alter table wp_comments change comment_content comment_content BLOB;
alter table wp_comments change comment_content comment_content text character set utf8 not null;
### comment\_approved
alter table wp_comments change comment_approved comment_approved VARBINARY(20);
alter table wp_comments change comment_approved comment_approved VARCHAR(20) character set utf8 not null default ‘1’;
### comment\_agent
alter table wp_comments change comment_agent comment_agent VARBINARY(255);
alter table wp_comments change comment_agent comment_agent VARCHAR(255) character set utf8 not null default ”;
### comment\_type
alter table wp_comments change comment_type comment_type VARBINARY(20);
alter table wp_comments change comment_type comment_type VARCHAR(20) character set utf8 not null default ”;

ALTER TABLE wp_comments CHARACTER SET utf8;

### commentmeta meta\_key
alter table wp_commentmeta change meta_key meta_key VARBINARY(255);
alter table wp_commentmeta change meta_key meta_key VARCHAR(255) character set utf8;
### commentmeta meta\_value
alter table wp_commentmeta change meta_value meta_value LONGBLOB;
alter table wp_commentmeta change meta_value meta_value LONGTEXT character set utf8;

ALTER TABLE wp_commentmeta CHARACTER SET utf8;

### link\_url
alter table wp_links change link_url link_url VARBINARY(255);
alter table wp_links change link_url link_url VARCHAR(255) character set utf8 not null default ”;
### link\_name
alter table wp_links change link_name link_name VARBINARY(255);
alter table wp_links change link_name link_name VARCHAR(255) character set utf8 not null default ”;
### link\_image
alter table wp_links change link_image link_image VARBINARY(255);
alter table wp_links change link_image link_image VARCHAR(255) character set utf8 not null default ”;
### link\_target
alter table wp_links change link_target link_target VARBINARY(25);
alter table wp_links change link_target link_target VARCHAR(25) character set utf8 not null default ”;
### link\_description
alter table wp_links change link_description link_description VARBINARY(255);
alter table wp_links change link_description link_description VARCHAR(255) character set utf8 not null default ”;
### link\_visible
alter table wp_links change link_visible link_visible VARBINARY(20);
alter table wp_links change link_visible link_visible VARCHAR(20) character set utf8 not null default ‘Y’;
### link\_rel
alter table wp_links change link_rel link_rel VARBINARY(255);
alter table wp_links change link_rel link_rel VARCHAR(255) character set utf8 not null default ”;
### link\_notes
alter table wp_links change link_notes link_notes MEDIUMBLOB;
alter table wp_links change link_notes link_notes MEDIUMTEXT character set utf8 not null;
### link\_rss
alter table wp_links change link_rss link_rss VARBINARY(255);
alter table wp_links change link_rss link_rss VARCHAR(255) character set utf8 not null default ”;

ALTER TABLE wp_links CHARACTER SET utf8;

### option\_name
alter table wp_options change option_name option_name VARBINARY(64);
alter table wp_options change option_name option_name VARCHAR(64) character set utf8 not null default ”;
### option\_value
alter table wp_options change option_value option_value LONGBLOB;
alter table wp_options change option_value option_value LONGTEXT character set utf8 not null;
### wp\_options autoload
alter table wp_options change autoload autoload VARBINARY(20);
alter table wp_options change autoload autoload VARCHAR(20) character set utf8 not null default ‘yes’;

ALTER TABLE wp_options CHARACTER SET utf8;

### wp\_postmeta meta\_key
alter table wp_postmeta change meta_key meta_key VARBINARY(255);
alter table wp_postmeta change meta_key meta_key VARCHAR(255) character set utf8;
### wp\_postmeta meta\_value
alter table wp_postmeta change meta_value meta_value LONGBLOB;
alter table wp_postmeta change meta_value meta_value LONGTEXT character set utf8;

ALTER TABLE wp_postmeta CHARACTER SET utf8;

### wp\_terms name
alter table wp_terms change name name VARBINARY(200);
alter table wp_terms change name name VARCHAR(200) character set utf8 not null default ”;
### wp\_terms slug
alter table wp_terms change slug slug VARBINARY(200);
alter table wp_terms change slug slug VARCHAR(200) character set utf8 not null default ”;

ALTER TABLE wp_terms CHARACTER SET utf8;

### wp\_term\_taxonomy taxonomy
alter table wp_term_taxonomy change taxonomy taxonomy VARBINARY(32);
alter table wp_term_taxonomy change taxonomy taxonomy VARCHAR(32) character set utf8 not null default ”;
### wp\_term\_taxonomy description
alter table wp_term_taxonomy change description description LONGBLOB;
alter table wp_term_taxonomy change description description LONGTEXT character set utf8 not null;

ALTER TABLE wp_term_taxonomy CHARACTER SET utf8;

### term\_relationships has no encoded content, but switch carset anyway
ALTER TABLE wp_term_relationships CHARACTER SET utf8;

### wp\_usermeta meta\_key
alter table wp_usermeta change meta_key meta_key VARBINARY(255);
alter table wp_usermeta change meta_key meta_key VARCHAR(255) character set utf8;
### wp\_usermeta meta\_value
alter table wp_usermeta change meta_value meta_value LONGBLOB;
alter table wp_usermeta change meta_value meta_value LONGTEXT character set utf8;

ALTER TABLE wp_usermeta CHARACTER SET utf8;

### user\_login
alter table wp_users change user_login user_login VARBINARY(60);
alter table wp_users change user_login user_login VARCHAR(60) character set utf8 not null default ”;
### user\_pass
alter table wp_users change user_pass user_pass VARBINARY(64);
alter table wp_users change user_pass user_pass VARCHAR(64) character set utf8 not null default ”;
### user\_nicename
alter table wp_users change user_nicename user_nicename VARBINARY(50);
alter table wp_users change user_nicename user_nicename VARCHAR(50) character set utf8 not null default ”;
### user\_email
alter table wp_users change user_email user_email VARBINARY(100);
alter table wp_users change user_email user_email VARCHAR(100) character set utf8 not null default ”;
### user\_url
alter table wp_users change user_url user_url VARBINARY(100);
alter table wp_users change user_url user_url VARCHAR(100) character set utf8 not null default ”;
### user\_activation\_key
alter table wp_users change user_activation_key user_activation_key VARBINARY(60);
alter table wp_users change user_activation_key user_activation_key VARCHAR(60) character set utf8 not null default ”;
### wp\_users display\_name
alter table wp_users change display_name display_name VARBINARY(250);
alter table wp_users change display_name display_name VARCHAR(250) character set utf8 not null default ”;

ALTER TABLE wp_users CHARACTER SET utf8;

Posted in Server Administration, Web Development | Tagged , | Leave a comment

How to set the Featured Image in WordPress

To set a featured image, while editing a page click the “set featured image” link, or if one is existing click the remove link and then click the “set featured image” link.

The Featured Image In WordPress - How To Set

Next you can choose one of the tabs on the window that pops up. If you want to upload an image just drag the image to the window or click on “select file” and choose the image you want. You can also select an image from the media library by clicking on that tab, or if images have already been attached to that post a “gallery” tab will show up.

Wordpress Choose The Feature Image You Want

After you upload the image, or if you go to the media library, you can click on the image name to show more details about it. Then, near the bottom there will be a “use as featured image” link.

Media Library Select Featured Image

Posted in Tech Tips, Web Development | Tagged , , , | Leave a comment

Textmate: Toggle Insert Anywhere

When I click somewhere on a line of text – in the empty space part after content – the cursor moves to the exact position I’ve clicked rather than jumping to the end of the line like every other editor seems to do.

This is how to reset this behavior and fix Textmate – that is, to click and have the cursor move to the end of that line and not to the actual position you click with the mouse.

This is caused by Freehand Editing mode being turned on. Here are the two editing modes that Textmate allows, and here is how to enable / disable both of them:

###Freehand Editing
(Edit » Mode » Freehand Editing)

– Allows the caret to move past end of line and inside tab characters.
– It is also possible to place the caret unrestricted by line endings (and tabs) by holding down ? while placing the caret with the mouse.

###Overwrite Mode
(Edit » Mode » Overwrite Mode)

– This lets you type over existing text

Fix Cursor Move To The End Of That Line in Textmate

Posted in Mac, Software, Tech Tips | Tagged , , , , , | 1 Comment

Remote Desktop to Raspberry Pi from OS X w/ ssh XForwarding

Ssh Xforwarding

Can you already ssh into your raspberry pi? In short, you will need to make sure you have a public key in the `/home/pi/.ssh/authorized_keys` directory. The directory should be `chmod 700` and the file `chmod 600`. Good. If not see the notes below.

You can then SSH to the box with something like:

ssh [email protected] -i /path/to/private.key -X

The `-i` option will specify your private key and `-X` will turn on X Forwarding.

Once you’ve logged in you should be able to run `lxsession` to start the Lightweight Desktop (LXDE):

Raspberry Pi From Os X with X11 / X Forwarding

If you can’t already SSH into your pi, fusionstrike has some notes on how to set that up.

One more note: don’t try and do this as the root user. You may get some errors about `A window manager is already running on screen` – do it as the `pi` user as I mentioned above.

Posted in Server Admin | Tagged , , , | Leave a comment