On Sunday 15 August 2004 18:24, Ing. Malosek Pavol wrote: try set up the postgresql log in the postgresql data directory file postgresql.conf than you will see the sql query that is reaching in the database than it is easy to fix .... Sergio > hello > I have 2 Welltech Lan Phone 201 and gnugk on a linux box /debian 3.0, > 2.6.6 kernel/. I have donloaded binary gnugk 2.0.8 from www.gnugk.org > > GK works fine till I want to set SQLPasswordAuth, I think I have tryed > all I know and I'm still recieving > > 1 RasSrv.cxx(1002) GK RRQ Received > 1 h235auth.cxx(525) H235RAS H235AuthSimpleMD5 digest does not match. > 2 gkauth.cxx(448) GkAuth SQLPasswordAuth check failed > > and > > RRJ|200.0.10.204|ladnicka2:h323_ID=102:dialedDigits=202:dialedDigits|terminal|securityDenial; > RRJ|200.0.10.104|ladnicka1:h323_ID=104:dialedDigits=204:dialedDigits|terminal|securityDenial; > RRJ|200.0.10.204|ladnicka2:h323_ID=102:dialedDigits=202:dialedDigits|terminal|securityDenial; > RRJ|200.0.10.104|ladnicka1:h323_ID=104:dialedDigits=204:dialedDigits|terminal|securityDenial; > > I have created simple table just > > CREATE TABLE voipusers ( h323id varchar(40) unique,password varchar(30)); > > I have put plain passwords and h323ids in table. > > and my gnugk looks: > > [Gatekeeper::Main] > Fourtytwo=42 > Name=PalmaGK > TimeToLive=60 > > [GkStatus::Auth] > rule=allow > > [Gatekeeper::Auth] > SQLPasswordAuth=required;RRQ > default=allow > > [SQLPasswordAuth] > Driver=PostgreSQL > Host=localhost > Database=voipdb > Username=name > Password=passwd > Query=SELECT password from voipusers where h323id = '%1' > > ---------------- > > thanks in advance for any kind of help > > malo > > > > > ------------------------------------------------------- > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > > _______________________________________________________ > > List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > Homepage: http://www.gnugk.org/ > ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
