[OpenSIPS-Devel] [ opensips-Bugs-3442873 ] problem with address add ...

[SourceForge.net]

Bugs item #3442873, was opened at 2011-11-26 08:23
Message generated for change (Tracker Item Submitted) made by rrevels
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3442873&group_id=232389

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: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Richard Revels (rrevels)
Assigned to: Nobody/Anonymous (nobody)
Summary: problem with address add ...

Initial Comment:
Starting at line 1077 in opensipsctl is


                        CONTEXT_INFO=""
                        if [ ! -z "$6" ]; then
                                CONTEXT_INFO="$6"

                                QUERY="insert into $ADDRESS_TABLE \
                                        ($ADDRESS_GRP_COLUMN, $ADDRESS_IP_COLUMN, $ADDRESS_MASK_COLUMN, \
                                        $ADDRESS_PORT_COLUMN, $ADDRESS_PROTO_COLUMN, $ADDRESS_CONTEXT_INFO_COLUMN) \
                                        VALUES ('$1', '$2', '$3', '$4', '$5', CONTEXT_INFO);"

                                PATTERN=""
                                if [ ! -z "$7" ]; then
                                        PATTERN="$7"

                                        QUERY="insert into $ADDRESS_TABLE \
                                                ($ADDRESS_GRP_COLUMN, $ADDRESS_IP_COLUMN, $ADDRESS_MASK_COLUMN, \
                                                $ADDRESS_PORT_COLUMN, $ADDRESS_PROTO_COLUMN, $ADDRESS_CONTEXT_INFO_COLUMN, $ADDRESS_PATTERN_COLUMN) \
                                                VALUES ('$1', '$2', '$3', '$4', '$5', CONTEXT_INFO, PATTERN);"
                                fi
                        fi

Needs to have CONTEXT_INFO and PATTERN identified correctly and quoted in sql statements.


                        CONTEXT_INFO=""
                        if [ ! -z "$6" ]; then
                                CONTEXT_INFO="$6"

                                QUERY="insert into $ADDRESS_TABLE \
                                        ($ADDRESS_GRP_COLUMN, $ADDRESS_IP_COLUMN, $ADDRESS_MASK_COLUMN, \
                                        $ADDRESS_PORT_COLUMN, $ADDRESS_PROTO_COLUMN, $ADDRESS_CONTEXT_INFO_COLUMN) \
                                        VALUES ('$1', '$2', '$3', '$4', '$5', '$CONTEXT_INFO');"

                                PATTERN=""
                                if [ ! -z "$7" ]; then
                                        PATTERN="$7"

                                        QUERY="insert into $ADDRESS_TABLE \
                                                ($ADDRESS_GRP_COLUMN, $ADDRESS_IP_COLUMN, $ADDRESS_MASK_COLUMN, \
                                                $ADDRESS_PORT_COLUMN, $ADDRESS_PROTO_COLUMN, $ADDRESS_CONTEXT_INFO_COLUMN, $ADDRESS_PATTERN_COLUMN) \
                                                VALUES ('$1', '$2', '$3', '$4', '$5', '$CONTEXT_INFO', '$PATTERN');"
                                fi
                        fi


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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3442873&group_id=232389