Can't create unknown class SQLAcct
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
I have compiled gnugk 2.2beta5 from CVS with the follwing options ...
HAS_ACCT=1 NO_LDAP=1 NO_RADIUS=1 NO_PGSQL=1 LARGE_FDSET=1 make both
I ran gatekeeper with the following cmd ..
./gnugk -r -c gnugk.ini -tttt
I get the following message ....
factory.h Init Can't Create Unknown class SQLAcct
What could be the problem ? Is my config right ? is there a better way to do
mysql-accouting, if so can someone please give me the mysql schema and config
to
do so ?
Thanks in advance ...
-rahul
my gatekeeper.ini file has the following ...
[Gatekeeper::Main]
Fourtytwo=42
Name=SifyGK
EndpointIDSuffix=_sifygnugk1
StatusPort=7000
TimeToLive=480
TotalBandwidth=-1
[RoutedMode]
GKRouted=1
H245Routed=0
CallSignalPort=1720
CallSignalHandlerNumber=2
RemoveH245AddressOnTunneling=1
AcceptNeighborsCalls=0
AcceptUnregisteredCalls=0
DropCallsByReleaseComplete=1
SendReleaseCompleteOnDRQ=1
SupportNATedEndpoints=1
Q931PortRange=20000-20020
H245PortRange=30000-30010
ConnectTimeout=60000
[Proxy]
Enable=1
#InternalNetwork=192.168.1.127/255.255.255.128, 192.168.1.255/255.255.255.128
T120PortRange=1024-65535
RTPPortRange=1024-65535
ProxyForNAT=1
ProxyForSameNAT=0
[GkStatus::Auth]
rule=allow
Shutdown=forbid
#KeyFilled=11
[RasSrv::GWPrefixes]
[RasSrv::RewriteE164]
[RasSrv::PermanentEndpoints]
[RasSrv::Neighbors]
[RasSrv::LRQFeatures]
NeighborTimeout=2
ForwardHopCount=2
IncludeDestinationInfoInLCF=1
CiscoGKCompatible=1
[RasSrv::RRQFeatures]
AcceptGatewayPrefixes=1
OverwriteEPOnSameAddress=1
[RasSrv::ARQFeatures]
ArjReasonRouteCallToSCN=1
ArjReasonRouteCallToGatekeeper=1
CallUnregisteredEndpoints=0
RemoveTrailingChar=#
[CallTable]
GenerateNBCDR=1
GenerateUCCDR=0
DefaultCallDurationLimit=0
AcctUpdateInterval=60
[EndPoint]
Gatekeeper=no
Type=Gateway
RRQRetryInterval=10
ARQTimeout=2
[Endpoint::RewriteE164]
[Gatekeeper::Auth]
#SimplePasswordAuth=optional;RRQ
#AliasAuth=optional;RRQ
SQLPasswordAuth=optional;RRQ
SQLAliasAuth=required;RRQ
default=allow
#[Password]
#KeyFilled=123
#PasswordTimeuot=120
[RasSrv::RRQAuth]
MYEP5=allow
[SQLPasswordAuth]
Driver=MySQL
Host=localhost
Database=gkcontrol
Username=gnugk
Password=secret
CacheTimeout=300
Query=SELECT h235password FROM users WHERE alias = '%1' AND IS active
[SQLAliasAuth]
Driver=MySQL
Host=localhost
Database=gkcontrol
Username=gnugk
Password=secret
CacheTimeout=300 Query=SELECT IF(LENGTH(TRIM(authcond)), authcond,
CONCAT('sigip:',host, IF(port, CONCAT(':',port),''))) as authrule FROM users
WHERE alias = '%1' AND GatekeeperId = '%2' AND active
[Gatekeeper::Acct]
SQLAcct=required
[SQLAcct]
Driver=MySQL
Host=localhost
Database=gkcontrol
Username=gnugk
Password=secret
MinPoolSize=5 #StartQuery=INSERT INTO call (gkname, sessid, callno, username,
calling, called, duration, disconnectcause) VALUES ('%g', '%s', %n, '%u',
'%{Calling-Station-Id}', '%{Called-Station-Id}', %d, %c) StartQueryAlt=UPDATE
call SET username = '%u', calling = '%{Calling-Station-Id}', called =
'%{Called-Station-Id}', duration = %d, disconnectcause = %c WHERE gkname = '%g'
AND sessid = '%s'
UpdateQuery=UPDATE call SET duration = %d WHERE gkname = '%g' AND sessid = '%s'
#StopQuery=UPDATE call SET username = '%u', calling = '%{Calling-Station-Id}',
called = '%{Called-Station-Id}', duration = %d, disconnectcause = %c WHERE
gkname = '%g' AND sessid = '%s' #StopQueryAlt=INSERT INTO call (gkname, sessid,
callno, username, calling, called, duration, disconnectcause) VALUES ('%g',
'%s', %n, '%u', '%{Calling-Station-Id}', '%{Called-Station-Id}', %d, %c)
--------------------------------------------------
[Index of Archives]
[SIP]
[Open H.323]
[Gnu Gatekeeper]
[Asterisk PBX]
[ISDN Cause Codes]
[Yosemite News]