Re: SQLPasswodrAuth problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi all
I compliled pwlib and openh323 and gate keeper as well, but with the same resutls.
I started to play with SqlAliasAuth with postgresql but it does not work at all.
I'm a little confused now if I'm doing some BIG mistake(s) but where. should I use mysql or radius auth???? or it has to work with pgsql as well???
thanks
 
malo
 
 
DATABASE
voipdb-> ;
  h323id   | password |        authrule
-----------+----------+-------------------------
 ladnicka1 | passwd   | sigip:200.0.10.104:1070
 ladnicka2 | secret   | sigip:200.0.10.204:1070
(2 rows)
CONFIG
[Gatekeeper::Main]
Fourtytwo=42
Name=PalmaGK
TimeToLive=60
 
[RoutedMode]
GKRouted=1
H245Routed=0
 
[Proxy]
Enable=0
 
[GkStatus::Auth]
rule=allow
 
[Gatekeeper::Auth]
SQLAliasAuth=sufficient;RRQ
default=allow
 
[SQLAliasAuth]
Driver=PostgreSQL
Host=localhost
Database=voipdb
Username=gkradius
Password=gkradius
Query=SELECT authrule from voipusers where h323id='%1'
LOG
RasSrv.cxx(1002)  GK      RRQ Received
gksql.cxx(309)   SQLAliasAuth    Executing query: SELECT authrule from voipusers where h323id='ladnicka2'
gkauth.cxx(1804)  Gk      RRQAuth condition 'sigip:200.0.10.204:1070' rejected endpoint ladnicka2
gkauth.cxx(448)   GkAuth  SQLAliasAuth check failed
RasSrv.cxx(1295)  RRJ|200.0.10.204|ladnicka2:h323_ID=102:dialedDigits=202:dialedDigits|terminal|securityDenial;
RasSrv.cxx(2332)  GK      Send to 200.0.10.204:1024
 


[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux