[OpenSIPS-Users] TextDB and Registrant issues

[Ovidiu Sas]

The tables are automatically generated and that's the initial layout.
There might be an issue with opensipsctl tool while dealing with
dbtext tables or in your case, since your table was empty, you did
something wrong (like having the DBENGINE set to something else then
TEXT).
If you populate dbtext by hand or using the pi_http module, it will work fine.

Your previous logs shows that your dbtext file has no records and the
logs confirmed that.
You posted an output of 'opensipsctl db show registrant' that doesn't
look at all as a dbtext output.
My guess here is that you use opensipsctl to populate a db different
then dbtext and therefore no records in your dbtext registrant file.


Regards,
Ovidiu Sas

On Wed, Jun 4, 2014 at 3:21 PM, Kurtis Heimerl <kheimerl at endaga.com> wrote:
> The tables were automatically generated, and there are definitely
> outstanding issues with textdb that I ran into:
> http://sourceforge.net/p/openser/bugs/593/
>
>
> On Wed, Jun 4, 2014 at 6:59 AM, Ovidiu Sas <osas at voipembedded.com> wrote:
>>
>> Hello,
>>
>> There are no issues with dbtext.  Please read the dbtext documentation
>> and use the proper format for the table.
>>
>> Regards,
>> Ovidiu Sas
>>
>> On Tue, Jun 3, 2014 at 11:36 PM, Kurtis Heimerl <kheimerl at endaga.com>
>> wrote:
>> > For the webcrawlers, I was was able to resolve this by switching to
>> > postgres. I guess textdb has some issues.
>> >
>> >
>> > On Fri, May 30, 2014 at 6:23 PM, Kurtis Heimerl <kheimerl at endaga.com>
>> > wrote:
>> >>
>> >> Hey List,
>> >>
>> >> Here's my current conundrum:
>> >> I have opensips running with textdb pointed at
>> >> /usr/local/etc/opensips/dbtext. I've enabled the uac_registrant module
>> >> and
>> >> pointed it at the same directory (though it should be noted that this
>> >> was
>> >> done manually, as it wouldn't use the default for some reason).
>> >>
>> >> I've put a registrant into the db:
>> >> sudo opensipsctl db show registrant
>> >> [1, 'sip:sip.DOMAIN.com', '', 'sip:NAME at sip.DOMAIN.com', '', 'NAME',
>> >> 'PASSWORD', 'sip:opensips at localhost', '', 600, '']
>> >>
>> >> However, the uac_registrant module doesn't seem to read this:
>> >> sudo opensipsctl fifo reg_reload
>> >> May 31 01:20:27 ip-172-31-27-53 /usr/sbin/opensips[6034]:
>> >> INFO:uac_registrant:load_reg_info_from_db: loading [0] records from db
>> >>
>> >> This is actually confirmed by actually going through the textdb itself,
>> >> there's nothing in the registrant table!
>> >> cat dbtext/registrant
>> >> id(int,auto) registrar(string) proxy(string,null) aor(string)
>> >> third_party_registrant(string,null) username(string,null)
>> >> password(string,null) binding_URI(string) binding_params(string,null)
>> >> expiry(int,null) forced_socket(string,null)
>> >>
>> >> What's going on here? I've double checked that they are reading from
>> >> the
>> >> same db, and they should be, unless there's another one somewhere
>> >> that's
>> >> outside of configuration? The log seems to think it's fine:
>> >> May 30 22:00:28 ip-172-31-27-53 /usr/sbin/opensips[6033]:
>> >> INFO:db_text:dbt_init: using database at:
>> >> /usr/local/etc/opensips/dbtext
>> >>
>> >> Any suggestions/directions would be appreciated.
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>> > _______________________________________________
>> > Users mailing list
>> > Users at lists.opensips.org
>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> >
>>
>>
>>
>> --
>> VoIP Embedded, Inc.
>> http://www.voipembedded.com
>>
>> _______________________________________________
>> 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
>



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com