Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 2:36 pm
Voice Broadcast System


All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: cc_ui_authen + pwd_encoded = connection error [possible bug]
PostPosted: Fri Oct 14, 2011 1:42 am 
Offline

Joined: Tue Oct 11, 2011 10:56 pm
Posts: 12
Hello Everyone,

The cc_ui_authen is now using pwd_encoded, however what is in charge of en/decrypt this?
I am getting Connection failed....

Thanks in Advance,

Nick.


Last edited by symack on Fri Oct 14, 2011 2:10 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: cc_ui_authen + pwd_encoded = connection error?
PostPosted: Fri Oct 14, 2011 7:58 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi


If you are getting connection failed, it is unlikely to be the password encoding, it is more likely to be your database username password or connection.

Make sure you can log into the MySQL console with the same credentials you have in /etc/a2billing.conf, e.g. mysql -ua2billinguser -pa2billingpassword -hhostname a2billing14


Joe


Top
 Profile  
 
 Post subject: Re: cc_ui_authen + pwd_encoded = connection error?
PostPosted: Fri Oct 14, 2011 12:55 pm 
Offline

Joined: Tue Oct 11, 2011 10:56 pm
Posts: 12
Hello Joe,

Thank you so much for your response. I have attempted at the instalation twice already, and can't
seem to get pass the "Connection failed". As for database credentials, they work find from console.
In both the GUI and CLI "a2billing.php"I am getting the error. Here are the following php modules installed:

[PHP Modules]
Core
ctype
date
dom
ereg
fileinfo
filter
gd
gettext
hash
iconv
json
libxml
mcrypt
mysql
pcntl
pcre
PDO
pdo_sqlite
Phar
posix
Reflection
session
SimpleXML
SPL
SQLite
sqlite3
standard
tokenizer
xml
xmlreader
xmlwriter
zlib

[Zend Modules]


When I issue a:

#yes "" | /usr/local/php/bin/php -e /var/lib/asterisk/agi-bin/a2billing.php 1
GET VARIABLE IDCONF
Connection failed

In manager.conf, I have made sure that all the write settings are present:

[myasterisk]
secret=mycode
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user,originate

I have attached the log from within asterisk cli. Is there any way to get
meaningfull logs from a2billing.php?

I have the following, but they are all empty

touch /var/log/a2billing/a2billing_agi.log
touch /var/log/a2billing/a2billing_api_callback_request.log
touch /var/log/a2billing/a2billing_api_card.log
touch /var/log/a2billing/a2billing_api_ecommerce_request.log
touch /var/log/a2billing/a2billing_epayment.log
touch /var/log/a2billing/a2billing_paypal.log
touch /var/log/a2billing/cront_a2b_alarm.log
touch /var/log/a2billing/cront_a2b_archive_data.log
touch /var/log/a2billing/cront_a2b_autorefill.log
touch /var/log/a2billing/cront_a2b_batch_process.log
touch /var/log/a2billing/cront_a2b_bill_diduse.log
touch /var/log/a2billing/cront_a2b_check_account.log
touch /var/log/a2billing/cront_a2b_currency_update.log
touch /var/log/a2billing/cront_a2b_invoice.log
touch /var/log/a2billing/cront_a2b_subscription_fee.log
touch /var/log/asterisk/a2billing-daemon-callback.log

Thanks in Advance,

Nick


Attachments:
log.txt [1.87 KiB]
Downloaded 604 times
Top
 Profile  
 
 Post subject: Re: cc_ui_authen + pwd_encoded = connection error?
PostPosted: Fri Oct 14, 2011 1:53 pm 
Offline

Joined: Tue Oct 11, 2011 10:56 pm
Posts: 12
Ok, I think this is a bug. When I recompiled php with mysqli support, a2billing.php worked fine from command line,
and asterisk cli however, the GUI is calling mysql_connect and not mysqli_connect:

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/a2billing/common/lib/common.defines.php:118) in /usr/local/apache/htdocs/a2billing/common/lib/admin.module.access.php on line 68

Fatal error: Call to undefined function mysql_connect() in /usr/local/apache/htdocs/a2billing/common/lib/adodb/drivers/adodb-mysql.inc.php on line 364

Your help is greatly appreciated,

Nick.


Top
 Profile  
 
 Post subject: Re: cc_ui_authen + pwd_encoded = connection error?
PostPosted: Fri Oct 14, 2011 2:10 pm 
Offline

Joined: Tue Oct 11, 2011 10:56 pm
Posts: 12
When I compile php with both mysql and mysqli support, I get the following:

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/a2billing/common/lib/common.defines.php:118) in /usr/local/apache/htdocs/a2billing/common/lib/admin.module.access.php on line 68

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/a2billing/common/lib/common.defines.php:118) in /usr/local/apache/htdocs/a2billing/common/lib/admin.module.access.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/a2billing/common/lib/common.defines.php:118) in /usr/local/apache/htdocs/a2billing/common/lib/admin.module.access.php on line 119


Top
 Profile  
 
 Post subject: Re: cc_ui_authen + pwd_encoded = connection error [possible bug]
PostPosted: Mon Oct 24, 2011 3:28 pm 
Offline

Joined: Fri Jan 18, 2008 9:54 pm
Posts: 135
Hello ,

Check and make sure that 'php-mysql' is installed

Hope it helps !


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


All times are UTC


Who is online

Users browsing this forum: No registered users and 4 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