#574 Problems on 'kamctl' script on CR command

[Edson - 4lists]

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.

[Edson - 4lists]

re-sending...

[Henning Westerholt]

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