[Sems] [Serusers] accounting

Stefan Sayer sayer at fokus.fraunhofer.de
Mon Aug 1 15:31:31 CEST 2005


hello,

if you really want to do that in sems (for whatever reason) and if you 
have the same email address for the user in subscriber and aliases 
table you probably can do the same without modifying the DB by joining 
the two tables (assuming USERCOL = "username"):

select subscriber.email_address from (subscriber join aliases on 
subscriber.username = aliases.username and subscriber.domain = 
aliases.domain) where aliases.username = cmd.user

(not 100%sure about whether sql syntax is correct - do we need the 
brackets?)

which would translate into
...
          SerDBQuery email_query("(subscriber join aliases on 
subscriber.username = aliases.username and subscriber.domain = 
aliases.domain)");
          email_query.addKey("subscriber.email_address");
          email_query.addWhereClause("aliases.username = \"" +
  cmd.user + "\"");

          int query_res = email_query.execute();
...


Stefan

harry gaillac wrote:
> Hello,
> 
> If somebody is interested to send voicemessages to
> both user account and their aliases:
> sip:alice at mydomain or  sip:123456789 at mydomain  or 
> sip:s.alice at mydomain for example.
> 
> 
> 
> I add in  AnswerMachine.cpp file (voicemail module):
> //////////////////////////////////////////////////////
>     if(AmConfig::SendMethod == "fifo"){
> 
>         DBG("`P-Email-Address' has not been found:
> trying fifo db\n");
> 
>         SerDBQuery email_query("aliases");
>         email_query.addKey("email_address");
>         email_query.addWhereClause("username = \"" +
> cmd.user + "\"");
> 
>         int query_res = email_query.execute();
> 
>         if(query_res < 0)
>             ERROR("voicemail: error while fetching
> user's email address");
>         else if(query_res > 0) {
>             cmd.email = email_query.getVal(0,0);
>             DBG("email address for user '%s': <%s>\n",
>                 cmd.user.c_str(),cmd.email.c_str());
>         }
>     }
> ///////////////////////////////////////////////////////
> i added column email-address in aliases table:
> 
> ///////////////////////////////////////////////////////
> mysql> select * from aliases;
> +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
> | username | domain     | contact              |
> email_address         | received | expires            
> | q    | callid                                       
>                 | cseq | last_modified  | replicate |
> state | flags | user_agent        |
> +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
> | 85       | nxs.yi.org | sip:bob at nxs.yi.org   |
> gaillacharry at yahoo.fr | NULL     | 2005-07-24 18:08:41
> | 1.00 |
> The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
> |   42 | 20050725153201 |         0 |     0 |   128 |
> SIP Express Router FIFO |
> | 84       | nxs.yi.org | sip:alice at nxs.yi.org |
> gaillacharry at yahoo.fr | NULL     | 2005-07-24 18:09:19
> | 1.00 |
> The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
> |   42 | 20050725153232 |         0 |     0 |   128 |
> SIP Express Router FIFO |
> +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
> 2 rows in set (0.00 sec)
> ///////////////////////////////////////////////////////
>  
> 
> 
> 
>>--- harry gaillac <gaillacharry at yahoo.fr> a écrit :
>>
>>
>>>Hello,
>>>
>>>I use ser/serweb-0.9.3 I added tow accounts with
>>>numerical aliases.
>>>When I dial user1 at domain to user2 at domain it's ok.
>>>if i wish to forward to voicemail sems send me
>>
>>back
>>
>>>voicemessages.
>>>However if i dial alias1 at domain to alias2 at domain I
>>>get
>>>
>>>the message below.
>>>
>>>How can I solve this problem ?
>>>
>>>Harry
>>>
>>>
>>
> 
> 
> 	
> 	
> 		
> ___________________________________________________________________________
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
> Téléchargez cette version sur http://fr.messenger.yahoo.com
> 
> _______________________________________________
> Sems mailing list
> sems at lists.iptel.org
> http://lists.iptel.org/cgi-bin/mailman/listinfo/sems
> 




More information about the sr-users mailing list