Wordpress New Development Single Site Install Checklist

From GLMWiki
Revision as of 13:47, 14 October 2015 by Kc8wxm (Talk | contribs)

Jump to: navigation, search

Word Press New Development Single Site Install

[]Create the domain on ispConfig 

- Go to https://dev55.gaslightmedia.com:8080
- Create new website 
  - client is GaslightMedia, 
  - domain is [websitename].gaslightmedia.com(no www or trailing domain extension)
  -Auto-Subdomain 'None'
  - SAVE
- Click on the website. Go to the Options tab, and add the following to nginx directives
  (Note ... so far (1/19/15), it appears we can copy and paste from another working domain)

location / {
	try_files $uri $uri/ /index.php?$args;
}

# Add trailing slash to */wp-admin requests.
rewrite /admin$ $scheme://$host$uri/ permanent;


===============================================================

<ENGINEERING -- STOP CONFIG --- RE-TASK to Steve, or Laury in his absence>

===============================================================

[]Install wordpress using ispconfig 

APS Installer > Available Packages > Search for "Wordpress"
Click newest version > "Install this package"
Install Location: <site to install>
Admin login: <yourname/laury/steve>
password: <up to you> -- '''no confirmation!!!'''
Administrator's email: <yourname>@gaslightmedia.com
Site Name: <site to install>

Refresh Installed Packages after 30-60s, should say "Installation_success"

[]setup local hosts file so you can goto the site 

e.g.:
  /etc/hosts
 66.129.32.54 www.wildbillsatvs.com wildbillsatvs.com

[] change default table_prefix to glm_ --this can be found in wp-config.php of the according site.

Password can be found in wp-config

Tables 

RENAME table `wp_commentmeta` TO `glm_commentmeta`;
RENAME table `wp_comments` TO `glm_comments`;
RENAME table `wp_links` TO `glm_links`;
RENAME table `wp_options` TO `glm_options`;
RENAME table `wp_postmeta` TO `glm_postmeta`;
RENAME table `wp_posts` TO `glm_posts`;
RENAME table `wp_terms` TO `glm_terms`;
RENAME table `wp_term_relationships` TO `glm_term_relationships`;
RENAME table `wp_term_taxonomy` TO `glm_term_taxonomy`;
RENAME table `wp_usermeta` TO `glm_usermeta`;
RENAME table `wp_users` TO `glm_users`;

Options 

SELECT * FROM `glm_options` WHERE `option_name` LIKE '%wp_%'

Meta 

SELECT * FROM `glm_usermeta` WHERE `meta_key` LIKE '%wp_%'

Add users to site sql for creating users 

RENAME table `wp_commentmeta` TO `glm_commentmeta`;
RENAME table `wp_comments` TO `glm_comments`;
RENAME table `wp_links` TO `glm_links`;
RENAME table `wp_options` TO `glm_options`;
RENAME table `wp_postmeta` TO `glm_postmeta`;
RENAME table `wp_posts` TO `glm_posts`;
RENAME table `wp_terms` TO `glm_terms`;
RENAME table `wp_term_relationships` TO `glm_term_relationships`;
RENAME table `wp_term_taxonomy` TO `glm_term_taxonomy`;
RENAME table `wp_usermeta` TO `glm_usermeta`;
RENAME table `wp_users` TO `glm_users`;

INSERT INTO `glm_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
('cscott', '$P$BJMie6Dwyp.RD6V6lGgh88TuJ/r625.', 'cscott', 'cscott@gaslightmedia.com', '', NOW(), '', 0, 'cscott'),
('steve', '$P$BiMOzSw8hM5a/K/1pMj961nQvejfAZ1', 'steve', 'steve@gaslightmedia.com', '', NOW(), '', 0, 'steve'),
('laury', '$P$BUQqo9GDEdRxgPGN3xHgxTAmhZmYUO1', 'laury', 'laury@gaslightmedia.com', '', NOW(), '', 0, 'laury'),
('jodie', '$P$BzO0XuOIXx8b8x6ztWSKejkiK5lhvd/', 'jodie', 'jodie@gaslightmedia.com', '', NOW(), '', 0, 'jodie'),
('candace', '$P$BAlC7cLEMtoBHes6Dd9RNEib5SOuWe.', 'candace', 'billing@gaslightmedia.com', '', NOW(), '', 0, 'jodie'),
('anthony', '$P$BubULLBz9zOc1k7sQ6gQHkjCI40pOU1', 'anthony', 'anthony@gaslightmedia.com', '', NOW(), '', 0, 'anthony'),
('ianw', '$P$BkBgZf2R8hSjXD0SfKxdYfgChefI5X.', 'ianw', 'ian@gaslightmedia.com', '', NOW(), '', 0, 'ianw'),
('collins', '$P$BtB2gYe2c1PUAgCOwSWsUimqVSyuFs.', 'collins', 'collins@gaslightmedia.com', '', NOW(), '', 0, 'collins')
('anthonyt', '$P$B/zbmiq88UcZV12WWYeAkR0D34i5cW/', 'anthonyt', 'talarico@gaslightmedia.com', '', NOW(), '', 0, 'anthonyt'),
('charis', '$P$B6jJkDScyhuRPCfYDrsyrEnVNW406v/', 'charis', 'charis@gaslightmedia.com', '', NOW(), '', 0, 'charis');

UPDATE `glm_options` SET `option_name` = 'glm_user_roles' WHERE `option_name` = 'wp_user_roles';
UPDATE `glm_usermeta` SET `meta_key` = 'glm_capabilities' WHERE `meta_key` = 'wp_capabilities';
UPDATE `glm_usermeta` SET `meta_key` = 'glm_user_level' WHERE `meta_key` = 'wp_user_level';

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'steve'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'candace'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'ianw'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'glm_capabilities', 'a:1:{s:6:"editor";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'collins'), 'glm_user_level', '7');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthonyt'), 'glm_user_level', '10');

INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'charis'), 'glm_user_level', '10');


UPDATE `glm_options` SET `option_value` ='America/Detroit' WHERE `option_name` = 'timezone_string';
UPDATE `glm_options` SET `option_value` ='0' WHERE `option_name` = 'start_of_week';
UPDATE `glm_options` SET `option_value` ='page' WHERE `option_name` = 'show_on_front';
UPDATE `glm_options` SET `option_value` ='2' WHERE `option_name` = 'page_on_front';

UPDATE `glm_posts` SET `post_title` = 'Front Page' WHERE `post_type` = 'page';

[] trash all pages and posts that are in default install
[] set timezone to detroit 
[] start of week to Sunday
[] export pages and change any dev.gaslightmedia.com references to site url.
[] import pages
[] set front page
[] import pages
[] import options
[] setup plugins
[] setup new users

Common Plugins 

(get rid of default installed Akismet, WP multibyte japanese patch, and Hello Dolly)
[] WP Plugins installed:
[] TinyMCE
[] Nextgen Gallery
- [] Nextgen custom fields
- [] Nextgen GLM templates (when theme is active)
[] Metaslider
[] User role editor
[] Wordpress importer
[] Wordpress options importer
[] Navxt
[] Advanced excerpt
[] CMS tree view
[] Yoast SEO: /wp-admin/update.php?action=install-plugin&plugin=wordpress-seo&_wpnonce=e95209c785
[] Restricted Site Access

(should be already set once plugin is activated) update settings > reading > Restrict site access to visitors who are logged in or allowed by IP address
and > Send them to the WordPress login screen 

GLM Plugins Installed:
[] git clone git@cvs2:WP-Plugins/Gaslightify.git
[] git clone git@cvs2:WP-Plugins/glm-client-info.git
[] git clone git@cvs2:WP-Plugins/glm-blocks.git
[] git clone git@cvs2:WP-Plugins/glm-support-form.git


update the seo > Titles & meta > Post types (and taxonomies) turn off meta boxes for all seo


Import Nextgen images 

!!! First go to Media > Settings and make sure the dimensions are the SAME as on Dev, or you'll be missing image resizings and will have to copy them over

Get the export from the database at dev.gaslightmedia.com site on ISPConfig for ngg_albums, ngg_galleries, and ngg_pictures
Edit those files to replace wp_8 with glm, and take out the /sites/8 part (the 8 here will be dependent on the ID for that site in dev.gaslightmedia.com multisite)
Import those into the database of the new site AFTER installing the nextgen plugin, in this order: albums, galleries, pictures.

Make sure all the gallery templates are set properly again, they'll still point to their old location (This might be more easily doable through the database?) - also set default templates for thumbnails (and any other used) in Gallery Settings to glmPhotos, ajax pagination to Yes, show slideshow link to No, Compact Album template to GlmAlbums, override thumbnail dimensions for both to 220x190

Other Options > Lightbox Effects > Effect to use: Lightbox
Other Options > Thumbnail Opts > Default Thumbnail Dims > 220x190


NavXT 

Settings > Navxt > Home Breadcrumb > Home Template (Unlinked) > Replace '%htitle%' with the word Home

User Role Editor 

Set user role permissions for Editor for:
- Nextgen managing albums and galleries and uploading images
- UNSET Yoast SEO bulk edit permission

Yoast SEO 

- Get User Role Editor so that "seo bulk edit" can be disabled for Editors
- Go into the settings: Titles and Metas, and click "Hide" at every checkbox.

Ninja Forms 

Do an export/import to the new site
Make sure notifications are brought over. Might have to do this manually.

Change the wordpress settings so that it's www.website.com and not website.com

Once finished, archive the site on dev.gaslightmedia.com so only super admins can see it.

Retrieved from "https://wiki.gaslightmedia.com/index.php?title=Wordpress_New_Development_Single_Site_Install_Checklist&oldid=1998"