Hi Dovid!<div><br></div><div>Thanks for that idea!</div><div><br></div><div>Regards,</div><div>Ronald<br><br><div class="gmail_quote">On Sun, Jan 9, 2011 at 3:57 AM, Dovid Bender <span dir="ltr"><<a href="mailto:os-list@dovid.net">os-list@dovid.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">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.</font></div>
<div> </div>
<blockquote style="padding-right:0px;padding-left:5px;margin-left:5px;border-left:#000000 2px solid;margin-right:0px"><div><div></div><div class="h5">
<div style="font:10pt arial">----- Original Message ----- </div>
<div style="background:#e4e4e4;font:10pt arial"><b>From:</b>
<a title="rbcepres@gmail.com" href="mailto:rbcepres@gmail.com" target="_blank">Ronald Cepres</a>
</div>
<div style="font:10pt arial"><b>To:</b> <a title="users@lists.opensips.org" href="mailto:users@lists.opensips.org" target="_blank">OpenSIPS users mailling list</a> </div>
<div style="font:10pt arial"><b>Sent:</b> Friday, January 07, 2011
19:16</div>
<div style="font:10pt arial"><b>Subject:</b> Re: [OpenSIPS-Users] drouting:
no valid routing rules</div>
<div><br></div>
<div>Hi Bogdan,</div>
<div><br></div>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.
<div><br></div>
<div>Thanks for attending anyway!</div>
<div><br></div>
<div>Regards,</div>
<div>Ronald<br><br>
<div class="gmail_quote">On Sat, Jan 8, 2011 at 12:23 AM, Bogdan-Andrei Iancu
<span dir="ltr"><<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="padding-left:1ex;margin:0px 0px 0px 0.8ex;border-left:#ccc 1px solid">Hi
Ronald,<br><br>may sound as a stupid question, but are you sure the db_url
of drouting module points to the right database
?<br><br>Regards,<br>Bogdan<br><br>Ronald Cepres wrote:<br>
<blockquote class="gmail_quote" style="padding-left:1ex;margin:0px 0px 0px 0.8ex;border-left:#ccc 1px solid">
<div>
<div></div>
<div>Hi to all!<br><br>After upgrading from 1.6.3 to 1.6.4, I
keep on getting this log when starting
OpenSIPS:<br><br>WARNING:drouting:dr_load_routing_info: table "dr_rules"
is empty<br>DBG:drouting:dr_load_routing_info: 0 records found in
dr_rules<br>WARNING:drouting:dr_load_routing_info: no valid routing rules
-> discarding all destinations.<br><br>Yet, my "dr_rules" table
contains at least 100k rules and here is the description of the
table:<br><br>+-------------+------------------+------+-----+---------+----------------+<br>|
Field | Type
| Null | Key | Default | Extra
|<br>+-------------+------------------+------+-----+---------+----------------+<br>|
ruleid | int(10) unsigned | NO | PRI | NULL
| auto_increment |<br>| groupid | char(255)
| NO | | NULL
| |<br>|
prefix | char(64) | NO
| | NULL |
|<br>| timerec | char(255)
| NO | | NULL |
|<br>| priority
| int(11) | NO |
| 0 |
|<br>| routeid | char(255)
| NO | | NULL |
|<br>| gwlist
| char(255) | NO |
| NULL |
|<br>| attrs | char(255)
| YES | | NULL |
|<br>| description
| char(128) | NO | |
|
|<br>+-------------+------------------+------+-----+---------+----------------+<br><br>Am
I missing something
here?<br><br>Thanks!<br><br>Regards,<br>Ronald<br><br><br></div></div>------------------------------------------------------------------------<br><br>_______________________________________________<br>Users
mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote><br><br>--
<br>Bogdan-Andrei Iancu<br>OpenSIPS Event - expo, conf, social,
bootcamp<br>2 - 4 February 2011, ITExpo, Miami, USA<br><a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br><br><br>_______________________________________________<br>Users
mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br></div>
</div></div><p>
</p><hr><div class="im">
<p></p>_______________________________________________<br>Users mailing
list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div><p></p></blockquote></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>