Thanks Foong for your reply... My netmeeting port keeps on incrementing by 1 or 2 sometimes... Don't know why... Anyways I don't want to authenticate with IP+port... My main aim is to authenticate with H323_ID and Password... Do I have to rewrite the SQL Script...?? Any example will help me get any idea... Thanks once again Regards Nitesh -----Original Message----- From: openh323gk-users-admin@lists.sourceforge.net [mailto:openh323gk-users-admin@lists.sourceforge.net] On Behalf Of chiew325@tm.net.my Sent: Thursday, July 31, 2003 9:27 AM To: openh323gk-users@lists.sourceforge.net Subject: Re: [Openh323gk-users] Need Help with MySQL 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/ ------------------------------------------------------- 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/
