Hello mate, there should be a file called mysql.ini that shows you what you need to do. Just look for the MySQLPasswordAuth section. Have fun :) Foong ----- Original Message ----- From: Nitesh Divecha <nitesh@incallusb.com> Date: Friday, August 1, 2003 2:35 am Subject: RE: [Openh323gk-users] Need Help with MySQL > 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/ > ------------------------------------------------------- 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/