[OpenSIPS-Users] dbtext problem with dialog table initialization on Voyage Linux

[Jeff Pyle]

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
<bogdan at opensips.org>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 <bogdan at opensips.org>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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131022/c9c8186c/attachment-0001.htm>