Hello,
Some of the kamctl commands don't work properly with sqlite because it uses SQL functions that sqlite does not support.
For example:
- kamctl domain add ...
Fails with:
sqlite_query: /usr/bin/sqlite3 /etc/kamailio/db.sqlite insert into domain (domain, last_modified) VALUES ('...',now());
Error: no such function: now
ERROR: domain - SQL Error
- kamctl speeddial list...
Fails with:
Dumping speed-dials for user=<...>
sqlite_query: /usr/bin/sqlite3 /etc/kamailio/db.sqlite SELECT CONCAT(sd_username,'@',sd_domain) AS 'Short number', new_uri AS 'New URI',description FROM speed_dial WHERE username='...' AND domain='...';
Error: no such function: CONCAT
There are probably lots of other examples too.
Regards,
Peter
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd