[OpenSIPS-Users] Opensips + asterisk 1.4

[Willian Mazzardo - SYSSVOIP]

I think if I can change this query, it will work:

Jul 18 18:00:13 opensips /usr/sbin/opensips[7146]:
DBG:db_mysql:re_init_statement:  query  is <select password,ha1 from
subscriber where username=? AND domain=?>, ptr=(nil)

Use without domain=  and now accept any domain.

It is possible?


Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br
55 3537 2030


2013/7/18 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br>

> Sorry ... for test.provider.com I use  opensips.provider.com.br
>
> ;)
>
>
> Willian Mazzardo
> Depto TI - SYSSVOIP
> www.syssvoip.com.br
> 55 3537 2030
>
>
> 2013/7/18 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br>
>
>> Hi Nick ... thanks for your help ... very appreciated.
>>
>> Here is the news... changed the opensips.cfg to your modeparams, and
>> use_domain to 0 and the problem still the same:
>>
>> In my domain tables I have all domains (10.1.1.2, test.provider.com) but
>> into subscriber, i have recreated without VIEW and use more simple data,
>> like 1000 and 1001 as username and password = teste and domain = 10.1.1.2.
>>
>> If I try register softphone with domain = 10.1.1.2, it work, but if I try
>> domain = test.provider.com wich is using 10.1.1.2 as IP address, doesn't
>> work.
>>
>> here is the log:
>>
>> http://pastebin.com/zTz0eNjV
>>
>> Thanks for your help
>>
>>
>> Willian Mazzardo
>> Depto TI - SYSSVOIP
>> www.syssvoip.com.br
>> 55 3537 2030
>>
>>
>> 2013/7/18 Nick Khamis <symack at gmail.com>
>>
>>>  First things first. Forget the asterisk box for now. The phones are
>>> not getting registered with OpenSIPS.
>>> dOES the username, domain, in the digest make sense? Also, recheck the
>>> auth part of your configuration:
>>>
>>> # ----- auth params -----
>>> modparam("auth","username_spec","$avp(user_spec)")
>>> modparam("auth","password_spec","$avp(pass_spec)")
>>>
>>>
>>> # ----- auth_db params -----
>>> /* uncomment the following lines if you want to enable the DB based
>>>    authentication */
>>>
>>> modparam("auth_db", "user_column", "username")
>>> modparam("auth_db", "password_column", "ha1")
>>> # modparam("auth_db", "password_column2", "ha1b")
>>> modparam("auth_db", "use_domain", 1)
>>> modparam("auth_db", "calculate_ha1", 0)
>>> modparam("auth_db", "load_credentials", "rpid")
>>> modparam("auth_db", "load_credentials", "$avp(pass_spec)=ha1")
>>>
>>> Maybe start with clear text username/password and then add the md5 when
>>> you know that it is working. Oh!!! Increase
>>> the debug level of OpenSIPS (debug=4), and eye the REGISTER, it will
>>> show you the clear text usernames and passwords
>>> being sent, the comparisson, and why it's etting rejected. You can post
>>> it on pastebin, but please make sure it's for an example
>>> user (i.e, 1001/12345a), that you will delete later.
>>>
>>> >> Not all my customers use same dns name to register.
>>> >> I have some:  sip.myprovider.com, sip2.myprovider.com,
>>> sip3.myprovider.com and I have my IPs (111.222.333.444).
>>> >> Can I let domain blank to use "any" ?
>>>
>>>
>>> Set, modparam("auth_db", "use_domain", 0).
>>>
>>> Let us know how you progress.
>>>
>>> Cheers,
>>>
>>> Nick from Toronto.
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130718/39352c15/attachment.htm>