[OpenSIPS-Devel] OpenSIPS 1.11.2 and aliases table

[Răzvan Crainea]

Hi, Steve!

Your problem is that the aliases table was not alinged to the location 
table. I have fixed this on all affected versions. However, it is very 
unlikely we will support this table in the future releases, since this 
functionality has been fully implemented by the alias_db module[1]. So 
you'd better consider updating your script.

[1] http://www.opensips.org/html/docs/modules/1.12.x/alias_db

Best regards,

Răzvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com

On 09/18/2014 12:16 AM, Steve Ames wrote:
>
> I vaguely recall this happening in 1.8.2 also but…
>
> Completely fresh 1.11.2 install. Getting the following error:
>
> Sep 17 17:05:48 [6151] ERROR:core:db_check_table_version: invalid 
> version 1007 for table aliases found, expected 1009
>
> Sep 17 17:05:48 [6151] ERROR:usrloc:register_udomain: error during 
> table version check.
>
> Versions table does show 1007.
>
> Registrar-create.sql shows the following:
>
> INSERT INTO version (table_name, table_version) values ('aliases','1007');
>
> CREATE TABLE aliases (
>
> id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
>
> username CHAR(64) DEFAULT '' NOT NULL,
>
> domain CHAR(64) DEFAULT NULL,
>
> contact CHAR(255) DEFAULT '' NOT NULL,
>
> received CHAR(128) DEFAULT NULL,
>
> path CHAR(128) DEFAULT NULL,
>
> expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL,
>
> q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
>
> callid CHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
>
> cseq INT(11) DEFAULT 13 NOT NULL,
>
> last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
>
> flags INT(11) DEFAULT 0 NOT NULL,
>
> cflags INT(11) DEFAULT 0 NOT NULL,
>
> user_agent CHAR(255) DEFAULT '' NOT NULL,
>
> socket CHAR(64) DEFAULT NULL,
>
> methods INT(11) DEFAULT NULL,
>
> sip_instance CHAR(255) DEFAULT NULL,
>
> CONSTRAINT alias_idx UNIQUE (username, domain, contact, callid)
>
> ) ENGINE=MyISAM;
>
> It seems to be missing the ‘attr’ column that 1009 requires.
>
>
>
> _______________________________________________
> Devel mailing list
> Devel at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20141006/051cb005/attachment.htm>