Mystery solved. It's not working here either. I missed it before because logging shows up differently in this environment.
- Jeff On Tue, Oct 22, 2013 at 10:50 AM, Bogdan-Andrei Iancu <[email protected]>wrote: > ** > 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 Developerhttp://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]>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
