[Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2

Daniel-Constantin Mierla daniel at voice-system.ro
Tue Mar 20 18:43:08 CET 2007


Hello,

seems that some column is missing in location table. Can you start 
openser in higher debug mode and see the output. Should give you more hints.

Cheers,
Daniel


On 03/20/07 19:32, Daryl Sanders wrote:
> When the issue is completely solved I will certainly do that.
> At this point I still get the following error, even with the
> presumably correct columns.
> But at least OpenSER starts now.
>
>     2(26689) db_insert_ucontact(): Error while inserting contact
>     2(26689) ERROR:usrloc:insert_ucontact: failed to insert in database
>
> This error occurs when a phone tries to register.
>
> - Daryl
>
>
>
> On 3/20/07, Ovidiu Sas <sip.nslu at gmail.com> wrote:
>> Then pls. create a patch and upload the patch to the traker:
>>
>> diff -Naur textdb.sh.old textdb.sh.new
>>
>>
>> Regards,
>> Ovidiu Sas
>>
>> On 3/20/07, Daryl Sanders <daryl.sanders at gmail.com> wrote:
>> > One correction to my previous post...
>> >
>> > When using method 2 (textdb.sh) to create dbtext tables, the
>> > subscriber table format appears broken. I was able to correct this
>> > issue by using the following columns.
>> >
>> > phplib_id(str) username(str) domain(str) password(str)
>> > first_name(str,null) last_name(str,null) phone(str,null)
>> > email_address(str) datetime_created(int,null)
>> > datetime_modified(int,null) confirmation(str,null) flag(str,null)
>> > sendnotification(str,null) greeting(str,null) ha1(str) ha1b(str)
>> > allow_find(str) timezone(str,null) rpid(str,null) domn(int,null)
>> > uuid(str,null)
>> >
>> > - Daryl
>> >
>> >
>> > On 3/20/07, Daryl Sanders <daryl.sanders at gmail.com> wrote:
>> > > When using db_mode=1,2 or 3 I get the following error when starting
>> > > OpenSER 1.2 using dbtext as the usrloc DB.
>> > >
>> > >  1(23052) preload_udomain(): Error while doing db_query
>> > >  1(23052) ERROR:ul:child_init(1): Error while preloading domain 
>> 'location'
>> > >  1(23052) ERROR:init_mod_child: Error while initializing module 
>> usrloc, rank 1
>> > >
>> > > I am wondering if their may be a problem with the columns in the
>> > > location table file.
>> > >
>> > > I tried two different methods of creating the initial table files...
>> > >
>> > > 1.) sc.dbtext dbtext /usr/local/etc/openser/dbtext/
>> > > 2.) textdb.sh create /usr/local/etc/openser/dbtext/
>> > >
>> > > The first method has problems with the version file that I tried to
>> > > repair by trying to mimic the mysql table structure.
>> > >
>> > > The second method seems to work ok with the exception of the error I
>> > > mentioned above when starting OpenSER.
>> > >
>> > > Any help would be greatly appreciated!
>> > >
>> > > Thanks,
>> > > Daryl
>> > >
>> >
>> > _______________________________________________
>> > Users mailing list
>> > Users at openser.org
>> > http://openser.org/cgi-bin/mailman/listinfo/users
>> >
>>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>




More information about the Users mailing list