[OpenSIPS-Users] drouting: no valid routing rules

[Dovid Bender]

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