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@mydomain or sip:123456789@mydomain or sip:s.alice@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 fetchinguser'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@nxs.yi.org | gaillacharry@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@nxs.yi.org | gaillacharry@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@yahoo.fr a écrit :
Hello,
I use ser/serweb-0.9.3 I added tow accounts with numerical aliases. When I dial user1@domain to user2@domain it's ok. if i wish to forward to voicemail sems send me
back
voicemessages. However if i dial alias1@domain to alias2@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@lists.iptel.org http://lists.iptel.org/cgi-bin/mailman/listinfo/sems