Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 12:10 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: "Connection failed", but MySQL connection from the CLI works
PostPosted: Tue Dec 20, 2016 9:54 pm 
Offline

Joined: Thu Jun 05, 2008 5:35 pm
Posts: 37
Hi everyone.

I have A2Billing set up on a new server, upgrading from v2.0.14 to v2.2.0 but I'm getting the dreaded "Connection failed" white screen of death.

I took the database configuration settings out of /etc/a2billing.conf and was able to successfully connect to our database using the CLI mysql client to connect to our remote server. The old server that we're replacing (and still using) is also able to connect to this same remote server without any issue.

I'm pretty sure that I've got all the file permissions right (going by this thread: viewtopic.php?t=1929), but I may have gotten something wrong somewhere. I'm definitely not getting any PHP errors in my Apache error log, so that hasn't been much help either.

Any help will be appreciated, and I will happily cooperate with any suggestion.


Top
 Profile  
 
 Post subject: Re: "Connection failed", but MySQL connection from the CLI works
PostPosted: Fri Dec 23, 2016 3:50 pm 
Offline

Joined: Thu Jun 05, 2008 5:35 pm
Posts: 37
I finally found the issue.

You can't use a hashmark in the password for the new version of A2Billing. This was possible in the old version, and it was working literally everywhere else on our server - in my PHP test script, in shell scripts that accessed the same database, in Asterisk and even in other web apps.

But nope. Not A2Billing v2.2.0!


Top
 Profile  
 
 Post subject: Re: "Connection failed", but MySQL connection from the CLI works
PostPosted: Fri Mar 16, 2018 2:58 pm 
Offline

Joined: Tue Dec 02, 2008 2:38 pm
Posts: 6
I'm getting the same thing. My test php script connects fine, as well as from the cmd line. Any ideas on where else to look?

I've removed all special characters from the password.

Running CENTOS 7 / PHP 5.6 / APACHE

cat /etc/centos-release
CentOS Linux release 7.4.1708 (Core)

php -m
[PHP Modules]
bz2
calendar
Core
ctype
curl
date
dom
ereg
exif
fileinfo
filter
ftp
gettext
hash
iconv
json
libxml
mcrypt
mhash
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
readline
Reflection
session
SimpleXML
sockets
SPL
sqlite3
standard
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zip
zlib

[Zend Modules]


mysql -u a2billinguser -p -h XXXXXXXXXXXX mya2billing

MariaDB [mya2billing]> show tables;
+---------------------------+
| Tables_in_mya2billing |
+---------------------------+
| cc_agent |
| cc_agent_commission |
| cc_agent_signup |
| cc_agent_tariffgroup |
...
97 rows in set (0.00 sec)


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


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