THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Peter Dunkley (pd) 

Attached to Project - sip-router
Summary - kamctl does not work properly for sqlite
Task Type - Bug Report
Category - utils
Status - New
Assigned To - 
Operating System - All
Severity - Low
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - 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

and,
  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.

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=356

You are receiving this message because you have requested it from the Flyspray 
bugtracking system.  If you did not expect this message or don't want to 
receive mails in future, you can change your notification settings at the URL 
shown above.

_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

Reply via email to