asterisk users - Feb 2011 - Realtime MySQL - Asterisk 1.8.2

Hi to all.

I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem,
the asterisk don't connect in the base and show this message:

[Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441
realtime_multi_mysql: MySQL RealTime: Invalid database specified:
'asterisk_teste' (check res_mysql.conf)


I checked the asterisk config file (res_mysql.conf) and the configuration is
ok. My configuration of table and extconfig.conf is the same of the version
1.6.0.

The cdr use the same base, same user/pass, and his save the registers ok.

This is happening to the queues, queues_members, muscionhold and queue_log
in Realtime (That's is all the modules i use in Realtime).

I tested the base and the MySQL and is working ok.


I appreciate in advance any help,
-- 
Rodrigo Lang
Opening your mind - Just another Open Source
site<http://openingyourmind.wordpress.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110217/e4dc8ab8/attachment.htm>

On Thu, 2011-02-17 at 11:28 -0200, Rodrigo Lang wrote:
> Hi to all.
> 
> I make some tests with Asterisk 1.8.2 in Realtime. But i have one
> problem, the asterisk don't connect in the base and show this message:
> 
> [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441
> realtime_multi_mysql: MySQL RealTime: Invalid database specified:
> 'asterisk_teste' (check res_mysql.conf)
> 
> 
> I checked the asterisk config file (res_mysql.conf) and the
> configuration is ok. My configuration of table and extconfig.conf is
> the same of the version 1.6.0.
> 
> The cdr use the same base, same user/pass, and his save the registers
> ok.
> 
> This is happening to the queues, queues_members, muscionhold and
> queue_log in Realtime (That's is all the modules i use in Realtime).
> 
> I tested the base and the MySQL and is working ok.
> 
> 
> I appreciate in advance any help,
> -- 
> Rodrigo Lang
> Opening your mind - Just another Open Source site
The res_mysql.conf format changed from 1.6 to 1.8

The config now goes in in the following format

[db-name]
dbhost = x.x.x.x
dbname = db-name
dbuser = db-user
dbpass = db-pass
dbport = 3306


Is this how yours is set up?

-- 
Ishfaq Malik
Software Developer
PackNet Ltd

Office:   0161 660 3062