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

[Brian LaVallee]

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 <lobna.hegazy at gmail.com>
Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
Date: Tue, 14 May 2013 22:57:34 +0200
To: Asterisk Users Mailing List - Non-Commercial Discussion
<asterisk-users at lists.digium.com>
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: 

(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 


On Tue, May 14, 2013 at 10:22 PM, Gertjan Baarda <gertjan.baarda at gmail.com>
wrote:
> 
> 
> On Tuesday, May 14, 2013, Lobna Hegazy  wrote:
>> 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
>> 
>> 
>> On Tue, May 14, 2013 at 10:00 PM, Gertjan Baarda <gertjan.baarda at gmail.com>
>> wrote:
>>> 
>>> 
>>> On Tuesday, May 14, 2013, Lobna Hegazy  wrote:
>>>> 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.
>>>> 
>>>> 
>>>> -- 
>>>> Best Regards,
>>>> Lobna Hegazy
>>> 
>>> Can you be (a lot) more specific?
>>> Are you running Apache? Distro? Firewall and such.  
>>> 
>>> 
>>> -- 
>>> Sent from Gmail Mobile
>>> 
>>> --
>>> _____________________________________________________________________
>>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>>                http://www.asterisk.org/hello
>>> 
>>> asterisk-users mailing list
>>> To UNSUBSCRIBE or update options visit:
>>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>> 
>> 
>> 
>> -- 
>> Best Regards,
>> Lobna Hegazy
>> Public Relations Committee
>> Bdaya l we love charity
>> German University in Cairo
> 
> 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?
> 
> 
> -- 
> Sent from Gmail Mobile
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users



-- 
Best Regards,
Lobna Hegazy
Public Relations Committee
Bdaya l we love charity
German University in Cairo


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130515/02fe18b5/attachment.htm>