VoIP Mailing List Archives :: View topic - [asterisk-users] How to use phpmyadmin to remotely access asterisk mysql database?

Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community

[asterisk-users] How to use phpmyadmin to remotely access asterisk mysql database?

VoIP Mailing List Archives Forum Index -> Asterisk Users

View previous topic :: View next topic

Author

Message

rafa.alfurqan at gmail...
Guest

Posted: Thu Sep 11, 2014 2:42 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Hi, Could anyone help me to tell me about how to install and using phpmyadmin to remotely access asterisk mysql database? I'm using asterisk 11.0.1 on ubuntu 10.04 and mysql-server version is 5.1.73-0ubuntu0.10.04.1 (ubuntu) really need help. thank you

asterisk_list at earth...
Guest

Posted: Thu Sep 11, 2014 3:19 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

On Thursday 11 Sep 2014, rafa alfurqan wrote:

Quote:

Hi,

Could anyone help me to tell me about how to install and using phpmyadmin
to remotely access asterisk mysql database?

I'm using asterisk 11.0.1 on ubuntu 10.04
and mysql-server version is 5.1.73-0ubuntu0.10.04.1 (ubuntu)

really need help.

thank you

As you're on Ubuntu, you can begin with

$ sudo apt-get install phpmyadmin

If you have any more questions about PHPMyAdmin, you would do better to ask
them on a MySQL or PHPMyAdmin forum.

Also, 10.04 is a really old Ubuntu release now, even although it is a Long
Term Support one. Consider upgrading to 14.04. You can apt-get dist-upgrade
straight from an LTS release to the next LTS release, without needing to go
through all the intermediate releases.

--
AJS

Note: Originating address only accepts e-mail from list! If replying off-
list, change address to asterisk1list at earthshod dot co dot uk .

--
_____________________________________________________________________
-- 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

rafa.alfurqan at gmail...
Guest

Posted: Thu Sep 11, 2014 3:37 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

Also, 10.04 is a really old Ubuntu release now, even although it is a Long
Term Support one.Â Consider upgrading to 14.04.Â You can apt-get dist-upgrade
straight from an LTS release to the next LTS release, without needing to go
through all the intermediate releases.

rainer.piper at soho-p...
Guest

Posted: Thu Sep 11, 2014 3:46 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

Also, 10.04 is a really old Ubuntu release now, even although it is a Long
Term Support one. Consider upgrading to 14.04. You can apt-get dist-upgrade
straight from an LTS release to the next LTS release, without needing to go
through all the intermediate releases.

alokkic at gmail.com
Guest

Posted: Thu Sep 11, 2014 3:50 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

yes u can access form same phpmyadmin both database, depends, for which database u entered userid and password on phpmyadmin login page.

On Thu, Sep 11, 2014 at 2:06 PM, rafa alfurqan <rafa.alfurqan@gmail.com (rafa.alfurqan@gmail.com)> wrote:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

really appreciate for the advice, i'll do that after i could remote to asterisk database from phpmyadmin.

actually i have installed freeradius-server on my ubuntu too, and i could remote the database freeradius from phpmyadmin.
is it possible if same phpmyadmin could remote database from freeradius-server and asterisk (they are on same server)?

thank you

--
_____________________________________________________________________
-- 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

rafa.alfurqan at gmail...
Guest

Posted: Thu Sep 11, 2014 4:01 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Hi Rainer,

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

yes i'm sure coz it's not for commercial, just for my research.

Quote:

I suggestÂ HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

i just heard HeidiSQL from here, it's like a tool? actually i have no basic for anything about database or voip.

if you mind, would you give me a tutorial or anything to configure that?

thank you so much
Â

On Thu, Sep 11, 2014 at 3:46 PM, Rainer Piper <rainer.piper@soho-piper.de (rainer.piper@soho-piper.de)> wrote:

Quote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

I suggestÂ HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

link to heidiSQL -> http://www.heidisql.com/

--
Rainer Piper
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: [url=callto:004922897167161]+49 228 97167161[/url]
P2P: sip:rainer@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer@xmpp.soho-piper.de (rainer@xmpp.soho-piper.de)

--
_____________________________________________________________________
-- 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

rafa.alfurqan at gmail...
Guest

Posted: Thu Sep 11, 2014 4:03 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Hi Alok,

Quote:

yes u can access form same phpmyadmin both database, depends, for which database u entered userid and password on phpmyadmin login page.

it's there anything i have to configure in asterisk file so the phpmyadmin could work for asterisk?

coz in freeradius-server, i have to configure a few file so phpmyadmin could work.

Thank you

rainer.piper at soho-p...
Guest

Posted: Thu Sep 11, 2014 4:28 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Quote:

Hi Rainer,

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

yes i'm sure coz it's not for commercial, just for my research.

Quote:

I suggest HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

i just heard HeidiSQL from here, it's like a tool? actually i have no basic for anything about database or voip.

HeidiSQL is like phpmyadmin !!!!
have a look at http://www.heidisql.com/
Features

Free for everyone, OpenSource.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

Quote:

if you mind, would you give me a tutorial or anything to configure that?

thank you so much

On Thu, Sep 11, 2014 at 3:46 PM, Rainer Piper <rainer.piper@soho-piper.de (rainer.piper@soho-piper.de)> wrote:

Quote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

I suggest HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

link to heidiSQL -> http://www.heidisql.com/

--
Rainer Piper
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: [url=callto:004922897167161]+49 228 97167161[/url]
P2P: sip:rainer@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer@xmpp.soho-piper.de (rainer@xmpp.soho-piper.de)

--
_____________________________________________________________________
-- 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

--
Rainer Piper
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: +49 228 97167161
P2P: [url=sip:rainer@sip.soho-piper.de:5072]sip:rainer@sip.soho-piper.de:5072[/url] (pjsip-test)
XMPP: rainer@xmpp.soho-piper.de (rainer@xmpp.soho-piper.de)

rainer.piper at soho-p...
Guest

Posted: Thu Sep 11, 2014 4:39 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Am 11.09.2014 um 11:28 schrieb Rainer Piper:

Quote:

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Quote:

Hi Rainer,

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

yes i'm sure coz it's not for commercial, just for my research.

Quote:

I suggest HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

i just heard HeidiSQL from here, it's like a tool? actually i have no basic for anything about database or voip.

I use HeidiSQL to administrate my 9x Nodes MariaDB Galera 10.0 Multimaster DB Cluster. Wink

*SMILE*
I just love this tool Wink

Quote:

HeidiSQL is like phpmyadmin !!!!
have a look at http://www.heidisql.com/
Features

Free for everyone, OpenSource.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

Quote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

rafa.alfurqan at gmail...
Guest

Posted: Thu Sep 11, 2014 4:39 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Hi Rainer,

okay, thanks for your advice.

so i think it would work for freeradius too.

Cheers

On Thu, Sep 11, 2014 at 4:28 PM, Rainer Piper <rainer.piper@soho-piper.de (rainer.piper@soho-piper.de)> wrote:

Quote:

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Quote:

Hi Rainer,

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

yes i'm sure coz it's not for commercial, just for my research.

Quote:

I suggestÂ HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

i just heard HeidiSQL from here, it's like a tool? actually i have no basic for anything about database or voip.

HeidiSQL is like phpmyadmin !!!!
have a look at http://www.heidisql.com/
Features

Free for everyone, OpenSource.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

Quote:

if you mind, would you give me a tutorial or anything to configure that?

thank you so much
Â

On Thu, Sep 11, 2014 at 3:46 PM, Rainer Piper <rainer.piper@soho-piper.de (rainer.piper@soho-piper.de)> wrote:

Quote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

--
Rainer Piper
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: [url=tel:%2B49%20228%2097167161]+49 228 97167161[/url]
P2P: sip:rainer@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer@xmpp.soho-piper.de (rainer@xmpp.soho-piper.de)

--
_____________________________________________________________________
-- 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

rainer.piper at soho-p...
Guest

Posted: Thu Sep 11, 2014 4:44 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

Am 11.09.2014 um 11:39 schrieb rafa alfurqan:

Quote:

Hi Rainer,

okay, thanks for your advice.

so i think it would work for freeradius too.

I think so ... freeradius DB is mySQL or oracle.

Quote:

Cheers

On Thu, Sep 11, 2014 at 4:28 PM, Rainer Piper <rainer.piper@soho-piper.de (rainer.piper@soho-piper.de)> wrote:

Quote:

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Quote:

Hi Rainer,

Quote:

are you sure about allowing remote access to phpmyadmin ??? think about security first !!!

yes i'm sure coz it's not for commercial, just for my research.

Quote:

I suggest HeidiSQL Client at your Home PC
connecting via SSH Tunnel to your remote mySQL listening at localhost only.

i just heard HeidiSQL from here, it's like a tool? actually i have no basic for anything about database or voip.

HeidiSQL is like phpmyadmin !!!!
have a look at http://www.heidisql.com/
Features

Free for everyone, OpenSource.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

Quote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i could remote to asterisk database from phpmyadmin?

Quote:

--
Rainer Piper
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: [url=tel:%2B49%20228%2097167161]+49 228 97167161[/url]
P2P: sip:rainer@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer@xmpp.soho-piper.de (rainer@xmpp.soho-piper.de)

--
_____________________________________________________________________
-- 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

asterisk_list at earth...
Guest

Posted: Thu Sep 11, 2014 5:17 am Post subject: [asterisk-users] How to use phpmyadmin to remotely access as

On Thursday 11 Sep 2014, rafa alfurqan wrote:

Quote:

Hi,

thank you for your repplied,

Quote:

As you're on Ubuntu, you can begin with
$ sudo apt-get install phpmyadmin

i did that, so what i have to do for the configuration in asterisk so i
could remote to asterisk database from phpmyadmin?

If you installed PHPMyAdmin on the same server as Asterisk, then it should
Just Work because as far as PHPMyAdmin is concerned, the MySQL server is
local. What do you get when you point a web browser at /phpmyadmin on
server's IP address?

All PHPMyAdmin is, is a tool for building up database queries and displaying
the results. Anything you can do using the MySQL command line, you can do
with PHPMyAdmin.

If you can get a query such as

SELECT * FROM cdr ORDER BY calldate DESC LIMIT 1;

to work from the command line, then it will work through PHPMyAdmin.
Conversely, if it *doesn't* work from the command line, then you need to sort
that *first*.

--
AJS

Note: Originating address only accepts e-mail from list! If replying off-
list, change address to asterisk1list at earthshod dot co dot uk .

--
_____________________________________________________________________
-- 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

Display posts from previous:

	VoIP Mailing List Archives Forum Index -> Asterisk Users	All times are GMT - 5 Hours
Page 1 of 1

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 vote in polls in this forum