Hi Jeff, Maybe a different version? - the change was done with 1.9 version. Previously, the dlg_int was int and auto incremented by DB. Starting with 1.9 the dlg_int is computed and filled in by OpenSIPS as DB long.
Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/22/2013 05:47 PM, Jeff Pyle wrote: > 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] <mailto:[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 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] <mailto:[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
