[sr-dev] [ openser-Bugs-2796454 ] Problems on 'kamctl' script on CR command

[SourceForge.net]

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=2796454&group_id=139143

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
>Group: ver 1.5.x
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Edson - 4lists (egschubert)
>Assigned to: Henning Westerholt (henningw)
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.

----------------------------------------------------------------------

>Comment By: Henning Westerholt (henningw)
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=2796454&group_id=139143