[asterisk-users] Cisco SX20 disconnecting before call

[Norman Laidla]

Good day,

I'm trying to set up a video conferencing solution for our office. Currently, 
my testing setup has my laptop running MicroSIP and a Debian VM with Asterisk 
installed on it, with the other end being a Cisco Telepresence SX20 box. Video 
calls from MicroSIP to SX20 work perfectly, but if I try to place a call from 
the SX20, it pops up a "Connecting" screen for a second, then the call ends 
with "Call has disconnected". I've set Asterisk's verbosity to 5, but the CLI 
reports nothing during the attempt. A Google search found a thread with a 
similar issue (however, theirs was with Cisco Unified Connection Manager), 
where changing the URI to include the domain helped, but on mine, the URI has 
gone from "1000" to "1...@xx.xx.xx.xx" to "sip:1...@xx.xx.xx.xx" with no change 
in behavior.

If anyone has experience with a setup like mine, I would very much appreciate 
any and all advice you can give me.

Best regards,
Norman
-- 
_
-- 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

[Mitul Limbani]

Read GotoIfTime function.p
On 12-Sep-2014 3:13 AM, "Joseph"  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

Re: [asterisk-users] if statement recording - after hours

[Brian LaVallee]

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

[Eric Wieling]

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

[Joseph]

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

[James Thomas]

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

[asterisk-users] if statement recording - after hours

[Joseph]

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] chan_sip.c:23647 handle_request_invite: Failed to authenticate device

[motty cruz]

Hello Deepak,

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

> On Thu, Sep 11, 2014 at 10:14 AM, Deepak Bhatia 
> 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 601;
> > tag=2f498fbd
> > [Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite:
> > Failed to authenticate device 601;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

Re: [asterisk-users] Ast to Ast TLS trunk

[Rusty Newton]

On Wed, Sep 10, 2014 at 2:14 PM, Rizwan H Qureshi
 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

[Rusty Newton]

On Thu, Sep 11, 2014 at 10:14 AM, Deepak Bhatia  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 601;
> tag=2f498fbd
> [Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite:
> Failed to authenticate device 601;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] ASTERISK AND CHAT MESSAGES

[Rusty Newton]

On Thu, Sep 11, 2014 at 10:46 AM, mohamed keita
 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
>  from ;
> 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

[asterisk-users] ASTERISK AND CHAT MESSAGES

[mohamed keita]

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
 from ;
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

[asterisk-users] chan_sip.c:23647 handle_request_invite: Failed to authenticate device

[Deepak Bhatia]

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 601;
tag=2f498fbd
[Sep 10 12:55:24] NOTICE[15043]: chan_sip.c:23647 handle_request_invite:
Failed to authenticate device 601;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

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

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?

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

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

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

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

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

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

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

[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

[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