I think this is what's going on. When the user pin is invalid, 0 rows come back, prompting UNAVAILABLE RESOURCES message. If pin is valid, it comes back with a row, but the first column is not 1, which is what it needs to see it as success, so it sends a SECURITY DENIAL. Try this SELECT 1 FROM pin_table WHERE user_pin LIKE '%u' --- "Z.Farhan" <mailzafa@xxxxxxxxx> wrote: > > To authenticate a user from a MySQL database,I set > only two additional config section to *.ini file as > follows... > > [Gatekeeper::Auth] > SQLAuth=required;RRQ > > [SQLAuth] > Driver=MySQL > Host=192.168.0.94:3306 > Database=dialer > Username=root > Password= > RegQuery=SELECT user_pin FROM pin_table WHERE > user_pin > LIKE '%u' > CacheTimeout=30 > MinPoolSize=1 > > Here,I want, if my user_pin is valid my voip dialer > will be connected with GnuGK to pass my call to > remote end,but the problem is 'if user_pin is > invalid > then it shows UNAVAILABLE RESOURCES' and 'if > user_pin > is valid then it shows SECURITY DENIAL' > > Please,anyone give me the solution........ > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by Oracle Space > Sweepstakes > Want to be the first software developer in space? > Enter now for the Oracle Space Sweepstakes! > http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click > _______________________________________________________ > > Posting: > mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: > http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > Unsubscribe: > http://lists.sourceforge.net/lists/listinfo/openh323gk-users > Homepage: http://www.gnugk.org/ > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
