Creating access control into Lazarus + Firebird applications

This is a getting started article (written in Portuguese) from a series of articles related to Firebird and Lazarus
In the first part it’s explained how to install Lazarus and Firebird/Flamerobin on Ubuntu

I have been implementing the access control on my applications. It is a simple model, I have been “improving” since I started the program and always adapting to the new reality that has been presented. Not the last word on programming, but I believe it can be a good start for those who want to implement something from scratch.

Firebird internals : Asyncronous System Trap

What is Asyncronous System Trap ? : This is similar to Unixes signal’s or OS interrupts.
Technically this is callbacks from Lock Manager into the Engine called when
somebody acquires lock at level not compatible with current level. In this case
all processes who owns the lock receives notification and should take appropriate
action to release lock (immediately or deferred-ASAP).

The main trick with AST’s handlers is that AST is send asynchronously and
handler must take care to work correctly. Since v2.5 all ATS handlers runs in
separate thread. Before v2.5 it works using signals on Unixes and threads on
Windows.

PS the issue with old glibc and FB 2.5 is that since v2.5 we abandoned usage of old
System V semaphores (do you remember “semaphores are exhausted” error ? now
you can forget it completely) and start to use pthread mutexes. And old glibc have a
bugs in pthread mutex implementation.

Extracting glibc info in #Linux to see if is greater or equal with 2.7

Related to previous announcement:If you are on ubuntu and your ubuntu release is greater than Hardy (8.04) you are safe , on other distributions you can determine this way the glibc version
You must run the /lib/libc.so.6 and it will return the glibc version
in the first row.
In ubuntu or any debian based distro

/lib/libc.so.6 | head -n 1
GNU C Library (Ubuntu EGLIBC 2.13-0ubuntu1) stable release version
2.13, by Roland McGrath et al.

in this case glibc is 2.13
and is builded from eglibc sources
https://launchpad.net/ubuntu/+source/eglibc

another option is dpkg interrogation

dpkg -l libc6

on rpm based distros

rpm -q glibc

ps: other alternative ways

1 21 22 23 24 25 78