I am a contributor to the Drupal community and a Drupal engineer for SPI. This is a bare-bones Drupal 8 site I set up to record things I learn. Many times, I’ve had to learn something a second time because I didn’t keep notes the first time. I hope to fix that by keeping notes here. I also hope the notes help you, whether you’re learning something for the first, the second, or the hundredth time.
I am used to flushing memcached by connecting with telnet and issuing the flush_all command. Today I found that the telnet command has been removed from macOS High Sierra. Netcat works just as well for sending text over a TCP connection and is available on High Sierra.
Found an article that provides essential information not found in PECL installation messages: https://arcadian83.livejournal.com/16386.html. The key is that the php.ini path has to be added to both PEAR and PECL.
This afternoon, most of the sites running on my computer started responding with “500 Internal Server Error”. The Apache error log showed the following error:
[Tue Jul 19 16:17:01.418642 2016] [core:alert] [pid 79692] [client 127.0.0.1:53041] /Users/darren/.htaccess: <IfModule not allowed here
composer require is the command to add packages to a composer project. Dreamhost shared hosting kills this command for using too much memory. To install new packages on Dreamhost shared hosting,
The Bitcoin block chain had reached 85 gigabytes last week, so it was no longer practical to run a full node client on my laptop. A full node client verifies a transaction by checking earlier transactions all the way back to when the network first issued the funds used in the current transaction. To do this, it first has to download every block of transactions in the chain. The alternative is a client that uses simplified payment verification (SPV).
Bright House Networks does not support IPv6, so I use the the Hurricane Electric IPv6 Tunnel Broker service to reach the IPv6 Internet. Last Wednesday night, Netflix started showing an error message when I tried to play movies: “You seem to be using an unblocker or proxy. Please turn off any of these services and try again.” Netflix customer support first said my access was blocked because my IPv6 address came from a different state. I switched to a tunnel in my own state, but Netflix still blocked me.
I’ve been able to connect to an Acquia database before from MySQL Workbench 6.2.4 on OS X, but today I was getting an error:
Could not connect the SSH Tunnel
Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
To see the logs, go to Help » Show Log File. The relevant log file is wb.log, and the error message is
SSHException: Incompatible ssh peer (no acceptable kex algorithm)
I selected Help » Check for Updates, and was told,
I was trying to get a list of highest numbered records from an SQL database table. My first attempt used a GROUP BY and an aggregate function:
SELECT * FROM field_data GROUP BY revision_id HAVING delta = MAX(delta)
This means to only return records which contain the highest delta values their revision IDs. I know SELECT statements are only supposed to have fields which appear in the GROUP BY clause, but I tried it just in case. The HAVING filter had no effect. My second attempt used a join: