Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

Howto Perl: Crypt::CBC module with the blowfish encryption cipher

by Jason L Froebe on April 9, 2013, no comments

I came up with the following example a few years back. Crypt::CBC is quite easy to use but can be confusing to new users of it. I prefer to use the subroutines encrypt_hex and decrypt as the encoded string is hexidecimal not in binary format. This allows me to work with it as if it [...]

Share Button

GIMP Magazine Issue 3 has been released!

by Jason L Froebe on March 8, 2013, no comments

  ISSUE 3 HIGHLIGHTS We are featuring the cover story on Andrea Zanovello, a highly talented photographer with some stunning shots to gaze at.  In an exclusive interview Andrea tells us all about his photography and what he hopes for in the next version of GIMP We have the first ever Issue of “The Hunt [...]

Share Button

HOWTO: Building Perl module DBD::Sybase 1.14 on Windows (32bit or 64bit) with ActiveState Perl 5.16, Microsoft Visual Studio and Sybase OpenClient 15.7

by Jason L Froebe on February 20, 2013, 2 comments

Compiling the DBD::Sybase Perl module really requires Microsoft Visual C++ 2005 or higher. To get started open the “Visual Studio 2005 Command Prompt”. You will need to fix the Makefile.PL file: if ( $^O eq ‘MSWin32′ ) { $lib_string = “-L$SYBASE/lib -llibct.lib -llibcs.lib -llibtcl.lib -llibcomn.lib -llibintl.lib -llibblk.lib $attr{EXTRA_LIBS} -lm”; to if ( $^O eq ‘MSWin32′ [...]

Share Button

HowTo: Getting the Spice client up and working on Ubuntu 12.10 with libvirt / virt-manager

by Jason L Froebe on February 10, 2013, no comments

Unfortunately, when you install the Spice client on Ubuntu 12.x, it doesn’t include everything you need to get it to work sudo apt-get update sudo apt-get install spice-client-gtk qemu-kvm-spice python-spice-client-gtk If you’re up to date on your 12.10 patches, you shouldn’t need to modify the libvirt-qemu file for Apparmor but if you have troubles, add [...]

Share Button

Optimizing the Firefox (SQLite databases)

by Jason L Froebe on January 27, 2013, no comments

Most people that want to speed up Firefox know about the various settings in about:config but many forget that Firefox uses SQLite databases that can become cluttered. In your home directory ($HOME on *nix/Mac and %APPDIR% on Windows), run sqlite3 with vacuum, reindex and analyze on eche of the *.sqlite databases. Don’t have sqlite3? No [...]

Share Button
Facebook login by WP-FB-AutoConnect