[sr-dev] kamctl not working properly for sqlite

[Peter Dunkley]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20131015/7c4c336d/attachment.html>