How to use sql.php from an AGI to connect to asteriskcrddb?

FreePBX Tips and Tricks
1

I’m having some trouble with Freepbx sql.php library for an agi.

I can use it without problem to access the asterisk database, however I can’t use this class to access the asteriskcdrb database.

The problem is that $dbname is declared as private. If I replace private by public in sql.php I can then do a
$db2 = new AGIDB($AGI);
$db2->dbname=‘asteriskcdrdb’;
and it works well.

Is there a way to use the public $dbhandle to change the $dbname from the agi without having to change sql.php?

1 Like