24 Jul
2005
24 Jul
'05
6:15 p.m.
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
///////////////////////////////////////////////////////
Jul 24 14:58:15 serveur1 Sems[2535]: Error:
(AmSession.cpp)(startSession)(497): 404 voicemail: no
email address for user <84>
Jul 24 14:58:15 serveur1 /usr/sbin/ser[7495]: ACC:
call missed: method=INVITE,
i-uri=sip:84@nxs.yi.org:5060;user=phone,
o-uri=sip:h.gaillac@192.168.0.20,
call_id=66219bb6-f9eef79c-bc2479d3(a)192.168.0.21,
from="test"
<sip:test@nxs.yi.org>;tag=CB323432-D0A509E1, code=404
voicemail: no email address for user <84>, userpart=84
///////////////////////////////////////////////////////
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
24 Jul
24 Jul
9:42 p.m.
Can we add email_address column in aliases table
and something like in AnswerMachine.cpp (voicemail
plugin):
email address would be added in aliases table
with someting like: serctl alias add <alias> <uri>
<email>
///////////////////////////////////////////////////////
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
+ "\"");
///////////////////////////////////////////////////////
--- 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
///////////////////////////////////////////////////////
Jul 24 14:58:15 serveur1 Sems[2535]: Error:
(AmSession.cpp)(startSession)(497): 404 voicemail:
no
email address for user <84>
Jul 24 14:58:15 serveur1 /usr/sbin/ser[7495]: ACC:
call missed: method=INVITE,
i-uri=sip:84@nxs.yi.org:5060;user=phone,
o-uri=sip:h.gaillac@192.168.0.20,
call_id=66219bb6-f9eef79c-bc2479d3(a)192.168.0.21,
from="test"
<sip:test@nxs.yi.org>;tag=CB323432-D0A509E1,
code=404
voicemail: no email address for user <84>,
userpart=84
///////////////////////////////////////////////////////
Appel audio GRATUIT partout dans le monde avec le
nouveau Yahoo! Messenger
Téléchargez cette version sur
http://fr.messenger.yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
26 Jul
26 Jul
3:38 p.m.
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 :
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
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
4:58 p.m.
Is this a question or tip for others on how to achieve what you want?
You are doing something unconventional here. Why modify sems' code and the
db structure when you can do what you want with the current ser/sems with
suitable routing logic.
I always lookup the aliases to find the "real" user id and forward to that
user id's voicemail. Other people on the list will likely follow the same
logic. You may have a hard time getting response from others. Not that you
are doing anything wrong with your method but I don't see many people would
follow your way.
Zeus
-----Original Message-----
From: serusers-bounces(a)lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] On Behalf Of harry gaillac
Sent: Tuesday, 26 July 2005 8:39 PM
To: harry gaillac
Cc: serusers(a)lists.iptel.org; sems(a)lists.iptel.org
Subject: [Serusers] accounting
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 :
______________________________________________________________
_____________
Appel audio GRATUIT partout dans le monde avec le nouveau
Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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
8:08 p.m.
Hello,
Is this a question or tip for others on how to
achieve what you want?
both but I don't ask for people achieve what I want.
You are doing something unconventional here.
I don't want to offend anybody but what are the
conventions ?
Why
modify sems' code and the
db structure when you can do what you want with the
current ser/sems with
suitable routing logic.
Why not both ?
I always lookup the aliases to find the
"real" user
id and forward to that
user id's voicemail. Other people on the list will
likely follow the same
logic.
I agree it's not the shortest way.
In fact I use serweb+ser+sems.
I don't find the way to use serweb "forwarding to
voicemail" without modifying sems .
You may have a hard time getting response
from others. Not that you
are doing anything wrong with your method but I
don't see many people would
follow your way.
Zeus
Harry
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
1 Aug
1 Aug
6:31 p.m.
New subject: [Sems] [Serusers] accounting
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 :
___________________________________________________________________________
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
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
7 Aug
7 Aug
3:20 a.m.
New subject: [Sems] [Serusers] accounting
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
25 Jul
25 Jul
4:11 p.m.
On Jul 24, 2005 at 15:15, harry gaillac <gaillacharry(a)yahoo.fr> wrote:
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 ?
Why don't you use lookup("aliases") before forwarding to voicemail?
Andrei
5:03 p.m.
Hello,
I try to make ser/sems/serweb working together.
I add account like this:
"user@domain" and aliase "123@domain".
I ever set "Lookup("aliases");" in ser.cfg.
It's ok for direct calls.
However if callee set "forward to voicemail" via
Serweb or if the callee is unavaible or busy
voicemail module just query subscribers table.
Sems return:
Sems[2535]: Error:
(AmSession.cpp)(startSession)(497): 404 voicemail:
no
email address for user <aliase>
I would like sems find email of the alias !
Harry
--- Andrei Pelinescu-Onciul <andrei(a)iptel.org> a écrit
:
On Jul 24, 2005 at 15:15, harry gaillac
<gaillacharry(a)yahoo.fr> wrote:
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
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 ?
Why don't you use lookup("aliases") before
forwarding to voicemail?
Andrei
5:08 p.m.
You should look at swicthing them, I dont work with sems, but normally
when a user wishes to pick up voicemail, they will have to dial a
numeric number, instead of a alias like iqbal(a)sip.domain.com
Hence many many eons ago, I switched my logic to storing numeric numbers
in subscribers and names in aliases, fits better with the general telco
scenario
iqbal
harry gaillac wrote:
Hello,
I try to make ser/sems/serweb working together.
I add account like this:
"user@domain" and aliase "123@domain".
I ever set "Lookup("aliases");" in ser.cfg.
It's ok for direct calls.
However if callee set "forward to voicemail" via
Serweb or if the callee is unavaible or busy
voicemail module just query subscribers table.
Sems return:
Sems[2535]: Error:
(AmSession.cpp)(startSession)(497): 404 voicemail:
no
email address for user <aliase>
I would like sems find email of the alias !
Harry
--- Andrei Pelinescu-Onciul <andrei(a)iptel.org> a écrit
:
On Jul 24, 2005 at 15:15, harry gaillac
<gaillacharry(a)yahoo.fr> wrote:
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
.
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 ?
Why don't you use lookup("aliases") before
forwarding to voicemail?
Andrei
6840
days inactive
6853
days old
9 comments
5 participants
participants (5)
-
Andrei Pelinescu-Onciul -
harry gaillac -
Iqbal -
Stefan Sayer -
Zeus Ng