Re: [asterisk-users] Unable to open Asterisk database
Ciao Andrea, thanks for answering. Indeed you are rightit was some kind of strange problem, infact after setting the correct native music-on-hold (but why??) everything got right. It is such a strange thing I'm still a bit confused about it so didn't post the solution :)) Thank you Giorgio Incantalupo Andrea Spadaccini wrote: 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, ___ --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
[asterisk-users] 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 ___ --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
Re: [asterisk-users] Unable to open Asterisk database
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. ___ --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
Re: [asterisk-users] Unable to open Asterisk database
Hi Benjamin, I checked in every place and it seems all right. The strangest thing is that _Asterisk is writing CDR records inside the right table_that's why I do not understand this message. I would expect Asterisk not to fill in the DB. Can I ignore the warning? TIA Giorgio Incantalupo Benjamin Jacob wrote: 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. ___ --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 ___ --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
Re: [asterisk-users] Unable to open Asterisk database
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. ___ --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
[Asterisk-Users] Unable to open Asterisk database
Hi, i have asterisk 1.2.5 working fine from a database in the following way: asterisk loaded as root realtime logging to a mysqld 5.x daemon listening in localhost database is astbill with username astbilluser allowed to the database the root user in mysqld has a password res_mysql.conf in /etc/asterisk has: [general] dbhost = 127.0.0.1 dbname = astbill dbuser = astbilluser dbpass = dbport = 3306 I now want to run asterisk with the -U asterisk and -G asterisk credentials. When I do it I have the error (asterisk is a valid user/group in the system with nologin as shell): /var/log/asterisk/messages: WARNING[5230] db.c: Unable to open Asterisk database WARNING[5230] db.c: Database unavailable asterisk does not exist in mysqld as a user. Asterisk loads, but cannot connect to the database, What other perms should I give it either to the mysqld or to asterisk? Thanks, -- --- Erick Perez Linux User 376588 http://counter.li.org/ (Get counted!!!) Panama, Republic of Panama ___ --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
Re: [Asterisk-Users] Unable to open Asterisk database
Erick, I now want to run asterisk with the -U asterisk and -G asterisk credentials. When I do it I have the error (asterisk is a valid user/group in the system with nologin as shell): /var/log/asterisk/messages: WARNING[5230] db.c: Unable to open Asterisk database WARNING[5230] db.c: Database unavailable I believe this refers to the AstDB not the mySQL database. Make sure the astdb file is writeable by user asterisk. The file is usually in /var/lib/astdb. --Luki ___ --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
Re: [Asterisk-Users] Unable to open Asterisk database
Luki you're the mana thousand thanks. On 3/29/06, Luki [EMAIL PROTECTED] wrote: Erick, I now want to run asterisk with the -U asterisk and -G asterisk credentials. When I do it I have the error (asterisk is a valid user/group in the system with nologin as shell): /var/log/asterisk/messages: WARNING[5230] db.c: Unable to open Asterisk database WARNING[5230] db.c: Database unavailable I believe this refers to the AstDB not the mySQL database. Make sure the astdb file is writeable by user asterisk. The file is usually in /var/lib/astdb. --Luki ___ --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 -- --- Erick Perez Linux User 376588 http://counter.li.org/ (Get counted!!!) Panama, Republic of Panama ___ --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