20 Mar
2007
20 Mar
'07
2:14 p.m.
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
20 Mar
20 Mar
4:48 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
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(a)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
6:10 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6:32 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
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(a)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(a)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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6:43 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
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(a)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(a)gmail.com> wrote:
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
7:06 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
With debug=9, I did not see any errors when starting OpenSER, however
I do get the following error when a phone tries to register.
2(27383) DBT:dbt_table_check_row: NULL value not allowed - field 0
2(27383) DBT:db_insert: cannot insert the new row!!
2(27383) DBT:db_insert: make clean!
2(27383) db_insert_ucontact(): Error while inserting contact
2(27383) ERROR:usrloc:insert_ucontact: failed to insert in database
2(27383) build_contact(): Created Contact HF: Contact:
<sip:1000@x.x.x.x:5060>;expires=300
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
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(a)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(a)gmail.com> wrote:
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
7:31 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
I noticed the "NULL value not allows" errors for field 0 and field 2.
In my location table file "field 0" = id(int) and "field 2" =
domain(str).
I tried to correct the errors by adding ",null" to the column type for
each of these columns. This resulted the errors going away, however no
new rows are added to the dbtext location table file when a phone
registers.
- Daryl
On 3/20/07, Daryl Sanders <daryl.sanders(a)gmail.com> wrote:
With debug=9, I did not see any errors when starting
OpenSER, however
I do get the following error when a phone tries to register.
2(27383) DBT:dbt_table_check_row: NULL value not allowed - field 0
2(27383) DBT:db_insert: cannot insert the new row!!
2(27383) DBT:db_insert: make clean!
2(27383) db_insert_ucontact(): Error while inserting contact
2(27383) ERROR:usrloc:insert_ucontact: failed to insert in database
2(27383) build_contact(): Created Contact HF: Contact:
<sip:1000@x.x.x.x:5060>;expires=300
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
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(a)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(a)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(a)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(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
7:33 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
On 03/20/07 20:31, Daryl Sanders wrote:
I noticed the "NULL value not allows" errors
for field 0 and field 2.
In my location table file "field 0" = id(int) and "field 2" =
domain(str).
I tried to correct the errors by adding ",null" to the column type for
each of these columns. This resulted the errors going away, however no
new rows are added to the dbtext location table file when a phone
registers.
The dbtext tables are in memory only. They are flushed back to harddrive
when openser is stopped.
Cheers,
Daniel
- Daryl
On 3/20/07, Daryl Sanders <daryl.sanders(a)gmail.com> wrote:
With debug=9, I did not see any errors when
starting OpenSER, however
I do get the following error when a phone tries to register.
2(27383) DBT:dbt_table_check_row: NULL value not allowed - field 0
2(27383) DBT:db_insert: cannot insert the new row!!
2(27383) DBT:db_insert: make clean!
2(27383) db_insert_ucontact(): Error while inserting contact
2(27383) ERROR:usrloc:insert_ucontact: failed to insert in database
2(27383) build_contact(): Created Contact HF: Contact:
<sip:1000@x.x.x.x:5060>;expires=300
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
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(a)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(a)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(a)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(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
7:37 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
Ok that makes sense. When I restarted OpenSER the table location got populated.
Should I file a bug report regarding the incorrect structure of the
subscriber and location dbtext tables?
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
On 03/20/07 20:31, Daryl Sanders wrote:
I noticed the "NULL value not allows"
errors for field 0 and field 2.
In my location table file "field 0" = id(int) and "field 2" =
domain(str).
I tried to correct the errors by adding ",null" to the column type for
each of these columns. This resulted the errors going away, however no
new rows are added to the dbtext location table file when a phone
registers.
The dbtext tables are in memory only. They are flushed back to
harddrive
when openser is stopped.
Cheers,
Daniel
- Daryl
On 3/20/07, Daryl Sanders <daryl.sanders(a)gmail.com> wrote:
With debug=9, I did not see any errors when
starting OpenSER, however
I do get the following error when a phone tries to register.
2(27383) DBT:dbt_table_check_row: NULL value not allowed - field 0
2(27383) DBT:db_insert: cannot insert the new row!!
2(27383) DBT:db_insert: make clean!
2(27383) db_insert_ucontact(): Error while inserting contact
2(27383) ERROR:usrloc:insert_ucontact: failed to insert in database
2(27383) build_contact(): Created Contact HF: Contact:
<sip:1000@x.x.x.x:5060>;expires=300
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
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(a)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(a)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(a)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(a)openser.org
>> > http://openser.org/cgi-bin/mailman/listinfo/users
>> >
>>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
7:38 p.m.
New subject: [Users] Re: Only db_mode=0 works with dbtext loaction table in 1.2
On 03/20/07 20:37, Daryl Sanders wrote:
Ok that makes sense. When I restarted OpenSER the
table location got
populated.
Should I file a bug report regarding the incorrect structure of the
subscriber and location dbtext tables?
that would be great. Please attach the patch
as well :-) . thanks,
Daniel
- Daryl
On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
On 03/20/07 20:31, Daryl Sanders wrote:
I noticed the "NULL value not allows"
errors for field 0 and field 2.
In my location table file "field 0" = id(int) and "field 2" =
domain(str).
I tried to correct the errors by adding ",null" to the column type for
each of these columns. This resulted the errors going away, however no
new rows are added to the dbtext location table file when a phone
registers.
The dbtext tables are in memory only. They are flushed back to
harddrive
when openser is stopped.
Cheers,
Daniel
- Daryl
On 3/20/07, Daryl Sanders <daryl.sanders(a)gmail.com> wrote:
> With debug=9, I did not see any errors when starting OpenSER, however
> I do get the following error when a phone tries to register.
>
> 2(27383) DBT:dbt_table_check_row: NULL value not allowed - field 0
> 2(27383) DBT:db_insert: cannot insert the new row!!
> 2(27383) DBT:db_insert: make clean!
> 2(27383) db_insert_ucontact(): Error while inserting contact
> 2(27383) ERROR:usrloc:insert_ucontact: failed to insert in database
> 2(27383) build_contact(): Created Contact HF: Contact:
> <sip:1000@x.x.x.x:5060>;expires=300
>
> - Daryl
>
> On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
> > 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(a)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(a)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(a)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(a)openser.org
> >> > http://openser.org/cgi-bin/mailman/listinfo/users
> >> >
> >>
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
21 Mar
21 Mar
2:57 p.m.
Hi,
Now that you have figured it out and that we are going to solve it ...
could you try working it out so that the sc.dbtext.sh uses the
textdb.sh script? this way we only have to mantain one file ...
Tks!
Cesc
On 3/20/07, Daryl Sanders <daryl.sanders(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
6465
days inactive
6466
days old
10 comments
4 participants
participants (4)
-
Cesc -
Daniel-Constantin Mierla -
Daryl Sanders -
Ovidiu Sas