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

2014-09-11 Thread 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?

2014-09-11 Thread 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?

2014-09-11 Thread 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 callto:004922897167161
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?

2014-09-11 Thread 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 rafa.alfur...@gmail.com
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?

2014-09-11 Thread 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 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 callto:004922897167161
 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?

2014-09-11 Thread 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?

2014-09-11 Thread 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
   http://heidisql.googlecode.com/svn/trunk/out/readme.txt
 * Connect via SSH tunnel, or pass SSL settings
 * Create and edit tables
   http://www.heidisql.com/screenshots.php?which=table_editor, views
   http://www.heidisql.com/screenshots.php?which=view_editor, stored
   routines
   http://www.heidisql.com/screenshots.php?which=stored_routines,
   triggers
   http://www.heidisql.com/screenshots.php?which=trigger_editor and
   scheduled events
   http://www.heidisql.com/screenshots.php?which=event_editor.
 * Generate nice SQL-exports
   http://www.heidisql.com/screenshots.php?which=export_sql, compress
   these afterwards, or put them on the clipboard.
 * Export from one server/database directly to another server/database
 * Manage user-privileges
   http://www.heidisql.com/screenshots.php?which=usermanager
 * Import text-files
   http://www.heidisql.com/screenshots.php?which=import_textfile
 * Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP
   Array http://www.heidisql.com/screenshots.php?which=export_textfile
 * Browse and edit table-data using a comfortable grid
   http://www.heidisql.com/screenshots.php?which=data
 * Bulk edit tables (move to db, change engine, collation etc.)
 * Batch-insert ascii or binary files into tables
   http://www.heidisql.com/screenshots.php?which=insert_files
 * Write queries with customizable syntax-highlighting and
   code-completion http://www.heidisql.com/screenshots.php?which=query
 * Pretty reformat disordered SQL
 * Monitor and kill client-processes
   http://www.heidisql.com/screenshots.php?which=host_processlist
 * Find specific text in all tables of all databases of one server
   http://www.heidisql.com/screenshots.php?which=find_text_on_server
 * Optimize and repair tables in a batch manner
   http://www.heidisql.com/screenshots.php?which=maintenance
 * Launch a parallel mysql.exe command line window using your current
   connection settings
 * And much more http://www.heidisql.com/screenshots.php



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.pi...@soho-piper.de 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 callto:004922897167161
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@xmpp.soho-piper.de mailto: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: 

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

2014-09-11 Thread 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
http://heidisql.googlecode.com/svn/trunk/out/readme.txt
  * Connect via SSH tunnel, or pass SSL settings
  * Create and edit tables
http://www.heidisql.com/screenshots.php?which=table_editor,
views http://www.heidisql.com/screenshots.php?which=view_editor,
stored routines
http://www.heidisql.com/screenshots.php?which=stored_routines,
triggers
http://www.heidisql.com/screenshots.php?which=trigger_editor and
scheduled events
http://www.heidisql.com/screenshots.php?which=event_editor.
  * Generate nice SQL-exports
http://www.heidisql.com/screenshots.php?which=export_sql,
compress these afterwards, or put them on the clipboard.
  * Export from one server/database directly to another server/database
  * Manage user-privileges
http://www.heidisql.com/screenshots.php?which=usermanager
  * Import text-files
http://www.heidisql.com/screenshots.php?which=import_textfile
  * Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and
PHP Array
http://www.heidisql.com/screenshots.php?which=export_textfile
  * Browse and edit table-data using a comfortable grid
http://www.heidisql.com/screenshots.php?which=data
  * Bulk edit tables (move to db, change engine, collation etc.)
  * Batch-insert ascii or binary files into tables
http://www.heidisql.com/screenshots.php?which=insert_files
  * Write queries with customizable syntax-highlighting and
code-completion http://www.heidisql.com/screenshots.php?which=query
  * Pretty reformat disordered SQL
  * Monitor and kill client-processes
http://www.heidisql.com/screenshots.php?which=host_processlist
  * Find specific text in all tables of all databases of one server
http://www.heidisql.com/screenshots.php?which=find_text_on_server
  * Optimize and repair tables in a batch manner
http://www.heidisql.com/screenshots.php?which=maintenance
  * Launch a parallel mysql.exe command line window using your current
connection settings
  * And much more http://www.heidisql.com/screenshots.php



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.pi...@soho-piper.de 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 callto:004922897167161
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@xmpp.soho-piper.de mailto: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?

2014-09-11 Thread 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 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
http://heidisql.googlecode.com/svn/trunk/out/readme.txt
- Connect via SSH tunnel, or pass SSL settings
- Create and edit tables
http://www.heidisql.com/screenshots.php?which=table_editor, views
http://www.heidisql.com/screenshots.php?which=view_editor, stored
routines
http://www.heidisql.com/screenshots.php?which=stored_routines,
triggers http://www.heidisql.com/screenshots.php?which=trigger_editor
and scheduled events
http://www.heidisql.com/screenshots.php?which=event_editor.
- Generate nice SQL-exports
http://www.heidisql.com/screenshots.php?which=export_sql, compress
these afterwards, or put them on the clipboard.
- Export from one server/database directly to another server/database
- Manage user-privileges
http://www.heidisql.com/screenshots.php?which=usermanager
- Import text-files
http://www.heidisql.com/screenshots.php?which=import_textfile
- Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP
Array http://www.heidisql.com/screenshots.php?which=export_textfile
- Browse and edit table-data using a comfortable grid
http://www.heidisql.com/screenshots.php?which=data
- Bulk edit tables (move to db, change engine, collation etc.)
- Batch-insert ascii or binary files into tables
http://www.heidisql.com/screenshots.php?which=insert_files
- Write queries with customizable syntax-highlighting and
code-completion http://www.heidisql.com/screenshots.php?which=query
- Pretty reformat disordered SQL
- Monitor and kill client-processes
http://www.heidisql.com/screenshots.php?which=host_processlist
- Find specific text in all tables of all databases of one server
http://www.heidisql.com/screenshots.php?which=find_text_on_server
- Optimize and repair tables in a batch manner
http://www.heidisql.com/screenshots.php?which=maintenance
- Launch a parallel mysql.exe command line window using your current
connection settings
- And much more http://www.heidisql.com/screenshots.php


  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.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 callto:004922897167161
 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 

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

2014-09-11 Thread 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 
rainer.pi...@soho-piper.de 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
http://heidisql.googlecode.com/svn/trunk/out/readme.txt
  * Connect via SSH tunnel, or pass SSL settings
  * Create and edit tables
http://www.heidisql.com/screenshots.php?which=table_editor,
views
http://www.heidisql.com/screenshots.php?which=view_editor,
stored routines
http://www.heidisql.com/screenshots.php?which=stored_routines,
triggers
http://www.heidisql.com/screenshots.php?which=trigger_editor
and scheduled events
http://www.heidisql.com/screenshots.php?which=event_editor.
  * Generate nice SQL-exports
http://www.heidisql.com/screenshots.php?which=export_sql,
compress these afterwards, or put them on the clipboard.
  * Export from one server/database directly to another
server/database
  * Manage user-privileges
http://www.heidisql.com/screenshots.php?which=usermanager
  * Import text-files
http://www.heidisql.com/screenshots.php?which=import_textfile
  * Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup
and PHP Array
http://www.heidisql.com/screenshots.php?which=export_textfile
  * Browse and edit table-data using a comfortable grid
http://www.heidisql.com/screenshots.php?which=data
  * Bulk edit tables (move to db, change engine, collation etc.)
  * Batch-insert ascii or binary files into tables
http://www.heidisql.com/screenshots.php?which=insert_files
  * Write queries with customizable syntax-highlighting and
code-completion
http://www.heidisql.com/screenshots.php?which=query
  * Pretty reformat disordered SQL
  * Monitor and kill client-processes
http://www.heidisql.com/screenshots.php?which=host_processlist
  * Find specific text in all tables of all databases of one
server
http://www.heidisql.com/screenshots.php?which=find_text_on_server
  * Optimize and repair tables in a batch manner
http://www.heidisql.com/screenshots.php?which=maintenance
  * Launch a parallel mysql.exe command line window using your
current connection settings
  * And much more http://www.heidisql.com/screenshots.php



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.pi...@soho-piper.de 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