<HTML>
<HEAD>
<TITLE>Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12pt'>It sounds like phpMyAdmin is NOT on the same server as the Asterisk DB.<BR>
<BR>
You will run into a couple possible issues when allowing remote MySQL access on the Asterisk server, <BR>
<BR>
You will need to set the MySQL user privileges to a specific host or a wildcard (%).<BR>
Most common issue is the firewall, likely iptables on the Asterisk server. Allow: tcp/3306<BR>
<BR>
To test the privileges, stop iptables and try this from the local machine:<BR>
mysql --host=asterisk_server --user=myuser --password=mypass<BR>
<BR>
If you can access the MySQL on the Asterisk server, adjust and restart iptables. Then try again with the firewall in place.<BR>
<BR>
To add the Asterisk server to phpMyAdmin, see the following: <a href="http://goo.gl/J1Py5">http://goo.gl/J1Py5</a><BR>
<BR>
<BR>
Brian<BR>
</SPAN><SPAN STYLE='font-size:11pt'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"><B>From: </B>Lobna Hegazy <<a href="lobna.hegazy@gmail.com">lobna.hegazy@gmail.com</a>><BR>
<B>Reply-To: </B>Asterisk Users Mailing List - Non-Commercial Discussion <<a href="asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><BR>
<B>Date: </B>Tue, 14 May 2013 22:57:34 +0200<BR>
<B>To: </B>Asterisk Users Mailing List - Non-Commercial Discussion <<a href="asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><BR>
<B>Subject: </B>Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database<BR>
<BR>
I'm successfully configured with mysql. After research, accessing Astersik MySQL database requires 2 major steps which are: <BR>
<BR>
(1) Allow remote access. <BR>
(2) Add the new server to my local php configuration files. <BR>
<BR>
I'm just asking for the right steps to do these two major steps.<BR>
<BR>
Thank you in advance <BR>
<BR>
<BR>
On Tue, May 14, 2013 at 10:22 PM, Gertjan Baarda <<a href="gertjan.baarda@gmail.com">gertjan.baarda@gmail.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
On Tuesday, May 14, 2013, Lobna Hegazy wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>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. <BR>
<BR>
Thank you for any help<BR>
<BR>
<BR>
On Tue, May 14, 2013 at 10:00 PM, Gertjan Baarda <<a href="gertjan.baarda@gmail.com">gertjan.baarda@gmail.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
On Tuesday, May 14, 2013, Lobna Hegazy wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Dear All, <BR>
<BR>
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 <I>ssh.<BR>
</I><BR>
Asterisk Version: 11.3.0<BR>
MySQL Version: mysql-server.x86_64 0:5.1.69-1.el6_4 <BR>
<BR>
Please ask me for any specifications you need, thank you in advance.<BR>
<BR>
<BR>
-- <BR>
Best Regards,<BR>
Lobna Hegazy<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
Can you be (a lot) more specific?<BR>
Are you running Apache? Distro? Firewall and such. <BR>
<FONT COLOR="#888888"><BR>
<BR>
-- <BR>
Sent from Gmail Mobile<BR>
</FONT><BR>
--<BR>
_____________________________________________________________________<BR>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com">http://www.api-digital.com</a> --<BR>
New to Asterisk? Join us for a live introductory webinar every Thurs:<BR>
<a href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a><BR>
<BR>
asterisk-users mailing list<BR>
To UNSUBSCRIBE or update options visit:<BR>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<BR>
-- <BR>
Best Regards,<BR>
Lobna Hegazy<BR>
Public Relations Committee<BR>
<B>Bdaya</B> l we love charity<BR>
<B>German University in Cairo<BR>
</B></SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
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?<BR>
<BR>
<BR>
-- <BR>
Sent from Gmail Mobile<BR>
<BR>
--<BR>
_____________________________________________________________________<BR>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com">http://www.api-digital.com</a> --<BR>
New to Asterisk? Join us for a live introductory webinar every Thurs:<BR>
<a href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a><BR>
<BR>
asterisk-users mailing list<BR>
To UNSUBSCRIBE or update options visit:<BR>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<BR>
-- <BR>
Best Regards,<BR>
Lobna Hegazy<BR>
Public Relations Committee<BR>
<B>Bdaya</B> l we love charity<BR>
<B>German University in Cairo<BR>
</B><BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>--<BR>
_____________________________________________________________________<BR>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com">http://www.api-digital.com</a> --<BR>
New to Asterisk? Join us for a live introductory webinar every Thurs:<BR>
<a href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a><BR>
<BR>
asterisk-users mailing list<BR>
To UNSUBSCRIBE or update options visit:<BR>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><BR>
</SPAN></FONT></FONT>
</BODY>
</HTML>