Drupal PDOException: SQLSTATE[HY000] [1045] Access denied for user

Published on Author JFLeave a comment

You might get this error and you’ve lost your mind trying to understand why you updated the password, logged into MySQL successfully from the command line, but still can’t get Drupal to talk to the db? PDOException: SQLSTATE[HY000] [1045] Access denied for user ‘drupal_user’@’127.0.0.1’ (using password: YES) in lock_may_be_available() (line 167 of /var/www/html/website.com/includes/lock.inc). The clue is probably right here beneath your… Continue reading Drupal PDOException: SQLSTATE[HY000] [1045] Access denied for user

Re-charging a Fujitsu AOU18RLQ Mini-split

Published on Author JF46 Comments

WARNING DISCLAIMER! This post is about a DIY configuration of an AC system that is intended for educational purposes only. Any liability is on you. The methods described herein can not only damage the environment by releasing dangerous gasses, cause catastrophic damage to you by coming into contact with these gasses which can just about… Continue reading Re-charging a Fujitsu AOU18RLQ Mini-split

Windows 10 Enterprise N Feature Pack with Media Player

Published on Author JFLeave a comment

Cannot find the right Media Pack installer for Windows 10? Look no further. You probably tried installing this one (KB3099229_x64.msu): KB3099229  Media Feature Pack for Windows 10 N and Windows 10 KN editions (November 2015) It didn’t work even though it does work from some people prior to April 2017. You now need to install… Continue reading Windows 10 Enterprise N Feature Pack with Media Player

How to connect to Acquia using SSH on Windows

Published on Author JFLeave a comment

  Overview This is one method to create a private/public key pair to connect to Acquia via SSH (either console or SFTP). It is a three step process for Windows only using Putty .70 and Puttygen that comes with it (you can try other versions, of course): Ignore any instructions from Acquia – they don’t… Continue reading How to connect to Acquia using SSH on Windows

How to exclude yum kernel updates in CentOS

Published on Author JFLeave a comment

CentOS, unlike some other distros, will automatically update the kernel when you yum -y update. In other places you have googled you will find that people have tried adding the following to yum.conf: exclude=kernel* or exclude=kernel/* This seems to mysteriously work from some people, but not for others. Below is what worked for me. To… Continue reading How to exclude yum kernel updates in CentOS

Website Performance best practices by Google

Published on Author JF1 Comment

Some pretty important stuff to consider best practice in today’s world: As a reminder, speed is a critical metric for SEO these days. https://developers.google.com/speed/docs/insights/rules Here’s the page speed tool: https://developers.google.com/speed/pagespeed/insights/ Example: https://developers.google.com/speed/pagespeed/insights/?url=http%3A%2F%2Fwww.processio.com%2F Kinda cool that it will minify a bunch of files (including images) that you can download.

Apache 2.4 Config for Drupal 7

Published on Author JFLeave a comment

Here are some configs to hopefully make your life easier setting up a brand new server. Specs: Ubuntu 16 Xenial LTS Apache 2.4.18 PHP 5.6.3 After default Apache install make sure to add these modules a2enmod rewrite a2enmod headers Host Conf file DocumentRoot “/var/www/sitename/siteroot” ServerName www.yoursitename.com <Directory “/var/www/sitename/siteroot”> allow from all [allows .htaccess to be used]… Continue reading Apache 2.4 Config for Drupal 7

How to install mysql 5.5 or 5.6 on ubuntu 16.04 xenial

Published on Author JF10 Comments

Installing MySQL 5.5/6 on Ubuntu 16.06 You might be hosting your site on something like Acquia and they have recently upgraded to Ubuntu 16 Xenial. However, you (as an awesome developer) still want to duplicate the environment as much as possible so you want to configure a local or staging server using Ubuntu, etc. Here’s… Continue reading How to install mysql 5.5 or 5.6 on ubuntu 16.04 xenial

Remove all traces of MySQL 5.x on Ubuntu

Published on Author JFLeave a comment

Originally from here, I cleaned it up a bit as an easy reference for me. This works on 14 and 16. sudo service mysql stop #or mysqld sudo apt-get remove –purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo deluser mysql sudo rm -rf /var/lib/mysql sudo apt-get purge mysql-server-core-5.5 (replace with your version… Continue reading Remove all traces of MySQL 5.x on Ubuntu