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