Web Development

Windows and Linux-based Web development: PHP – Node,js – ASP.NET – C#
IIS – Apache / Visual Studio – Atom – Notepad++

Moving a IIS WordPress Site to Amazon EC2 (New Prices!)

2017/10/16
By
Modified: 2017/11/12
RDP-Options

What is Wrong with Home Server? After a RAID drive hiccup on my local Windows 2008 Server, I was more inclined to consider an external hosting options.  And one of my friends already uses Amazon hosting for at least 4 years now.  So I decided to invest some time to explore this option.   What is Covered Here? – Terminology – Pricing – How to  extract your original ADMIN password – How to open a Custom Port on My Amazon Server – How to transfer files using RDP – How to launch an instance with Instance Store – What if I am Using SQL Express and need a regular D/B Backup…

Read more »


Amazon Linux Apache 2.4 reverse proxy with SSL to serve Node.js application

2017/10/09
By
Modified: 2017/10/09
SSL Test Report

Recently, I spent about 36 hours researching, and thinking, and trying, and learning a lot about Apache server before I could crack this one.  After I found a solution, a had a long <VirtualHost> entry.  In this article I present only entries that are required for reverse proxy to work and your Node.js app still to be aware of client IP address. Problem: You want Apache 2.4 to be your front end for your Node.js application.  All the transaction should occur over HTTPS. Your visitors do not have to specify a post number in URL. I do not cover here: – how to install and configure Node.js; – how to get a…

Read more »

SQL Error 80004005 – “Specified SQL server not found” – Solved

2017/10/08
By
Modified: 2017/09/16
SQL CFG Manager - Enable TCPIP

  Environment ASP or ASP.NET site is running on IIS 7.5. SQL Server 2008 R2 Express (10.50.1600.1) running on Windows 2008 Server R2 (W2K8 R2) x64.     Problem You will see one of two errors depending on whether you dealing with ASP or ASP.NET sites. On ASP.NET sites you will see  “Server Error – Error: 26 – Error Locating Server/Instance Specified” Server Error in '/YourApps' Application. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26…

Read more »

Add User Register Date Column in WordPress 3.X and 4.X

2017/10/04
By
Modified: 2017/09/16
WP-Users-with-Date-Column

This solution was last tested on WordPress 4.1.1 in March 2015.   This solution was tested on WordPress 3.1 running on IIS7 and IIS 7.5.  It will work on WordPress 3.1.1, on 3.2.1, and on 3.5.1.    This solution was just tested on WordPress 3.8.1 and works very well. This solution adds a new column to your admin user page, and makes it sortable (optional).   Here are the steps. -01- Find wp-admin\includes\class-wp-users-list-table.php and make a backup copy of the file. Call it class-wp-users-list-tableORIG.php.   -02- Open wp-admin\includes\class-wp-users-list-table.php in your favorite editor.   -03- Find line function get_columns() {   -04- Add a new line of code ‘user_registered’ => __(‘Date’), after…

Read more »

MH Magazine vs. Hueman – what I did not find in manuals

2017/09/25
By
Modified: 2017/09/28
MH Magazine Widget Titles 8 layouts

Server crash in September 2017 prompted a fury of activity, and WordPress upgrade was on the top of the list.  My site got frozen in time because new upgraded versions on free Magazine Basic lost so much functionality, that I preferred to keep old version rather than loose features. Top contenders as new theme candidates were MH Magazine and, a few days later, Hueman by Press Customizr.  I spend about 10-12 very intense hours (about a week in calendar days) in exploring features and interface of each of these two themes and Hueman began to win the competition.  The main reason was that Press Customizr included so much more in a free…

Read more »

How to Convert Julian Date to Gregorian in MS SQL

2017/09/20
By
Modified: 2017/09/16
SQL - Convert JUL to GREG

Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and date portions separately and them add them together and use CONVERT function to get any date format that you require. Here is a script that shows the conversion process step-by-step. SELECT -- Limit output for 9 rows TOP 9 -- 00 Julian date - 91244 FAEFTB, -- 01 Greg year - 1991 cast(left(CAST(FAEFTB as decimal)+1900000, 4) as char(4)) AS GREGYEAR, --…

Read more »

How to Work with MySQL – Basic Tasks

2017/09/16
By
Modified: 2017/09/10
How to Work with MySQL – Basic Tasks

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…

Read more »

Histiry of This Site – DomainWebCenter.com

2017/09/15
By
Modified: 2017/10/13
Site History - SunWebCenter

Welcome! This is not a typical article for reading. This is a log of important events in site development and growth.   2017 Oct 12 Thu First attempt was made today to transition to a new stable server with PHP7, latest MySQL, latest WP version and a brand-new theme. This transition is done under pressure from many directions: – old server finally died one day before replacement unit arrives; – latest D/B backup is available but too risky to apply in PROD environment; – an issue with Contact the Editor form was fixed here yesterday here – we are OK to go; Apologies, one more time, for loss of some small…

Read more »

Node.js -understanding callback when you have to wait

2017/09/12
By
Modified: 2017/09/10
Node.js -understanding callback when you have to wait

This post demonstrates: – how to write a callback function so that results from your database are returned by the time you are ready to render; – how to use multi-field LIKE syntax in a SELECT statement. The most important thing to understand in Node.js is a callback mechanism and its purpose.  It is all fine and dandy, when you just type something for the training session, or copying code from an Internet example, but things are different, when you need to write you own function that must rely on a callback function.  Here I will show no-blocking code that would process POST request, call for MySQL to execute a SELECT query and…

Read more »

PHP chokes server with TEMP files – Updated and Solved

2017/08/11
By
Modified: 2017/07/22
FastCGI Settings

I am running PHP on IIS 7.5.   This is a Windows 2012 Server.  Fresh clean install every time. The only way to access and delete these TEMP files are by using  a command prompt.  And this deletion procedure will run for several DAYS . . .   The Problem The story goes like this.  Fresh new instance of a Windows 2012 Server is great.  It runs fast and smooth.  But after 5 or 6 months MySQL service having hard times to start up.  And a little later – couldn’t start at all.  The only way I can make it run is to start it from a command prompt.  And finally the whole server just slows…

Read more »