[OpenSIPS-Users] Version of aliases table in v1.8.2

[Bogdan-Andrei Iancu]

Hi John,

You are right. I (1) misread the name of the faulty table and (2) 
completely forgot about the "aliases" table (thought no one is using it 
:) ).

I made the appropriate fix, it will be reflected later in the tarball 
(they are nightly re-generated). If you need a patch, you can generated 
from here:
     http://opensips.svn.sourceforge.net/opensips/?rev=9430&view=rev

Thanks and regards !

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 11/06/2012 10:12 PM, John Quick wrote:
> Hi Bogdan,
>
> It is a standard table, not a custom one.
> Using opensips-1.8.2_src.tar.gz downloaded from opensips.org
> Untarred it in /usr/src
> The script that is wrong is
> /usr/src/opensips-1.8.2-tls/scripts/mysql/registrar-create.sql
> This script is used when you run "opensipsdbctl create"
> It creates the table called opensips.aliases and inserts a row in
> opensips.version with "values ('aliases','1005')"
> The first time I ran opensips v1.8.2 it failed to start and gave error:
> "core:db_check_table_version: invalid version 1005 for table aliases found,
> expected 1007"
> So I manually changed the value in opensips.version from 1005 to 1007 so I
> could start opensips
> Then I got the new errors shown in my first post below.
> I added a field sip_instance to the aliases table and now opensips runs
> without errors.
>
> By the way, I had already installed v1.8.1 on this server beforehand, but I
> do not think this can be relevant because I upgraded to OpenSIPS v1.8.2
> *before* I created the opensips database in MySQL. I also ran "make clean"
> from the 1.8.1 directory and then from the 1.8.2 directory, before running
> 'make' and 'make install'.
>
> John
>
>
> -----Original Message-----
> From: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
> Sent: 06 November 2012 17:51
> To: john.quick at smartvox.co.uk; OpenSIPS users mailling list
> Subject: Re: [OpenSIPS-Users] Version of aliases table in v1.8.2
>
> Hi John,
>
> But this "sip_instance" is not a standard table, right ? you use it custom
> from script or ?
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
>
>
> On 11/06/2012 05:01 PM, John Quick wrote:
>> I am trying to install and run v1.8.2 but there seems to be a problem
>> with the structure/version of the aliases table.
>> The table created by the scripts is version 1005, but the program
>> wants version 1007.
>> I think there should be an extra field in 1007 - sip_instance. It is
>> not present in scripts/mysql/registrar-create.sql
>>
>> My log file has the following error on startup:
>> 2012-11-06 14:20:06  CRITICAL:db_mysql:wrapper_single_mysql_real_query:
>> driver error (1054): Unknown column 'sip_instance' in 'field list'
>> 2012-11-06 14:20:06  ERROR:core:db_do_query: error while submitting
>> query - [select
>> username,contact,expires,q,callid,cseq,flags,cflags,user_agent,receive
>> d,path ,socket,methods,last_modified,sip_instance from aliases ]
>> 2012-11-06 14:20:06  ERROR:usrloc:preload_udomain: db_query (1) failed
>> 2012-11-06 14:20:06  ERROR:usrloc:child_init: child(1): failed to
>> preload domain 'aliases'
>> 2012-11-06 14:20:06  ERROR:core:init_mod_child: failed to initializing
>> module usrloc, rank 1
>> 2012-11-06 14:20:06  ERROR:core:main_loop: init_child failed for UDP
>> listener
>>
>> John Quick
>> Smartvox Limited
>> Web: www.smartvox.co.uk
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>