[sr-dev] kamctl not working properly for sqlite

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