12 Aug
2015
12 Aug
'15
9:54 p.m.
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(a)lists.sip-router.org>
Subject: Re: [SR-Users] XCap Server + Postgre
Sure I have. But no field 'extension' in it
среда, 12 августа 2015 г. пользователь Asgaroth <00asgaroth00(a)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(a)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
--
Best regards,
Igor