[SR-Users] db_text error

[Daniel-Constantin Mierla]

Hello,

set debug=3 in kamailio.cfg and test again, you should get more details
about what kamailio tried to do and what is the potential error (maybe
some empty line).

Cheers,
Daniel

On 08/05/15 14:53, jaflong jaflong wrote:
>
> 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
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com