[OpenSIPS-Users] drouting: no valid routing rules

[Ronald Cepres]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110108/e208566a/attachment.htm>