Thanassis Bakalidis's Programming and DBA Scratch Pad

All things relative to everyday programming and DBA practices, This blog will not give you the ET staff, just little remindings about how things work. Subjects are relative to databases, programming, Linux, Windows and ... you name it. I used to have a notepad onto which I put down anything I thought I might need again. Hopefully this is going to be as good as the paper with the added value of being able to paste from.

Monday, 16 March 2020

›
Substitution for Microsoft's Calibri and Cambria fonts in LibreOffice I know that there are many people out there who get very disap...
Friday, 8 November 2019

Auto allocation of spice TLS ports requested but spice TLS is disabled in qemu.conf

›
I am not sure why this happens. My best guess is that there is some kind of address or port mangling. So you just a created a VM using libv...
Tuesday, 7 August 2018

How to use the latest PHPOffice/Spreadsheet with CakePHP 2.x

›
Preface Using the latest PHPOffice PhpSpreadsheet in a CakePHP3 application is relatively easy, A simple composer command like co...
Friday, 30 March 2018

JPA Calling a MySQL stored function

›
I have a stored function called getNextCode() that requires a string parameter and returns a string. I wish to call this from my JPA enabl...
Wednesday, 28 March 2018

Ubuntu: Setting up an MQTT Server and connecting via SSL

›
Foreward This has been a very frustrating story as I was asked to setup an MQTT server that would support -- every IT Manager's pri...
Tuesday, 22 November 2016

Linux: Verify a burned CD/DVD with the image file used for burning

›
So I just burned a CD sometime ago and I am not sure if it still works. A quick and easy way to test it's against the original ISO woul...
Friday, 3 June 2016

Using a raspberry pi (or any Debian based computer) to set up an open VPN server

›
Why There are many howto's explaining the set-up of an OpenVPN server. The majority of what I have seen, provide instructions about se...
Friday, 26 February 2016

Java Swing GUI's default and cancel buttons

›
None of these are mine. I just copied and re-factored them from here and here in stackoverflow.com. The code comes from a login form...
Saturday, 13 June 2015

JPA Queries containing count

›
A simple howto and reference regarding the usage of the count() function in your JPA code. First thing is correct syntax. Counting the ...
Friday, 10 April 2015

IP tables forward traffic between ethernet and wi-fi

›
Recently, I was asked to create a Linux based WI-fi access point using the new Raspberry Pi 2 Model B. This project had a .. happy ending, ...
Wednesday, 18 March 2015

MySQL Cross database foregin keys

›
Here is a small query to display all foreign keys across different databases. May come in very handy when deciding which database to restor...
Thursday, 12 March 2015

Last modified date/time for CakePHP projects

›
What is the last modification date of a CakePHP project? To answer that you would probably have to ask what is the latest date and time tha...
Saturday, 14 February 2015

Java: Read String from console

›
Once again, I was out there trying to find the neatest solution for reading a string from the IDE console. It turns out that the shortest ...
Wednesday, 15 October 2014

Listbox mnipulation with jQuery

›
This is my easy to paste reference code for list-box manipulation using jQuery. By the way, the HTML <input "type"="selec...
Saturday, 13 September 2014

GNOME3: How to enable desktop icons and right click menu

›
This is the third time I am looking this up, so I am making a quick howto note here. So in order to enable desktop icons on a newly inst...
Monday, 14 July 2014

CakePHP Find out the link that brough us to the current page

›
Most web applications today have some kind of menu build with anchor tags. The problem that the following script -- courtesy of my friend A...
Sunday, 18 May 2014

How to remove a particular host key from SSH's ./ssh/known_hosts file

›
I will leave the sed solution for the real gurus. As far as I am concerned the easy way to get the job down is use the ssh-keygen -R your...
Friday, 4 April 2014

Setting up Environment variables before Apache starts

›
That was the third time I had to look this up, so I am putting it down for reference. On Red Hat machines, apachectl sources /etc/sysc...
Thursday, 3 April 2014

Linux (EL6) Required packages for installing the 64 bit Oracle 12c Client

›
The Oracle documentation has a list of the packages required in order to install the database client software for Enterprise Linux 6. S...
Thursday, 20 March 2014

CakePHP-2 and AJAX The dependent list boxes problem (remake)

›
Forward Back in 2010, I had written a post regarding the case of dependent list boxes in a CakePHP view. Back at those days CakePHP was a...
2 comments:
›
Home
View web version

About Me

My photo
Athanassios Bakalidis
Komotini, Rodopi, Greece
A programmer by hobby and profession, My interests include WEB programming using JSP's, JSF and PHP. Since my student days I have grown to like "Borland's" compilers and IDEs so desktop programming with Delphi and C++ Builder is among my interests. (Now, I look forward to the day I will start a project with lazarous) My work duties involved programming with SAP's built in ABAP language, so you may find some little things about SAP programming here. My favourite OS is Linux (I used openSUSE and SLES both at home and at work, but since 2008 I started working with two Red Hat clones, CentOS and Oracle Enterprise Linux while I changed my personal computers OS to fedora). I am α strong supporter of open source software. I am also interested in Databases and database programming. My main database is (was) Oracle, though I try to keep in touch with MySQL as well
View my complete profile
Powered by Blogger.