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" <mico...@gmail.com>: >> 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@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@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
