[sr-dev] sipcapture sql anomaly
Alexandr Dubovikov
alexandr.dubovikov at gmail.com
Tue Apr 2 18:06:27 CEST 2013
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>
More information about the sr-dev
mailing list