Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Sep 18, 2019 4:12 pm
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Can not export CDRs in CSV using different mysql port number
PostPosted: Mon Dec 02, 2013 9:34 am 
Offline

Joined: Mon Dec 02, 2013 9:26 am
Posts: 2
Hi,

We have configured A2Billing to connect to a remote database server running on a different TCP port. However, every time we clicked the "Export CSV" link after generating the CDRs, the dump file contains the message "Error. Cannot connect to Database." I tried searching on this forum but I did not found anything related to our problem. Can someone from this forum direct me to an existing document or thread pertaining to the same setup we have? Any inputs or suggestions will greatly be appreciated in order to resolve this problem.

Thank you.

CMPJunior


Top
 Profile  
 
 Post subject: Re: Can not export CDRs in CSV using different mysql port number
PostPosted: Mon Dec 02, 2013 10:47 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
I've never tried running MySQL on a different port but it looks like this file - a2billing/admin/lib/iam_csvdump.php is being used to establish the database connection for CSV exports.

My guess would be it's only picking up the hostname, not the port from the config file.

Maybe here -

272 if(!$conn= $this->_db_connect_mysql($dbname, $user , $password, $host))

you could try -

272 if(!$conn= $this->_db_connect_mysql($dbname, $user , $password, $host:PORT-NUMBER))

but ... back it up and don't blame me :-)

or maybe wait for someone that knows what the code does ...


Top
 Profile  
 
 Post subject: Re: Can not export CDRs in CSV using different mysql port number
PostPosted: Mon Dec 02, 2013 11:43 am 
Offline

Joined: Mon Dec 02, 2013 9:26 am
Posts: 2
Thanks for the input. Adding ":<port number>" seems to worked.

CMPJunior


Top
 Profile  
 
 Post subject: Re: Can not export CDRs in CSV using different mysql port number
PostPosted: Mon Dec 02, 2013 1:26 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
It's probably worth sending a bug report as obviously that's not the best way to fix it as you'll lose the change if you upgrade.


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


All times are UTC


Who is online

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