Hi Jeff, Indeed, the flag "auto" should not be there starting with 1.9 . It seems DB_TEXT spec file was not updated :(, but I took care of that now - GIT is up to date.
So, let's move the next issue, when auto is removed :) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/22/2013 06:55 AM, Jeff Pyle wrote: > Hello, > > On 1.9 I'm seeing the following problem loading the dialog table from > dbtext at startup: > > DBG:db_text:dbt_load_file: request for table [dialog] > DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext] > DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog] > DBG:db_text:dbt_table_new: mtime is 1382412942 > DBG:db_text:dbt_load_file: column[0] is BIGINT! > DBG:db_text:dbt_load_file: error at row=0 col=0 c=a > ERROR:db_text:dbt_query: table does not exist! > ERROR:dialog:select_entire_dialog_table: Error while querying database > ERROR:db_text:dbt_free_result: invalid parameter value > DBG:db_text:dbt_load_file: request for table [dialog] > DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext] > DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog] > DBG:db_text:dbt_table_new: mtime is 1382412942 > DBG:db_text:dbt_load_file: column[0] is BIGINT! > DBG:db_text:dbt_load_file: error at row=0 col=0 c=a > ERROR:db_text:dbt_delete: failed to load table <dialog>! > ERROR:dialog:remove_all_dialogs_from_db: failed to delete database > information > WARNING:dialog:init_dlg_db: failed to properly remove all the > dialogs form DB > > > The contents of the dialog file are from the source tree file > scripts/dbtext/opensips/dialog: > > dlg_id(long,auto) callid(string) from_uri(string) from_tag(string) > to_uri(string) to_tag(string) mangled_from_uri(string,null) > mangled_to_uri(string,null) caller_cseq(string) > callee_cseq(string) caller_ping_cseq(int) callee_ping_cseq(int) > caller_route_set(string,null) callee_route_set(string,null) > caller_contact(string) callee_contact(string) caller_sock(string) > callee_sock(string) state(int) start_time(int) timeout(int) > vars(string,null) profiles(string,null) script_flags(int) flags(int) > > > Above I see "error at row=0 col=0 c=a" which leads me to believe it > doesn't like the 'auto' in the dlg_id declaration. Indeed, if I > remove the 'auto' flag it starts okay. But dialogs saved to the table > don't match if Opensips has been restarted during the dialog's life. > I don't know if this is related to the absence of the 'auto' flag. > One problem at a time. > > This is on Voyage Linux 0.9 64-bit on an Intel Atom board. Exactly > the same Opensips .deb packages with exactly the same dbtext directory > running on a "normal" Debian 7 system do not cause this error. The > only difference I am aware of is on the Voyage/Atom system the dbtext > directory is in a ramdisk while on the Debian 7 system it's on a > normal disk. > > Any thought what might cause the 'auto' flag to throw an error in this > environment? > > > - Jeff > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
