7 Aug
2005
7 Aug
'05
12:20 a.m.
Hello,
You solution don't solve my problem !
I can't do what i expect with ser+serweb+sems with
your solution.
I want any account like username/password may received
calls from PSTN so I use aliases table + email_address
column.
I use serweb "forward to voicemail" features but
voicemail module just query subscriber table so I
can't forward call to voicemail .
I set to "lookup("aliases")" in route blocks too.
I want to set accounts like this
account: username/password where username=alice
=> sip:alice@domain
=> sip:123456@domain (aliase)
=> sip:s.alice@domain (aliase)
Thanks for help if somebody could povide a shortest
way
Regards
Harry
--- Stefan Sayer <sayer(a)fokus.fraunhofer.de> a écrit :
cmd.user.c_str(),cmd.email.c_str());
///////////////////////////////////////////////////////
///////////////////////////////////////////////////////
+----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
+----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
+----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+
///////////////////////////////////////////////////////
___________________________________________________________________________
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
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",
}
}
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 |
| 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 |
| 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