Hello,
Thanks for your quick reply Mr. Michal... I have made the change but still having the same problem..for your better idea.. i m attaching this config file as well as log file..
Please help for this..
Thanks,
Jigar Thakkar.
text/plain
[Gatekeeper::Main]
Fourtytwo=42
Name=JIGARS
TimeToLive=800
StatusPort=1800
#[RoutedMode]
#GKRouted=1
#H245Routed=1
#SupportNATedEndpoints=1
[GkStatus::Auth]
rule=allow
[CallTable]
AcctUpdateInterval=60
[Gatekeeper::Auth]
SQLPasswordAuth=required;RRQ,ARQ
[Gatekeeper::Acct]
SQLAcct=required;start;update;stop
FileAcct=required;start;update;stop
[FileAcct]
DetailFile=c:\jigar\call.log
TimeStampFormat=MySQL
StandardCDRFormat=0
CDRString=%g|%n|%d|%r|%c|%s|%u|%{CallId}|%{ConfId}|%{setup-time}|%{connect-time}|%{disconnect-time}|%{caller-ip}|%{callee-ip}|%{Dialed-Number}|%{Called-Station-Id}
Rotate=hourly
RotateTime=45
[SQLPasswordAuth]
Driver=MySQL
Host=localhost
Database=billing
Username=root
Password=root
MinPoolSize=5
Query=SELECT password FROM customer WHERE IPN = '%1'
[SQLAcct]
Driver=MySql
Host=localhost
Database=billing
Username=root
Password=root
MiniPoolSize=5
StopQuery=INSERT INTO cdrs (DateTimeInserted, Gatekeeper_Name, Call_Number, Call_Duration, ReleasedBy, Disconnect_Cause, Acct_Session_ID, H323_ID, Call_ID, Conf_ID, Setup_Time, Connect_Time, Disconnect_Time, Caller_IP, Callee_IP, Calling_Station_ID, Called_Station_ID) VALUES (NOW(),'%g', '%n', '%d', '%r', '%c', '%s', '%u', '%{CallId}', '%{ConfId}', '%{setup-time}', '%{connect-time}', '%{disconnect-time}', '%{caller-ip}', '%{callee-ip}', '%{Dialed-Number}', '%{Called-Station-Id}')
StopQueryAlt=INSERT INTO cdrs (DateTimeInserted, Gatekeeper_Name, Call_Number, Call_Duration, ReleasedBy, Disconnect_Cause, Acct_Session_ID, H323_ID, Call_ID, Conf_ID, Setup_Time, Connect_Time, Disconnect_Time, Caller_IP, Callee_IP, Calling_Station_ID, Called_Station_ID) VALUES (NOW(),'%g', '%n', '%d', '%r', '%c', '%s', '%u', '%{CallId}', '%{ConfId}', '%{setup-time}', '%{connect-time}', '%{disconnect-time}', '%{caller-ip}', '%{callee-ip}', '%{Dialed-Number}', '%{Called-Station-Id}')
[CallTable]
GenerateNBCDR=FALSE
GenerateUCCDR=TRUE
DefaultCallDurationLimit=86400
#[Endpoint]
#Gatekeeper=203.145.190.3
#Type=Terminal
#H323ID=999002408|338168
[RasSrv::LRQFeature]
AcceptForwardLRQ=1
IncludeDestinationInfoInLCF=1
AlwaysForwardLRQ=1
[RasSrv::RRQFeature]
AcceptEndpointIdentifier=1
AcceptGatewayPrefix=1
OverwriteEPpnSameAddress=1
[RasSrv::ARQFeature]
ArjReasonRoutedCallToSCN=1
ArjReasonRoutedCallToGatekeeper=1text/plain
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=127.0.0.0/255.0.0.0, IP=127.0.0.1
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=202.160.163.160/255.255.255.224, IP=202.160.163.167
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=202.160.163.167/255.255.255.255, IP=127.0.0.1
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=202.160.163.255/255.255.255.255, IP=202.160.163.167
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=224.0.0.0/224.0.0.0, IP=202.160.163.167
2005/03/07 19:58:59.484 2 Toolkit.cxx(96) Network=255.255.255.255/255.255.255.255, IP=202.160.163.167
2005/03/07 19:58:59.484 2 Toolkit.cxx(97) Default IP=202.160.163.167
2005/03/07 19:58:59.484 2 Toolkit.cxx(159) GK H.323 Proxy disabled
2005/03/07 19:58:59.484 1 gkacct.cxx(217) GKACCT Created module SQLAcct with event mask 7
2005/03/07 19:58:59.890 3 gksql.cxx(154) SQLAcct Database connection pool created: root@localhost[billing]
2005/03/07 19:58:59.890 1 sqlacct.cxx(103) GKACCT SQLAcct module creation failed: no start query configured
2005/03/07 19:58:59.890 1 sqlacct.cxx(118) GKACCT SQLAcct module creation failed: no update query configured
2005/03/07 19:58:59.890 1 gkacct.cxx(217) GKACCT Created module FileAcct with event mask 7
2005/03/07 19:58:59.890 1 gkacct.cxx(862) GKACCT FileAcct could not open file required for plain text accounting "c:\jigar\call.log" :No such file or directory
2005/03/07 19:58:59.890 2 gkacct.cxx(1034) GKACCT Successfully logged event 8
2005/03/07 19:58:59.890 1 gk.cxx(551) OpenH323 Gatekeeper - The GNU Gatekeeper with ID 'JIGARS' started on 0.0.0.0
Gatekeeper(GNU) Version(2.0.9) Ext(pthreads=0,acct=1,radius=1,mysql=1,pgsql=1,ldap=0,large_fdset=0) Build(Dec 7 2004, 14:22:43) Sys(2000 i586 v5.0.2195)
2005/03/07 19:58:59.953 2 gk.cxx(598) GK TimeToLive for Registrations: 800
2005/03/07 19:58:59.953 1 gkauth.cxx(330) GKAUTH SQLPasswordAuth rule added to check events: ARQ RRQ
2005/03/07 19:58:59.984 3 gksql.cxx(154) SQLPasswordAuth Database connection pool created: root@localhost[billing]
2005/03/07 19:58:59.984 2 WaitingARQ.cxx(61) GK Virtual Queue disabled for aliases
2005/03/07 19:58:59.984 2 WaitingARQ.cxx(71) GK Virtual Queue disabled for prefixes
2005/03/07 19:58:59.984 2 WaitingARQ.cxx(81) GK Virtual Queue disabled for regular expression
2005/03/07 19:58:59.984 2 RasSrv.cxx(660) GK Using Direct Signalling
2005/03/07 19:58:59.984 2 RasSrv.cxx(661) GK H.245 Routed Disabled
2005/03/07 19:59:00.000 1 MulticastGRQ.cxx(57) GK Multicast listener started
2005/03/07 19:59:00.015 1 RasSrv.cxx(2667) GK RasThread 1384 started
2005/03/07 19:59:00.015 2 RasSrv.cxx(2670) GK Entering connection handling loop
2005/03/07 19:59:05.109 1 gk.cxx(253) GK Gatekeeper shutdown due to CTRL_C_EVENT
2005/03/07 19:59:05.984 3 gk.cxx(100) GK Closing MulticastGRQThread
2005/03/07 19:59:05.984 1 MulticastGRQ.cxx(89) GK Multicast thread: Read error: Interrupted function call
2005/03/07 19:59:06.000 1 MulticastGRQ.cxx(89) GK Multicast thread: Read error: Socket closed or invalid
2005/03/07 19:59:06.000 2 RasSrv.cxx(816) GK Closing RasThread
2005/03/07 19:59:06.000 1 RasSrv.cxx(2697) GK RAS thread: Read error: Interrupted function call
2005/03/07 19:59:06.000 2 GkStatus.cxx(149) GK Closing Status thread.
2005/03/07 19:59:06.000 2 GkStatus.cxx(164) GK Closed Status thread.
2005/03/07 19:59:06.000 1 RasSrv.cxx(2697) GK RAS thread: Read error: Socket closed or invalid
2005/03/07 19:59:06.000 1 RasSrv.cxx(2731) GK RasThread terminated!
2005/03/07 19:59:06.031 1 RasSrv.cxx(846) GK RasSrv closed
2005/03/07 19:59:06.031 1 gkauth.cxx(337) GKAUTH SQLPasswordAuth rule removed
2005/03/07 19:59:06.031 3 gk.cxx(126) GK Deleting global singleton objects
2005/03/07 19:59:06.031 2 gkacct.cxx(1034) GKACCT Successfully logged event 16
2005/03/07 19:59:06.031 1 gkacct.cxx(222) GKACCT Destroyed module SQLAcct
2005/03/07 19:59:06.031 1 gkacct.cxx(222) GKACCT Destroyed module FileAcct
2005/03/07 19:59:06.031 3 gk.cxx(132) GK Global singleton objects deleted
2005/03/07 19:59:06.031 1 gk.cxx(984) GK Logging closed
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=127.0.0.0/255.0.0.0, IP=127.0.0.1
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=202.160.163.160/255.255.255.224, IP=202.160.163.167
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=202.160.163.167/255.255.255.255, IP=127.0.0.1
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=202.160.163.255/255.255.255.255, IP=202.160.163.167
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=224.0.0.0/224.0.0.0, IP=202.160.163.167
2005/03/07 19:59:23.234 2 Toolkit.cxx(96) Network=255.255.255.255/255.255.255.255, IP=202.160.163.167
2005/03/07 19:59:23.234 2 Toolkit.cxx(97) Default IP=202.160.163.167
2005/03/07 19:59:23.234 2 Toolkit.cxx(159) GK H.323 Proxy disabled
2005/03/07 19:59:23.234 1 gkacct.cxx(217) GKACCT Created module SQLAcct with event mask 7
2005/03/07 19:59:23.250 3 gksql.cxx(154) SQLAcct Database connection pool created: root@localhost[billing]
2005/03/07 19:59:23.250 1 sqlacct.cxx(103) GKACCT SQLAcct module creation failed: no start query configured
2005/03/07 19:59:23.250 1 sqlacct.cxx(118) GKACCT SQLAcct module creation failed: no update query configured
2005/03/07 19:59:23.250 1 gkacct.cxx(217) GKACCT Created module FileAcct with event mask 7
2005/03/07 19:59:23.250 1 gkacct.cxx(862) GKACCT FileAcct could not open file required for plain text accounting "c:\jigar\call.log" :No such file or directory
2005/03/07 19:59:23.250 2 gkacct.cxx(1034) GKACCT Successfully logged event 8
2005/03/07 19:59:23.281 1 gk.cxx(551) OpenH323 Gatekeeper - The GNU Gatekeeper with ID 'JIGARS' started on 0.0.0.0
Gatekeeper(GNU) Version(2.0.9) Ext(pthreads=0,acct=1,radius=1,mysql=1,pgsql=1,ldap=0,large_fdset=0) Build(Dec 7 2004, 14:22:43) Sys(2000 i586 v5.0.2195)
2005/03/07 19:59:23.359 2 gk.cxx(598) GK TimeToLive for Registrations: 800
2005/03/07 19:59:23.359 1 gkauth.cxx(330) GKAUTH SQLPasswordAuth rule added to check events: ARQ RRQ
2005/03/07 19:59:23.390 3 gksql.cxx(154) SQLPasswordAuth Database connection pool created: root@localhost[billing]
2005/03/07 19:59:23.390 2 WaitingARQ.cxx(61) GK Virtual Queue disabled for aliases
2005/03/07 19:59:23.390 2 WaitingARQ.cxx(71) GK Virtual Queue disabled for prefixes
2005/03/07 19:59:23.390 2 WaitingARQ.cxx(81) GK Virtual Queue disabled for regular expression
2005/03/07 19:59:23.390 2 RasSrv.cxx(660) GK Using Direct Signalling
2005/03/07 19:59:23.390 2 RasSrv.cxx(661) GK H.245 Routed Disabled
2005/03/07 19:59:23.390 1 MulticastGRQ.cxx(57) GK Multicast listener started
2005/03/07 19:59:23.484 1 RasSrv.cxx(2667) GK RasThread 2444 started
2005/03/07 19:59:23.484 2 RasSrv.cxx(2670) GK Entering connection handling loop
2005/03/07 19:59:40.937 2 GkStatus.cxx(335) GK GkStatus new status client: addr 202.160.163.167
2005/03/07 19:59:58.718 2 RasSrv.cxx(2702) GK Read from 202.160.163.167:3666
2005/03/07 19:59:58.718 3 RasSrv.cxx(2714) GK
gatekeeperRequest {
requestSeqNum = 20755
protocolIdentifier = 0.0.8.2250.0.4
rasAddress = ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 3666
}
endpointType = {
vendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 20 octets {
4f 70 65 6e 68 33 32 33 20 4f 70 65 6e 50 68 6f Openh323 OpenPho
6e 65 00 00 ne..
}
versionId = 26 octets {
31 2e 37 2e 30 20 28 4f 70 65 6e 48 33 32 33 20 1.7.0 (OpenH323
76 31 2e 31 31 2e 35 29 00 00 v1.11.5)..
}
}
terminal = {
}
mc = FALSE
undefinedNode = FALSE
}
endpointAlias = 1 entries {
[0]=h323_ID 5 characters {
006a 0069 0067 0061 0072 jigar
}
}
authenticationCapability = 2 entries {
[0]=pwdHash <<null>>
[1]=authenticationBES radius <<null>>
}
algorithmOIDs = 2 entries {
[0]=1.2.840.113549.2.5
[1]=1.2.840.113548.10.1.2.1
}
supportsAltGK = <<null>>
}
2005/03/07 19:59:58.718 1 RasSrv.cxx(962) GK GRQ Received
2005/03/07 19:59:58.734 2 RasSrv.cxx(1030) GCF|202.160.163.167|jigar:h323_ID|terminal;
2005/03/07 19:59:58.734 3 RasSrv.cxx(2632) GK Send to 202.160.163.167:3666
gatekeeperConfirm {
requestSeqNum = 20755
protocolIdentifier = 0.0.8.2250.0.4
gatekeeperIdentifier = 6 characters {
004a 0049 0047 0041 0052 0053 JIGARS
}
rasAddress = ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 1719
}
}
2005/03/07 19:59:58.734 2 RasSrv.cxx(2702) GK Read from 202.160.163.167:3666
2005/03/07 19:59:58.734 3 RasSrv.cxx(2714) GK
registrationRequest {
requestSeqNum = 20756
protocolIdentifier = 0.0.8.2250.0.4
discoveryComplete = TRUE
callSignalAddress = 1 entries {
[0]=ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 1720
}
}
rasAddress = 1 entries {
[0]=ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 3666
}
}
terminalType = {
vendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 20 octets {
4f 70 65 6e 68 33 32 33 20 4f 70 65 6e 50 68 6f Openh323 OpenPho
6e 65 00 00 ne..
}
versionId = 26 octets {
31 2e 37 2e 30 20 28 4f 70 65 6e 48 33 32 33 20 1.7.0 (OpenH323
76 31 2e 31 31 2e 35 29 00 00 v1.11.5)..
}
}
terminal = {
}
mc = FALSE
undefinedNode = FALSE
}
terminalAlias = 1 entries {
[0]=h323_ID 5 characters {
006a 0069 0067 0061 0072 jigar
}
}
gatekeeperIdentifier = 6 characters {
004a 0049 0047 0041 0052 0053 JIGARS
}
endpointVendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 20 octets {
4f 70 65 6e 68 33 32 33 20 4f 70 65 6e 50 68 6f Openh323 OpenPho
6e 65 00 00 ne..
}
versionId = 26 octets {
31 2e 37 2e 30 20 28 4f 70 65 6e 48 33 32 33 20 1.7.0 (OpenH323
76 31 2e 31 31 2e 35 29 00 00 v1.11.5)..
}
}
tokens = 1 entries {
[0]={
tokenOID = 1.2.840.113548.10.1.2.1
timeStamp = 1110254398
challenge = 16 octets {
89 63 a8 9a 20 5b 69 d5 c8 d9 2b 4a dc 30 15 1e ?c¨? [iÕÈÙ+JÜ0..
}
random = 151
generalID = 6 characters {
006a 0069 0067 0061 0072 0000 jigar
}
}
}
cryptoTokens = 1 entries {
[0]=cryptoEPPwdHash {
alias = h323_ID 5 characters {
006a 0069 0067 0061 0072 jigar
}
timeStamp = 1110254398
token = {
algorithmOID = 1.2.840.113549.2.5
paramS = {
}
hash = Hex: dc f7 98 9d 70 89 e5 54 50 7e e1 ad 7f 41 45 c7
}
}
}
keepAlive = FALSE
willSupplyUUIEs = TRUE
maintainConnection = FALSE
supportsAltGK = <<null>>
usageReportingCapability = {
nonStandardUsageTypes = 0 entries {
}
startTime = <<null>>
endTime = <<null>>
terminationCause = <<null>>
}
callCreditCapability = {
canDisplayAmountString = TRUE
canEnforceDurationLimit = TRUE
}
}
2005/03/07 19:59:58.734 1 RasSrv.cxx(1056) GK RRQ Received
2005/03/07 19:59:58.875 3 gkauth.cxx(1201) GKAUTH SQLPasswordAuth RRQ check ok
2005/03/07 19:59:58.875 1 RasTbl.cxx(68) New EP|202.160.163.167:1720|jigar:h323_ID|terminal|3053_endp
2005/03/07 19:59:58.875 2 RasSrv.cxx(1363) RCF|202.160.163.167:1720|jigar:h323_ID|terminal|3053_endp;
2005/03/07 19:59:58.875 3 RasSrv.cxx(2632) GK Send to 202.160.163.167:3666
registrationConfirm {
requestSeqNum = 20756
protocolIdentifier = 0.0.8.2250.0.4
callSignalAddress = 1 entries {
[0]=ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 0
}
}
terminalAlias = 1 entries {
[0]=h323_ID 5 characters {
006a 0069 0067 0061 0072 jigar
}
}
gatekeeperIdentifier = 6 characters {
004a 0049 0047 0041 0052 0053 JIGARS
}
endpointIdentifier = 9 characters {
0033 0030 0035 0033 005f 0065 006e 0064 3053_end
0070 p
}
timeToLive = 800
willRespondToIRR = FALSE
maintainConnection = FALSE
serviceControl = 1 entries {
[0]={
sessionId = 0
contents = callCreditServiceControl {
callStartingPoint = connect <<null>>
}
reason = open <<null>>
}
}
}
2005/03/07 20:03:15.156 1 gk.cxx(253) GK Gatekeeper shutdown due to CTRL_C_EVENT
2005/03/07 20:03:15.515 3 gk.cxx(100) GK Closing MulticastGRQThread
2005/03/07 20:03:15.515 1 MulticastGRQ.cxx(89) GK Multicast thread: Read error: Interrupted function call
2005/03/07 20:03:15.515 1 MulticastGRQ.cxx(89) GK Multicast thread: Read error: Socket closed or invalid
2005/03/07 20:03:15.515 2 RasSrv.cxx(816) GK Closing RasThread
2005/03/07 20:03:15.531 3 RasSrv.cxx(2632) GK Send to 202.160.163.167:3666
unregistrationRequest {
requestSeqNum = 1
callSignalAddress = 1 entries {
[0]=ipAddress {
ip = 4 octets {
ca a0 a3 a7 Ê £§
}
port = 1720
}
}
endpointIdentifier = 9 characters {
0033 0030 0035 0033 005f 0065 006e 0064 3053_end
0070 p
}
gatekeeperIdentifier = 6 characters {
004a 0049 0047 0041 0052 0053 JIGARS
}
cryptoTokens = 1 entries {
[0]=cryptoEPPwdHash {
alias = h323_ID 5 characters {
006a 0069 0067 0061 0072 jigar
}
timeStamp = 1110254595
token = {
algorithmOID = 1.2.840.113549.2.5
paramS = {
}
hash = Hex: 1c 14 44 e8 9e 97 b3 96 db d0 59 11 2a aa f0 29
}
}
}
reason = maintenance <<null>>
}
2005/03/07 20:03:15.546 1 RasSrv.cxx(2697) GK RAS thread: Read error: Interrupted function call
2005/03/07 20:03:15.546 2 GkStatus.cxx(149) GK Closing Status thread.
2005/03/07 20:03:15.546 1 RasSrv.cxx(2697) GK RAS thread: Read error: Socket closed or invalid
2005/03/07 20:03:15.546 1 RasSrv.cxx(2731) GK RasThread terminated!
2005/03/07 20:03:15.546 2 GkStatus.cxx(571) GK GkStatus client 1 (202.160.163.167) has disconnected
2005/03/07 20:03:15.656 2 GkStatus.cxx(164) GK Closed Status thread.
2005/03/07 20:03:15.656 1 RasSrv.cxx(846) GK RasSrv closed
2005/03/07 20:03:15.656 1 gkauth.cxx(337) GKAUTH SQLPasswordAuth rule removed
2005/03/07 20:03:15.656 3 gk.cxx(126) GK Deleting global singleton objects
2005/03/07 20:03:15.656 3 RasTbl.cxx(196) Gk Delete endpoint: 3053_endp 0
2005/03/07 20:03:15.656 2 gkacct.cxx(1034) GKACCT Successfully logged event 16
2005/03/07 20:03:15.656 1 gkacct.cxx(222) GKACCT Destroyed module SQLAcct
2005/03/07 20:03:15.656 1 gkacct.cxx(222) GKACCT Destroyed module FileAcct
2005/03/07 20:03:15.656 3 gk.cxx(132) GK Global singleton objects deleted
2005/03/07 20:03:15.656 1 gk.cxx(984) GK Logging closed
D2V ISP - Gujarat's Quality Minded Internet Service Provider - Explore it.
