[asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
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 -- _ -- 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
Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
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
Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
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.baa...@gmail.comwrote: 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* -- _ -- 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
Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
what problem you encounter? On Tue, May 14, 2013 at 9:42 PM, Lobna Hegazy lobna.heg...@gmail.comwrote: 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 -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
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.baa...@gmail.comjavascript:_e({}, 'cvml', 'gertjan.baa...@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
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.baa...@gmail.comwrote: 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.baa...@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
Re: [asterisk-users] Using PHPMyAdmin to remotely access Asterisk MySQL Database
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.heg...@gmail.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Tue, 14 May 2013 22:57:34 +0200 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@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.baa...@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.baa...@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 -- _ -- 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