Hello, in tables 'location' and 'aliases' you have to add a new column 'socket(str,null)'. The structure would be like:
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) socket(str,null)
I will update the documentation to reflect this.
Daniel
On 06/25/05 19:34, Alexandre Passito wrote:
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