If your terminal does not support password, then using SQLPasswordAuth
does not make much sense. Besides, the query should return a password
rather than a '1'.
----- Original Message -----
From: "Daniel García García" <danielgg@xxxxxxx>
Sent: Friday, August 12, 2005 9:54 PM
I am working with Gnugk Gatekeeper y it works fine, but i have one
problem with SQLPasswordAuth.
System Configuration:
- OS: Debian GNU/Linux unstable (kernel 2.4.27)
- Gnugk: 2.2.2-3
- libraries versions: libopenh323-1. 1.15.3-4
- Mysql: 4.0.24-7
config file (gatekeeper.ini):
[Gatekeeper::Main]
Fourtytwo=42
Name=Servidor_Sala_Quercus
# EncryptAllPasswords=0
# KeyFilled=0
#EndpointIDSuffix=_terminal
#RedirectGK=Endpoints > 1
#AlternateGKs=158.49.126.95:1719:true:120:Servidor_Sala_Quercus_2
#Sendto=158.49.126.95:1719
#[RoutedMode]
# AcceptUnregisteredCalls=0
[RoutedMode]
GKRouted=1
H245Routed=0
CallSignalPort=1721
[Gatekeeper::Auth]
SQLPasswordAuth=required;RRQ,ARQ
[SQLPasswordAuth]
Driver=MySQL
Host=localhost
Port=3306
Database=name
Username=username-database
Password=password-database
Table=customer
Query=SELECT 1 from Alumnos where Nombre='%u';
CacheTimeout=30
MinPoolSize=1
My problem:
- Gnugk connect with my Mysql database (SQLPasswordAuth Connection pool:
1 SQL connections created, 0 failed) but when Gnugk execute the Query i
have the following error:
GKAUTH SQLPasswordAuth RRQ check failed
RasSrv.cxx(375)
RRJ|127.0.0.1|pepitogrillo:h323_ID|terminal|securityDenial;
¿What happen? I understand this error. I have tested with
SimplePasswordAuth and Gnugk works fine.
The error message which Gnugk shows is:
OpenH323 Gatekeeper - The GNU Gatekeeper with ID 'Servidor_Sala_Quercus'
started
Gatekeeper(GNU) Version(2.2.2)
Ext(pthreads=1,radius=1,mysql=1,pgsql=1,large_fdset=0) Build(Jul 17 2005,
07:43:51) Sys(Linux i686 2.4.27)
2005/08/12 13:32:17.022 1 gk.cxx(507) OpenH323
Gatekeeper - The GNU Gatekeeper with ID 'Servidor_Sala_Quercus' started
Gatekeeper(GNU) Version(2.2.2)
Ext(pthreads=1,radius=1,mysql=1,pgsql=1,large_fdset=0) Build(Jul 17 2005,
07:43:51) Sys(Linux i686 2.4.27)
Listen on 192.168.1.3,127.0.0.1
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
2005/08/12 13:32:17.023 2 singleton.cxx(32) Create instance:
CallTable(2)
Disable Bandwidth Management
2005/08/12 13:32:17.024 2 gk.cxx(545) GK TimeToLive
for Registrations: -1
2005/08/12 13:32:17.025 2 singleton.cxx(32) Create instance:
RasServer(3)
2005/08/12 13:32:17.025 2 ProxyChannel.cxx(105) RTPPortRange:
1024-65535
2005/08/12 13:32:17.026 2 singleton.cxx(32) Create instance:
Agent(4)
2005/08/12 13:32:17.027 5 job.cxx(352) JOB Worker
threads: 1 total - 1 busy, 0 idle
2005/08/12 13:32:17.028 5 job.cxx(161) JOB Worker
32771 started
2005/08/12 13:32:17.029 5 job.cxx(180) JOB Starting
Job ProxyH(0) at Worker thread 32771
2005/08/12 13:32:17.032 3 yasocket.cxx(768) ProxyH(0) waiting...
2005/08/12 13:32:17.033 5 job.cxx(352) JOB Worker
threads: 2 total - 2 busy, 0 idle
2005/08/12 13:32:17.033 2 RasSrv.cxx(703) GK Using
Routed Signalling
2005/08/12 13:32:17.034 2 RasSrv.cxx(704) GK H.245
Routed Disabled
2005/08/12 13:32:17.034 2 singleton.cxx(32) Create instance:
GkStatus(5)
2005/08/12 13:32:17.035 5 job.cxx(161) JOB Worker
49156 started
2005/08/12 13:32:17.036 5 job.cxx(180) JOB Starting
Job ProxyRTP(0) at Worker thread 49156
2005/08/12 13:32:17.036 3 yasocket.cxx(768) ProxyRTP(0)
waiting...
2005/08/12 13:32:17.037 5 job.cxx(352) JOB Worker
threads: 3 total - 3 busy, 0 idle
2005/08/12 13:32:17.037 2 singleton.cxx(32) Create instance:
RegistrationTable(6)
2005/08/12 13:32:17.038 5 job.cxx(352) JOB Worker
threads: 4 total - 4 busy, 0 idle
2005/08/12 13:32:17.038 2 RasSrv.cxx(740) GK Home =
192.168.1.3,127.0.0.1
2005/08/12 13:32:17.039 1 RasSrv.cxx(491) Listening to
192.168.1.3:1719(U)
2005/08/12 13:32:17.039 5 yasocket.cxx(678) RasServer total
sockets 1
2005/08/12 13:32:17.039 1 RasSrv.cxx(491) Listening to
192.168.1.3:1718(Mcast)
2005/08/12 13:32:17.039 5 yasocket.cxx(678) RasServer total
sockets 2
2005/08/12 13:32:17.039 1 RasSrv.cxx(496) Can't listen to
192.168.1.3:1721
2005/08/12 13:32:17.039 3 yasocket.cxx(784) TCP Delete
listener 192.168.1.3:1721
2005/08/12 13:32:17.039 1 GkStatus.cxx(1248) STATUS Could not
open listening socket at 192.168.1.3:7000, error(12, Address already in
use)
2005/08/12 13:32:17.039 1 RasSrv.cxx(496) Can't listen to
192.168.1.3:7000
2005/08/12 13:32:17.039 3 yasocket.cxx(784) TCP Delete
listener 192.168.1.3:7000
2005/08/12 13:32:17.039 1 RasSrv.cxx(491) Listening to
127.0.0.1:1719(U)
2005/08/12 13:32:17.040 5 yasocket.cxx(678) RasServer total
sockets 3
2005/08/12 13:32:17.040 1 RasSrv.cxx(496) Can't listen to
127.0.0.1:1721
2005/08/12 13:32:17.040 3 yasocket.cxx(784) TCP Delete
listener 127.0.0.1:1721
2005/08/12 13:32:17.040 1 GkStatus.cxx(1248) STATUS Could not
open listening socket at 127.0.0.1:7000, error(12, Address already in use)
2005/08/12 13:32:17.040 1 RasSrv.cxx(496) Can't listen to
127.0.0.1:7000
2005/08/12 13:32:17.040 3 yasocket.cxx(784) TCP Delete
listener 127.0.0.1:7000
2005/08/12 13:32:17.040 1 RasSrv.cxx(799) RAS Add
broadcast listener
2005/08/12 13:32:17.040 5 yasocket.cxx(678) RasServer total
sockets 4
2005/08/12 13:32:17.040 1 gkauth.cxx(329) GKAUTH
SQLPasswordAuth rule added to check RAS: ARQ RRQ, OTHER: NONE
2005/08/12 13:32:17.041 1 gkauth.cxx(1109) GKAUTH
SQLPasswordAuth KeyFilled config variable is missing
2005/08/12 13:32:17.041 4 sqlauth.cxx(310) SQLAUTH
SQLPasswordAuth query: SELECT 1 from Alumnos where Nombre='%u';
2005/08/12 13:32:17.045 5 gksql_mysql.cxx(480) SQLPasswordAuth
MySQL connection to GkQuercus@localhost[GkQuercus]established successfully
2005/08/12 13:32:17.046 3 gksql.cxx(166) SQLPasswordAuth
Database connection pool created: GkQuercus@localhost[GkQuercus]
2005/08/12 13:32:17.047 5 gksql.cxx(170) SQLPasswordAuth
Connection pool: 1 SQL connections created, 0 failed
2005/08/12 13:32:17.090 4 gkauth.cxx(871) GkAuth H.235
capabilities selected for GCF:
Authentication mechanisms:
pwdHash <<null>>
authenticationBES radius <<null>>
Authentication algorithm OIDs:
1.2.840.113549.2.5
1.2.840.113548.10.1.2.1
2005/08/12 13:32:17.093 2 Routing.cxx(562) VQueue (CTI)
Virtual queues disabled - no virtual queues configured
2005/08/12 13:32:17.093 2 singleton.cxx(32) Create instance:
Routing::Analyzer(7)
2005/08/12 13:32:17.095 2 gkacct.cxx(982) GKACCT
Successfully logged event 8
2005/08/12 13:32:17.095 5 job.cxx(161) JOB Worker
65541 started
2005/08/12 13:32:17.096 5 job.cxx(180) JOB Starting
Job GkStatus at Worker thread 65541
2005/08/12 13:32:17.097 3 yasocket.cxx(768) GkStatus waiting...
2005/08/12 13:32:17.097 5 job.cxx(161) JOB Worker
81926 started
2005/08/12 13:32:17.098 5 job.cxx(180) JOB Starting
Job TCPServer at Worker thread 81926
2005/08/12 13:32:17.099 3 yasocket.cxx(768) TCPServer waiting...
2005/08/12 13:32:17.099 5 job.cxx(352) JOB Worker
threads: 5 total - 5 busy, 0 idle
2005/08/12 13:32:17.100 5 job.cxx(161) JOB Worker
98311 started
2005/08/12 13:32:17.101 5 job.cxx(180) JOB Starting
Job HouseKeeping at Worker thread 98311
2005/08/12 13:32:22.199 5 yasocket.cxx(709) RasServer 1
sockets selected from 4, total 4/0
2005/08/12 13:32:22.199 4 RasSrv.cxx(201) RAS Receiving
on 127.0.0.1:1719(U)
2005/08/12 13:32:22.200 2 RasSrv.cxx(170) RAS Read from
127.0.0.1:5020
2005/08/12 13:32:22.201 3 RasSrv.cxx(209) RAS
gatekeeperRequest {
requestSeqNum = 14795
protocolIdentifier = 0.0.8.2250.0.4
rasAddress = ipAddress {
ip = 4 octets {
7f 00 00 01 ....
}
port = 5020
}
endpointType = {
vendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 14 octets {
67 6e 6f 6d 65 6d 65 65 74 69 6e 67 00 00 gnomemeeting..
}
versionId = 26 octets {
31 2e 32 2e 31 20 28 4f 70 65 6e 48 33 32 33 20 1.2.1 (OpenH323
76 31 2e 31 35 2e 33 29 00 00 v1.15.3)..
}
}
terminal = {
}
mc = FALSE
undefinedNode = FALSE
}
endpointAlias = 1 entries {
[0]=h323_ID 12 characters {
0070 0065 0070 0069 0074 006f 0067 0072 pepitogr
0069 006c 006c 006f illo
}
}
supportsAltGK = <<null>>
}
2005/08/12 13:32:22.204 5 job.cxx(352) JOB Worker
threads: 6 total - 6 busy, 0 idle
2005/08/12 13:32:22.204 5 job.cxx(161) JOB Worker
114696 started
2005/08/12 13:32:22.205 5 job.cxx(180) JOB Starting
Job GRQ at Worker thread 114696
2005/08/12 13:32:22.205 1 RasSrv.cxx(330) RAS GRQ Received
2005/08/12 13:32:22.207 2 RasSrv.cxx(375)
GCF|127.0.0.1|pepitogrillo:h323_ID|terminal;
2005/08/12 13:32:22.207 3 RasSrv.cxx(221) RAS Send to
127.0.0.1:5020
gatekeeperConfirm {
requestSeqNum = 14795
protocolIdentifier = 0.0.8.2250.0.4
gatekeeperIdentifier = 21 characters {
0053 0065 0072 0076 0069 0064 006f 0072 Servidor
005f 0053 0061 006c 0061 005f 0051 0075 _Sala_Qu
0065 0072 0063 0075 0073 ercus
}
rasAddress = ipAddress {
ip = 4 octets {
7f 00 00 01 ....
}
port = 1719
}
}
2005/08/12 13:32:22.216 5 RasSrv.cxx(235) RAS Sent
Successful
2005/08/12 13:32:22.217 5 job.cxx(415) JOB Job GRQ
deleted
2005/08/12 13:32:22.217 5 job.cxx(404) JOB Worker
threads: 6 total - 5 busy, 1 idle
2005/08/12 13:32:22.223 5 yasocket.cxx(709) RasServer 1
sockets selected from 4, total 4/0
2005/08/12 13:32:22.223 4 RasSrv.cxx(201) RAS Receiving
on 127.0.0.1:1719(U)
2005/08/12 13:32:22.224 2 RasSrv.cxx(170) RAS Read from
127.0.0.1:5020
2005/08/12 13:32:22.225 3 RasSrv.cxx(209) RAS
registrationRequest {
requestSeqNum = 14796
protocolIdentifier = 0.0.8.2250.0.4
discoveryComplete = TRUE
callSignalAddress = 2 entries {
[0]=ipAddress {
ip = 4 octets {
7f 00 00 01 ....
}
port = 1720
}
[1]=ipAddress {
ip = 4 octets {
c0 a8 01 03 ....
}
port = 1720
}
}
rasAddress = 1 entries {
[0]=ipAddress {
ip = 4 octets {
7f 00 00 01 ....
}
port = 5020
}
}
terminalType = {
vendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 14 octets {
67 6e 6f 6d 65 6d 65 65 74 69 6e 67 00 00 gnomemeeting..
}
versionId = 26 octets {
31 2e 32 2e 31 20 28 4f 70 65 6e 48 33 32 33 20 1.2.1 (OpenH323
76 31 2e 31 35 2e 33 29 00 00 v1.15.3)..
}
}
terminal = {
}
mc = FALSE
undefinedNode = FALSE
}
terminalAlias = 1 entries {
[0]=h323_ID 12 characters {
0070 0065 0070 0069 0074 006f 0067 0072 pepitogr
0069 006c 006c 006f illo
}
}
gatekeeperIdentifier = 21 characters {
0053 0065 0072 0076 0069 0064 006f 0072 Servidor
005f 0053 0061 006c 0061 005f 0051 0075 _Sala_Qu
0065 0072 0063 0075 0073 ercus
}
endpointVendor = {
vendor = {
t35CountryCode = 9
t35Extension = 0
manufacturerCode = 61
}
productId = 14 octets {
67 6e 6f 6d 65 6d 65 65 74 69 6e 67 00 00 gnomemeeting..
}
versionId = 26 octets {
31 2e 32 2e 31 20 28 4f 70 65 6e 48 33 32 33 20 1.2.1 (OpenH323
76 31 2e 31 35 2e 33 29 00 00 v1.15.3)..
}
}
timeToLive = 3600
keepAlive = FALSE
willSupplyUUIEs = TRUE
maintainConnection = FALSE
supportsAltGK = <<null>>
usageReportingCapability = {
nonStandardUsageTypes = 0 entries {
}
startTime = <<null>>
endTime = <<null>>
terminationCause = <<null>>
}
callCreditCapability = {
canEnforceDurationLimit = TRUE
}
}
2005/08/12 13:32:22.226 5 job.cxx(352) JOB Worker
threads: 6 total - 6 busy, 0 idle
2005/08/12 13:32:22.231 5 job.cxx(180) JOB Starting
Job RRQ at Worker thread 114696
2005/08/12 13:32:22.231 1 RasSrv.cxx(330) RAS RRQ Received
2005/08/12 13:32:22.232 3 gkauth.cxx(969) GKAUTH
SQLPasswordAuth RRQ check failed
2005/08/12 13:32:22.233 2 RasSrv.cxx(375)
RRJ|127.0.0.1|pepitogrillo:h323_ID|terminal|securityDenial;
2005/08/12 13:32:22.234 3 RasSrv.cxx(221) RAS Send to
127.0.0.1:5020
registrationReject {
requestSeqNum = 14796
protocolIdentifier = 0.0.8.2250.0.4
rejectReason = securityDenial <<null>>
gatekeeperIdentifier = 21 characters {
0053 0065 0072 0076 0069 0064 006f 0072 Servidor
005f 0053 0061 006c 0061 005f 0051 0075 _Sala_Qu
0065 0072 0063 0075 0073 ercus
}
}
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id?49
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
