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

[John Quick]

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
>