[Users] Problem with db_text module

[Alexandre Passito]

I was trying to start db_text but I got the following error. I tried
to put <socket> column where it requests after this error, but openser
did not start.

 0(0) DBT:dbt_cache_get_db: looking for db
/home/alexandre/Devel/openser-0.9. 4/bin/dbtext!
 0(0) DBT:dbt_cache_get_db: new db!
 0(0) DBT:dbt_load_file: request for table [version]
 0(0) DBT:dbt_load_file: db is [/home/alexandre/Devel/openser-0.9.4/bin/dbtex t]
 0(0) DBT:dbt_load_file: loading file
[/home/alexandre/Devel/openser-0.9.4/bi n/dbtext/version]
 0(0) DBT: column[0] is STR!
 0(0) DBT: column[1] is INT!
 0(0) DTB:dbt_db_get_table: version

 Content of [version]
table_name(str) table_version(int)
subscriber:3
location:6
aliases:6
 0(0) DBT:dbt_query: new res with 1 cols
 0(0) DBT:dbt_result_new: new res with 1 cols

Content of result
table_version(int)
6
 0(0) DBT:dbt_load_file: request for table [location]
 0(0) DBT:dbt_load_file: db is [/home/alexandre/Devel/openser-0.9.4/bin/dbtex t]
 0(0) DBT:dbt_load_file: loading file
[/home/alexandre/Devel/openser-0.9.4/bi n/dbtext/location]
 0(0) DBT: column[0] is STR!
 0(0) DBT: column[1] is STR!
 0(0) DBT: column[2] is STR!
 0(0) DBT: column[3] is INT!
 0(0) DBT: column[4] is DOUBLE!
 0(0) DBT: column[5] is STR!
 0(0) DBT: column[6] is INT!
 0(0) DBT: column[7] is STR!
 0(0) DBT: column[8] is INT!
 0(0) DBT: column[9] is INT!
 0(0) DBT: column[10] is INT!
 0(0) DBT: column[11] is STR!
 0(0) DBT: column[12] is STR!
 0(0) DTB:dbt_db_get_table: location

 Content of [location]
username(str) domain(str,null) contact(str,null) expires(int,null)
q(double,n ull) callid(str,null) cseq(int,null) last_modified(str)
replicate(int,null) s tate(int,null) flags(int) user_agent(str)
received(str)
 0(0) DBT:dbt_get_refs: ERROR column <socket> not found
 0(0) DBT:dbt_query: error while querying table!
 0(0) preload_udomain(): Error while doing db_query
 0(0) register_udomain(): Error while preloading domain 'location'
 0(0) domain_fixup(): Error while registering domain
ERROR: error -1 while trying to fix configuration
 0(0) DEBUG: tm_shutdown : start
 0(0) DEBUG: unlink_timer_lists : emptying DELETE list
 0(0) DEBUG: tm_shutdown : emptying hash table
 0(0) DEBUG: tm_shutdown : releasing timers
 0(0) DEBUG: tm_shutdown : removing semaphores
 0(0) DEBUG: tm_shutdown : destroying tmcb lists
 0(0) DEBUG: tm_shutdown : done
 0(0) DBT:destroy ...
 0(7157) shm_mem_destroy
 0(7157) destroying the shared memory lock

My tables are configured as follow:

version

table_name(str) table_version(int)
subscriber:3
location:6
aliases:6

subscriber

username(str) domn(str) password(str) first_name(str) last_name(str)
phone(str) email_address(str) datetime_created(int)
datetime_modified(int) confirmation(str) flag(str)
sendnotification(str) greeting(str) ha1(str) ha1b(str) perms(str)
allow_find(str) timezone(str,null) rpid(str,null) uuid(str,null)

location

username(str) domain(str,null) contact(str,null) expires(int,null)
q(double,null) callid(str,null) cseq(int,null) last_modified(str)
replicate(int,null) state(int,null) flags(int) user_agent(str)
received(str)

aliases

username(str) domain(str,null) contact(str,null) expires(int,null)
q(double,null) callid(str,null) cseq(int,null) last_modified(str)
replicate(int,null) state(int,null) flags(int) user_agent(str)
received(str)


Uou! It's hard to start...   :-)

Any help?


Best regards
-- 
Alexandre Passito
Universidade Federal do Amazonas
Departamento de Ciência da Computação
LabVoIP - GRSD