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 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@nxs.yi.org |
gaillacharry(a)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(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/cgi-bin/mailman/listinfo/sems