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@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
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@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@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@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
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@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
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@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@lists.iptel.org; sems@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 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
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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
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
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@fokus.fraunhofer.de a écrit :
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
Sems mailing list sems@lists.iptel.org
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
On Jul 24, 2005 at 15:15, harry gaillac gaillacharry@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
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@iptel.org a écrit :
On Jul 24, 2005 at 15:15, harry gaillac gaillacharry@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
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
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@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@iptel.org a écrit :
On Jul 24, 2005 at 15:15, harry gaillac gaillacharry@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
___________________________________________________________________________ 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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
.
-
Andrei Pelinescu-Onciul -
harry gaillac -
Iqbal -
Stefan Sayer -
Zeus Ng