This is the solution if anybody also need it. Looking at the code, I discovered that i can pass multiple aliases separated by comma in SQL request during Authentication. ex: SELECT 1, CONCAT(users.tel,',',users.full_name),.... In this case each registered user will have to alias: one his phone number, another - his full name... Now he can add/edit the ProxyChannel.cxx (line 2012) file: endptr mrewriteEndPointOut = m_call->GetCallingParty(); H225_ArrayOf_AliasAddress maliases = mrewriteEndPointOut->GetAliases(); PINDEX masize= maliases.GetSize(); H323SetAliasAddress(AsString(maliases[masize-1],FALSE), setupBody.m_sourceAddress[0]); That's all.... Now when user makes a call via NetMetting, the other site see his full name, that was extracted from the database during his registration process... Regards, Me --- On Wed, 9/17/08, Learning It <learningit@xxxxxxxxxxxxxx> wrote: > From: Learning It <learningit@xxxxxxxxxxxxxx> > Subject: Re: ScreenSourceAddress from SQL database > To: "GNU Gatekeeper Users" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> > Cc: "Jan Willamowius" <jan@xxxxxxxxxxxxxx> > Date: Wednesday, September 17, 2008, 8:40 PM > for the first step i did > > const PString screenSourceAddress = > m_call->GetSrcInfo(); > H323SetAliasAddress(screenSourceAddress, > setupBody.m_sourceAddress[0]); > > > anyway, i want to do it via sql.. so i have to play sql > functions... I was wondering if it is possible to create one > sql connection and to make queries via it (just to not > create an close an sql conneciton each time somebody is > making a call).... > > Keep diging > > Thanks > > > --- On Wed, 9/17/08, Learning It > <learningit@xxxxxxxxxxxxxx> wrote: > > > From: Learning It <learningit@xxxxxxxxxxxxxx> > > Subject: Re: ScreenSourceAddress > from SQL database > > To: "GNU Gatekeeper Users" > <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> > > Cc: "Jan Willamowius" > <jan@xxxxxxxxxxxxxx> > > Date: Wednesday, September 17, 2008, 3:29 PM > > Jan, > > > > I've found that place > > > > H323SetAliasAddress(screenSourceAddress, > > setupBody.m_sourceAddress[0]); > > in:ProxyChannel.cxx > > > > What variable holds registered alias from the > database? > > Just to change that row into something like: > > > > > H323SetAliasAddress(viariable_that_holds_the_registered_alias, > > setupBody.m_sourceAddress[0]); > > > > What about the second questions? Why users can not see > > eachother into "Name" list of NetMeeting? > > > > Thanks! > > > > > > > > --- On Wed, 9/17/08, Jan Willamowius > > <jan@xxxxxxxxxxxxxx> wrote: > > > > > From: Jan Willamowius <jan@xxxxxxxxxxxxxx> > > > Subject: Re: > ScreenSourceAddress > > from SQL database > > > To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > > > Date: Wednesday, September 17, 2008, 2:59 PM > > > Hi, > > > > > > thats not really the same: > > > You can overwrite the registration alias using > > SQLAuth, but > > > ScreenSourceAddress= overwrites the sourecAddress > > field in > > > the Setup > > > message on the fly where Netmeeting places the > first > > and > > > last name of > > > the user. SQLAuth isn't able to influence > that in > > the > > > same way > > > ScreenSourceAddress and ScreenDisplayIE can. > > > > > > Regards, > > > Jan > > > > > > > > > aiOne Inc. wrote: > > > > I believe it has been implemented for RRQ. > It > > does not > > > work > > > > dynamically on ARQ, LRQ > > > > > > > > Under [SQLAuth] do query as > > > > RegQuery= SELECT 1 AS accept, (SELECT > your_data > > FROM > > > your_table WHERE > > > > condtion) as aliases .... (if you are using > > SQLAuth, > > > my SQLPassword > > > > does not work so was not able to test. Any > help > > on > > > SQLPassword would > > > > be great (2008/09/17 09:56:25.071 1 > > > > h235auth.cxx(556) > > > > H235RAS H235AuthSimpleMD5 digest does not > match. > > > > 2008/09/17 09:56:25.071 3 > > gkauth.cxx(987) > > > GKAUTH > > > > SQLPasswordAuth RRQ check failed) > > > > > > > > This will over write their ID > > > > > > > > > -- > > > Jan Willamowius, jan@xxxxxxxxxxxxxx, > > http://www.gnugk.org/ > > > > > > > > > ------------------------------------------------------------------------- > > > This SF.Net email is sponsored by the Moblin Your > Move > > > Developer's challenge > > > Build the coolest Linux based applications with > Moblin > > SDK > > > & win great prizes > > > Grand prize is a trip for two to an Open Source > event > > > anywhere in the world > > > > > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > > > > > _______________________________________________________ > > > > > > Posting: > mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > > > Archive: > > > > > > http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users > > > Unsubscribe: > > > > > > http://lists.sourceforge.net/lists/listinfo/openh323gk-users > > > Homepage: http://www.gnugk.org/ > > > > > > > > > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin Your Move > > Developer's challenge > > Build the coolest Linux based applications with Moblin > SDK > > & win great prizes > > Grand prize is a trip for two to an Open Source event > > anywhere in the world > > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > > _______________________________________________________ > > > > Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > > Archive: > > > http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users > > Unsubscribe: > > > http://lists.sourceforge.net/lists/listinfo/openh323gk-users > > Homepage: http://www.gnugk.org/ > > > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move > Developer's challenge > Build the coolest Linux based applications with Moblin SDK > & win great prizes > Grand prize is a trip for two to an Open Source event > anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________________ > > Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: > http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users > Unsubscribe: > http://lists.sourceforge.net/lists/listinfo/openh323gk-users > Homepage: http://www.gnugk.org/ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
