[sr-dev] [tracker] Task opened: kamctl does not work properly for sqlite

sip-router bugtracker at sip-router.org
Fri Oct 18 01:01:54 CEST 2013


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.



More information about the sr-dev mailing list