Dear all, I have some studpid problem again
i use gnugk + freeradius + sqlbill , i thaing every thing is ok, it can control soft phone (ohphone or myphone)
BUT it cannot control cisco ATA 186 , if credit is empty it cannot disconnect it ;
this is my config of gnugk.ini
-----------------------// start //
[Gatekeeper::Main]
Fourtytwo=42
Name=eieiGK
TimeToLive=300
[RoutedMode]
GKRouted=1
H245Routed=1
;CallSignalPort=1721
CallSignalHandlerNumber=2
RemoveH245AddressOnTunneling=0
AcceptNeighborsCalls=1
AcceptUnregisteredCalls=0
SupportNATedEndpoints=1
DropCallsByReleaseComplete=1
RemoveCallOnDRQ=1
SendReleaseCompleteOnDRQ=1
[Proxy]
Enable=1
InternalNetwork=192.168.1.0/24
ProxyForNAT=1
[RoutingPolicy]
default=explicit,internal,parent,neighbor
[GkStatus::Auth]
rule=explicit | regex
regex=^(192\.168\.1\.[3-4]+)$
127.0.0.1=allow
default=forbid
[RasSrv::RRQFeatures]
OverwriteEPOnSameAddress=1
AcceptEndpointIdentifier=0
[RasSrv::ARQFeatures]
ArjReasonRouteCallToSCN=0
ArjReasonRouteCallToGatekeeper=1
;CallUnregisteredEndpoints=0
[RasSrv::PermanentEndpoints]
;192.168.1.88=111
;192.168.1.44=111
192.168.1.254=Primus;1,2,3,4,5,6,7,8,9
[Gatekeeper::Auth]
RadAuth=optional;RRQ,ARQ
SQLAliasAuth=required;RRQ
default=allow
[Gatekeeper::Acct]
RadAcct=required;start,update,stop,on,off
;SQLAcct=required;start,update,stop
[RadAuth]
Servers=192.168.1.99
SharedSecret=maibok23
AppendCiscoAttributes=1
IncludeTerminalAliases=1
IncludeEndpointIP=1
[RadAcct]
Servers=192.168.1.99
SharedSecret=maibok23
AppendCiscoAttributes=1
IncludeEndpointIP=1
[SQLAliasAuth]
Driver=PostgreSQL
Host=192.168.1.6
Database=gogoauth
Username=adminpg
Password=maibok78
Query=SELECT CASE WHEN u.framedip IS NOT NULL THEN 'allow' ELSE 'sigip:' || host(u.framedip) END FROM voipuser u JOIN voipaccount a ON u.accountid = a.id WHERE u.h323id = '%1' AND NOT u.disabled AND NOT a.disabled AND a.closed IS NULL
------------- // end //
and other config is same sqlbill i change for user /password / ip only
What wrong i do ?
thank you very much
---------------
Phiphat Watanasard [KLIM]
+66-1-8050678
-----------------------------------------
Original Message:
From: Zygmuntowicz Michal <m.zygmuntowicz@xxxxxxx>
To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Sent: Thu Oct 14 01:25:28 PDT 2004
Subject: Re: about freeradius and postgresql and gnuGK
It should be rather "voipradattr". But this is cosmetics only
- the authcheck_table and authreply_table macros are not
used by sqlbill.
Regarding the configuration you have almost ready scripts
in the conf dir.
----- Original Message -----
From: "Phiphat Klim Watanasard" <klim@xxxxxxxxxx>
Sent: Thursday, October 14, 2004 1:50 AM
> I dont under stan about postgresql.conf
> authcheck_table = "tpradattr"
> authreply_table = "tpradattr"
> i cannot find tpradattr table in sql statement in src directory;
> how does it work ?
> and i want to config with RadAliasAuth , Can you help me for config of
> freeraidus or postgreaql
> thank you very much
> ---------------
> Phiphat Watanasard [KLIM]
> +66-1-8050678
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
This E-mail message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying or distribution of this message, or the taking of any action based on it, is strictly prohibited. If you received this message in error, please contact the sender immediately by replying to this message and delete this message from your computer. Thank you.
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
