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@10.1.201.191 12(14932)
i'm not sure why 'sip:12222220002@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@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