[OpenSIPS-Users] drouting 1.6.3 fails

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Dec 9 13:15:14 CET 2010


Ok, that needs to be updated :)

just to :
    alter table dr_rules add column attrs CHAR(255) DEFAULT NULL;

Regards,
Bogdan

Anton Zagorskiy wrote:
> I'm using drouting 1.6.3
> Module's documentation say nothing about 'attrs' in the dr_rules table. (See
> http://www.opensips.org/html/docs/modules/1.6.x/drouting.html#id250026 )
>
> Is it possible to re-create drouting's tables?
>
>
>
>
>
> WBR, Anton Zagorskiy
> VoIP Developer, Oyster Telecom
> Phone.: +7 812 601-0666
> Fax: +7 812 601-0593
> a.zagorskiy at oyster-telecom.ru
> www.oyster-telecom.ru
>
>
>
>   
>> -----Original Message-----
>> From: users-bounces at lists.opensips.org [mailto:users-
>> bounces at lists.opensips.org] On Behalf Of Bogdan-Andrei Iancu
>> Sent: Thursday, December 09, 2010 3:02 PM
>> To: OpenSIPS users mailling list
>> Subject: Re: [OpenSIPS-Users] drouting 1.6.3 fails
>>
>> Hi Anton,
>>
>> it seams your table is no longer matching the drouting version you are
>> running. See :
>>
>> http://www.opensips.org/html/docs/db/db-schema-1.6.x.html#GEN-DB-DR-
>> RULES
>>
>> Regards,
>> Bogdan
>>
>> Anton Zagorskiy wrote:
>>     
>>> Hello.
>>>
>>> The drouting module trying to read 'attrs' column from a dr_rule
>>>       
>> table.
>>     
>>> There is no such column in that table.
>>>
>>>       
>> (http://www.opensips.org/html/docs/modules/1.6.x/drouting.html#id250026
>> )
>>     
>>> Mysql log:
>>> Query       select
>>> ruleid,groupid,prefix,timerec,priority,routeid,gwlist,attrs from
>>>       
>> dr_rules
>>     
>>> OpenSIPS log:
>>> [30268]: ERROR:db_mysql:db_mysql_submit_query: driver error: Unknown
>>>       
>> column
>>     
>>> 'attrs' in 'field list'
>>> [30268]: ERROR:core:db_do_query: error while submitting query
>>> [30268]: ERROR:drouting:dr_load_routing_info: DB query failed
>>> [30268]: CRITICAL:drouting:dr_reload_data: failed to load routing
>>>       
>> info
>>     
>>> [30268]: CRITICAL:drouting:dr_child_init: failed to load routing data
>>>
>>>
>>>
>>>
>>>
>>> WBR, Anton Zagorskiy
>>> VoIP Developer, Oyster Telecom
>>> Phone.: +7 812 601-0666
>>> Fax: +7 812 601-0593
>>> a.zagorskiy at oyster-telecom.ru
>>> www.oyster-telecom.ru
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>>       
>> --
>> Bogdan-Andrei Iancu
>> OpenSIPS Bootcamp
>> 15 - 19 November 2010, Edison, New Jersey, USA
>> www.voice-system.ro
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>     
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
15 - 19 November 2010, Edison, New Jersey, USA
www.voice-system.ro




More information about the Users mailing list