Sure I have. But no field 'extension' in it среда, 12 августа 2015 г. пользователь Asgaroth <00asgarot...@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-boun...@lists.sip-router.org > <javascript:_e(%7B%7D,'cvml','sr-users-boun...@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 > -- Best regards, Igor
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
