Hi Dovid! Thanks for that idea!
Regards, Ronald On Sun, Jan 9, 2011 at 3:57 AM, Dovid Bender <[email protected]> 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 <[email protected]> > *To:* OpenSIPS users mailling list <[email protected]> > *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 < > [email protected]> 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 >>> [email protected] >>> 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 >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > > ------------------------------ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
