[Users] Problem with db_text module

[Daniel-Constantin Mierla]

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
>  
>