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/