Using PHPMyAdmin To Remotely Access Asterisk MySQL Database

Home » Asterisk Users » Using PHPMyAdmin To Remotely Access Asterisk MySQL Database
Asterisk Users 6 Comments

Dear All,

I’m trying to connect to Asterisk CDR database using PHPMyAdmin but unfortunately all my trials and searches failed. So I’d be more than grateful if someone helped me with right steps to do this. Kindly note that I’m working on a remore server that I can connect to as a root using *ssh.*

Asterisk Version: 11.3.0
MySQL Version: mysql-server.x86_64 0:5.1.69-1.el6_4

Please ask me for any specifications you need, thank you in advance.

6 thoughts on - Using PHPMyAdmin To Remotely Access Asterisk MySQL Database

  • Can you be (a lot) more specific?
    Are you running Apache? Distro? Firewall and such.

  • I’m running XAMMP on Mac OS which includes Apache, MySQL, PHP, and Perl. phpMyAdmin now connected to the localhost server. What I’m willing to do is adding asterisk database server in order to access cdr database.

    Thank you for any help

  • Asterisk as such does not have a database server, it can use mysql as a backend for cdr. Is your cdr succesfully configured with mysql? Ergo:
    does is write the cdr entries into mysql?

  • I’m successfully configured with mysql. After research, accessing Astersik MySQL database requires 2 major steps which are:

    (1) Allow remote access.
    (2) Add the new server to my local php configuration files.

    I’m just asking for the right steps to do these two major steps.

    Thank you in advance

  • It sounds like phpMyAdmin is NOT on the same server as the Asterisk DB.

    You will run into a couple possible issues when allowing remote MySQL access on the Asterisk server,

    You will need to set the MySQL user privileges to a specific host or a wildcard (%). Most common issue is the firewall, likely iptables on the Asterisk server. Allow: tcp/3306

    To test the privileges, stop iptables and try this from the local machine:
    mysql –host=asterisk_server –user=myuser –password=mypass

    If you can access the MySQL on the Asterisk server, adjust and restart iptables. Then try again with the firewall in place.

    To add the Asterisk server to phpMyAdmin, see the following:
    http://goo.gl/J1Py5

    Brian

    From: Lobna Hegazy
    Reply-To: Asterisk Users Mailing List – Non-Commercial Discussion

    Date: Tue, 14 May 2013 22:57:34 +0200
    To: Asterisk Users Mailing List – Non-Commercial Discussion

    Subject: Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database

    I’m successfully configured with mysql. After research, accessing Astersik MySQL database requires 2 major steps which are: