[Serusers] accounting

[harry gaillac]

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