I am using GNUGK ver 2.0.7 and I would like to implement a simple MYSQL authentication mechanism using MySQLAliasAuth. I have already searched the archives with no luck so far. My Config is as follows
[Gatekeeper::Auth] MySQLAliasAuth=sufficient;RRQ
[MySQLAliasAuth] Host=192.168.1.6 Database=aliasDB User=myuser Password=mypassword Table=callcard IDField=cardserialno PasswordField=pincode
When i launch a ohphone executable with the following parameters
ohphone -g 192.168.1.3 -l -a -u test
I receive a RRJ from the server with a reason as SecurityDenial. Inspecting the LOG at level 4 shows the following
gkauth.cxx(818) MySQL Connect to server 192.168.1.6, database aliasDB
gkauth.cxx(828) MySQL select Password from callcard where cardserialno = '%0:id'
gkauth.cxx(832) MySQL Ready for query
gkauth.cxx(784) MySQL BadQuery: Unknown column 'Password' in 'field list'
gkauth.cxx(295) GKAuth MySQLAliasAuth check failed
Now as you can see even though i have specified a PasswordField in the config section, the query seems to be still selecting a Password column(which in my case doesnt exist in my callcard table). Also there is one more thing that is interesting and that is the comparison with the IDField column is done with a unknown ID "%0:id" which is also unrecognizable. Kindly outline any help in this regard.
-Saad Faisal
_________________________________________________________________
Find things fast with the new MSN Toolbar ? includes FREE pop-up blocking! http://clk.atdmt.com/AVE/go/onm00200414ave/direct/01/
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
