asterisk users - Oct 2006 - Unable to open Asterisk database

Hi,
I'm using mysql to store my cdr data. I compiled asterisk-addon module 
without problems and I see nothing unusual in my cdr_mysql.conf but when 
I do a reload I get this messages (never seen before):

Oct 16 09:43:16 WARNING[8576]: db.c:67 dbinit: Unable to open Asterisk 
database
Oct 16 09:43:16 WARNING[8576]: db.c:423 ast_db_gettree: Database unavailable

But If I try to connect from shell it works without any problem.

Does anybody know why?

Giorgio Incantalupo

Giorgio Incantalupo wrote:
> Hi,
> I'm using mysql to store my cdr data. I compiled asterisk-addon module 
> without problems and I see nothing unusual in my cdr_mysql.conf but 
> when I do a reload I get this messages (never seen before):
>
> Oct 16 09:43:16 WARNING[8576]: db.c:67 dbinit: Unable to open Asterisk 
> database
> Oct 16 09:43:16 WARNING[8576]: db.c:423 ast_db_gettree: Database 
> unavailable
>
> But If I try to connect from shell it works without any problem.
>
> Does anybody know why?
>
> Giorgio Incantalupo
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
cross check ur modules.conf and cdr_mysql.conf
modules.conf shud have 'load => cdr_addon_mysql.so'

neway..  its something to do with your sql configuration,
wrong passwords, usernames, host and permissions on sql.

seen these errors too often.  n the reasons r human error.

cheerz
Ben.

Ciao Giorgio,
> I'm using mysql to store my cdr data. I compiled asterisk-addon
> module without problems and I see nothing unusual in my
> cdr_mysql.conf but when I do a reload I get this messages (never seen
> before):
> 
> Oct 16 09:43:16 WARNING[8576]: db.c:67 dbinit: Unable to open
> Asterisk database
> Oct 16 09:43:16 WARNING[8576]: db.c:423 ast_db_gettree: Database
> unavailable
> 
> But If I try to connect from shell it works without any problem.
> 
> Does anybody know why?
I think that the error message refers to the Asterisk internal
database (AstDB), and not to MySQL.

This doesn't clarify the error, but might explain why you get a working
CDR.

Try to issue the "db get" and "db put" CLI commands, to see
if AstDB is
working.

HTH,

-- 
Andrea Spadaccini
Multimedia Technologies Institute s.r.l.