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@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@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@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@qa-voip-01 kamailio-3.1.1]# kamctl add testnumber testpass new user 'testnumber' addedMade 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
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users