Author Archives: juhap

Convert SPSS .SAV file to CSV (for Excel)

Posted on February 8, 2014 by juhap

SPSS alternative, GNU PSPP include a very easy to use tool that can convert the SPSS SAV file to CSV. This can be further read in to excel. Just open the csv file in Excel. If excel does not automatically … Continue reading →

Posted in Misc |

Filezilla GnuTLS error -15: An unexpected TLS packet was received and VsFTP

Posted on December 27, 2013 by juhap

Too-long-don’t-want-to-read–give-me-commands-to-paste-to-my-terminal: sudo /usr/sbin/setsebool -P ftp_home_dir 1 Long(er) story I ran into “interesting” problem on CentOS while trying to setup VsFTP with FTPS. I was using FileZilla to connect to the server. The VsFTPd version that comes with my CentOS version … Continue reading →

Posted in Misc |

Enable debug log in Azure Storage Emulator

Posted on July 29, 2013 by juhap

Azure Storage Emulator has logging capability but this is not enabled by default and it does not seem to be available via user interface. In order to enable the log, Head to the Storage Emulator data directory, which is located … Continue reading →

Posted in Azure |

Ubuntu, disable special effects

Posted on July 28, 2013 by juhap

I installed Ubuntu under Hyper-V and for reason the UI with all the effects is S-L-O-W. Quick steps for disabling the UI effects: Then head to the effects tab and disable those that you want. This does not make the … Continue reading →

Posted in Ubuntu |

Keymapper mappings for using Apple keyboard with Windows

Posted on June 15, 2013 by juhap

I fell in love with the full size Apple keyboard. It is low profile and I really like how it works. Plus it’s pretty affordable (compared to premium keyboards). Unfortunately by default few of the keys are out of place … Continue reading →

Posted in Web development |

Change SQL Server Express authentication mode

Posted on June 15, 2013 by juhap

When you install SQL Server Express you can select the authentication mode. If you want to enable SQL Server authentication mode (username and password) later on, you can use T-SQL to do it:

Posted in Web development |

Digging Liferay article categories from database

Posted on June 14, 2013 by juhap

In order to investigate certain issues I wanted to find out the journal categories directly from database. Below is the select I came up with. This is for MySQL. The string operations on the second line try to extract the … Continue reading →

Posted in Liferay |

Write log from Liferay velocity templates

Posted on June 14, 2013 by juhap

A simple example for writing log entries from Liferay velocity templates

Posted in Liferay |

Visio 2013 and 2016 disable rerouting

Posted on May 27, 2013 by juhap

Drop something to the drawing surface, all other shapes freak out, running away from your new shape which you just wanted to throw in the background. Sounds familiar? If this something you don’t like, then disable connector splitting. Head to … Continue reading →

Posted in Misc |

Disable Tomcat thread pool

Posted on May 2, 2013 by juhap

I recently ran into issues with a third party application that had certain issues with threadlocals. Namely certain parts of the application were using threadlocal to store information, but did not clean up the stored information. This information then caused … Continue reading →

Posted in Misc |