Re: [Openh323gk-users] Need Help with MySQL

["Hemant Kumar" <smith@hmhtel.com>]

Title: Message

you can change the SQL query the way you want in the code :)

 

----- Original Message -----

From: Nitesh Divecha

To: openh323gk-users@lists.sourceforge.net

Sent: Thursday, July 31, 2003 5:25 AM

Subject: [Openh323gk-users] Need Help with MySQL

Hello Everyone...

 

The only part I am stuck is with the SQL script...

GNUGK is compile with MySQL and also it does authentication, but when my netmeeting port is 1720.

 

What I mean is I have this script in my ini file:

 

[MySQLAliasAuth]
;
;SELECT CONCAT("sigip:",IPAddr,":1720") FROM IPNData WHERE IPN = %id AND Kind > 1
;
Host=localhost
Database=billing
User=
Password=

Table=IPNData
IDField=IPN
IPField=CONCAT("sigip:",IPAddr,":1720")
ExtraCriterion=Kind > 1
CacheTimeout=300

 

With this configuration I was able to login once when my port address was "1720". After that my port address keep on changing and GK keep on Denying me....

 

My main purpose is to authenticate netmeeting or any other H.323 software with IPN(Username) and Password.

 

Any feedback is highly appreciated...

 

Thank you...

Regards

Nitesh