Free Billing, Routing and Management software for Asterisk and VOIP
Home | Forums | Wiki | Manual | Open Source | Billing and BSS | Demo | Contact Us
DownLoad | Bugs | Help Wanted | Numbering Plan
  
 

er2002-can't connect to ASTBILL database on LOCALHOST

 
By orfeu at Wed, 2008-05-07 07:01 | AstBill Software - General and Support

Hello,
I have this problem that I can't solve for 4 days now so please help me if you can.

I've followed the install instructions on astbill site and in the end I managed to install asterisk and astbill on my debian.
The problem is that every time I start the server, in the View Logs>Asterisk Messages section of astbill I get 6 error messages and one of them that I think I most important looks like this:

...Can't connect to astbill database on localhost.er2002

I've double checked the /etc/asterisk/res_mysql.conf,
/home/astbill/astbill.conf and /home/astbill/wwwroot/sites/default/settings.php file for the correct configuration, the username and password are ok.
In my search on google I found out that there can be some problem with the addons packet so i've reinstall it but no effect.

If anyone has encountered the same problem or can figure it out please tell me.
Thanks.

Solve it! The problem was

By orfeu on Wed, 2008-05-07 17:13

Solve it!
The problem was the path to mysqld.sock for asterisk @ home.
Thanks.

» login or register to post comments

please I 've the same

By coolbibi on Mon, 2008-06-02 10:49

please I 've the same problem . can you explain me how can I do it
thanks

» login or register to post comments

Ok I 've now in my

By coolbibi on Mon, 2008-06-02 11:54

Ok I 've now in my /etc/asterisk/res_mysql.conf
;^M
; Sample configuration for res_config_mysql.c^M
;^M
; The value of dbhost may be either a hostname or an IP address.^M
; If dbhost is commented out or the string "localhost", a connection^M
; to the local host is assumed and dbsock is used instead of TCP/IP^M
; to connect to the server.^M
;^M
[general]^M
dbhost = localhost^M
dbname = astbill^M
dbuser = astbilluser^M
dbpass = astbill419^M
dbport = 3306^M
^M
; For Debian^M
; dbsock = /var/run/mysqld/mysqld.sock^M
^M
; For Asterisk @ Home ^M
dbsock = /var/run/mysqld/mysqld.sock^M
^M
~
but it's the same things

» login or register to post comments
  
BerliOS Developer LogoSourceForge.net Logo Drupal.org Logo