14 Dec
2010
14 Dec
'10
10:06 p.m.
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@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@localhost on openser
38 Query select table_version from version
where table_name='subscriber'
38 Quit
39 Connect openser@localhost on openser
39 Query select table_version from version
where table_name='subscriber'
39 Quit
40 Connect openser@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@localhost on openser
42 Connect openser@localhost on openser
43 Connect openser@localhost on openser
44 Connect openser@localhost on openser
45 Connect openser@localhost on openser
46 Connect openser@localhost on openser
47 Connect openser@localhost on openser
48 Connect openser@localhost on openser
49 Connect openser@localhost on openser
50 Connect openser@localhost on openser
51 Connect openser@localhost on openser
Quoting Graham Wooden <graham(a)g-rock.net>et>:
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@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(a)gmail.com>
wrote:
Hello,
On 12/14/10 6:31 AM, Graham Wooden wrote:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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@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@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