<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.17093" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY 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 style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=rbcepres@gmail.com href="mailto:rbcepres@gmail.com">Ronald Cepres</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=users@lists.opensips.org
href="mailto:users@lists.opensips.org">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">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 class=h5>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>
<P>
<HR>
<P></P>_______________________________________________<BR>Users mailing
list<BR>Users@lists.opensips.org<BR>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<BR></BLOCKQUOTE></BODY></HTML>