Yes, it seems it is looking for different database path -- can you
double check to be sure you set db_url properly for all modules?
Cheers,
Daniel
On 08/05/15 15:50, jaflong jaflong wrote:
Thanks, I got slightly more debug
0(3933) DEBUG: <core> [route.c:907]: fix_actions(): fixing save()
0(3933) INFO: db_text [dbt_base.c:99]: dbt_init(): using database at:
/usr/local/etc/kamailio/ 0(3933) DEBUG: db_text [dbt_lib.c:129]: dbt_cache_get_db():
looking for db /usr/local/etc/kamailio/!
0(3933) DEBUG: db_text [dbt_lib.c:150]: dbt_cache_get_db(): new db!
0(3933) DEBUG: db_text [dbt_file.c:102]: dbt_load_file(): request for table [version]
0(3933) DEBUG: db_text [dbt_file.c:109]: dbt_load_file(): db is
[/usr/local/etc/kamailio/]
0(3933) DEBUG: db_text [dbt_file.c:124]: dbt_load_file(): loading file
[/usr/local/etc/kamailio/]
0(3933) DEBUG: db_text [dbt_tb.c:187]: dbt_table_new(): mtime is 1431092741
0(3933) ERROR: db_text [dbt_base.c:207]: dbt_query(): table version not loaded! (too few
columns)
0(3933) ERROR: db_text [dbt_base.c:306]: dbt_query(): failed to query the table!
shouldnt this
"using database at: /usr/local/etc/kamailio/ 0(3933) " be like be
/usr/local/etc/kamailio/dbtext?
it seems it cant find dbtext?
Any help please
08.05.2015, 16:35, "Daniel-Constantin Mierla" <miconda(a)gmail.com>om>:
> 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(a)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
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)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