Generate csr and install ssl certificate through shell prompt
Web Hosting Tutorials, Cpanel Hosting January 30th, 2007Generate csr through shell on cpanel server using following command
root@server1[/]# /scripts/gencsr
Type the information as per script requested. It will create hostingcomments.com.csr file under directory /usr/share/ssl/cert also create hostingcomments.com.key file under directory /usr/share/ssl/private
* Check following steps to install ssl certificate.
1) Go to directory /usr/share/ssl/certs
root@server1[/]# cd /usr/share/ssl/certs
Create .crt file and paste ssl certificate into .crt file as per below
root@server1 [/usr/share/ssl/certs]# vi hostingcomments.com.crt
paste ssl certificate and save the file.
2) Add hostingcomments.com.cabundle file under directory /usr/share/ssl/certs
root@server1 [/usr/share/ssl/certs]# vi hostingcomments.com.cabundle
paste .cabundle cert provided by client and save the file.
cabundle certificate not provided by client nt then skip the above step.
3) Go to directory /usr/share/ssl/private and check .key file is already present for domain name.
4) Now you have to add ssl virtual host entry in httpd.conf.
Sample ssl virtual host entry is as per below. You have to replace domain name and dedicated as per your domain name and ip.
<IfDefine SSL>
<VirtualHost 165.75.54.25:443>
ServerAlias hostingcomments.com
ServerAdmin webmaster@hostingcomments.com
DocumentRoot /home/username/public_html
BytesLog domlogs/.com-bytes_log
ServerName hostingcomments.com
User username
Group username
CustomLog /usr/local/apache/domlogs/hostingcomments.com combined
ScriptAlias /cgi-bin/ /home/username/public_html/cgi-bin/
SSLEnable
SSLCertificateFile /usr/share/ssl/certs/hostingcomments.com.crt
SSLCertificateKeyFile /usr/share/ssl/private/hostingcomments.com.key
SSLCACertificateFile /usr/share/ssl/certs/hostingcomments.com.cabundle
SSLLogFile /usr/local/apache/domlogs/hostingcomments.com-ssl_data_log
SetEnvIf User-Agent “.*MSIE.*” nokeepalive ssl-unclean-shutdown
</VirtualHost>
</IfDefine>
5) If cabundle is not given by client then remove following line from your ssl virtual host entry
SSLCACertificateFile /usr/share/ssl/certs/hostingcomments.com.cabundle
6) Save httpd.conf file and restart the httpd service.
7) SSL certificate is installed and you are able to access domain with https://
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT * FROM wp_comments WHERE comment_post_ID = '89' AND comment_approved = '1' ORDER BY comment_date
