[sr-dev] sipcapture sql anomaly

[Alexandr Dubovikov]

Hi Mihaly,

yes, you should use new SQL schema (Version 2) there we use "auth" field to
be compatible with PostgresSQL.

https://code.google.com/p/homer/source/browse/sql/create_sipcapture_version_2.sql

we will fix FAQ ASAP.

Wbr,
Alexandr





2013/4/2 MÉSZÁROS Mihály <misi at niif.hu>

>  Hi Alexandr,
>
> I find few anomalies regarding sipcapture modul.
> May you could correct it?
>
> Issues i found:
>
>    1. kamailio-4.0.0/modules/sipcapture/sql/create_sipcapture.sql in
>    table sip_trace.
>
>    	`auth` varchar(256) NOT NULL,
>
>    but on page
>
>    http://code.google.com/p/homer/source/browse/sql/create_sipcapture.sql
>
>    	`authorization` varchar(256) NOT NULL,
>
>    So what is the correct?
>    I am experiencing problem if i use git version of homer.
>     db_mysql [km_dbase.c:122]: driver error on query: Unknown column
>    'auth' in 'field list'
>     2. on  http://kamailio.org/docs/modules/4.0.x/modules/sipcapture.html
>
>    6. Database setup
>    Before running Kamailio with the sipcapture module, you have to setup
>    the database tables where the module will store the data. For that, if the
>    table were not created by the installation script or you choose to install
>    everything by yourself you can use the sipcapture_create.sql, SQL script in
>    the sql folder of sipcapture module as template. You can also find the
>    complete database documentation on the project webpage,
>    http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html.
>
>    I couldn't find any information about sipcapture database on this
>    page, not even the complete db doc:
>    http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html
>
> Many Thanks,
> Misi
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130402/7ebc931f/attachment.htm>