Category: General

Enable SSL in PrestaShop 1.7

To enable SSL in PrestaShop 1.7, go to

Admin > Shop Parameters > General

On this page, you need to set YES for Enable SSL. After saving, you can enable “Enable SSL on all pages”.

PrestaShop SSL

Using phpMyAdmin/MySQL

You can run following SQL query to enable SSL.

select * from ps_configuration where name="PS_SSL_ENABLED";
select * from ps_configuration where name="PS_SSL_ENABLED_EVERYWHERE";
update ps_configuration set value="1" where name="PS_SSL_ENABLED";
update ps_configuration set value="1" where name="PS_SSL_ENABLED_EVERYWHERE";

See PrestaShop

October 31, 2020

Bots
- How to block Bad Bots (User Agents) using .htaccess
- How to block bad bots User-Agents in Nginx
October 27, 2020
Mechanical Keyboard
Here are some Tenkeyless Mechanical keyboards available in India.

https://www.thecosmicbyte.com – they have keyboard switches, have keyboard similar to Reddragon.

https://mdcomputers.in

https://www.amazon.in

https://www.flipkart.com

https://meckeys.com/category/keyboard/80-keyboard/page/1

https://www.genesispc.in/products/royal-kludge-rk-r87-black

https://keychron.in/product/gateron-switch-set

Switch Keys in Ubuntu

My escape key stopped working. I don’t use the caps lock key much, so I changed capslock to function as escape key.
```
sudo vi /etc/default/keyboard
```
Find the line that starts with XKBOPTIONS and modify it to include caps:escape:
```
XKBOPTIONS="caps:escape"
```
Reboot the computer.
October 24, 2020
Fetch as Google with curl
A hacked web site got hacked. The site listed on google SERP with text “There are essentially two prescribed drugs which viagra 200mg”.

When you visit the site in the browser and check the source, you see everything normal, no text related to Viagra. This is because malware on the site only shows that content to Google bot.

To see the malware inserted text, you can use Fetch as Google tool in your Google webmaster center. But before using the fetch as Google tool, you need to verify ownership of the site.

Another way is to change your browsers user agent to same as Google bot
```
Googlebot/2.1 (+http://www.google.com/bot.html)
```
You can see list of user agents used by google at

https://support.google.com/webmasters/answer/1061943?hl=en

To Fetch as site as google using curl, run
```
curl --user-agent "Googlebot/2.1 (+http://www.google.com/bot.html)" https://your-site-here.extn
```
Back to curl
September 24, 2020
G Suite TLS Negotiation failed, the certificate doesn’t match the host
When sending email from G Suite email account, email bounce with following error message
```
TLS Negotiation failed, the certificate doesn't match the host
```
This is because the G Suite Gmail account have Route configured and the SMTP server configured have no valid SSL.

Solution

You can install a valid SSL on your mail server or disable the TLS checking. To disable TLS checking, go to
```
G Suite Admin > Apps > G Suite > Gmail > Hosts
```
On this page, you will see your routes (remote SMTP servers). Edit the one you are using

You need to disable the check box “Require mail to be transmitted via a secure (TLS) connection (Recommended)”.

It is better get SSL fixed. If your mail server use a differnt SSL, just change server name in that page.
September 21, 2020
Download
- http://www.freedownloadmanager.org – Open source download manager
- http://www.jdownloader.org – open source download manager written in java
- Download a package using apt on Debian/Ubuntu
- https://www.converto.io/ – youtube video downloader
Torrent

https://thepiratebay.org/ – One of the oldest torrent site.
September 8, 2020
Bug Tracking Software
Here is list of software that can be used for bug tracking or issue tracking.
- http://www.redmine.org/ RudyOnRails, lot of features. good one
- http://www.bugzilla.org Perl, bug tracking only. Very popular, large projects use it.
- http://trac.edgewall.org/ Python, popular, i see many medium size project use them.
- http://www.mantisbt.org/ PHP MySQL
- http://flyspray.org/
- http://webissues.mimec.org/ PHP MySQL
- http://etraxis.sourceforge.net/ PHP MySQL
See Scripts
August 30, 2020
Search Engines

Here are some search engines that you can use as an alternative for Google.

https://metager.org
https://duckduckgo.com

August 10, 2020
CORS

Enable CORS in Apache
Enable CORS in Nginx

August 1, 2020
whmcs

WHMCS is popular billing/customer management software for web hosting providers. You can purchase it from

https://www.whmcs.com

Another alternative is ClientExec

https://www.clientexec.com

July 24, 2020
rDNS / Reverse DNS / PTR Record
Reverse DNS record or PTR Record is generally used by mail servers. Usually, the server’s hostname (FQDN – Fully Qualified Domain Name) is used as a reverse DNS record.
See DNS
June 22, 2020
Joomla
Joomla is a content Management system written in PHP and MySQL. It is Open Source and free to use.

Database login and other settings are stored in file configuration.php.

Enable Debug

In configuration.php file, find
```
public $error_reporting = 'none';
```
Replace with
```
public $error_reporting = 'development';
```
To find Joomla version
```
grep 'public $RELEASE' libraries/cms/version/version.php
```
Joomla admin URL
```
https://your-domain/administrator/
```
June 19, 2020

Category: General

Using phpMyAdmin/MySQL

Switch Keys in Ubuntu

Torrent