Re: Assistance with SQLAliasAuth in v2.08cvs and v2.2b4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What does the log file tell? Make sure (I assume you are using Windows version)
that the SQLAliasAuth got compiled (and not eliminated by linker) 
and the SQLAliasAuth module is initialized at the gatekeeper startup.

----- Original Message ----- 
From: "AP MUTHU" <apmuthu@xxxxxxx>
Sent: Thursday, April 08, 2004 11:07 AM


Assistance with SQLAliasAuth in v2.08cvs and v2.2b4

I tried the following in the gatekeeper.ini file:-

[Gatekeeper:Auth]
SQLAliasAuth=required;RRQ
default=reject

[RasSrv::RRQAuth]
default=reject

[SQLAliasAuth]
Driver=MySQL
Host=localhost
Database=gkbilling
Username=gnugk
Password=secret
CacheTimeout=0
Query=SELECT authcond FROM users WHERE alias = '%1' AND active


Also in MySQL I created a table 'gkbilling' with the following structure:-

drop table if exists `users`;
CREATE TABLE `users` (
  `aliasid` varchar(20) NOT NULL default '',
  `authcond` varchar(40) NOT NULL default '',
  `h235password` varchar(40) default NULL,
  `active` enum('1','0') NOT NULL default '1',
  PRIMARY KEY  (`aliasid`)

) TYPE=MyISAM;

INSERT INTO `users` VALUES 
('MYEPALIAS1','sigip:192.168.0.51:1720',NULL,'1');
INSERT INTO `users` VALUES 
('MYEPALIAS2','192.168.0.52:1720',NULL,'1');
INSERT INTO `users` VALUES 
('MYEPALIAS3','allow',NULL,'1');
The parameter %2 is supposed to have the Gatekeeper ID string in v2.2beta4.
Is it available in v2.08cvs ?

SQLConfig works well with MySQl for [RasSrv::RewriteE164] and so MySQL is
compiled correctly.

What is the correct way to use SQLAliasAuth in both versions?

I tried MSNetmeeting on the same machine running the GK with all
possiblitities of aliases for account name and phone number and found the
registration fot the client registering correctly with the gk even if not in
the MySQL database.

Thanks and Regards,
Ap.Muthu



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux