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

[rafa alfurqan]

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
-- 
_
-- 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] How to use phpmyadmin to remotely access asterisk mysql database?

[A J Stiles]

On Thursday 11 Sep 2014, rafa alfurqan wrote:
> 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

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

[rafa alfurqan]

Hi,

thank you for your repplied,

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

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

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

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

[Rainer Piper]

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Hi,

thank you for your repplied,

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


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

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


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: +49 228 97167161 
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@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

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

[Alok Srivastava]

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 
wrote:

> Hi,
>
> thank you for your repplied,
>
> > 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?
>
> > 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.
>
> 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
>
-- 
_
-- 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] How to use phpmyadmin to remotely access asterisk mysql database?

[rafa alfurqan]

Hi Rainer,

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

> 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 
wrote:

>  Am 11.09.2014 um 10:36 schrieb rafa alfurqan:
>
>  Hi,
>
>  thank you for your repplied,
>
> > 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?
>
> > 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.
>
>  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
>
>
>  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: +49 228 97167161 
> P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
> XMPP: rai...@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
>
-- 
_
-- 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] How to use phpmyadmin to remotely access asterisk mysql database?

[rafa alfurqan]

Hi Alok,

> 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
-- 
_
-- 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] How to use phpmyadmin to remotely access asterisk mysql database?

[Rainer Piper]

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Hi Rainer,

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

> 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 



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 
mailto:rainer.pi...@soho-piper.de>> wrote:


Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Hi,

thank you for your repplied,

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

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

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



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: +49 228 97167161 
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@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: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: ra

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

[Rainer Piper]

Am 11.09.2014 um 11:28 schrieb Rainer Piper:

Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Hi Rainer,

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

> 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. ;-)

*SMILE*
I just love this tool ;-)


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 



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 
mailto:rainer.pi...@soho-piper.de>> wrote:


Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Hi,

thank you for your repplied,

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

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

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



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: +49 228 97167161 
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@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:
   

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

[rafa alfurqan]

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 
wrote:

>  Am 11.09.2014 um 11:00 schrieb rafa alfurqan:
>
>   Hi Rainer,
>
> > 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.
>
> > 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 
>
>
>  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 
> wrote:
>
>>  Am 11.09.2014 um 10:36 schrieb rafa alfurqan:
>>
>>  Hi,
>>
>>  thank you for your repplied,
>>
>> > 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?
>>
>> > 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.
>>
>>  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
>>
>>
>>   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: +49 228 97167161 
>> P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
>> XMPP: rai...@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 UNSUBSCRIB

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

[Rainer Piper]

Am 11.09.2014 um 11:39 schrieb rafa alfurqan:

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.



Cheers

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


Am 11.09.2014 um 11:00 schrieb rafa alfurqan:

Hi Rainer,

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

> 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 



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
mailto:rainer.pi...@soho-piper.de>>
wrote:

Am 11.09.2014 um 10:36 schrieb rafa alfurqan:

Hi,

thank you for your repplied,

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

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

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



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
 

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

[A J Stiles]

On Thursday 11 Sep 2014, rafa alfurqan wrote:
> Hi,
> 
> thank you for your repplied,
> 
> > 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