Hi Bogdan, Perfect. Strange that it continues to work on the "full" system with 'auto'. I thought for sure it was something to do with the embedded Atom box.
I'll start a new thread soon with the dialog restore problem. - Jeff On Tue, Oct 22, 2013 at 9:37 AM, Bogdan-Andrei Iancu <[email protected]>wrote: > ** > 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 Developerhttp://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 > [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
