Realtime is not all it is cracked up to be. In particular Asterisk and Realtime is bar none the most aggressively hostile piece of software towards Firebird databases which is what I use in everything (9 years and counting). So far I have counted 5 reserved words I have tried to deal with.
I got very lucky modifying the source with voicemail to make it use the column name ‘secret’ instead of ‘password’ which is reserved with Firebird.
Is there a way to do column mappings anywhere in any configuration file to route around these reserved words? I asked the same question in the UnixODBC mailing lists too.
Worst case scenario I can modify the source but I have spent days pouring through the Asterisk source just trying to find ‘insert into’ statements and looking for the reserved words in the source has not lead me to any lines of code I could modify.
If anybody knows where I can find the realtime database code (source file or line) for Queues, Queue logs, SIP, Extensions, etc. it would be greatly appreciated.