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?
Hi Igor,
I personally don’t use the xcap module, but looking at that error message, it seems to me that Kamailio cannot find the subscriber table which it will use to lookup the authentication details.
Are you sure you have your Kamailio database and Kamailio database related settings setup properly?
Cheers
From: sr-users [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Igor Olhovskiy Sent: Wednesday 12 August 2015 11:37 To: sr-users@lists.sip-router.org Subject: [SR-Users] XCap Server + Postgre
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?
Sure I have. But no field 'extension' in it
среда, 12 августа 2015 г. пользователь Asgaroth 00asgaroth00@gmail.com написал:
Hi Igor,
I personally don’t use the xcap module, but looking at that error message, it seems to me that Kamailio cannot find the subscriber table which it will use to lookup the authentication details.
Are you sure you have your Kamailio database and Kamailio database related settings setup properly?
Cheers
*From:* sr-users [mailto:sr-users-bounces@lists.sip-router.org javascript:_e(%7B%7D,'cvml','sr-users-bounces@lists.sip-router.org');] *On Behalf Of *Igor Olhovskiy *Sent:* Wednesday 12 August 2015 11:37 *To:* sr-users@lists.sip-router.org javascript:_e(%7B%7D,'cvml','sr-users@lists.sip-router.org'); *Subject:* [SR-Users] XCap Server + Postgre
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
That’s odd, the error message
‘ERROR: relation "subscriber" does not exist’
Seems to imply that Kamailio cannot find that table, if it couldn’t find the column, I would have expected something like:
‘ERROR: column "extension" does not exist’
We use postgresql here too with Kamailio, but I’ve not used it with the xcap server module.
I’d investigate that issue first (where it is not finding the table)
Sorry I cannot provide more info, as I’ve not setup the xcap stuff myself.
Cheers
From: sr-users [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Igor Olhovskiy Sent: Wednesday 12 August 2015 18:11 To: Kamailio (SER) - Users Mailing List sr-users@lists.sip-router.org Subject: Re: [SR-Users] XCap Server + Postgre
Sure I have. But no field 'extension' in it
среда, 12 августа 2015 г. пользователь Asgaroth <00asgaroth00@gmail.com mailto:00asgaroth00@gmail.com > написал:
Hi Igor,
I personally don’t use the xcap module, but looking at that error message, it seems to me that Kamailio cannot find the subscriber table which it will use to lookup the authentication details.
Are you sure you have your Kamailio database and Kamailio database related settings setup properly?
Cheers
From: sr-users [mailto:sr-users-bounces@lists.sip-router.org javascript:_e(%7B%7D,'cvml','sr-users-bounces@lists.sip-router.org'); ] On Behalf Of Igor Olhovskiy Sent: Wednesday 12 August 2015 11:37 To: sr-users@lists.sip-router.org javascript:_e(%7B%7D,'cvml','sr-users@lists.sip-router.org'); Subject: [SR-Users] XCap Server + Postgre
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?
-
Asgaroth -
Igor Olhovskiy