Dear Alexandr,
Appreciated!
Thx,
Misi
On 2013-04-02 18:06, Alexandr Dubovikov wrote:
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…
we will fix FAQ ASAP.
Wbr,
Alexandr
2013/4/2 MÉSZÁROS Mihály <misi(a)niif.hu <mailto:misi@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