Re: [SR-Users] XCap Server + Postgre

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(a)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