Hi!
I'm experience really strange behavior of Kamailio.
Right now it's using postgre database
When trying to implement XCAP server capabilities, according to
http://kamailio.org/docs/modules/4.3.x/modules/xcap_server.html#idp76784
on a block
if (!www_authorize("xcap", "subscriber"))
{
www_challenge("xcap", "0");
exit;
}
While trying to test it via browser (user test, pass test)
I've got these errors in log
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed
with code 7 (PGRES_FATAL_ERROR)
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:239]: db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR: relation "subscriber" does not
exist#012LINE 1: select password from subscriber where extension='test' AND
u...#012 ^#012]
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed
with code 7 (PGRES_FATAL_ERROR)
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:239]: db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR: relation "subscriber" does not
exist#012LINE 1: select password from subscriber where extension='test' AND
u...#012 ^#012]
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:235]: db_postgres_submit_query(): postgres result check failed
with code 7 (PGRES_FATAL_ERROR)
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: WARNING: db_postgres
[km_dbase.c:239]: db_postgres_submit_query(): postgres query command
failed, connection status 0, error [ERROR: relation "subscriber" does not
exist#012LINE 1: select password from subscriber where extension='test' AND
u...#012 ^#012]
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: ERROR: db_postgres
[km_dbase.c:247]: db_postgres_submit_query(): 0x7f3fb0660b10 PQsendQuery
Error: ERROR: relation "subscriber" does not exist#012LINE 1: select
password from subscriber where extension='test' AND u...#012
^#012 Query: select password from subscriber where
extension='test' AND user_context='xcap'
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: ERROR: <core>
[db_query.c:132]: db_do_query_internal(): error while submitting query
Aug 12 12:34:57 sip01 /usr/sbin/kamailio[7655]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
Without this block, I don't get user auth.
Is it a bug or it's mine misconfiguration?
--
Best regards,
Igor