helo,
add a file in the billing table called 'Port'. this field store the
prot number for the endpoint.
edit you .ini script as follows:
IPField=CONCAT("sigip:",IPAddr,":","Port")
notice the port now replaced with the Port fileld name.
This only works if you know for sure what port an enpoint is going to
use. In your case it is impossible to authenticate by IP + port.
Are you sure Neetmeeting keep on refreshing port number? What port
range you would get normally?
MySQLAliasAuth authenticate based on H323 ID and IP+Port. For
authentication using H323 ID and Password use MySQLPasswordAuth
Foong
Foong
----- Original Message -----
From: Nitesh Divecha <nitesh@incallusb.com>
Date: Thursday, July 31, 2003 7:55 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
>
>
>
>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
List: Openh323gk-users@lists.sourceforge.net
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
