Hi all,
I'm running ser with dbtext, and I can't install mysql on my system.
Can anybody tell me if the aliases table is loaded by ser when it starts?
I also need to know what exactly each field must contain, so if somebody can give me an example of a line of the aliases table, it will be great.
Thanks in advance.
B.R. Xavier
Attached is a sample dbtext file which maps 5060@iptel.org to sip:jan@iptel.org. meaning of the columns is as follows:
username -- the alias username domain -- alias domain contact -- the URI the alias maps to received -- source IP and port of the REGISTER message (empty for aliases) expires -- The date and time the alias expires, in number of seconds since 1.1. 1970 UTC (ignored if permanent flag is set) q -- Preference of the alias among aliases with same username and domain callid -- Calli-ID from REGISTER message, not used for aliases cseq -- CSeq number from REIGSTER message, not used for aliases flags -- Various flags, flag 7 (value 127 if no other flag is set) means that the alias is permanent user_agent -- User agent string from REGISTER, not used with aliases instance -- SIP instance parameter, not used with aliases
On 08-12-2005 12:42, Xavier TRENTIN wrote:
Hi all,
I'm running ser with dbtext, and I can't install mysql on my system.
Can anybody tell me if the aliases table is loaded by ser when it starts?
Yes if you have lookup("aliases") in your configuration file.
Jan.
Thanks Jan,
I just forgot to backslash the ":" in the sip address...but it seems that it doesn't work anymore.
I've add 1005 as an alias for sip:1000@mydomain in my dbtext table.
When I run ser and try to show alias information I have the following answer :
#./serctl alias show 1005 entering fifo_cmd ul_show_contact aliases 1005@mydomain 404 Username 1005@mydomain in table aliases not found FIFO command was: :ul_show_contact:ser_receiver_5363 aliases 1005@mydomain
When I add the alias with serctl it works fine :
#./serctl alias add 1005 sip:1000@mysdomain entering fifo_cmd ul_add aliases 1005@mydomain sip:1000@mydomain 0 1.00 0 128 200 Added to table ('1005','sip:1000@mydomain) to 'aliases' FIFO command was: :ul_add:ser_receiver_6073 aliases 1005@mydomain sip:1000@mydomain 0 1.00 0 128
# ./serctl alias show 1005 entering fifo_cmd ul_show_contact aliases 1005@mydomain sip:1000@mydomain;q=1;expires=-11 FIFO command was: :ul_show_contact:ser_receiver_6108 aliases 1005@mydomain
Jan Janak a écrit :
Pas de virus detecté dans l'attachement no filename Pas de virus detecté dans l'attachement aliases
Votre Mail a été vérifié par InterScan. ***********-***********
Attached is a sample dbtext file which maps 5060@iptel.org to sip:jan@iptel.org. meaning of the columns is as follows:
username -- the alias username domain -- alias domain contact -- the URI the alias maps to received -- source IP and port of the REGISTER message (empty for aliases) expires -- The date and time the alias expires, in number of seconds since 1.1. 1970 UTC (ignored if permanent flag is set) q -- Preference of the alias among aliases with same username and domain callid -- Calli-ID from REGISTER message, not used for aliases cseq -- CSeq number from REIGSTER message, not used for aliases flags -- Various flags, flag 7 (value 127 if no other flag is set) means that the alias is permanent user_agent -- User agent string from REGISTER, not used with aliases instance -- SIP instance parameter, not used with aliases
On 08-12-2005 12:42, Xavier TRENTIN wrote:
Hi all,
I'm running ser with dbtext, and I can't install mysql on my system.
Can anybody tell me if the aliases table is loaded by ser when it starts?
Yes if you have lookup("aliases") in your configuration file.
Jan.
username(str) domain(str) contact(str) received(str,null) expires(int) q(double) callid(str,null) cseq(int,null) flags(int) user_agent(str,null) instance(str,null) 5060:iptel.org:sip:jan@iptel.org::2334042683:1.0:some-callid:1:127:::