asterisk users - Mar 2008 - Asterisk Realtime and SIP configuration

Dear all

I'm writing to the list for help as a last resort. I've exhausted all 
other options, so please forgive me. I've lurked here for years but 
never actually posted.

I'm trying to get Asterisk Realtime SIP configuration working, but it 
refuses to do so. I have all the necessary configuration in place, 
Asterisk makes a connection to the database, which can be verified with 
"realtime mysql status", but it WILL NOT query the database to find
SIP
accounts ([general] SIP configuration is still in the normal 
configuration file).

I'm tailing the MySQL query log and there simply aren't ANY queries on 
the table containing my SIP users. Here's my config:

-- res_mysql.conf
[general]
dbhost = 127.0.0.1
dbname = <valid name>
dbuser = <valid user>
dbpass = <valid pass>
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

-- extconfig.conf
[global]
sipusers => mysql,<valid db>,telephones
sippeers => mysql,<valid db>,telephones

(combinations of removing sipusers and sippeers lines make no difference)

Asterisk is *definitely* connecting successfully, and I've verified that 
the user it's using has all the relevant DB and table access within 
MySQL. But here's the funny thing:

When I issue "realtime mysql status", the following appears on the end
of the MySQL query log:

080307 10:11:09	      9 Init DB     <db name>

This happens reliably, I can up-arrow and enter as many times as I like 
and for each time a line like this will appear. This is how I know that 
Asterisk is definitely connecting to MySQL. But if I run "realtime load 
telephones name sip_1_002" I get (on the * console):

"No rows found matching search criteria."

... but NOTHING in the MySQL query log. It *IS NOT* querying the 
database, it's not even trying.

Why is it not doing this? Any ideas? I've lost significant brain cells 
to this and I'm out of options. I can't find a single other instance of 
someone having this problem.

Background information: Asterisk 1.4.14 running on its own (i.e. no 
external telephony). MySQL 5.0.22.

Many thanks!

Stu

-- 
Stuart Benjamin Ford
Chief Technical Officer

Zimo Communications Ltd.
Landmark House
Station Road
Cheadle Hulme
Cheshire
SK8 7BS

Switch	0800 321 3000
Fax	08703 850 860
Direct	0800 321 3763
E-mail	sbf at zimo.co.uk
Web	www.zimo.co.uk

What does "show config mappings" show ?

Julian

Stuart Ford wrote:
> Dear all
> 
> I'm writing to the list for help as a last resort. I've exhausted
all
> other options, so please forgive me. I've lurked here for years but 
> never actually posted.
> 
> I'm trying to get Asterisk Realtime SIP configuration working, but it 
> refuses to do so. I have all the necessary configuration in place, 
> Asterisk makes a connection to the database, which can be verified with 
> "realtime mysql status", but it WILL NOT query the database to
find SIP
> accounts ([general] SIP configuration is still in the normal 
> configuration file).
> 
> I'm tailing the MySQL query log and there simply aren't ANY queries
on
> the table containing my SIP users. Here's my config:
> 
> -- res_mysql.conf
> [general]
> dbhost = 127.0.0.1
> dbname = <valid name>
> dbuser = <valid user>
> dbpass = <valid pass>
> dbport = 3306
> dbsock = /var/lib/mysql/mysql.sock
> 
> -- extconfig.conf
> [global]
> sipusers => mysql,<valid db>,telephones
> sippeers => mysql,<valid db>,telephones
> 
> (combinations of removing sipusers and sippeers lines make no difference)
> 
> Asterisk is *definitely* connecting successfully, and I've verified
that
> the user it's using has all the relevant DB and table access within 
> MySQL. But here's the funny thing:
> 
> When I issue "realtime mysql status", the following appears on
the end
> of the MySQL query log:
> 
> 080307 10:11:09	      9 Init DB     <db name>
> 
> This happens reliably, I can up-arrow and enter as many times as I like 
> and for each time a line like this will appear. This is how I know that 
> Asterisk is definitely connecting to MySQL. But if I run "realtime
load
> telephones name sip_1_002" I get (on the * console):
> 
> "No rows found matching search criteria."
> 
> ... but NOTHING in the MySQL query log. It *IS NOT* querying the 
> database, it's not even trying.
> 
> Why is it not doing this? Any ideas? I've lost significant brain cells 
> to this and I'm out of options. I can't find a single other
instance of
> someone having this problem.
> 
> Background information: Asterisk 1.4.14 running on its own (i.e. no 
> external telephony). MySQL 5.0.22.
> 
> Many thanks!
> 
> Stu
>

Julian Lyndon-Smith wrote:
> What does "show config mappings" show ?
zateteis*CLI> core show config mappings
zateteis*CLI>

Config Engine: mysql

Seems mysteriously ... light :)

Stu

-- 
Stuart Benjamin Ford
Chief Technical Officer

Zimo Communications Ltd.
Landmark House
Station Road
Cheadle Hulme
Cheshire
SK8 7BS

Switch	0800 321 3000
Fax	08703 850 860
Direct	0800 321 3763
E-mail	sbf at zimo.co.uk
Web	www.zimo.co.uk

Julian Lyndon-Smith wrote:
> your extconfig is wrong.
> 
> try
> 
> [globals]
> [settings]
> 
> sipusers => mysql,<valid db>,telephones
> sippeers => mysql,<valid db>,telephones
Oh you're a life-saver! I have other problems with it now but they're 
unrelated to this config and I don't expect they're insurmountable, so 
many thanks!

Stu

-- 
Stuart Benjamin Ford
Chief Technical Officer

Zimo Communications Ltd.
Landmark House
Station Road
Cheadle Hulme
Cheshire
SK8 7BS

Switch	0800 321 3000
Fax	08703 850 860
Direct	0800 321 3763
E-mail	sbf at zimo.co.uk
Web	www.zimo.co.uk