Hi,
I have a situation really rare with SER 0.8.14 and MySQL 4.0.11. When I run SER and MySQL in the same box a can make and receive calls without problems, but when I split the DB to another box I always receive a message that says:
check_username(): Digest username and URI username match
3(15079) query="select grp from grp where username='2127701301' AND grp='local'"
3(15079) is_user_in(): User is not in group 'local'
3(15079) parse_headers: flags=-1
Running a ngrep port 3306 from SER I`d never seen a request to the DB getting out the server even though the SER application says to be executing it. (3(15079) query="select grp from grp where username='2127701301' AND grp='local'")
My question:
Do I have to set up anything else in ser.cfg or modified any parameter before to compile the aplication to work in diferent boxes ?
Best Regards,
Daniel Mizrachi
Thanks,
sql log for missed call:
///////////////////////////////////////////////////////
050713 14:23:31 340 Connect
ser(a)serveur1.home.net on
340 Init DB ser
340 Init DB ser
340 Query select first_name,
last_name from subscriber where (username='bob' and
domain='nxs.yi.org')
340 Init DB ser
340 Query select timezone
from subscriber where (username='bob' and
domain='nxs.yi.org')
340 Init DB ser
340 Query SELECT count(*)
FROM missed_calls t1 WHERE t1.username='bob' and
t1.domain='nxs.yi.org'
340 Init DB ser
340 Query SELECT count(*)
FROM missed_calls t1, aliases t2 WHERE
'sip:bob@nxs.yi.org'=t2.contact AND
t2.username=t1.username AND t2.domain=t1.domain
340 Init DB ser
340 Query (select
t1.from_uri as inv_to_uri,
t1.sip_from as inv_sip_to,
t1.sip_callid as inv_callid,
t1.time as inv_time,
t1.fromtag as inv_fromtag,
t1.sip_status as inv_status,
null
as bye_to_uri,
null
as bye_sip_to,
null
as bye_callid,
null
as bye_time,
null
as bye_fromtag,
null
as bye_totag,
null
as bye_from_uri,
null
as bye_sip_from,
null
as length,
t1.time as ttime , 'missed' as call_type FROM
missed_calls t1 WHERE t1.username='bob' and
t1.domain='nxs.yi.org' ) UNION (select t1.from_uri as
inv_to_uri,
t1.sip_from as inv_sip_to,
t1.sip_callid as inv_callid,
t1.time as inv_time,
t1.fromtag as inv_fromtag,
t1.sip_status as inv_status,
null
as bye_to_uri,
null
as bye_sip_to,
null
as bye_callid,
null
as bye_time,
null
as bye_fromtag,
null
as bye_totag,
null
as bye_from_uri,
null
as bye_sip_from,
null
as length,
t1.time as ttime , 'missed' as call_type FROM
missed_calls t1, aliases t2 WHERE
'sip:bob@nxs.yi.org'=t2.contact AND
t2.username=t1.username AND t2.domain=t1.domain )
order by ttime desc limit 0, 20
340 Quit
///////////////////////////////////////////////////////
missed_calls table:
mysql> select * from missed_calls;
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
| sip_from
| sip_to | sip_status |
sip_method | i_uri | o_uri
| from_uri | to_uri
| sip_callid
| username | domain | fromtag | totag | time
| timestamp |
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
| "alice" <sip:alice@nxs.yi.org>;tag=C7F9FEE3-D707AE46
| <sip:84@nxs.yi.org;user=phone> | 482 Loop Detected |
INVITE | sip:84@nxs.yi.org:5060;user=phone |
sip:alice@192.168.0.20 | sip:alice@nxs.yi.org |
sip:84@nxs.yi.org;user=phone |
a75a9eaf-a34e6609-202b22c(a)192.168.0.20 | n/a |
n/a | C7F9FEE3-D707AE46 | n/a | 2005-07-13
11:24:23 | 20050713132423 |
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
1 row in set (0.00 sec)
Serweb reply "No missed calls"
Harry
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
apparently that happens because of this line.
if (!mf_process_maxfwd_header("16")) {
sl_send_reply("483", "Too Many Hops !");
break;
};
but if i comment it out, there is a infinite loop happening at the background.
then it comeout timeout again.
btw, do u have
modparam("msilo", "registrar","sip:registrar@XXXXXX")
in ur ser.cfg?
At 08:18 PM 7/13/2005, you wrote:
>--- Kong <kongzs(a)irepublics.com> a écrit :
>
> > Humm.. that seems to help, but now i got this error.
> >
> > 483 Too Many Hops
> >
> > i wonder how is that....
> > do i really need this line?
> > modparam("msilo", "registrar",
> > "sip:registrar@XXXXXX")
>
>according to doc not really
>
> > At 07:08 PM 7/13/2005, you wrote:
> > >read
> > http://openser.org/docs/modules/0.9.x/msilo.html
> > >
> > > The method stores certain parts of the current
> > SIP
> > >request (it should be called when the request type
> > is
> > >MESSAGE and the destination user is offline or his
> > UA
> > >does not support MESSAGE requests). If the user is
> > >registered with a UA which does not support MESSAGE
> > >requests you should not use mode="0" if you have
> > >changed the request uri with the contact address of
> > >user's UA.
> > >
> > >Meaning of the parameters is as follows:
> > > mode - specifies what to save as R-URI.
> > >"0" - first check if new_uri is an address of
> > record.
> > >If yes, then use it and store it as R-URI,
> > otherwise
> > >look at R-URI and, if necessary, at URI from "To"
> > >header.
> > >"1" - look first at R-URI and then at URI from "To"
> > >header.
> > >"2" - look only at URI form "To" header.
> > >
> > >I have to set IM I use ser/serweb 0.9.3
> > >
> > >Harry
> > >--- Kong <kongzs(a)irepublics.com> a écrit :
> > >
> > > > Tried Windows Messenger, Xlite, SJPhone,
> > FireFly.
> > > >
> > > > modparam("msilo", "registrar",
> > > > "sip:registrar@XXXXXX")
> > > >
> > > > am i suppose to put XXXXXX as my domain?
> > > >
> > > > then do i need to create any user call
> > registrar?
> > > >
> > > > At 06:24 PM 7/13/2005, you wrote:
> > > > >What is your UA ?
> > > > >--- Kong <kongzs(a)irepublics.com> a écrit :
> > > > >
> > > > > > I am trying to implement Messaging from
> > serweb
> > > > to
> > > > > > UA, but not a success.
> > > > > >
> > > > > > i have this script in my ser.cfg
> > > > > >
> > > > > > if (!lookup("location")) {
> > > > > > if (method == "MESSAGE") {
> > > > > > if (!t_newtran()) {
> > > > > > sl_reply_error();
> > > > > > break;
> > > > > > };
> > > > > >
> > > > > > if (m_store("0")) {
> > > > > > t_reply("202", "Accepted for Later
> > > > > > Delivery");
> > > > > > break;
> > > > > > };
> > > > > > };
> > > > > >
> > > > > > sl_send_reply("404", "User Not Found
> > !");
> > > > > > break;
> > > > > > };
> > > > > >
> > > > > > but i read somewhere in google that i need
> > to
> > > > add in
> > > > > > this line.
> > > > > > modparam("msilo", "registrar",
> > > > > > "sip:registrar@iptel.org")
> > > > > > so that the UA will be notify if there is
> > any
> > > > new
> > > > > > message.
> > > > > >
> > > > > > If i don't add this line, the message can be
> > > > send
> > > > > > from serweb to the
> > > > > > account (which stored in SILO) then can be
> > > > checked
> > > > > > from the recipient
> > > > > > serweb account. But once i add the registrar
> > > > line
> > > > > > in, the sending process
> > > > > > return error code of 405 timeout. can i know
> > > > whats
> > > > > > the problem here?
> > > > > >
> > > > > > i am using ser-0.9.3
> > > > > >
> > > > > > thank you. >
> > > > >_______________________________________________
> > > > > > 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
> > > >
> > > > _______________________________________________
> > > > 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
> >
> > _______________________________________________
> > 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
Hello, Is it possible to allow an UA to make calls
without it registering itself? IN other words, I
disable registration on the phone and enter the
correct proxy info. Now when UA makes call, the INVITE
goes to SER. Can SER extract the contact info from the
INVITE and then upon detecting that the "user is not
registered" simply register the contact info?
Thanks
Dave
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Humm.. that seems to help, but now i got this error.
483 Too Many Hops
i wonder how is that....
do i really need this line?
modparam("msilo", "registrar", "sip:registrar@XXXXXX")
At 07:08 PM 7/13/2005, you wrote:
>read http://openser.org/docs/modules/0.9.x/msilo.html
>
> The method stores certain parts of the current SIP
>request (it should be called when the request type is
>MESSAGE and the destination user is offline or his UA
>does not support MESSAGE requests). If the user is
>registered with a UA which does not support MESSAGE
>requests you should not use mode="0" if you have
>changed the request uri with the contact address of
>user's UA.
>
>Meaning of the parameters is as follows:
> mode - specifies what to save as R-URI.
>"0" - first check if new_uri is an address of record.
>If yes, then use it and store it as R-URI, otherwise
>look at R-URI and, if necessary, at URI from "To"
>header.
>"1" - look first at R-URI and then at URI from "To"
>header.
>"2" - look only at URI form "To" header.
>
>I have to set IM I use ser/serweb 0.9.3
>
>Harry
>--- Kong <kongzs(a)irepublics.com> a écrit :
>
> > Tried Windows Messenger, Xlite, SJPhone, FireFly.
> >
> > modparam("msilo", "registrar",
> > "sip:registrar@XXXXXX")
> >
> > am i suppose to put XXXXXX as my domain?
> >
> > then do i need to create any user call registrar?
> >
> > At 06:24 PM 7/13/2005, you wrote:
> > >What is your UA ?
> > >--- Kong <kongzs(a)irepublics.com> a écrit :
> > >
> > > > I am trying to implement Messaging from serweb
> > to
> > > > UA, but not a success.
> > > >
> > > > i have this script in my ser.cfg
> > > >
> > > > if (!lookup("location")) {
> > > > if (method == "MESSAGE") {
> > > > if (!t_newtran()) {
> > > > sl_reply_error();
> > > > break;
> > > > };
> > > >
> > > > if (m_store("0")) {
> > > > t_reply("202", "Accepted for Later
> > > > Delivery");
> > > > break;
> > > > };
> > > > };
> > > >
> > > > sl_send_reply("404", "User Not Found !");
> > > > break;
> > > > };
> > > >
> > > > but i read somewhere in google that i need to
> > add in
> > > > this line.
> > > > modparam("msilo", "registrar",
> > > > "sip:registrar@iptel.org")
> > > > so that the UA will be notify if there is any
> > new
> > > > message.
> > > >
> > > > If i don't add this line, the message can be
> > send
> > > > from serweb to the
> > > > account (which stored in SILO) then can be
> > checked
> > > > from the recipient
> > > > serweb account. But once i add the registrar
> > line
> > > > in, the sending process
> > > > return error code of 405 timeout. can i know
> > whats
> > > > the problem here?
> > > >
> > > > i am using ser-0.9.3
> > > >
> > > > thank you. >
> > >_______________________________________________
> > > > 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
> >
> > _______________________________________________
> > 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
Hi all
Iam very new to this field. I would like to know how
can i configure this SER. I want to use this in our
Lab environment.
Thank You.
Regards,
Dinesh.
__________________________________________________________
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
Hi,
I have ser 0.9.3 installed on freebsd 4.10, everything else seems to
work fine, except that it says host is down in the logs. It happens only
after i run the softphone to test. I have port forwarded (the client's
behind a NAT) but to no avail.
Jul 13 14:46:05 flamejob ser[38889]: msg_send: ERROR: udp_send failed
Jul 13 14:47:24 flamejob ser[38889]: ERROR: udp_send:
sendto(sock,0x28411478,551,0,0x28408870,16): Host is down(64)
and here's my ser.cfg
debug=3 # debug level (cmd line: -dddddddddd)
#fork=yes
#log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://root:password@localhost/ser"
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- usrloc params --
modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
Thanks,
Zaihan
