[SR-Users] Can't Auth against Kamailio 3.1.1 - fresh install
Daniel-Constantin Mierla
miconda at gmail.com
Tue Dec 14 22:17:30 CET 2010
Hello,
run kamailio from console with -E -ddd command line parameters and read
the printed log messages. You should be able to figure out whether is
reaching authentication part of configuration file. Also, adding
xlog(...) calls in config file might be useful for you to troubleshoot.
From the logs you sent, looks like auth db is enabled. Maybe the
from/r-uri don't match myself condition, are you using hostnames or IP
addresses?
Cheers,
Daniel
On 12/14/10 9:06 PM, Graham Wooden wrote:
> Some more insight here. This time I did a distclean on the src, and
> followed the step-by-step from the GIT stable branch page (opposed to
> reference any other sources).
>
> I restarted kamailio now I am seeing more MySQL connectivity - but no
> queries to check the subscriber table upon authenticating. That
> select against the location table I believe was a result from me doing
> a "kamctl ul show".
>
> This is what MySQL is seeing. Any thoughts?
>
>
> 101214 13:44:10 37 Connect openser at localhost on openser
> 37 Query select table_version from version
> where table_name='location'
> 37 Query select username from location
> where username='dummy_user'
> 37 Quit
> 38 Connect openser at localhost on openser
> 38 Query select table_version from version
> where table_name='subscriber'
> 38 Quit
> 39 Connect openser at localhost on openser
> 39 Query select table_version from version
> where table_name='subscriber'
> 39 Quit
> 40 Connect openser at localhost on openser
> 40 Query select
> username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified
> from location
> 41 Connect openser at localhost on openser
> 42 Connect openser at localhost on openser
> 43 Connect openser at localhost on openser
> 44 Connect openser at localhost on openser
> 45 Connect openser at localhost on openser
> 46 Connect openser at localhost on openser
> 47 Connect openser at localhost on openser
> 48 Connect openser at localhost on openser
> 49 Connect openser at localhost on openser
> 50 Connect openser at localhost on openser
> 51 Connect openser at localhost on openser
>
>
>
> Quoting Graham Wooden <graham at g-rock.net>:
>
>> Thanks for the reply Daniel.
>>
>> That was one of the docs that I was referred to, and those defines were
>> added. I have this towards the top of the cfg file (above the
>> if/elses):
>>
>> #!define WITH_MYSQL
>> #!define WITH_AUTH
>> #!define WITH_USRLOCDB
>> #!define WITH_DEBUG
>> #!define WITH_ACCDB
>>
>> I turned up mysql query logging, and I don't see kamailio attempting to
>> query MySQL. All I get so far is this:
>>
>> 101214 6:53:25
>> 1 Connect UNKNOWN_MYSQL_US at localhost as anonymous on
>> 1 Quit
>>
>> I can the phone trying every 10-15 seconds to register...
>>
>> So, I am definitely missing a piece, somewhere, to tie in MySQL during
>> runtime. Which is weird, since I was able to use the kamdbctl to
>> create the
>> DB and kamctl to add the user. Nothing else was really
>> altered/removed from
>> the cfg, it's pretty much default right now.
>>
>> Thanks for any guidance.
>>
>> -graham
>>
>>
>>
>> On 12/14/10 4:02 AM, "Daniel-Constantin Mierla" <miconda at gmail.com>
>> wrote:
>>
>>> Hello,
>>>
>>> On 12/14/10 6:31 AM, Graham Wooden wrote:
>>>> Hi folks,
>>>>
>>>> Getting ready to stage my 1.4.2 upgrade to 3.1.1 - but apparently I am
>>>> missing something pretty basic here as I can't get a test subscriber
>>>> registered. Turned up debug and viewed the "401 Unauthorized"
>>>> repeating
>>>> messages.
>>>>
>>>> So I combed back through the INSTALL and the various references on
>>>> kamailio.org. And for full disclosure, here are the relevant steps
>>>> that I
>>>> have took:
>>>>
>>>> Did a make clean on the source and re-did the make, which looks like:
>>>>
>>>> make FLAVOUR=kamailio group_include="standard mysql"
>>>> include_modules="carrierroute acc mi_fifo kex tmx pv siputils
>>>> mi_rpc" cfg
>>>> all install
>>>>
>>>> Added my domain into kamctlrc.
>>>>
>>>> Created a fresh DB, started up kamailio and added a user:
>>>>
>>>> [root at qa-voip-01 kamailio-3.1.1]# kamctl add testnumber testpass
>>>> new user 'testnumber' added
>>>>
>>>> Made the appropriate changes to the default kamailio.cfg by adding
>>>> in the
>>>> defines. Restarted kamailio - no errors and all looked good.
>>>>
>>>> At this point, all indications would think that I can get the
>>>> subscriber
>>>> registered and get the location table updated ... But no such luck:
>>>>
>>>> [root at qa-voip-01 kamailio]# kamctl ul show
>>>> Domain:: location table=512 records=0 max_slot=0
>>>>
>>>> Any thoughts on where to look? I have confirmed that the
>>>> subscriber device
>>>> is using the right credentials. Using plaintext and the password is in
>>>> user's row in the subscriber table.
>>>>
>>>> I am sure it's something pretty basic; this is my first stab at 3.1
>>>> from my
>>>> 1.4 production machines.
>>> starting with 3.0, we introduced config define directives that allow to
>>> enable/disable easier features such as authentication. Practically,
>>> with
>>> default config you have to add #!define WITH_MYSQL and #!define
>>> WITH_AUTH
>>>
>>> For a step-by-step installation from GIT stable branch, see:
>>> http://www.kamailio.org/dokuwiki/doku.php/install:kamailio-3.1.x-from-git
>>>
>>>
>>> Cheers,
>>> Daniel
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
Kamailio (OpenSER) Advanced Training
Jan 24-26, 2011, Irvine, CA, USA
http://www.asipto.com
More information about the sr-users
mailing list