Maybe you should:
1. Specify the password when running ohphone.
2. Edit your query to be a valid SQL query.
Try running your query from mysql command
line utility to see whether it works.
----- Original Message -----
From: "wubo" <wubo@xxxxxxxxxxx>
Sent: Friday, October 22, 2004 5:07 AM
> openh323gk-users :
>
> when I use MySQL as a backend database to authenticate the endpoints. , I
> failed , why ? help me!
> The log as follows:
> 2004/10/22 09:58:16.260 5 job.cxx(360) JOB Worker
> threads: 6 total - 6 busy, 0 idle
> 2004/10/22 09:58:16.261 5 job.cxx(188) JOB Starting
> Job RRQ at Worker thread 7176
> 2004/10/22 09:58:16.261 1 RasSrv.cxx(312) RAS RRQ
> Received
> 2004/10/22 09:58:16.261 3 gkauth.cxx(1142) GKAUTH
> SQLPasswordAuth RRQ check failed
> 2004/10/22 09:58:16.262 2 RasSrv.cxx(357)
> RRJ|192.168.0.28|11:dialedDigits|terminal|securityDenial;
> 2004/10/22 09:58:16.262 3 RasSrv.cxx(203) RAS Send to
> 192.168.0.28:1135
> registrationReject {
> requestSeqNum = 12713
> protocolIdentifier = 0.0.8.2250.0.4
> rejectReason = securityDenial <<null>>
> gatekeeperIdentifier = 3 characters {
> 0047 004b 0031 GK1
> }
> }
>
>
> And my ini as follow:
>
> [Gatekeeper::Main]
> Fourtytwo=42
> Name=GK1
> TimeToLive=300
>
> [RoutedMode]
> GKRouted=1
> H245Routed=0
>
> [Gatekeeper::Auth]
> SQLPasswordAuth=required;RRQ
> default=allow
>
> [SQLPasswordAuth]
> Driver=MySQL
> Host=192.168.0.28
> Database=test
> Username=wubo
> Password=195161
> CacheTimeout=300
> Query=SELECT h235password FROM billing WHERE users='%1' IS Active
> MinPoolSize=5
>
> [GkStatus::Auth]
> rule=allow
>
>
>
> And , MySQL have a database called "test",contained a table called
> "billing",
> The "billing" have two field: users , h235password ,
>
> users h235password
> 11 22
>
> I use a ohphone , when I use : ohphone -a -l -u 11 -G GK1 , I failed .
> why ???
>
> wubo
> wubo@xxxxxxxxxxx
-------------------------------------------------------
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?9
Homepage: http://www.gnugk.org/
