CID lookup timeout for mysql query

[alsur (España)]

We just implemented a simple CID lookup through mysql view on our Freepbx to discover a day later that if the mysql source fails the incoming call fails!

I also Superfecta module installed but not activated so we thought to move it there but realised there is not a pure MySQL superfecta module. We are guessing we can find out the kind of reply from any of the available modules that work via MySQL and fake that table structure if required but wondering if the were any other easier alternatives.

Also wondering if the standard Freepbx CID lookup has a timeout value one could set anywhere… this is so if the mysql query lookup fails the call continues being routed.

thanks.

[lgaetz (Lorne Gaetz)]

@alsur

but realised there is not a pure MySQL superfecta module

You’re looking for SFDatabase in superfecta.

[alsur (España)]

Thanks. Yes found it after posting and working fine… including timeout in case of a failed mysql connection. Hope it helps someone else.