bcoz u set PasswordField=pincode and u r selecting password field...have u checked that pincode exists or not in database ----- Original Message ----- From: "Saad Faisal" <saad_faisal1976@xxxxxxxxxxx> To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Friday, March 12, 2004 3:55 PM Subject: MySQLAliasAuth > Hi > > 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/ > ------------------------------------------------------- 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/
