1. I understand the mysql connection is success. Can you see the tables in mysql database. Show Tables?
2. Apached user / group .... Which user running the httpd dameon. 3. Does the Apache user/group have access to the /etc/a2billing.conf 4. Did you apply the following permissions/rights chmod 755 /var/www/html/a2billing/admin/templates_c chmod 755 /var/www/html/a2billing/customer/templates_c chmod 755 /var/www/html/a2billing/agent/templates_c chown -Rf asterisk:asterisk /var/www/html/a2billing/admin/templates_c chown -Rf asterisk:asterisk /var/www/html/a2billing/customer/templates_c chown -Rf asterisk:asterisk /var/www/html/a2billing/agent/templates_c On Sun, Jun 20, 2010 at 10:02 AM, saurin ajmeri <[email protected]> wrote: > Thanks Bruce, > > However, my installation is pure asterisk and a2b. > > fresh centos with lamp and then I installed asterisk 1.6 through yum, then > a2billing 1.7. > > a2billing.conf is also has right info for database. I can connect database > through mysql > prompt with same credential. but when i tried webgui i am > getting connection failed. > > let me clarify more in detail.I have 2 server now A and B. > - A has asterisk 1.4 and a2biling 1.4 > - On B i have installed asterisk 1.6 and a2billing 1.7. > > Server A is running fine. Server B has gui connection failed problem. I > have > also tried to connect from web gui of B to database A and its also failing. > > thanks again......... > > Saurin > > On Sat, Jun 19, 2010 at 11:34 PM, Bruce N <[email protected]> wrote: > > > Correction to last e-mail. For Elastix the password for mysql root is: > > eLaStIx.2oo7 (notice that is oo and not ZERO ZERO) > > > > And here is an example of what your /etc/a2billing.conf may include: > > > > [database] > > hostname = localhost > > port = > > user = a2billinguser > > password = a2billing > > dbname = mya2billing > > dbtype = mysql > > > > Above is correct provided you have created a Mysql user with above info > and > > have given it proper access to mya2billing database. > > > > -Bruce > > > > > From: [email protected] > > > To: [email protected] > > > CC: [email protected] > > > Date: Sat, 19 Jun 2010 23:26:48 -0400 > > > Subject: RE: [on-asterisk] Need help on A2billing - Webgui getting > > connection failed right after login > > > > > > > > > > > connection error in case of A2Billing is due to wrong password entered > > for Mysql during installation or that /etc/a2billing.conf has the wrong > > password for Mysql set in it. > > > > > > > > > > > > One more thing, if you had a previous version of A2Billing installed, > try > > this: > > > > > > > > > > > > mysql -uroot -ppassw0rd ;;;; I am assuming you are using a LAMP flavour > > like Trixbox, Piaf, or Elastix (password for Elastix is eLasTiX.2oo7) > > > > > > > > > > > > drop database mya2billing; > > > > > > quit; > > > > > > > > > > > > And then re-install the A2B v1.7 schema again. Once done, login with > > root/changepassword. > > > > > > > > > > > > -Bruce > > > > > > > Date: Sat, 19 Jun 2010 12:16:50 -0400 > > > > From: [email protected] > > > > To: [email protected] > > > > CC: [email protected] > > > > Subject: Re: [on-asterisk] Need help on A2billing - Webgui getting > > connection failed right after login > > > > > > > > same generic password as per instruction, which is changepassword. > > > > > > > > once i hit login i get right away " Connection failed " at top left > > corner. > > > > > > > > Thanks, > > > > Saurin > > > > > > > > On Sat, Jun 19, 2010 at 11:33 AM, Aloysius Lloyd < > > > > [email protected]> wrote: > > > > > > > > > what is the error? > > > > > > > > > > what is the password you used for the user : root > > > > > > > > > > > > > > > > > > > > > > > > > On Sat, Jun 19, 2010 at 11:26 AM, saurin ajmeri <[email protected] > > > > wrote: > > > > > > > > > >> Hi All, > > > > >> > > > > >> I know there are many people using A2Billling and might point me > in > > right > > > > >> direction. > > > > >> > > > > >> I am trying a2billing 1.7 on asterisk 1.6. I did installation > > according to > > > > >> instruction posted on a2billing web. However at admin webgui I am > > getting > > > > >> connection failed right after putting user id and password. > > > > >> > > > > >> I am not sure what I missed, Checked the log but there is not much > > in the > > > > >> log. I have old machine that I installed astersik 1.4 with > A2billing > > 1.4 > > > > >> almost year ago. so tried to connect that database and getting > same > > thing. > > > > >> > > > > >> Did reinstall couple of time and having same issue, I am pretty > sure > > there > > > > >> is some permission issue that i might missed or not in > installation > > > > >> instruction. Tried forum and didn't find any answer. > > > > >> > > > > >> I can connect to database through mysql manually, only webgui > > throwing > > > > >> connection failed error. > > > > >> > > > > >> Thanks in advance........... > > > > >> > > > > >> > > > > >> Saurin > > > > >> > > > > > > > > > > > > > > > > _________________________________________________________________ > > > Look 'em in the eye: FREE Messenger video chat > > > http://go.microsoft.com/?linkid=9734386 > > > > ------------------------------ > > Your Photo on Bing.ca: You Could WIN on Canada Day! Submit a Photo Now! > > <http://go.microsoft.com/?linkid=9734380> > > >
