Asterisk CDR Database Unavailable!
Other than this message "Asterisk CDR Database Unavailable!" I've got a successful installation.
I have created the asteriskcdrdb database and table (cdr). I am using Freeswitch not Asterisk however.
Anyway, how do I get rid of this message?
I also cannot create sip devices for Freeswitch under the 'Switch Config' menu.
Obviously there is a database issue, because when I execute astpp-rate-engine.pl I get this message:
Connected to ASTPP Database!
DBI:mysql:database=asteriskcdrdb;host=localhost
DBI connect('database=asteriskcdrdb;host=localhost','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/astpp/astpp-common.pl line 1017
CDR DATABASE IS DOWN
Another thing; why is there a big empty white block in the gui, with the menus at the very bottom, requiring me to scroll down? I'd like to work on these templates and make them pretty :D
Re: My previous post "perl: bad interpreter: permission denied"
I started anew, with a clean machine and ran make resolve_perl_dep. That solved it. I didn't realize CPAN perl was needed.
Thanks!
UPDATE: I created a mysql user asteriskcdrdb and password then added those configs to system and now all is working!
UPDATE2: the path for css was wrong for my install in the templates. After adding /html/ to the path the menus show properly!
same issue with that Asterisk CDR Database Unavailable!
Dear sir, I installed everything on and run into exact the same issue as described here. I read the comment about adding a asteriskcdrdb user and password but that will not solve my issue. Any help please. Like to run astpp with freeswitch on centos.
Re same issue with that Asterisk CDR Database Unavailable!
Once you have the ASTPP interface installed you can go into the gui into "System"->"Configuration" and edit the settings for connecting to the CDR database.
Update
Thanks for posting back!
still got some issues
I am still stuck on a couple things.
1st. How do you change the big white empty space between the blue header and settings menus? I have to scroll all the way down the page to see the menus. This is not so in the user cgi. It seems like theres an extra table in there, taking up most of the page.
2nd. How do users login? I can create accounts and passwords but what are the usernames? Nothing seems to work besides the auth setting.
3rd. Freeswitch SIP entries come up as an error: INSERT INTO directory (username,domain) VALUES ('1000', '$${local_ip_v4}') failed. Maybe I don't have the context right? I have tried entering global, public, and default.
4th. When I try to create a Provider under LCR I get this error: INSERT INTO sip (callerid,name,accountcode,canreinvite,context,host,insecure,mailbox,nat,port,qualify,secret,type,username,disallow,allow,cancallforward) VALUES (' <110822> ', '110822', '110822', 'no', 'custom-astpp', 'dynamic', 'very', '110822@default', 'yes', '5060', 'yes', '1234', 'peer', '110822', 'all', 'g729,ulaw,alaw', NULL) failed
Thank you so much. Everything else seems fine.
Space issue
Did you ever resolve the space issue?