Spyderserve Web Development

Category: Hosting and Databases

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 […]

Setting Up a Public/Private Key Pair on Centos

First you have to create the public and private key pair files. Open the Terminal application Execute the following command ssh-keygen -t rsa Go through the questions and answer.  Most of the time the defaults are fine. This will generate two files in your user’s ~/.ssh/ directory (if you followed the defaults).  The first one, […]

Spyderserve  2225 Bemiss Road Suite D Valdosta, Georgia 31602 United States