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 To: OpenSIPS users mailling list 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
