Bugs item #2796454, was opened at 2009-05-25 14:35 Message generated for change (Comment added) made by henningw You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=743020&aid=279645… Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: tools Priority: 5 Private: No Submitted By: Edson - 4lists (egschubert) Summary: Problems on 'kamctl' script on CR command Initial Comment: Just updated to the last SVN: ... Kamailio-151:~/sip-server # kamailio -V version: kamailio 1.5.1-notls (i386/linux) flags: STATISTICS, USE_IPV6, USE_TCP, USE_SCTP, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, PKG_SIZE 4194304 poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. svnrevision: 2:5858M @(#) $Id: main.c 5608 2009-02-13 16:48:17Z henningw $ main.c compiled on 11:09:12 May 25 2009 with gcc 4.3 And 'kamctl cr' says: ... cr addcarrier <carrier> <scan_prefix> <domain> <rewrite_host> ................ <prob> <strip> <rewrite_prefix> <rewrite_suffix> ............... <flags> <mask> <comment> .........................add a carrier ... But command: ... Kamailio-151:~/sip-server # kamctl cr addcarrier 1 0 2 X.X.X.X 1 1 123456 '' '' '' 'Output_Route_X123' Output_Route_X123 ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Rota_de_saida_pelo_IPIPGW)' at line 1 ERROR: cr - SQL Error Kamailio-151:~/sip-server # On script 'kamctl', line 1357: if [ $# -gt 8 ] ; then COMMENT=$9 Edson. ---------------------------------------------------------------------- Date: 2009-05-29 07:40 Message: Hi Edson, thanks for the report. Indeed the order of inserted data was not consistent to the help output, should be fixed now. Please keep in mind that if you specify the flags as empty strings '' the statement will also not work, use 0 instead. ./kamctl cr addcarrier 1 0 2 X.X.X.X 1 1 123456 '' '0' '0' 'Output_Route_X123' Henning ---------------------------------------------------------------------- Comment By: Edson - 4lists (egschubert) Date: 2009-05-28 15:15 Message: re-sending... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=743020&aid=279645…