[asterisk-bugs] [Asterisk 0015077]: [patch] Realtime SIP not working in current SVN

Mon May 11 14:54:49 CDT 2009

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=15077 
====================================================================== 
Reported By:                MichaelLinke
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15077
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!): 147 
Request Review:              
====================================================================== 
Date Submitted:             2009-05-11 06:22 CDT
Last Modified:              2009-05-11 14:54 CDT
====================================================================== 
Summary:                    [patch] Realtime SIP not working in current SVN
Description: 
There seams to be an broken connection beetwen the Aterisk SIP Module in
Realtime mode and res_config_mysql.
Asterisk report an missimg mysql table for alle configured tables in
extconfig.conf.
The mysql server is working and the tables exist. The mysql server log
shows that no request hast been send to the server.
And "realtime mysql status" shows that the realtime module is connected to
the mysql server.
Using the same configurations files, this mysql configuration is working
in Asterisk 1.4 and 1.6.0 without any problems. 
And the  cdr_addon_mysql.c works in this svn version using the same mysql
parameters.

It seams as the there is a bug so that no request is send and so the
asterisk think that there is no table. So the error message is wrong.

====================================================================== 

---------------------------------------------------------------------- 
 (0104548) MichaelLinke (reporter) - 2009-05-11 14:54
 http://bugs.digium.com/view.php?id=15077#c104548 
---------------------------------------------------------------------- 
Hi, here a new log and the requested files:

Asterisk SVN-trunk-r193461, Copyright (C) 1999 - 2009 Digium, Inc. and
others.
Created by Mark Spencer <markster at digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for
details.
This is free software, with components licensed under the GNU General
Public
License version 2 and other licenses; you are welcome to redistribute it
under
certain conditions. Type 'core show license' for details.
=========================================================================
[ Booting...
[ Reading Master Configuration ]
[ Initializing Custom Configuration Options ]
[May 11 21:31:33] NOTICE[5374]: cdr.c:1441 do_reload: CDR simple logging
enabled.
[May 11 21:31:33] NOTICE[5374]: loader.c:860 load_modules: 99 modules will
be loaded.
...[May 11 21:31:33] NOTICE[5374]: config.c:1958
ast_config_engine_register: Registered Config Engine mysql
....SIP channel loading...
[May 11 21:31:33] WARNING[5374]: res_config_mysql.c:203 find_table:
Database 'asterisk' not found!
[May 11 21:31:33] WARNING[5374]: res_config_mysql.c:1124 require_mysql:
Table sip_intern not found in database.  This table should exist if you're
using realtime.
..[May 11 21:31:33] ERROR[5374]: pbx_dundi.c:4597 set_config: Unable to
load config dundi.conf
...........[May 11 21:31:33] NOTICE[5374]: app_meetme.c:4435
load_config_meetme: Audio buffers per channel set to 16
[May 11 21:31:33] WARNING[5374]: res_config_mysql.c:203 find_table:
Database 'asterisk' not found!
[May 11 21:31:33] WARNING[5374]: res_config_mysql.c:1124 require_mysql:
Table meetme not found in database.  This table should exist if you're
using realtime.

cat /etc/asterisk/extconfig.conf
; Static and realtime external configuration
; engine configuration
;
; Please read doc/extconfig.txt for basic table
; formatting information.
;
[settings]
;
; Static configuration files:
;
; file.conf => driver,database[,table]
;
; maps a particular configuration file to the given
; database driver, database and table (or uses the
; name of the file as the table if not specified)

;
; Realtime configuration engine
;
meetme => mysql,asterisk,meetme
sippeers => mysql,asterisk,sip_intern
sipusers => mysql,asterisk,sip_intern
;sipregs => mysql,asterisk,sip_intern
extensions => mysql,asterisk,dialplan

speak => mysql,asterisk,dialplan_helper_record
record => mysql,asterisk,dialplan_helper_speak

# vi /etc/asterisk/res_mysql.conf
;
; Sample configuration for res_config_mysql.c
;
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string "localhost", a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
;
[general]
dbhost = wwx.xxxx.de
dbname = asterisk
dbuser = xxxxxxx
dbpass = xxxxxxx
dbport = 3306
dbsock = /tmp/mysql.sock
requirements=warn

And here the MYSQL Server Log:
tail -f /var/log/mysql/mysql.log

090511 21:37:1213007 Connect    asterisk at localhost on asterisk
                13007 Query     SET NAMES ''
                13007 Query     DESC cdr

As we see here there is an connect, but only from the cdr module. The
Realtime module don't speak with the server. If I connect to mysql server
from the shell using the same parameters, I can see all needed tables and
data. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-11 14:54 MichaelLinke   Note Added: 0104548                          
======================================================================