[asterisk-users] How to use phpmyadmin to remotely access asterisk mysql database?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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
[asterisk-users] chan_sip.c:23647 handle_request_invite: Failed to authenticate device
Hi, Why are we getting message in the asterisk [Sep 10 12:55:23] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107; tag=2f498fbd [Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107;tag=209a8aa9 Regards Deepak Bhatia -- _ -- 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-users] ASTERISK AND CHAT MESSAGES
Hello. I have properly configured my asterisk server with some SIP accounts that work very well. Now when I want to send a chat message from my SIP client(Zoiper), I receive the following error message: *WARNING [2578]: chan_sip.c: 14511 receive_message: Received Message to sip: @. transport = UDP from sip: @. transport = UDP; tag = b03dfe52, dropped it. .. * Thank you in advance for your help. -- _ -- 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] ASTERISK AND CHAT MESSAGES
On Thu, Sep 11, 2014 at 10:46 AM, mohamed keita keitamohamed1...@gmail.com wrote: Hello. I have properly configured my asterisk server with some SIP accounts that work very well. Now when I want to send a chat message from my SIP client(Zoiper), I receive the following error message: WARNING [2578]: chan_sip.c: 14511 receive_message: Received Message to sip: @. transport = UDP from sip: @. transport = UDP; tag = b03dfe52, dropped it. .. Thank you in advance for your help. Mohamed, It is difficult to investigate an issue such as this without at least a few details about the software environment and what you are trying to accomplish. There isn't typically much we can do with just a single WARNING message excerpted from a log. For those that may be able to help you, you may want to provide at a minimum: * The exact version of Asterisk you are using. * The steps you took to produce the issue. * What you expected to happen and what actually happened. * What version of Zoiper you are using. * The destination of the SIP text message you are trying to send it to. (i.e. is this phone to phone, or phone to Asterisk, etc). Thanks, -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- 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] chan_sip.c:23647 handle_request_invite: Failed to authenticate device
On Thu, Sep 11, 2014 at 10:14 AM, Deepak Bhatia dee...@voxomos.com wrote: Hi, Why are we getting message in the asterisk [Sep 10 12:55:23] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107; tag=2f498fbd [Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107;tag=209a8aa9 Regards Deepak Bhatia Deepak, This is commonly a wrong password on the client-side. That is, the device attempting to call Asterisk is failing an authentication challenge for one reason or another. For anyone to help you, you would probably need to post your sip.conf configuration (full) and screenshots of your soft/hard client configuration. Obviously you would want to use a fake password and sanitize IP addresses if necessary. Thanks, -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- 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] Ast to Ast TLS trunk
On Wed, Sep 10, 2014 at 2:14 PM, Rizwan H Qureshi rizwanhas...@gmail.com wrote: Hi Everyone, How can I create a TLS based sip trunk between two asterisk servers. I have been trying to do it but i dont know how to defined the client certificate on the asterisk server. Has anyone tried this? There is a tutorial for secure calling with TLS and SRTP here: https://wiki.asterisk.org/wiki/display/AST/Secure+Calling+Tutorial -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- 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] chan_sip.c:23647 handle_request_invite: Failed to authenticate device
Hello Deepak, 601sip:601@111.118.185.107;tag=2f498fbd is the 111.118.185.107 your server IP? it could be a client trying to authenticate as Rusty suggest or an attacker attempting to gain access, if you want to find out what IP address that request is coming from do the following command. make sure you have tcpdump installed. tcpdump -lni eth0 -f udp port 5060 monitor your server to make sure you catch the attacker, also you could do tcpdump -w capture.cap and analyze it with wireshark. Thanks, Motty On Thu, Sep 11, 2014 at 2:28 PM, Rusty Newton rnew...@digium.com wrote: On Thu, Sep 11, 2014 at 10:14 AM, Deepak Bhatia dee...@voxomos.com wrote: Hi, Why are we getting message in the asterisk [Sep 10 12:55:23] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107; tag=2f498fbd [Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite: Failed to authenticate device 601sip:601@111.118.185.107;tag=209a8aa9 Regards Deepak Bhatia Deepak, This is commonly a wrong password on the client-side. That is, the device attempting to call Asterisk is failing an authentication challenge for one reason or another. For anyone to help you, you would probably need to post your sip.conf configuration (full) and screenshots of your soft/hard client configuration. Obviously you would want to use a fake password and sanitize IP addresses if necessary. Thanks, -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- 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
[asterisk-users] if statement recording - after hours
In my dial plan I have these two lines: exten = _NXX,n,Set(recordfilename=${CALLERID(num)}-${EXTEN}-${STRFTIME(${EPOCH},MST,%C%y-%m-%d-%H%M)}.wav) exten = _NXX,n,MixMonitor(${recordfilename},b) How to add if statement to execute these line only after let say 5pm. To record conversation only after 5pm. -- Joseph -- _ -- 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] if statement recording - after hours
GotoIfTime() Check out- http://www.voip-info.org/wiki/view/Asterisk+cmd+GotoIfTime If the time is within a certain range, execute the recording dialplan. If it's outside the range, then skip to the dialplan after the recording stuff. -- _ -- 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] if statement recording - after hours
I'm trying to avoid type the same sub-routine on each pattern, so I included the time in [outgoing] first three lines. The way I understand if the time is past 17pm it will start recording, execute next two lines. But I'm not certain what will happen if the time is before 17pm will it go to exten = 2 to it will go to in of the pattern in [goto-dialout]. [outgoing] exten = s,1,GotoIfTime(17:00-24:00,*,*,*?outgoing,s,2) ;rec exten = s,n,Set(recordfilename=${CALLERID(num)}-${EXTEN}-${STRFTIME(${EPOCH},MST,%C%y-%m-%d-%H%M)}.wav) exten = s,n,MixMonitor(${recordfilename},b) include = blocked-numbers include = goto-dialout [goto-dialout] exten = _NXX,1,Dial(SIP/7780${EXTEN}@pstn-9998,60,tr) exten = _NXX,n,GotoIf($[$[${DIALSTATUS} = BUSY] | $[${DIALSTATUS} = CONGESTION]]?line2) exten = _NXX,n(line2),Dial(SIP/9780${EXTEN}@pstn-,60,tr) exten = _NXX,n,Hangup() exten = _18X,1,Set(CHANNEL(musicclass)=default) exten = _18X,n,Dial(SIP/7${EXTEN}@pstn-9998,60,tr) -- joseph On 09/11/14 17:18, James Thomas wrote: GotoIfTime() Check out- [1]http://www.voip-info.org/wiki/view/Asterisk+cmd+GotoIfTime If the time is within a certain range, execute the recording dialplan. If it's outside the range, then skip to the dialplan after the recording stuff. References 1. http://www.voip-info.org/wiki/view/Asterisk+cmd+GotoIfTime -- _ -- 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] if statement recording - after hours
See ExecIf in the output of core show applications. The IF function might be useful, see core show functions. I assume the Asterisk Book also covers this. -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Joseph Sent: Thursday, September 11, 2014 5:43 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] if statement recording - after hours In my dial plan I have these two lines: exten = _NXX,n,Set(recordfilename=${CALLERID(num)}-${EXTEN}-${STRFTIME(${EPOCH},MST,%C%y-%m-%d-%H%M)}.wav) exten = _NXX,n,MixMonitor(${recordfilename},b) How to add if statement to execute these line only after let say 5pm. To record conversation only after 5pm. -- Joseph -- _ -- 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] if statement recording - after hours
There are multiple ways to do time-of-day routing. ExecIf w/ IFTIME, GotoIfTime, and ExecIfTime. I put some examples below. Sincerely, Brian LaVallee On 9/12/14, 10:05, Eric Wieling wrote: See ExecIf in the output of core show applications. The IF function might be useful, see core show functions. I assume the Asterisk Book also covers this. -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Joseph Sent: Thursday, September 11, 2014 5:43 PM To: asterisk-users@lists.digium.com Subject: [asterisk-users] if statement recording - after hours In my dial plan I have these two lines: exten = _NXX,n,Set(recordfilename=${CALLERID(num)}-${EXTEN}-${STRFTIME(${EPOCH},MST,%C%y-%m-%d-%H%M)}.wav) exten = _NXX,n,MixMonitor(${recordfilename},b) [main] exten = _NXX,1,NoOP(Check Time) same = GotoIfTime(9:00-17:00,mon-fri,*,*?open:closed) [open] exten = _NXX,1,NoOP(Normal Call) [closed] exten = _NXX,1,NoOP(Take a Message) ; end [main] exten = _NXX,1,NoOP(Check Time) same = n,ExecIf(${IFTIME(9:00-17:00,mon-fri,*,*?1:0)}?Goto(closed)) same = n,NoOp(Process Normal Call) [closed] exten = _NXX,1,NoOP(Take a Message) ; end [main] exten = _NXX,1,NoOP(Check Time) same = n,ExecIfTime(9:00-17:00,mon-fri,*,*?open) same = n,NoOp(Take a Message) [open] exten = _NXX,1,NoOP(Normal Call) ; end How to add if statement to execute these line only after let say 5pm. To record conversation only after 5pm. -- _ -- 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] if statement recording - after hours
Read GotoIfTime function.p On 12-Sep-2014 3:13 AM, Joseph syscon...@gmail.com wrote: In my dial plan I have these two lines: exten = _NXX,n,Set(recordfilename=${CALLERID(num)}-${EXTEN}-${ STRFTIME(${EPOCH},MST,%C%y-%m-%d-%H%M)}.wav) exten = _NXX,n,MixMonitor(${recordfilename},b) How to add if statement to execute these line only after let say 5pm. To record conversation only after 5pm. -- Joseph -- _ -- 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