[OpenSIPS-Users] drouting: no valid routing rules

[Ronald Cepres]

Hi Dovid!

Thanks for that idea!

Regards,
Ronald

On Sun, Jan 9, 2011 at 3:57 AM, Dovid Bender <os-list at dovid.net> wrote:

>  Just to add my 2c. When ever I have a db issue I enable verbose logging
> to a file and then try to replicate the queries that OpenSipS is trying to
> do. Saves a lot of time.
>
>
> ----- Original Message -----
> *From:* Ronald Cepres <rbcepres at gmail.com>
> *To:* OpenSIPS users mailling list <users at lists.opensips.org>
> *Sent:* Friday, January 07, 2011 19:16
> *Subject:* Re: [OpenSIPS-Users] drouting: no valid routing rules
>
> Hi Bogdan,
>
> yes it is the right url. anyway, i solved my own problem now. it appears to
> me that when i migrated my data, the  previous data on the 'description'
> column of my 1.6.3 table was placed on the new 'attrs' column on 1.6.4
> instead of on the 'description' column. That might have caused an error
> somewhere but there are no logs regarding that issue.
>
> Thanks for attending anyway!
>
> Regards,
> Ronald
>
> On Sat, Jan 8, 2011 at 12:23 AM, Bogdan-Andrei Iancu <
> bogdan at voice-system.ro> wrote:
>
>> Hi Ronald,
>>
>> may sound as a stupid question, but are you sure the db_url of drouting
>> module points to the right database ?
>>
>> Regards,
>> Bogdan
>>
>> Ronald Cepres wrote:
>>
>>>  Hi to all!
>>>
>>> After upgrading from 1.6.3 to 1.6.4, I keep on getting this log when
>>> starting OpenSIPS:
>>>
>>> WARNING:drouting:dr_load_routing_info: table "dr_rules" is empty
>>> DBG:drouting:dr_load_routing_info: 0 records found in dr_rules
>>> WARNING:drouting:dr_load_routing_info: no valid routing rules ->
>>> discarding all destinations.
>>>
>>> Yet, my "dr_rules" table contains at least 100k rules and here is the
>>> description of the table:
>>>
>>>
>>> +-------------+------------------+------+-----+---------+----------------+
>>> | Field       | Type             | Null | Key | Default | Extra
>>>  |
>>>
>>> +-------------+------------------+------+-----+---------+----------------+
>>> | ruleid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment
>>> |
>>> | groupid     | char(255)        | NO   |     | NULL    |
>>>  |
>>> | prefix      | char(64)         | NO   |     | NULL    |
>>>  |
>>> | timerec     | char(255)        | NO   |     | NULL    |
>>>  |
>>> | priority    | int(11)          | NO   |     | 0       |
>>>  |
>>> | routeid     | char(255)        | NO   |     | NULL    |
>>>  |
>>> | gwlist      | char(255)        | NO   |     | NULL    |
>>>  |
>>> | attrs       | char(255)        | YES  |     | NULL    |
>>>  |
>>> | description | char(128)        | NO   |     |         |
>>>  |
>>>
>>> +-------------+------------------+------+-----+---------+----------------+
>>>
>>> Am I missing something here?
>>>
>>> Thanks!
>>>
>>> Regards,
>>> Ronald
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>>
>> --
>> Bogdan-Andrei Iancu
>> OpenSIPS Event - expo, conf, social, bootcamp
>> 2 - 4 February 2011, ITExpo, Miami,  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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110109/67d429e5/attachment.htm>