[SR-Users] db_text error

[jaflong jaflong]

db_text error

I am getting the following error on using db_text

 0(6638) INFO: db_text [dbt_base.c:99]: dbt_init(): using database at: /usr/local/etc/kamailio/ 0(6638) ERROR: db_text [dbt_base.c:207]: dbt_query(): table version not loaded! (too few columns)
 0(6638) ERROR: db_text [dbt_base.c:306]: dbt_query(): failed to query the table!


I have thisin my kamailio.cfg
#!define DBURL "text:///usr/local/etc/kamailio/dbtext"


I created the following files

cat > /usr/local/etc/kamailio/dbtext/version

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


cat > /usr/local/etc/kamailio/dbtext/subscriber

username(str) password(str) ha1(str) domain(str) ha1b(str)
someuser:someuser:xxx:10.1.1.5:xxx

can some advise how to get db_text work for me


Regards