1)
download private key file from cpanel ----- ssl/STL ---- private key---
click edit, copy encoded part into a new file. Save to /bin/www/private.key
2)
download certificate file, from godaddy, my product, SSL,
click download button, choose other type.
Only 1 file xxxx.crt is the one we need, copy to /bin/www/public.cert
you can copy past encoded certificate from cpanel---ssl , click Certificate(CRT), click edit,
copy encoded certificate
3)
/bin/www file add https code.
// readFileSync function must use __dirname get current directory
// require use ./ refer to current directory.
==================== redirect http:// to https:// ===============================
Because of domain transparentgov.net bind to IP, by default, user will get http://transparentgov.net
We must redirect all http://.... to https://..........
Other urls are automatically without this .htaccess file.
http://agv1.transparentgov.net will forward to https://transparentgov.net:3000 at google domain.
http://ms1.transparentgov.net will forward to https://transparentgov.net/mapserver1/viewer at google domain
pdfbay.org domain forward to https://transparentgov.net/glassgov1
so only .htaccess under cleargov1 need to update redirect.
cpanel ----- file manager ------
public_html/cleargov1/ folder,
setting (top right corner) ---- show hidden files
htaccess file must be at the folder you want redirect really happen !
Not public_html ( root ) folder.
From time to time we are asked how you can force your website visitors to view your website over https. For example, if a visitor access http://domain.com, you can force them to https://domain.com so that they are always using the SSL certificate.
The following instructions gives you code to add to an .htaccess file. If your .htaccess file has existing code, then you shoud place the following code examples above the existing code of your .htaccess file so that the newly added code is executed first.
How to force your visitors to use your Shared SSL Certificate
Next to http://(www.)? choose the domain name you are working with
Next to redirects to, enter your website's url using the Shared SSL Certificate
We recommend having Redirect with or without www. selected, so that the user will be forced to use SSL whether they use domain.com or www.domain.com
Ensure Wild Card Redirect is selected
Click Add
When testing, we were redirecting example.com to https://secure21.webhostinghub.com/~whhsup5/
You can see below how the rewrite was setup before we clicked "Add"
When you save this redirect, cPanel actually sets up the redirect by editing your .htaccess file. You don't need to do anything further from here (other than test). If you were actually looking for the .htaccess code to perform this type of redirect, cPanel added the following code to the .htaccess file:
How to force your visitors to use your Dedicated SSL certificate
If you try to setup a Dedicated SSL redirect using the same steps above, cPanel will fail with an error message, similar to:
Redirecting to https://www.example.com/ will cause a redirection loop because 'http://example.com/'
which is located at /home/whhsup5/public_html/
is above 'https://www.example.com/'
which is located at /home/whhsup5/public_html/
The following changes to the .htaccess file will require that you make use of the edit options available within the cPanel. You will need to edit the .htaccess file to force the re-direct. Depending on your situation, you may need to re-direct all website traffic, only a specific domain, or a folder to use HTTPS.
Forcing a specific domain to use HTTPS
To force a specific domain to use HTTPS, use the following lines of code in the .htaccess file in your website's root folder:
In the .htaccess code above, if abcd.com website is accessed, it will re-direct to https://xyz.com You will need to replace abcd\.com with the domain name you're forcing to https and also replace www.xyz.comwith the domain name to where the website traffic will be re-directed. Here's an example:
In the example above, any one typing in http://test-site.com will automatically be re-directed to https://some-website.com.
Forcing all website traffic to use HTTPS
In order to force all web traffic to use HTTPS, use the following code in your .htaccess file. If you are hosting multiple websites on your account, it is possible to have an .htaccess file for each website. Make sure that you are editing the .htaccess file that is in the root folder where you want the re-direct to occur.
Make sure you change the folder reference to the actual folder name. Then be sure to replace www.yourdomain.com/folder with your actual domain name and folder you want to force the SSL on.
this will use time stamp create a dump file, then zip it to CAB file.
use 7-zip to extract it.
windows task scheduler, to schedule this batch file.
---------------------------------------------
@ECHO OFF
set TIMESTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%
REM Export all databases into file C:\backup\mysql\databases.[year][month][day].sql
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" --all-databases --result-file="C:\backup\mysql\databases.%TIMESTAMP%.sql" --user=root --password=aaaa1111
REM Change working directory to the location of the DB dump file.
C:
CD C:\backup\mysql
REM Compress DB dump file into CAB file (use "EXPAND file.cab" to decompress).
MAKECAB "databases.%TIMESTAMP%.sql" "databases.%TIMESTAMP%.sql.cab"
REM Delete uncompressed DB dump file.
DEL /q /f "databases.%TIMESTAMP%.sql"
