Enabling logging for your MySQL queries from the MySQL prompt

Submitted by Druss on Sat, 2016-06-04 01:44

I usually find it a chore to edit the MySQL conf files (as for one, I often have no idea which my.cnf file to edit!) One way to work around this issue, particularly if you want to change a setting temporarily, is to simply enable the change dynamically via the MySQL command prompt. This can be accomplished by modifying "global" variables which can be listed with commands like so:

Aegir: Site backup error "Could not back up sites directory for drupal"

Submitted by Druss on Sat, 2015-12-19 18:08

If you encounter,

Could not back up sites directory for drupal

when trying to back up a site using Aegir, then this is because there are some permission issues with some of the files in the sites directory.

In my case, these files were in the private/temp/ directory. Listing all offending files can be done by the following command:

MongoDB on Linux with pecl "configure: error: Cannot find OpenSSL's libraries"

Submitted by Druss on Sun, 2015-12-06 21:29

Edit: Skip this and scroll down for a proper fix!

Just tried installing MongoDB support for PHP on Kubuntu 15.10 via pecl and ran into the following error message which caused the installation to fail:

configure: error: Cannot find OpenSSL's libraries

While this can probably be fixed using some magickery, in my case, I did not want SSL support on a dev server. I just wanted to get the fucker up and running. To this end, I discovered that the issue was that I was using:

Kubuntu 15.10 / KDE not automounting partitions

Submitted by Druss on Tue, 2015-12-01 19:42

So I upgraded my Linux box to the latest Kubuntu 15.10 (Wily Werewolf!) and it's been an interesting few days ironing out niggles. One of them has been the missing partition manager icon which (IIRC) was present in 14.04 and where I could control which partitions were automounted at login. From the looks of it, there is no easy solution for this like installing a package or some weird Plasma widget. The only solution I was provided on IRC was the following roundabout-borderline-hack:

Missing Skype icon in Kubuntu 15.10 (KDE Plasma 5)

Submitted by Druss on Thu, 2015-11-19 15:13

So if you've just installed or upgraded to the new version of Kubuntu (Wily Werewolf), you will notice that Skype runs fine but does not appear in the system tray as an icon. The workaround to fix this is to install the sni-qt package, but specifically the 32-bit version of the package (as Skype is a 32-bit app). To do this, open a terminal and type:

sudo apt-get install sni-qt:i386

This will also install a dependency. Once this is installed, quit Skype and restart it to find the familiar green check in your system tray.

Changing/customizing MySQL's command prompt

Submitted by Druss on Mon, 2015-10-26 12:10

I wanted to add a timestamp to my MySQL command prompt to keep a track of when the previous command on my screen was executed (my mysql window is open all the time). As per MySQL's docs, this can be done with something like:

mysql>  prompt [\w, \R:\m]> 
PROMPT set to '[\w, \R:\m]> '
[Sun, 12:30]>

(Note that there's a space after the > in the prompt command.)

The other options for the prompt command are:

Tags:

Installing a fresh copy of a program under Wine

Submitted by Druss on Thu, 2015-10-22 00:34

So here I was happy with my installation of program foo.exe under Wine in Linux (Kubuntu if you must know). All of a sudden, the program starts whining a little, wobbling a touch, and generally exhibiting wonky tendencies. While I could have uninstalled it and tried to reinstall it to see if that fixes the problem, there's a neater solution that is only available for Wine users.

Eclipse: Cannot create project content in workspace.

Submitted by Druss on Mon, 2015-09-07 21:48

If you run into the following error while adding a project into Eclipse from existing source using the New Project dialog,

Cannot create project content in workspace.

then you are very likely trying to create a new Eclipse project that contains Eclipse metadata files from a previous Eclipse project created at the same location. The fix for this is to import this pre-existing project into your workspace using the Import, General, Existing Projects into Workspace option.

A journey Without You

Submitted by Druss on Tue, 2015-09-01 00:53

No self-respecting guy will admit to liking soppy girly pop by artists such as Mariah Carey. But it was with some happiness that TIL that a long-"loathed" favorite of mine, Mariah's Without You is actually a rip-off of a 1970 song by Welsh rock group, Badfinger (whose own story is pretty shocking (two of its band members committed suicide)). So I can now openly admit to liking the song :)

Adding a custom (service) menu to KDE's Dolphin (to queue a folder in VLC)

Submitted by Druss on Sat, 2015-08-29 22:07

I was looking for a way to add a custom context (right-click) menu to KDE's Dolphin (in Kubuntu 14.10, Utopic) that (much like in Windows) would allow me to enqueue an entire folder/directory in Videolan. Many of the examples that I looked at were rather sketchy or incomplete. Here's a simple working example that might be of help to someone else out there. You can modify it appropriately to get it working for other applications as well.

Pages

Subscribe to languor.us RSS