Re: SQLAuth

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You need to put 1 or 0 (T/F or TRUE/FALSE may also work) in the first column to accept/reject the request.

----- Original Message ----- From: "Marc Khayat" <marckhayat@xxxxxxxxxxx>
Sent: Thursday, April 21, 2005 3:57 PM



I created a table called "users" which contains the user info.
I'm doing the following Query:
RegQuery= SELECT * FROM users WHERE callerip = '%{callerip}'

It is sending the query to MySQL, but receives an error eventhough if i try it directly, it gives a complete row. This is the error:
2005/04/21 16:52:13.471 5 gksql.cxx(368) SQLAuth Executing query: SELECT * FROM users WHERE callerip = '192.168.0.164'
2005/04/21 16:52:13.471 3 gkauth.cxx(964) GKAUTH SQLAuth RRQ check failed
2005/04/21 16:52:13.471 2 RasSrv.cxx(373) RRJ|192.168.0.164|voip.192.168.0.164:h323_ID=500:dialedDigits|gateway|security
Denial;


Any idea about this? Is my RegQuery wrong?

Thanks,



------------------------------------------------------- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 _______________________________________________________

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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux