[Serusers] ser.cfg scripting error

[Evan Borgström]

	Querying mysql using exec_dset is messy and takes a lot of resources. 
However, to keep it clean I'd do this in an external script. Something like:

#!/bin/sh
user=`/bin/echo $1 | /bin/awk -F'@' '{print $1}' | /bin/awk -F':' 
'{print $2}'`
query="select contact from location where username=\"$user\";"
mysql -user -pheslo -h10.1.201.107 -Bs -e "$query" ser


	Then in your ser.cfg just do: exec_dset("/path/to/script.sh"); and make 
sure it's chmod'd 0755. The reason that the docs all recommend using 
;echo >/dev/null as the last part of exec_dset is because the command 
passes the RURI as the argument, so in the command above it would 
actually get called as "/path/to/script.sh sip:12222220002 at 10.1.201.191" 
so you can see how the awk command in the above script pulls the 
username out. Also if you're going to use this make sure your db_mode is 
set to 1 (write through) so that changes to the usrloc tables are made 
immediately. Note that this doesn't handle domains so if you have 
user1 at domain1.tld and user1 at domain2.tld this snippet wont work.

	Check back through the mailing list for the carrier-grade framework 
discussion. SER in it's current incarnation (especially 0.8) doesn't 
deal well with a active-active setup, that discussion talks about a 
bunch of different ideas on how to handle this situation.


-Evan


Jack Wei wrote:
> 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 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers