[Serdev] ser crashes - ua name to long

[Klaus Darilion]

The crash is due to sprintf instead of snprintf in postgres module.

I fixed it in openser. If you are using ser+postgres please port the fix 
to ser:
http://openser.org/pipermail/devel/2005-August/000346.html
http://openser.org/pipermail/devel/2005-September/000577.html

regards
klaus

Dariusz Dwornikowski wrote:
> we had a SER 0.10.99 crash , when user with user agent name > 50 chars 
> registered:
> we use pgsql, with column type varchar(50), i know this is the problem, 
> but should'n be there some
> warning only ? is there possibility to do some actions in config to 
> prevent registering such users ?
> 
> ser crashes completely. :
> 
> Sep 22 20:16:32 aster2 /usr/local/sbin/ser[3840]: PG[362] submit_query 
> query 'insert into location 
> (username,contact,expires,q,callid,cseq,flags,user_agent,received ) 
> values 
> ('ptomaszewski002','sip:ptomaszewski002 at 83.x.x.x:45090','2005-09-22 
> 20:16:34 +0200',-1.00     
> ,'B3E952041B3E434744BEF86958C8B104 at sip.inotel.pl',24477,0,'X-PRO release 
> 1106t stamp 18642 OS=Win CE 4.21 1088',NULL)', result 'ERROR:  value too 
> long for type character varying(50) '
>