Spyderserve Web Development

Archives: Knowledge Articles

Convert p7b Certificate File to pem

Converting Your Existing Certificate To PEM Format If your certificate is not in PEM format, you can convert it to the PEM format using the following OpenSSL commands: Convert DER to PEM openssl x509 -inform der -in certificate.cer -out certificate.pem Convert P7B to PEM openssl pkcs7 -print_certs -in certificate.p7b -out certificate.pem Convert PFX to PEM […]

Install Composer into Project on Centos [Quick Reference]

Navigate to project directory curl -sS https://getcomposer.org/installer | php Create a file in same directory named composer.json Then add the required packages to the json file: (example) { “require”: { “psr/log”: “1.0.0”, “phpunit/php-timer”: “1.0.7”, “symfony/event-dispatcher”: “3.0.0” } } Once the json file has been edited and saved, execute the following: php composer.phar install This will download […]

Removing SSLv3 Support From Apache

To disable SSLv3 support for Apache you need to look for the ssl configuration file (in Centos it is at /etc/httpd/conf.d/ssl.conf) and modify the SSLProtocol line: SSLProtocol all -SSLv2 -SSLv3 You can also add the line after SSLEngine On in a Virtual Host file. Just be aware that old versions of Internet Explorer (<=6) do […]

Installing MariaDB on Centos 7

Step 1: Add the MariaDB repo to your system.  The script below must be run as root. curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash Step 2: Install MariaDB server and client sudo yum install MariaDB-server MariaDB-client -y Step 3: Start the initial MariaDB service sudo systemctl start mariadb.service Step 4: Set the MariaDB service to auto-start […]

MySQL Error: Unknown collation: ‘utf8mb4_unicode_520_ci’

Currently, it seems anyway, a lot of the underlining technologies that I use everyday to build websites (ie, PHP and MySQL) are quickly upgrading and making big changes.  These changes are exciting and I look forward to utilizing them as soon as I can but sometimes it is hard to just “flip the switch” on […]

Spyderserve  PO Box 5831 Valdosta, Georgia 31603 United States