[Serusers] ser.cfg scripting error

[Jack Wei]

my setup is 2 ser servers & 1 mysql server.  i want to look up a user in table
"location" to see if one of the two ser servers registered the user, so i've
decided to follow the example in the admin guide and use exec_dset().  however,
i'm getting an error output.  anyone knows what's wrong with the following?


        if ( !exec_dset( 'QUERY="select contact from location where
username=\"$SIP_OUSER\"";
                DEST_URI=`mysql -user -pheslo -h10.1.201.107 -Bs -e"$QUERY"
ser`;
                if [ -z "$DEST_URI" ] then exit 1 fi;
                echo "$DEST_URI"; echo > /dev/null;' ) )
        {
                xlog("L_INFO", "\n\n%ru is not online (in db)\n");
                sl_send_reply( "404", "User does not exist" );
                break;
        };




the error output is:




sh: -c: line 4: syntax error: unexpected end of file
12(14932) ERROR:exec_str: no uri from QUERY="select contact from location where
username=\"$SIP_OUSER\"";
                DEST_URI=`mysql -user -pheslo -h10.1.201.107 -Bs -e"$QUERY"
ser`;
                if [ -z "$DEST_URI" ] then exit 1 fi;
                echo "$DEST_URI"; echo > /dev/null;
sip:12222220002 at 10.1.201.191
12(14932) 





i'm not sure why 'sip:12222220002 at 10.1.201.191' is there, but i think that
might be part of the problem.  when i tried the following:




if ( !exec_dset( 'echo sip:12222220002 at 10.1.201.65; echo > /dev/null' ) )



it works fine.

Jack Wei


		
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail