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
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
