Tag: mysql

OAMP – Apache using FastCGI Process Manager on OpenBSD

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…

Read More »

Manual mysql_secure_installation on QNAP

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.

Read More »

Solve a “Submit For Review” issue on WordPress

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…

Read More »

Manually change WordPress’ home and siteurl in MySQL

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’ home…

Read More »

Configure SOGo to use MySQL socket

When connecting SOGo with MySQL, you may either use a remote or a local server. To use a remote server, you’ll configure SOGo with such directives: SOGoProfileURL = “mysql://sogouser:sogopass@mysqlhost:3306/sogodbname/sogo_user_profile”; To use a local MySQL server, you will need to access the mysql.socket file. And when it is secured with chroot&friends, the mysql.sock may not be where SOGo expects it. I…

Read More »