Magento how to check whether SSL redirection is enabled using MySQL command line and disable it if needed

To check whether SSL redirection is enabled or disabled in Magento using MySQL command line, you can execute the following SQL query:

SELECT * FROM core_config_data WHERE path LIKE '%web/secure/use_rewrites%';

If the value of the value column is set to 1, then SSL redirection is enabled.… Read the rest

SSL certificates used by the main services on a cPanel server

Paths:

/var/cpanel/ssl/apache_tls/`hostname`/certificates
/var/cpanel/ssl/cpanel/mycpanel.pem
/var/cpanel/ssl/exim/myexim.crt
/var/cpanel/ssl/dovecot/mydovecot.crt
/var/cpanel/ssl/ftp/myftpd-rsa-key.pem
/var/cpanel/ssl/mail_apns/cert.pem

Here is a brief explanation of each path:

/var/cpanel/ssl/apache_tls/hostname/certificates: This is the directory where the SSL certificates for the Apache web server are stored. The hostname folder contains the certificate files for the specific hostname used for the cPanel account.

Read the rest

How to generate Self-Signed SSL on cPanel server using command line

Run and put your domain:

read -p "Domain: " domain; username=`/scripts/whoowns $domain`; email=`grep @ /var/cpanel/users/$username |tail -n1 |cut -d '=' -f2|sed -e 's/@/\%40/'`; whmapi1 generatessl domains=$domain countryName=US stateOrProvinceName=Texas localityName=Houston organizationName="The Justice League of GG" emailAddress=$email pass=`openssl rand -base64 15` keysize=2048 skip_certificate=0

Now use WHM to install it

Enjoy!… Read the rest

WordPress enable force SSL over wp-config.php

You will need to edit domain name using the following and append it into your wp-config.php file

define('WP_SITEURL', 'https://www.example.com');
define('WP_HOME', 'https://www.example.com');
define('FORCE_SSL_ADMIN', true);
define('FORCE_SSL_LOGIN', true);
if( isset($_SERVER['HTTP_CF_VISITOR']) && strpos($_SERVER['HTTP_CF_VISITOR'], 'https') )
$_SERVER['HTTPS']='on';
Read the rest

How to enable/disable SSL for Prestashop via MySQL command line

Enter your database

mysql your_database;

Check the value

select * from ps_configuration where name like '%SSL_ENABLED%';

To enable

update ps_configuration set value = '1' where name = 'PS_SSL_ENABLED';
update ps_configuration set value = '1' where name = 'PS_SSL_ENABLED_EVERYWHERE';

To disable

update ps_configuration set value = '0' where name = 'PS_SSL_ENABLED';
update ps_configuration set value = '0' where name = 'PS_SSL_ENABLED_EVERYWHERE';

 … Read the rest