Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 11:20 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 15 posts ] 
Author Message
 Post subject: connection failed
PostPosted: Sun Jul 31, 2011 4:01 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
I am getting connection failed each time I try to log into the admin pannel and none of my calls are working.

I can login to database using the mysql client and I can see all the tables just fine.

[database]
hostname = localhost
;port = 5432
user = a2billing
password = *********
dbname = a2billing
dbtype = mysql

error_log:
[Sun Jul 31 11:51:31 2011] [error] [client 74.233.41.147]
PHP Warning: mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (28000/1045):
Access denied for user 'a2bdbuser'@'localhost' (using password: YES) in /opt/a2billing/1.8.1/common/lib/adodb/drivers/adodb-mysqli.inc.php on line 109,


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 4:32 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Parece ser que el user no es a2billing

Ahí pone que el user es a2bdbuser,+


Cámbialo.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 4:33 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
The user you have is : a2bdbuser and not a2billing.

Change it.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 4:58 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
We were hacked any my partners made some changes to the db access but he is out in the mountains today with no access.

I updated a2billing.conf to:

[database]
hostname = localhost
user = a2bdbuser
password = xxxx
dbname = a2billing
dbtype = mysql

error_log:
PHP Warning: mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (28000/1045): Access denied for user 'a2bdbuser'@'localhost' (using password: YES) in /opt/a2billing/1.8.1/common/lib/adodb/drivers/adodb-mysqli.inc.php on line 109, referer:

I verified that I can connect to the db using a2bduser and password

Other place I should update?


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 6:25 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Are you sure that the DB name is a2billing.

In the installation the DB name is mya2billing


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 6:35 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
I am sure thats the db.

I can connect to database a2billing using user a2bdbuser and password. Where else do I have to specify the database password? Seems password is failing when I try to access the a2b admin panel.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 6:48 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Try to connect in console :

mysql a2billing -u a2bdbuser - p

And make a select of a table.

The DB name, user , password and port ara in the a2billing.conf

Make sure you have the the same credentials in both a2billing.conf and the DB.

It seem that doesn´t match.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 7:27 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
I can see the tables using the client. Could it be a2b is not using my a2billingg.conf file or its reading the username/password from some place else. When I change username is that file my error_log stays the same:


mysql> show tables;
+---------------------------+
| Tables_in_a2billing |
+---------------------------+
| banner_text |
| cc_agent |
| cc_agent_commission |
| cc_agent_signup |
| cc_agent_tariffgroup |
| cc_alarm |
| cc_alarm_report |
| cc_autorefill_report |
| cc_backup |
| cc_billing_customer |
| cc_call |
| cc_call_archive |
| cc_callback_spool |
| cc_callerid |
| cc_callplan_lcr |
| cc_campaign |
| cc_campaign_config |
| cc_campaign_phonebook |
| cc_campaign_phonestatus |
| cc_campaignconf_cardgroup |
| cc_card |
| cc_card_archive |
| cc_card_group |
| cc_card_history |
| cc_card_package_offer |
| cc_card_seria |
| cc_card_subscription |
| cc_cardgroup_service |
| cc_charge |
| cc_config |
| cc_config_group |
| cc_configuration |
| cc_country |
| cc_currencies |
| cc_did |
| cc_did_destination |
| cc_did_use |
| cc_didgroup |
| cc_epayment_log |
| cc_epayment_log_agent |
| cc_iax_buddies |
| cc_invoice |
| cc_invoice_conf |
| cc_invoice_item |
| cc_invoice_payment |
| cc_iso639 |
| cc_logpayment |
| cc_logpayment_agent |
| cc_logrefill |
| cc_logrefill_agent |
| cc_message_agent |
| cc_monitor |
| cc_notification |
| cc_notification_admin |
| cc_outbound_cid_group |
| cc_outbound_cid_list |
| cc_package_group |
| cc_package_offer |
| cc_package_rate |
| cc_packgroup_package |
| cc_payment_methods |
| cc_payments |
| cc_payments_agent |
| cc_payments_status |
| cc_paypal |
| cc_phonebook |
| cc_phonenumber |
| cc_prefix |
| cc_provider |
| cc_ratecard |
| cc_receipt |
| cc_receipt_item |
| cc_remittance_request |
| cc_restricted_phonenumber |
| cc_server_group |
| cc_server_manager |
| cc_service |
| cc_service_report |
| cc_sip_buddies |
| cc_sip_buddies_empty |
| cc_speeddial |
| cc_status_log |
| cc_subscription_service |
| cc_subscription_signup |
| cc_support |
| cc_support_component |
| cc_system_log |
| cc_tariffgroup |
| cc_tariffgroup_plan |
| cc_tariffplan |
| cc_templatemail |
| cc_ticket |
| cc_ticket_comment |
| cc_timezone |
| cc_trunk |
| cc_ui_authen |
| cc_version |
| cc_voucher |
| contact |
| login |
| rates |
| rates1 |
+---------------------------+
102 rows in set (0.00 sec)


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 7:29 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Where have you te Conf file.

You must put it in /etc


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 7:30 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
Mysql use port 3306. You dont have any port in your conf file.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 7:44 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
Files are in /etc/asterisk

updated with port:

[database]
hostname = localhost
port = 3306
user = a2bdbuser
password = xxxxxxx
dbname = a2billing
dbtype = mysql

same error:

[Sun Jul 31 15:41:35 2011] [error] [client 74.233.41.147] PHP Warning: mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (28000/1045): Access denied for user 'a2bdbuser'@'localhost' (using password: YES) in /opt/a2billing/1.8.1/common/lib/adodb/drivers/adodb-mysqli.inc.php on line 109, referer:


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 7:56 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
You must put it in /etc not in /etc/asterisk


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 8:19 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
I was using the wrong file. I was using file in /etc/asterisk.
I update file in /etc with the new db password and got very excited after a long day. Same error

[database]
hostname = localhost
port = 3306
user = a2bdbuser
password = xxxxxx
dbname = a2billing
dbtype = mysql



[Sun Jul 31 16:11:51 2011] [error] [client 74.233.41.147] PHP Warning: mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (28000/1045): Access denied for user 'a2bdbuser'@'localhost' (using password: YES) in /opt/a2billing/1.8.1/common/lib/adodb/drivers/adodb-mysqli.inc.php on line 109, referer:


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 8:40 pm 
Offline

Joined: Tue Jun 22, 2010 8:37 pm
Posts: 152
The machine is the localhost ?

Try to put 127.0.0.1

If the machine is other yo need to put in hostname the IP of the machine who have the DB.

I can´t say you anything more.

Ah : put 777 permision in the conf file

I hope you can solve this problem.


Top
 Profile  
 
 Post subject: Re: connection failed
PostPosted: Sun Jul 31, 2011 9:13 pm 
Offline

Joined: Fri Dec 03, 2010 5:18 pm
Posts: 35
I solved the problem.

First mistake was I was updating the wrong file (/etc/asterisk/as2billing.conf). I should should have been udpating /etc/a2billing.com). I removed the file in /etc/asterisk to avoid future confusion and I updated my user name, password and port and in /etc/a2billing.conf. That worked.

Thanks for the suggetions.

Dave


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 15 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 16 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group