[asterisk-dev] Problem with res_config_mysql

Taylor, Jonn jonnt at taylortelephone.com
Thu Nov 8 20:50:27 CST 2012


I am trying to use res_config_mysql to store phone information from 
chan_sccp-b. I can not get the module to connect to the mysql database. 
I can configure the sccp module with config files and everything works 
fine. Here is my configs.

res_config_mysql.conf

[general]
dbhost = localhost
dbport = 3306
dbname = asterisk
dbuser = asteriskuser
dbpass = xxxxxxxxx
dbsock = /var/lib/mysql/mysql.sock
requirements=warn ; or createclose or createchar

Asterisk SVN-trunk-r375175, Copyright (C) 1999 - 2012 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.
=========================================================================
   == Parsing '/etc/asterisk/extconfig.conf': Found
   == Binding meetme to odbc/meetme/booking
   == Binding sccpdevice to mysql/asterisk/sccpdeviceconfig
   == Binding sccpline to mysql/asterisk/sccpline
Connected to Asterisk SVN-trunk-r375175 currently running on gateway 
(pid = 19431)
gateway*CLI> realtime mysql status
general connected to asterisk at localhost, port 3306 with username 
asteriskuser for 9 minutes.
     -- SCCP: Accepted connection from 192.168.183.120
     -- SCCP: Using ip 192.168.183.1
     -- SCCP: Alarm Message: Severity: Informational (2), 24: 
Name=SEP001BD51256C4 Load=8.1(2.0) Last=Phone-Reg-Rej [2048/2025302208]
[2012-11-08 20:48:46] WARNING[9513]: res_config_mysql.c:335 
realtime_mysql: MySQL RealTime: Invalid database specified: asterisk 
(check res_mysql.conf)
[2012-11-08 20:48:46] NOTICE[9513]: sccp_actions.c:439 
sccp_handle_register: SEP001BD51256C4: Rejecting device: Device Unknown
gateway*CLI>




More information about the asterisk-dev mailing list