Actually the table has the priority column in ver 1.11. Anyway, thanks for your response Bogdan, I will try to find a workarround for this version until we upgrade to 2.x.
Thanks & Regards Federico On Mon, Aug 17, 2015 at 5:56 AM, Bogdan-Andrei Iancu <bog...@opensips.org> wrote: > Hi Federico, > > This is an known issue with the older versions of OpenSIPS (not being able > set an order for the records). In 2.1 this was solved by having a priority > column which dictates the oder of usage of records. > > For versions before 2.1, you have to rely on the oder provided by DB :(. > > Regards, > > Bogdan-Andrei Iancu > OpenSIPS Founder and Developerhttp://www.opensips-solutions.com > > On 14.08.2015 20:49, Federico Edorna wrote: > > Hello Guys, > I'm using dispatcher module with postgres database. The ds_select_dst > function in the script file is used like this: > > ds_select_dst("$(var(ds_set){s.int})","8"); > > that is, using "8" algorithm (first entry in set is chosen) because I need > to use always the same destination in the set while it is up. If not, then > the backup destination (next in the set) is used. > > The problem I've found is that when the sets are read from database > (opensips restart or fifo ds_reload), the select hasn't a "order" directive > in the sql statement, so the order is defined depending of the last tuple > update. The postgres log shows this when doing a fifo ds_reload: > > 2015-08-14 11:36:53 ART [23684]: [1-1] LOG: duration: 0.582 ms > statement: select setid,destination,socket,state,weight,attrs from > sbc.dispatcher > > And the syslog & debug=6 shows: > > DBG:db_postgres:db_postgres_submit_query: 0x7f4344987010 > PQsendQuery(select setid,destination,socket,state,weight,attrs from > sbc.dispatcher ) > > So, any sql update in any column will change the order in the set because > we don't have the "order by priority" for example. > > Is there any way to use the weight, priority or the id to have a fixed > order in the set(s) destination? > > > Many Thanks! > Federico > > > _______________________________________________ > Users mailing > listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users > > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users