[asterisk-users] Re: Asterisk Realtime

[Mike Hammett]

  == Parsing '/etc/asterisk/res_mysql.conf': [Mar  7 14:12:37] DEBUG[4380]:
config.c:844 config_text_file_load: Parsing /etc/asterisk/res_mysql.conf
Found
[Mar  7 14:12:37] WARNING[4380]: res_config_mysql.c:555 parse_config: MySQL
RealTime: No database host found, using localhost via socket.
[Mar  7 14:12:37] WARNING[4380]: res_config_mysql.c:555 parse_config: MySQL
RealTime: No database host found, using localhost via socket.
[Mar  7 14:12:37] WARNING[4380]: res_config_mysql.c:569 parse_config: MySQL
RealTime: No database port found, using 3306 as default.
[Mar  7 14:12:37] WARNING[4380]: res_config_mysql.c:569 parse_config: MySQL
RealTime: No database port found, using 3306 as default.
[Mar  7 14:12:37] DEBUG[4380]: res_config_mysql.c:585 parse_config: MySQL
RealTime Host:
[Mar  7 14:12:37] DEBUG[4380]: res_config_mysql.c:586 parse_config: MySQL
RealTime Port: 3306
[Mar  7 14:12:37] DEBUG[4380]: res_config_mysql.c:590 parse_config: MySQL
RealTime User: asterisk
[Mar  7 14:12:37] DEBUG[4380]: res_config_mysql.c:591 parse_config: MySQL
RealTime Password: yourpassword
[Mar  7 14:12:37] DEBUG[4380]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Successfully connected to database.
[Mar  7 14:12:37] NOTICE[4380]: config.c:1174 ast_config_engine_register:
Registered Config Engine mysql
[Mar  7 14:12:37] NOTICE[4380]: config.c:1174 ast_config_engine_register:
Registered Config Engine mysql
MySQL RealTime driver loaded.
res_config_mysql.so => (MySQL RealTime Configuration Driver)


------------------------------

Message: 5
Date: Thu, 01 Mar 2007 20:58:37 +0100
From: Philipp Kempgen <philipp.kempgen at amooma.de>
Subject: Re: [asterisk-users] Asterisk Realtime
To: Asterisk Users Mailing List - Non-Commercial Discussion
	<asterisk-users at lists.digium.com>
Message-ID: <45E7306D.4080001 at amooma.de>
Content-Type: text/plain; charset=ISO-8859-15

Brian Capouch wrote:
> Mike Hammett wrote:
>> Could someone provide some steps for troubleshooting Realtime?  I can't 
>> see any signs that it's working.  I followed and double-checked a few 
>> different guides around the net, but haven't been able to figure it out.
> 
> You don't say which version you're running.
> 
> I *think* the syntax is the same for both:
> 
> realtime <driver-name> status
> 
> will show you the status.  For postgres it's pgsql for driver name 
> (that's what I use).  I think the other driver ids are mysql and odbc.
> 
> If you don't see yourself connected, that's where to start.

Or put
console => notice,warning,error,verbose,debug

in logger.conf
/ run asterisk -vvvvvvvvvvvvvvvvvvvdddddddddddddddddddc  :)

This will give you all MySQL queries and warnings.

Regards,
  Philipp

-- 
amooma GmbH - Bachstr. 126 - 56566 Neuwied - http://www.amooma.de
     Let's use IT to solve problems and not to create new ones.
           Asterisk? -> http://www.das-asterisk-buch.de

Geschdftsf|hrer: Stefan Wintermeyer
Handelsregister: Neuwied B 14998


------------------------------