I used to use “Featured Images” in my posts to illustrate the main tag. Now that I changed my theme (namely Twenty Fourteen), those icon-sized images don’t show up well. I decided to simply drop them all so that nothing is displayed by the theme. This is done easily using MySQL:
Once upon a time, there was a way to run PHP with Apache on OpenBSD using the php-*-ap2 package. At that time, OpenBSD shipped with home-patched Apache 1.3 and provided Apache 2.x as a package. Since then, Apache 1.x was dropped from base, replaced with httpd(8) and ports gave the opportunity to run either Apache 1.x or Apache 2.x. This is when PHP packages and Apache 2.x became quite a pain in the ass to use. Thanks to the ports, one could deal with it. But binary PHP packages are not built this way. One way to get PHP and Apache is to use FastCGI. Here’s how to run the OAMP 6.0.
Continue reading “OAMP – Apache using FastCGI Process Manager on OpenBSD”
I have installed the SQL server on my QNAP TS-453mini but couldn’t find the
mysql_secure_installation script. As far as I understood it, it simply changes the root password, disable remote sensible access and deletes the test database. So I decided to run the commands manually inside phpMyAdmin.
Lately, I couldn’t publish any more articles on my WordPress instance. Instead of the “Publish” button, I only got “Submit For Review”. As I upgraded WordPress recently, I thought this might be either a new feature or some permissions that were dropped ; but I just couldn’t find any.
After a few dig&read on the Internet, most of this behavior seemed to reveal a problem with the database. And I recently had a few bunch of crashes on the infrastructure ; thanks to my electric power provider…
In my tidy process, I had to copy WordPress from one host to another, then access it from various URLs so that the production and the development versions were both accessible from the same public IP. To duplicate the data in a fast manner, I dumped the SQL data and tarred the WWW directory. The problem is that WordPress’
siteurl are kept the same between those instances. And since you try to access the administration zone, you’re redirected to the original location… To modify the duplicated instance, you can configure WordPress straight from MySQL.
Here are the directions:
Continue reading “Manually change WordPress’ home and siteurl in MySQL”