Re: [asterisk-users] WebRTC softphone for Asterisk - any suggestion?

[Lenz Emilitri]

Looks yummy! http://phono.com/webrtc


2013/5/31 Adnan <112linuxstockh...@gmail.com>

> Voxeo/Phono webrtc.
>
> /Adnan
>
>
> On Fri, May 31, 2013 at 1:53 PM, Lenz Emilitri wrote:
>
>>
>> Hi All,
>> I wonder if any of you has some suggestions on which WebRTC
>> client/softphone to use for a click-to-dial, webpage hosted solution. Any
>> suggestions?
>> Thanks
>> l.
>> --
>> Loway - home of QueueMetrics - http://queuemetrics.com
>> Test-drive WombatDialer beta @ http://wombatdialer.com
>>
>> --
>> _
>> -- 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
>



-- 
Loway - home of QueueMetrics - http://queuemetrics.com
Test-drive WombatDialer beta @ http://wombatdialer.com
--
_
-- 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] 回覆︰ WebRTC softphone for Asterisk - any suggestion?

[kingman chui]

you can use sipml5 web page ,,, It work for webrtc...


>
> 寄件人︰ Lenz Emilitri 
>收件人︰ Asterisk Users Mailing List - Non-Commercial Discussion 
> 
>傳送日期︰ 2013年06月3日 (週一) 6:34 PM
>主題︰ Re: [asterisk-users] WebRTC softphone for Asterisk - any suggestion?
>  
>
>
>Looks yummy! http://phono.com/webrtc
>
>
>
>
>2013/5/31 Adnan <112linuxstockh...@gmail.com>
>
>Voxeo/Phono webrtc.
>>
>>
>>/Adnan
>>
>>
>>
>>On Fri, May 31, 2013 at 1:53 PM, Lenz Emilitri  wrote:
>>
>>
>>>
>>>Hi All,
>>>
>>>I wonder if any of you has some suggestions on which WebRTC client/softphone 
>>>to use for a click-to-dial, webpage hosted solution. Any suggestions? 
>>>Thanksl. -- 
>>>
>>>Loway - home of QueueMetrics - http://queuemetrics.com/
>>>
>>>Test-drive WombatDialer beta @ http://wombatdialer.com/   
>>>--
>>>_
>>>-- 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
>>
>
>
>-- 
>
>Loway - home of QueueMetrics - http://queuemetrics.com/
>
>Test-drive WombatDialer beta @ http://wombatdialer.com/  
>--
>_
>-- 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] WebRTC softphone for Asterisk - any suggestion?

[Yves A.]

looks yummy indeed... but how does it interact with an asterisk? phono 
uses afaiu voxeo-cloud to make place calls, send sms and so on...
I do not see a way to use phono without their cloud services, not did I 
see any hint about charges for calls...


yves

Am 03.06.2013 12:34, schrieb Lenz Emilitri:

Looks yummy! http://phono.com/webrtc


2013/5/31 Adnan <112linuxstockh...@gmail.com 
>


Voxeo/Phono webrtc.

/Adnan


On Fri, May 31, 2013 at 1:53 PM, Lenz Emilitri
mailto:lenz.lo...@gmail.com>> wrote:


Hi All,
I wonder if any of you has some suggestions on which WebRTC
client/softphone to use for a click-to-dial, webpage hosted
solution. Any suggestions?
Thanks
l.
-- 
Loway - home of QueueMetrics - http://queuemetrics.com

Test-drive WombatDialer beta @ http://wombatdialer.com

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




--
Loway - home of QueueMetrics - http://queuemetrics.com
Test-drive WombatDialer beta @ http://wombatdialer.com


--
_
-- 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] Asterisk T.38 Pass-Through doesn't work

[Andrey Polovov]

Thank you for reply, Larry!

On 06/03/2013 05:14 AM, Larry Moore wrote:

1) On SPA112 set "FAX T38 Redundancy" = 3

I have tried to change this value with no effect.

2) Add t38pt_usertpsource=yes in [mtt] section
This option take no positive effect for me, asterisk continues to use 
ports from udptl.conf range. But in the oser side, I think, that there 
are no problems with network, because:
* on router, that provide internet for asterisk configured full DNAT 
from white IP to asterisk server,

* fax between asterisk cmd SendFax and PSTN fax works great.

3) Change maxdatagram=200 to maxdatagram=1400
4) In udptl.conf change T38FaxMaxDatagram to a value of 1400
5) In udptl.conf change use_even_ports to yes

This settings doesnt help me.

You don't appear to list the sip.conf entry for the SPA112.
I`m sorry, spa112 peer settings are in mysql extconfig, config file 
analogue:

[297]
context=office
secret=xxx
host-dynamic
nat=yes
type=friend
callerid=297
disallow=all
allow=alaw

Where did t38pt_rtp & t38_tcp come from?
This settings I have googled on some forum and then add to my config 
with despair.
You may also want to experiment with the SPA112 setting "FAX T38 ECM 
Enable"

This option doesnt help me too :(.

Additional info: fax between two SPA112 works perfect! Now I returned 
settings to original state as described in first letter.


--
Андрей Половов, ведущий инженер ЗАО «Флант».
http://www.flant.ru/
+7 (495) 721-10-27, доб. 412
+7 (925) 816-66-83


--
_
-- 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 T.38 Pass-Through doesn't work

[Larry Moore]

On 3/06/2013 8:04 PM, Andrey Polovov wrote:

Thank you for reply, Larry!

On 06/03/2013 05:14 AM, Larry Moore wrote:

1) On SPA112 set "FAX T38 Redundancy" = 3

I have tried to change this value with no effect.

2) Add t38pt_usertpsource=yes in [mtt] section

This option take no positive effect for me, asterisk continues to use
ports from udptl.conf range. But in the oser side, I think, that there
are no problems with network, because:
* on router, that provide internet for asterisk configured full DNAT
from white IP to asterisk server,
* fax between asterisk cmd SendFax and PSTN fax works great.

3) Change maxdatagram=200 to maxdatagram=1400
4) In udptl.conf change T38FaxMaxDatagram to a value of 1400
5) In udptl.conf change use_even_ports to yes

This settings doesnt help me.

You don't appear to list the sip.conf entry for the SPA112.

I`m sorry, spa112 peer settings are in mysql extconfig, config file
analogue:
[297]
context=office
secret=xxx
host-dynamic
nat=yes
type=friend
callerid=297
disallow=all
allow=alaw

Where did t38pt_rtp & t38_tcp come from?

This settings I have googled on some forum and then add to my config
with despair.

You may also want to experiment with the SPA112 setting "FAX T38 ECM
Enable"

This option doesnt help me too :(.

Additional info: fax between two SPA112 works perfect! Now I returned
settings to original state as described in first letter.




Have you checked the installed version of firmware against the latest 
available from Cisco?


Looking at your SIP information when your ITSP initiated a T.38 session 
it did not indicate a maxmimum bitrate, it would appear your spa112 
attempted to negotiate a connection at 2400bps.


Do you have a sip debug session when you sent a fax from your Asterisk 
box to the PSTN, it would be interesting to see if it sends it as a t.38 
or reverts to G711 audio.


You will only want to experiment with the ECM option once you have t.38 
working.


Larry.

--
_
-- 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] Confbridge doesn't kick chan_local

[Chris Gentle]

I have a confbridge setup that feeds the conference from the ALSA
microphone input (this is the conference leader) and then uses
app_ices to send the conference audio to icecast.

I start the conference leader like this:

console dial 1000_admin@conferences

I join the ices user to the confbridge with a call file:

Channel:  Local/1000@conferences
MaxRetries: 2
RetryTime: 60
WaitTime: 30
Context: conferences
Extension: 1000_ices
Priority: 1

This all seems to work great until I need to kill the conference.  My
confbridge user profile sets all users up with end_marked=yes so that
they should be kicked when the leader exits.  The Local channel
doesn't seem to exit properly:

<< Hangup on console >>
-- Stopped music on hold on Local/1000@conferences-;2
--  Playing
'custom/thank-you.slin' (language 'en')
-- Executing [1000@conferences:2]
Hangup("Local/1000@conferences-;2", "") in new stack
  == Spawn extension (conferences, 1000, 2) exited non-zero on
'Local/1000@conferences-;2'
  == Spawn extension (conferences, 1000_ices, 4) exited non-zero on
'Local/1000@conferences-;1'
[Jun  3 07:44:27] NOTICE[18237]: pbx_spool.c:402 attempt_thread: Call
completed to Local/1000@conferences

The bridge gets left in an odd state.  Rather than the bridge being
destroyed, a "confbridge list" shows the conference is still active
with 0 users.  I have to restart asterisk to clear it.

I wonder if someone might take a look at my dialplan snippet below and
see if I'm doing something wrong before I file a bug report.  I'm
using Asterisk 11.4.0.

[conferences] ; {{{
  ; this is where normal callers enter the conference
  exten => 
1000,1,ConfBridge(${EXTEN},testfone_bridge,testfone_user,testfone_user_menu)
  exten => 1000,n,Hangup()

  ; this is where the conf leader enters
  exten => 1000_admin,1,Answer()
  exten => 1000_admin,n,Set(CALLERID(name)=ConfLeader)
  exten => 1000_admin,n,Set(CALLERID(num)=001000)
  exten => 1000_admin,n,Set(CONFBRIDGE(user,admin)=yes)
  exten => 1000_admin,n,Set(CONFBRIDGE(user,marked)=yes)
  exten => 1000_admin,n,Set(CONFBRIDGE(bridge,record_conference)=yes)
  exten => 
1000_admin,n,ConfBridge(1000,testfone_bridge,testfone_user,testfone_user_menu)
  exten => 1000_admin,n,Hangup()

  ; this is the Local channel that connects to app_ices
  exten => 1000_ices,1,Answer()
  exten => 1000_ices,n,Ices(/home/asterisk/asterisk-ices-1000.xml)
 ;exten => 1000_ices,n,Hangup()
;}}}



--
Chris

--
_
-- 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 debian package and digium repository

[Daniel Pocock]

On 07/08/12 23:11, Rusty Newton wrote:
> On 8/7/2012 7:27 AM, Paul Belanger wrote:
>> On 12-08-07 03:31 AM, ml asterisk wrote:
>>> Hi,
>>>
>>> I used to install asterisk on debian squeeze with digium repository.
>>> The last build of asterisk available is 1.8.11.1.
>>> Is this repository discontinued ?
>>>
>> Since leaving Digium they have become unmaintained.  If you are
>> interested in helping out, you might want to reach out to
>> #asterisk-dev or asterisk-dev mailing list.
>>
> Matt Jordan has been working on getting it sorted out, but we only
> have so much time and resources. Anyone who wants to step up and help
> out, don't be shy! As Paul said: #asterisk-dev or asterisk-dev mailing
> list.
>
Can anybody clarify the current situation with packages?

The wiki says they stopped being supported in March 2012:
https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages

but
a) it's not clear if it is talking about the asterisk.org hosted
packages or the debian.org hosted packages
b) the asterisk.org hosted .deb packages appear to be updated in
November 2012
c) Debian 7 was released with Asterisk 1.8 at the beginning of May 2013,
that means it is supported as long as Debian 7 is current + 1 year
(approximately 3 years total)
d) Ubuntu appears to be carrying 1.8 in their best-efforts supported
"universe" catalog

Furthermore, I notice that on packages.asterisk.org RHEL6 has Asterisk
11 packages but Debian/Ubuntu (pool directory) still has 1.8

Having a look at Debian's PTS, I found that Asterisk 11 packaging is a
work-in-progress, it may be possible for people to obtain it from
Debian's SVN or git and build packages with dpkg-buildpackage



--
_
-- 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 debian package and digium repository

[Joshua Colp]

Daniel Pocock wrote:

On 07/08/12 23:11, Rusty Newton wrote:

On 8/7/2012 7:27 AM, Paul Belanger wrote:

On 12-08-07 03:31 AM, ml asterisk wrote:

Hi,

I used to install asterisk on debian squeeze with digium repository.
The last build of asterisk available is 1.8.11.1.
Is this repository discontinued ?


Since leaving Digium they have become unmaintained.  If you are
interested in helping out, you might want to reach out to
#asterisk-dev or asterisk-dev mailing list.


Matt Jordan has been working on getting it sorted out, but we only
have so much time and resources. Anyone who wants to step up and help
out, don't be shy! As Paul said: #asterisk-dev or asterisk-dev mailing
list.


Can anybody clarify the current situation with packages?

The wiki says they stopped being supported in March 2012:
https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages


There has been no change in the situation. The asterisk.org Debian 
packages have not been updated. The debian.org packages are done by 
others, so I can't speak on that.


--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.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] Fiber or regular DSL Supported Gateways/PRI

[Nick Khamis]

Hello Everyone,

I am looking to getting converged with the local ILEC here in Canada
(Bell or Telus), and was wondering if I can get some more information
about typical setups. DIDs and channel offerings from third party
clecs does not fit our business model and that's why we are looking to
purchasing phone numbers directly from the ILEC, and manging our own
PRIs for a convergence of sorts. My questions are:

* Do we need a T1/3 of DS3 connection setup, or can we function of
regular IPX, DSL, Fiber...
* If we can function on a regular fiber or DSL connection, which media
gateways provide a WAN interface for such a connection, or will we
need a ethernet to T1 adapter to plug our connection to the appliance
(e.g.,  audiocodes or sangoma).

Finally, if you have recently setup such an interconnection, some
details on what to expect, options and so on would be greatly
appreciated.

Kind Regards,

Nick.

--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

Hi

i have installed a new Asterisk server on Fedora. My first server use
Asterisk 1.6.x with a MySQL CDR and
realtime.

I have a small problems, when i configure on the new server, the same
information in MySQL, we have a error:

[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to
connect database server SSI on myhost.myserver.com (err 2003). Check debug
for more info.
[Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
found in database.  This table should exist if you're using realtime.
[Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
database SSI on myhost.myserver.com.
[Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
database SSI on myhost.myserver.com.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database user found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database password found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database host found, using localhost via socket.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database name found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database port found, using 3306 as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database socket found (and unable to detect a suitable path).

The exacly same config work on 1.6.x

and from the new server, the database access is Ok:

[root@voip-2 log]# !mys
mysql -h myhost.myserver.com -u Asterisk -p SSI
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5185
Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> select * from VoiceMail;
+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
| uniqueid | customer_id | context  | mailbox| password |
fullname | email | pager | tz  | attach | saycid |
dialout | callback | review | operator | envelope | sayduration |
saydurationm | sendvoicemail | delete | nextaftercmd | forcename |
forcegreetings | hidefromdir | stamp   |
+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
<..>


anyone know the problems ?

thanks
olivier
--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Ron Wheeler]

It looks like your database configuration is missing in Asterisk.

It is making up information about the connection using defaault values  
as if it did not find any database configuration.


Ron

On 03/06/2013 10:49 AM, Olivier CALVANO wrote:

Hi

i have installed a new Asterisk server on Fedora. My first server use 
Asterisk 1.6.x with a MySQL CDR and

realtime.

I have a small problems, when i configure on the new server, the same 
information in MySQL, we have a error:


[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: 
Failed to connect database server SSI on myhost.myserver.com 
 (err 2003). Check debug for more info.
[Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail 
not found in database.  This table should exist if you're using realtime.
[Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql 
database SSI on myhost.myserver.com .
[Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql 
database SSI on myhost.myserver.com .
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database user found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database password found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database host found, using localhost via socket.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database name found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database port found, using 3306 as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No 
database socket found (and unable to detect a suitable path).


The exacly same config work on 1.6.x

and from the new server, the database access is Ok:

[root@voip-2 log]# !mys
mysql -h myhost.myserver.com  -u Asterisk 
-p SSI

Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5185
Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights 
reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.


mysql> select * from VoiceMail;
+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
| uniqueid | customer_id | context  | mailbox| password | 
fullname | email | pager | tz  | attach | 
saycid | dialout | callback | review | operator | envelope | 
sayduration | saydurationm | sendvoicemail | delete | nextaftercmd | 
forcename | forcegreetings | hidefromdir | stamp   |

+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
<..>


anyone know the problems ?

thanks
olivier




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



--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

The database schema (table) is different in Asterisk 11.4 ?

because i have configured:

cdr_mysql.conf
extconfig.conf
res_config_mysql.conf

and on the mysql server, it's the old database of 1.6.x

i see:

[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to
connect database server xxx on xxx (err 2003). Check debug for more info.

can i put debug ? i don't know where

thanks
olivier




2013/6/3 Ron Wheeler 

>  It looks like your database configuration is missing in Asterisk.
>
> It is making up information about the connection using defaault values  as
> if it did not find any database configuration.
>
> Ron
>
>
> On 03/06/2013 10:49 AM, Olivier CALVANO wrote:
>
>Hi
>
>  i have installed a new Asterisk server on Fedora. My first server use
> Asterisk 1.6.x with a MySQL CDR and
> realtime.
>
>  I have a small problems, when i configure on the new server, the same
> information in MySQL, we have a error:
>
> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server SSI on myhost.myserver.com (err 2003). Check
> debug for more info.
> [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
> found in database.  This table should exist if you're using realtime.
> [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
> database SSI on myhost.myserver.com.
> [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
> database SSI on myhost.myserver.com.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database user found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database password found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database host found, using localhost via socket.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database name found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database port found, using 3306 as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database socket found (and unable to detect a suitable path).
>
>  The exacly same config work on 1.6.x
>
> and from the new server, the database access is Ok:
>
> [root@voip-2 log]# !mys
> mysql -h myhost.myserver.com -u Asterisk -p SSI
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 5185
> Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)
>
> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> select * from VoiceMail;
>
> +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
> | uniqueid | customer_id | context  | mailbox| password |
> fullname | email | pager | tz  | attach | saycid |
> dialout | callback | review | operator | envelope | sayduration |
> saydurationm | sendvoicemail | delete | nextaftercmd | forcename |
> forcegreetings | hidefromdir | stamp   |
>
> +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
>  <..>
>
>
>  anyone know the problems ?
>
> thanks
> olivier
>
>
>
>
> --
> _
> -- 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
>
>
>
> --
> Ron Wheeler
> President
> Artifact Software Inc
> email: rwhee...@artifact-software.com
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>
> --
> _
> -- 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
>

Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

Strange too, in the logs:


[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database user found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database password found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database host found, using localhost via socket.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database name found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database port found, using 3306 as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database socket found (and unable to detect a suitable path).
[Jun  3 17:09:49] NOTICE[3464] config.c: Registered Config Engine mysql
[Jun  3 17:09:49] ERROR[3464] res_config_mysql.c: MySQL RealTime: Failed to
connect database server SSI on  (err 2003). Check debug for more info.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: Table Comptes_IAX not
found in database.  This table should exist if you're using realtime.


Hi said "No database host found" but in the log i have "Failed to connect
database server SSI on " with SSI and  correct into my config file



2013/6/3 Olivier CALVANO 

> The database schema (table) is different in Asterisk 11.4 ?
>
> because i have configured:
>
> cdr_mysql.conf
> extconfig.conf
> res_config_mysql.conf
>
> and on the mysql server, it's the old database of 1.6.x
>
> i see:
>
> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server xxx on xxx (err 2003). Check debug for more info.
>
> can i put debug ? i don't know where
>
> thanks
> olivier
>
>
>
>
> 2013/6/3 Ron Wheeler 
>
>>  It looks like your database configuration is missing in Asterisk.
>>
>> It is making up information about the connection using defaault values
>> as if it did not find any database configuration.
>>
>> Ron
>>
>>
>> On 03/06/2013 10:49 AM, Olivier CALVANO wrote:
>>
>>Hi
>>
>>  i have installed a new Asterisk server on Fedora. My first server use
>> Asterisk 1.6.x with a MySQL CDR and
>> realtime.
>>
>>  I have a small problems, when i configure on the new server, the same
>> information in MySQL, we have a error:
>>
>> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
>> to connect database server SSI on myhost.myserver.com (err 2003). Check
>> debug for more info.
>> [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
>> found in database.  This table should exist if you're using realtime.
>> [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
>> database SSI on myhost.myserver.com.
>> [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
>> database SSI on myhost.myserver.com.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database user found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database password found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database host found, using localhost via socket.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database name found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database port found, using 3306 as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database socket found (and unable to detect a suitable path).
>>
>>  The exacly same config work on 1.6.x
>>
>> and from the new server, the database access is Ok:
>>
>> [root@voip-2 log]# !mys
>> mysql -h myhost.myserver.com -u Asterisk -p SSI
>> Enter password:
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 5185
>> Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)
>>
>> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql> select * from VoiceMail;
>>
>> +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
>> | uniqueid | customer_id | context  | mailbox| password |
>> fullname | email | pager | tz  | attach | saycid |
>> dialou

[asterisk-users] DAHDI 2.6 and OPENVOX cards

[Mordechay Kaganer]

B.H.

Hello, all :-)

We have some OPENVOX D410P PRI cards and we are successfully using them
with Asterisk boxes which are based on stock ubuntu 12.04 DAHDI and
Asterisk packages.

The card is recognized by DAHDI as 'Wildcard TE410P (2nd Gen)' and it uses
wct4xxp driver.

Now, i'm trying to run this hardware with DAHDI 2.6.2 package which is
available from asterisk.org site and looks like, it is not working with my
card - i've compiled and configured it. It recognizes my card,  but after
loading dahdi and the config, the card is not functional - it shows green
lights even when no E1 cable connected, and dahdi_test gives 0.0% all the
time so looks like it doesn't generate interrupts.

Thanks for your help :-)
-- 
משיח NOW!
Moshiach is coming very soon, prepare yourself!
יחי אדוננו מורינו ורבינו מלך המשיח לעולם ועד!
--
_
-- 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] RHEL6 packages - SRTP support?

[Daniel Pocock]

I tried installing the Asterisk 11 RHEL6 packages from packages.asterisk.org

I followed this guide:
https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages

The SRTP support appears to be missing though.  I notice libsrtp was not
automatically installed as a dependency, and no srtp module exists under
/usr/lib64/asterisk/modules

Is it still necessary to do a source build every time SRTP is needed? 
Or is the srtp module distributed in some other rpm?

--
_
-- 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] Minimum requirement for Asterisk IVR

[Justin Killen]

1)  I'm sure it's possible, it's just a matter of talking to the mobile network 
in question and finding out what kind of options they have available.

2/3) Once asterisk gets the call, it can redirect it to just about any endpoint 
you'd like it to.  For more information on asterisk's IVR capabilities, I 
suggest starting here: 
http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/asterisk-IVR.html

What modules you'll need will vary depending on how asterisk is connected to 
the PTSN and to the external IVR application.

'Do we need to install complete Asterisk'?  I guess this depends on your 
definition of 'complete'.  My advice to you as a start/test would be to install 
asterisk and all the sample configurations and then start playing around with 
connections.

-Justin

From: asterisk-users-boun...@lists.digium.com 
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of luke devon
Sent: Saturday, June 01, 2013 7:59 AM
To: Astericks
Subject: [asterisk-users] Minimum requirement for Asterisk IVR

Hi

1. When a mobile user dial an IVR short code , mobile network able to divert 
that call to Asterisk platform.

2. There would be web servers which are holds Voice XML .

3. Asterisk would be able to redirect the mobile request to certain Voice XML 
server accordingly.

Just for like this setup , how do we install asterisk with minimum of asterisk 
modules ?

Do we need to install complete Asterisk just for the IVR functionality ?

Thanks in advance
Luke





--
_
-- 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] RHEL6 packages - SRTP support?

[jg]

You need to download libsrtp manually from 
http://srtp.sourceforge.net/srtp-1.4.2.tgz


I never had any problems compiling this packages.

jg

--
_
-- 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] missing build dependency / mISDNutils-devel and other errors

[Daniel Pocock]

Building from the source RPM I get an error

 mISDNuser-devel is needed

I was able to obtain all the other build dependencies from EPEL 6, but
that one doesn't appear to existing in EPEL or in packages.asterisk.org

I then tried adding --nodeps to the rpmbuild command:

   rpmbuild --rebuild --nodeps asterisk-11.4.0-1_centos6.src.rpm

Running as a normal user, the build fails on the line

   mv asterisk-sources-11.4.0-1_centos6.make.err /var/log/

due to the permissions on /var/log/

As a hack, I set the perms on /var/log/ to 0777 and try again and then
it fails with some "file not found" messages at the end of the build,
missing:
cdr_adaptive_odbc.so
cdr_odbc.so
cel_odbc.so
func_odbc.so
res_config_odbc.so
res_odbc.so

I checked my system, unixODBC-devel is present, so it appears to be a
build config issue with the spec file




--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Ron Wheeler]

Fix this.

[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database user found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database password found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database host found, using localhost via socket.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database name found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database port found, using 3306 as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No 
database socket found (and unable to detect a suitable path).


Asterisk is telling you that you have not configured ANY database.

It is not worrying about what tables are in it because you have not even 
defined the database itself.
There is NO database at all so worrying about versions is not Asterisk's 
big problem..


The rest of the messages after that are a bit screwy because the 
routines producing the error are not aware that there is no database at 
all so they just complain about the piece that they know about.



Ron


On 03/06/2013 12:19 PM, Olivier CALVANO wrote:

No other idea ?




2013/6/3 Olivier CALVANO >


Hi

i have installed a new Asterisk server on Fedora. My first server
use Asterisk 1.6.x with a MySQL CDR and
realtime.

I have a small problems, when i configure on the new server, the
same information in MySQL, we have a error:

[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime:
Failed to connect database server SSI on myhost.myserver.com
 (err 2003). Check debug for more info.
[Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table
VoiceMail not found in database.  This table should exist if
you're using realtime.
[Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to
mysql database SSI on myhost.myserver.com
.
[Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to
mysql database SSI on myhost.myserver.com
.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database user found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database password found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database host found, using localhost via socket.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database name found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database port found, using 3306 as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database socket found (and unable to detect a
suitable path).

The exacly same config work on 1.6.x

and from the new server, the database access is Ok:

[root@voip-2 log]# !mys
mysql -h myhost.myserver.com  -u
Asterisk -p SSI
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5185
Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition
(GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current
input statement.

mysql> select * from VoiceMail;

+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
| uniqueid | customer_id | context  | mailbox| password |
fullname | email | pager | tz  | attach |
saycid | dialout | callback | review | operator | envelope |
sayduration | saydurationm | sendvoicemail | delete | nextaftercmd
| forcename | forcegreetings | hidefromdir | stamp   |

+--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
<..>


anyone kn

Re: [asterisk-users] DAHDI 2.6 and OPENVOX cards

[Russ Meyerriecks]

On Mon, Jun 03, 2013 at 06:34:42PM +0300, Mordechay Kaganer wrote:
> The card is recognized by DAHDI as 'Wildcard TE410P (2nd Gen)' and it uses
> wct4xxp driver.

What's the output of 'lspci -n' ?

-- 
Russ Meyerriecks
Digium, Inc. | Linux Kernel Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
direct: +1 256-428-6025
Check us out at: www.digium.com & www.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] Is uniqueid/sequence a safe CDR table primary key ?

[Olivier]

Hi,

When dealing with CDR SQL tables, I always added an auto-incremented cdr_id
key as a primary key, just in case provided uniqueid key went wrong.

Now I'm facing a situation where I need to insert into a database's table
and from the dialplan, a reference to the CDR record which is currently
processed.

So my questions are:

1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be safely
used as CDR's table primary key  (ie I cannot have any uniqueid/sequence
combination from one CDR record to match a past uniqueid/sequence
combination) ?

2. Suggestions ?

Regards
--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

No other idea ?




2013/6/3 Olivier CALVANO 

> Hi
>
> i have installed a new Asterisk server on Fedora. My first server use
> Asterisk 1.6.x with a MySQL CDR and
> realtime.
>
> I have a small problems, when i configure on the new server, the same
> information in MySQL, we have a error:
>
> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server SSI on myhost.myserver.com (err 2003). Check
> debug for more info.
> [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
> found in database.  This table should exist if you're using realtime.
> [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
> database SSI on myhost.myserver.com.
> [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
> database SSI on myhost.myserver.com.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database user found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database password found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database host found, using localhost via socket.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database name found, using 'asterisk' as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database port found, using 3306 as default.
> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
> database socket found (and unable to detect a suitable path).
>
> The exacly same config work on 1.6.x
>
> and from the new server, the database access is Ok:
>
> [root@voip-2 log]# !mys
> mysql -h myhost.myserver.com -u Asterisk -p SSI
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 5185
> Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)
>
> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> select * from VoiceMail;
>
> +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
> | uniqueid | customer_id | context  | mailbox| password |
> fullname | email | pager | tz  | attach | saycid |
> dialout | callback | review | operator | envelope | sayduration |
> saydurationm | sendvoicemail | delete | nextaftercmd | forcename |
> forcegreetings | hidefromdir | stamp   |
>
> +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+
> <..>
>
>
> anyone know the problems ?
>
> thanks
> olivier
>
>
>
--
_
-- 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] RHEL6 packages - SRTP support?

[Jason Parker]

The packages currently do not support SRTP.

On 06/03/2013 10:56 AM, Daniel Pocock wrote:

I tried installing the Asterisk 11 RHEL6 packages from packages.asterisk.org

I followed this guide:
https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages

The SRTP support appears to be missing though.  I notice libsrtp was not
automatically installed as a dependency, and no srtp module exists under
/usr/lib64/asterisk/modules

Is it still necessary to do a source build every time SRTP is needed?
Or is the srtp module distributed in some other rpm?



--
_
-- 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] MeetMe exit status?

[Matthew Jordan]

On 06/02/2013 08:36 PM, Patrick Lists wrote:
> Hi,
> 
> Does MeetMe in Asterisk 11.4 set some kind of exit status or a var so I
> know for example if a conf ended normally or if someone gave a wrong
> conf number or pin?
> 
> Thanks,
> Patrick
> 

There is no channel variable that provides that level of granularity.
The closest available is the MEETMESECS channel variable, which tells
you how many seconds the participant was in the conference.

You can find a full list on the Asterisk wiki:

https://wiki.asterisk.org/wiki/display/AST/MeetMe+Channel+Variables

Matt

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
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] DAHDI 2.6 and OPENVOX cards

[Mordechay Kaganer]

B.H.

Thanks for the reply

On Mon, Jun 3, 2013 at 7:42 PM, Russ Meyerriecks wrote:

> On Mon, Jun 03, 2013 at 06:34:42PM +0300, Mordechay Kaganer wrote:
> > The card is recognized by DAHDI as 'Wildcard TE410P (2nd Gen)' and it
> uses
> > wct4xxp driver.
>
> What's the output of 'lspci -n' ?
>

the output for the relevant card is:

# lspci -n
04:01.0 0780: d161:0410 (rev 02)

#lspci
04:01.0 Communication controller: Digium, Inc. Wildcard TE410P/TE412P
quad-span T1/E1/J1 card 3.3V (rev 02)


>
> --
> Russ Meyerriecks
> Digium, Inc. | Linux Kernel Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> direct: +1 256-428-6025
> Check us out at: www.digium.com & www.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
>



-- 
משיח NOW!
Moshiach is coming very soon, prepare yourself!
יחי אדוננו מורינו ורבינו מלך המשיח לעולם ועד!
--
_
-- 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] Confbridge doesn't kick chan_local

[Matthew Jordan]

On 06/03/2013 08:11 AM, Chris Gentle wrote:
> I have a confbridge setup that feeds the conference from the ALSA
> microphone input (this is the conference leader) and then uses
> app_ices to send the conference audio to icecast.
> 
> I start the conference leader like this:
> 
> console dial 1000_admin@conferences
> 
> I join the ices user to the confbridge with a call file:
> 
> Channel:  Local/1000@conferences
> MaxRetries: 2
> RetryTime: 60
> WaitTime: 30
> Context: conferences
> Extension: 1000_ices
> Priority: 1
> 
> This all seems to work great until I need to kill the conference.  My
> confbridge user profile sets all users up with end_marked=yes so that
> they should be kicked when the leader exits.  The Local channel
> doesn't seem to exit properly:
> 



That is odd. ConfBridge doesn't really care about the channel
technology; if a Local channel joins with the same user profile as a SIP
channel, it should treat those channels in the same fashion.

Ices may be throwing it off here however. I'd try two different tests:

(1) Verify that with all 'normal' channel drivers, such as chan_sip,
that the Conference tears down correctly.

(2) Verify that a Local channel in an infinite wait gets ejected
properly and the conference tears down.

You can do that by:

exten => 1000_wait,1,Answer()
exten => 1000_wait,2,Wait(1)
exten => 1000_wait,3,Hangup()

(Or something equally sinister)

If both (1) and (2) are successful, than there's some impact that the
Ices application is having on the Local channel that is messing up the
reference counting inside the ConfBridge. Otherwise, it's an error in
ConfBridge.

Matt

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
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] Is uniqueid/sequence a safe CDR table primary key ?

[Matthew Jordan]

On 06/03/2013 11:20 AM, Olivier wrote:
> Hi,
> 
> When dealing with CDR SQL tables, I always added an auto-incremented
> cdr_id key as a primary key, just in case provided uniqueid key went wrong.
> 
> Now I'm facing a situation where I need to insert into a database's
> table and from the dialplan, a reference to the CDR record which is
> currently processed.
> 
> So my questions are:
> 
> 1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be
> safely used as CDR's table primary key  (ie I cannot have any
> uniqueid/sequence combination from one CDR record to match a past
> uniqueid/sequence combination) ?

Possibly. Things to keep in mind:

* You can run into uniqueid collisions across multiple systems if you do
not specify a system name in asterisk.conf or do not specify a unique
system name in asterisk.conf.
* You can run into uniqueid collisions if your system clock goes
backwards for any reason (the uniqueid for a channel happens to use a
timestamp for its uniqueness)

Whether or not this is unique enough will be completely dependent on
your overall system configuration.

In general, the recommended combination that *should* uniquely specify a
CDR (when configured correctly) is linkedid (which should be enabled and
added to your schema), uniqueid, and sequence number, with the asterisk
system name specified.

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
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] RHEL6 packages - SRTP support?

[Daniel Pocock]

On 03/06/13 18:46, Jason Parker wrote:
> The packages currently do not support SRTP.
>

I tried building manually from the source RPM

Before running rpmbuild, I installed libsrtp-devel and I notice that
res_srtp.so is generated during the build

However, the rpmbuild fails for other reasons (see the other email I
sent to the list about mISDNutils-devel and other spec file errors)

Can you confirm the exact procedure you recommend for rpmbuild on a
CentOS6 system?



--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

Thanks for your help Ron,

Do you know where is the confirguration ?

Because i have put into res_config_mysql.conf:

[general]
dbhost = myhost.mydomain.net
dbname = MyDB
dbuser = MyUser
dbpass = MyPassword
dbport = 3306
dbsock = /tmp/mysql.sock
dbcharset = latin1
requirements = warn


after in extconfig.conf:
sipusers => mysql,general,Comptes_SIP
sippeers => mysql,general,Comptes_SIP
iaxusers => mysql,general,Comptes_IAX
iaxpeers => mysql,general,Comptes_IAX
extensions => mysql,general,Extensions
meetme => mysql,general,MeetMe
musiconhold => mysql,general,Musiconhold
voicemail => mysql,general,VoiceMail

and in cdr_mysql.conf

[global]
hostname=myhost.mydomain.net
dbname=MyDB
table=Cdr
password=MyPassword
user=MyUser
port=3306
sock=/tmp/mysql.sock

[aliases]
start=calldate
end=callend
callerid=clid
src=src
dst=dst
dcontext=dcontext
channel=channel
dstchannel=dstchannel
lastapp=lastapp
lastdata=lastdata
duration=duration
billsec=billsec
disposition=disposition
amaflags=amaflags
accountcode=accountcode
userfield=userfield
uniqueid=uniqueid
CodeTier=CodeTier



you know what file I forgot to configure?
Olivier












2013/6/3 Ron Wheeler 

>  Fix this.
>
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database user found, using 'asterisk' as default.
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database password found, using 'asterisk' as default.
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database host found, using localhost via socket.
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database name found, using 'asterisk' as default.
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database port found, using 3306 as default.
> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
> database socket found (and unable to detect a suitable path).
>
> Asterisk is telling you that you have not configured ANY database.
>
> It is not worrying about what tables are in it because you have not even
> defined the database itself.
> There is NO database at all so worrying about versions is not Asterisk's
> big problem..
>
> The rest of the messages after that are a bit screwy because the routines
> producing the error are not aware that there is no database at all so they
> just complain about the piece that they know about.
>
>
> Ron
>
>
>
> On 03/06/2013 12:19 PM, Olivier CALVANO wrote:
>
> No other idea ?
>
>
>
>
> 2013/6/3 Olivier CALVANO 
>
>>Hi
>>
>>  i have installed a new Asterisk server on Fedora. My first server use
>> Asterisk 1.6.x with a MySQL CDR and
>> realtime.
>>
>>  I have a small problems, when i configure on the new server, the same
>> information in MySQL, we have a error:
>>
>> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
>> to connect database server SSI on myhost.myserver.com (err 2003). Check
>> debug for more info.
>> [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
>> found in database.  This table should exist if you're using realtime.
>> [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
>> database SSI on myhost.myserver.com.
>> [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
>> database SSI on myhost.myserver.com.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database user found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database password found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database host found, using localhost via socket.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database name found, using 'asterisk' as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database port found, using 3306 as default.
>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>> database socket found (and unable to detect a suitable path).
>>
>>  The exacly same config work on 1.6.x
>>
>> and from the new server, the database access is Ok:
>>
>> [root@voip-2 log]# !mys
>> mysql -h myhost.myserver.com -u Asterisk -p SSI
>> Enter password:
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 5185
>> Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)
>>
>> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql> select * from VoiceMail;
>>
>> +-

Re: [asterisk-users] RHEL6 packages - SRTP support?

[Jason Parker]

On 06/03/2013 12:03 PM, Daniel Pocock wrote:

I tried building manually from the source RPM

Before running rpmbuild, I installed libsrtp-devel and I notice that
res_srtp.so is generated during the build

However, the rpmbuild fails for other reasons (see the other email I
sent to the list about mISDNutils-devel and other spec file errors)

Can you confirm the exact procedure you recommend for rpmbuild on a
CentOS6 system

rpmbuild --rebuild --without tds --without misdn somepackage.src.rpm

--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Bakko]

Hello,

are you sure MySQL socket is in /tmp directory?

dbsock = /tmp/mysql.sock

Regards

El 03/06/2013 12:16, Olivier CALVANO escribió:

Thanks for your help Ron,

Do you know where is the confirguration ?

Because i have put into res_config_mysql.conf:

[general]
dbhost = myhost.mydomain.net 
dbname = MyDB
dbuser = MyUser
dbpass = MyPassword
dbport = 3306
dbsock = /tmp/mysql.sock
dbcharset = latin1
requirements = warn


after in extconfig.conf:
sipusers => mysql,general,Comptes_SIP
sippeers => mysql,general,Comptes_SIP
iaxusers => mysql,general,Comptes_IAX
iaxpeers => mysql,general,Comptes_IAX
extensions => mysql,general,Extensions
meetme => mysql,general,MeetMe
musiconhold => mysql,general,Musiconhold
voicemail => mysql,general,VoiceMail

and in cdr_mysql.conf

[global]
hostname=myhost.mydomain.net 
dbname=MyDB
table=Cdr
password=MyPassword
user=MyUser
port=3306
sock=/tmp/mysql.sock

[aliases]
start=calldate
end=callend
callerid=clid
src=src
dst=dst
dcontext=dcontext
channel=channel
dstchannel=dstchannel
lastapp=lastapp
lastdata=lastdata
duration=duration
billsec=billsec
disposition=disposition
amaflags=amaflags
accountcode=accountcode
userfield=userfield
uniqueid=uniqueid
CodeTier=CodeTier



you know what file I forgot to configure?
Olivier












2013/6/3 Ron Wheeler >


Fix this.

[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database user found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database password found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database host found, using localhost via socket.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database name found, using 'asterisk' as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database port found, using 3306 as default.
[Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database socket found (and unable to detect a
suitable path).

Asterisk is telling you that you have not configured ANY database.

It is not worrying about what tables are in it because you have
not even defined the database itself.
There is NO database at all so worrying about versions is not
Asterisk's big problem..

The rest of the messages after that are a bit screwy because the
routines producing the error are not aware that there is no
database at all so they just complain about the piece that they
know about.


Ron



On 03/06/2013 12:19 PM, Olivier CALVANO wrote:

No other idea ?




2013/6/3 Olivier CALVANO mailto:o.calv...@gmail.com>>

Hi

i have installed a new Asterisk server on Fedora. My first
server use Asterisk 1.6.x with a MySQL CDR and
realtime.

I have a small problems, when i configure on the new server,
the same information in MySQL, we have a error:

[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL
RealTime: Failed to connect database server SSI on
myhost.myserver.com  (err 2003).
Check debug for more info.
[Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table
VoiceMail not found in database.  This table should exist if
you're using realtime.
[Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect
to mysql database SSI on myhost.myserver.com
.
[Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect
to mysql database SSI on myhost.myserver.com
.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database user found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database password found, using 'asterisk' as
default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database host found, using localhost via socket.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database name found, using 'asterisk' as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database port found, using 3306 as default.
[Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL
RealTime: No database socket found (and unable to detect a
suitable path).

The exacly same config work on 1.6.x

and from the new server, the database access is Ok:

[root@voip-2 log]# !mys
mysql -h myhost.myserver.com  -u
Asterisk -p SSI
Enter password:
Reading table information for completion of tabl

Re: [asterisk-users] DAHDI 2.6 and OPENVOX cards

[Russ Meyerriecks]

On Mon, Jun 03, 2013 at 07:46:42PM +0300, Mordechay Kaganer wrote:
> # lspci -n
> 04:01.0 0780: d161:0410 (rev 02)
> 
> #lspci
> 04:01.0 Communication controller: Digium, Inc. Wildcard TE410P/TE412P
> quad-span T1/E1/J1 card 3.3V (rev 02)

Strange that another manufacturer is using Digium's pci vendor and device
ids. This is not a bug in DAHDI. If this card ever worked with DAHDI, it's
only by coincidence. You'll probably need to contact your manufacturer for
support.

-- 
Russ Meyerriecks
Digium, Inc. | Linux Kernel Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
direct: +1 256-428-6025
Check us out at: www.digium.com & www.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] Confbridge doesn't kick chan_local

[Chris Gentle]

On Mon, Jun 3, 2013 at 11:52 AM, Matthew Jordan  wrote:
> (1) Verify that with all 'normal' channel drivers, such as chan_sip,
> that the Conference tears down correctly.

OK, looks like this is the problem.  Taking chan_local out of the
picture, I tested it with an incoming SIP call and an incoming IAX
call and sure enough, the tear down fails.  So if I rely on
end_marked=yes to kick all my conference participants when the leader
exits, it fails like this:

 << Hangup on console >>
--  Playing 'confbridge-leave.slin' (language 'en')
-- Stopped music on hold on SIP/gent_2880-0002
--  Playing 'custom/thank-you.ulaw' (language 'en')
-- Executing [1000@conferences:2] Hangup("SIP/gent_2880-0002",
"") in new stack
== Spawn extension (conferences, 1000, 2) exited non-zero on
'SIP/gent_2880-0002'

confbridge list shows this:

Conference Bridge Name   Users  Marked Locked?
 == == 
1000  0  0 unlocked

Now my confbridge is in a bad state.

I tested it on both 11.4.0 and 11.3.0 on two different boxes with the
same results.

> If both (1) and (2) are successful, than there's some impact that the
> Ices application is having on the Local channel that is messing up the
> reference counting inside the ConfBridge. Otherwise, it's an error in
> ConfBridge.

So what do you think?  Should I file a bug?

--
Chris

--
_
-- 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] DAHDI 2.6 and OPENVOX cards

[Emiliano Vazquez]

Openvox have anothers modules to compile dahdi.

You need compile with the latest openvox-dahdi [1] or diff this with the 
latest dahdi from digium.



Best regards.

[1] http://downloads.openvox.cn/pub/drivers/dahdi-linux-complete/



--
Emiliano Vazquez | PcCentro Informatica & CCTV
Office: +54 (11) 4635-3218 y Rotativas
Movil: 011-15-6253-7165
Mail: emilianovazq...@gmail.com
Web: http://www.pccentro.com.ar


--
_
-- 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] MeetMe exit status?

[Patrick Lists]

On 06/03/2013 06:47 PM, Matthew Jordan wrote:

On 06/02/2013 08:36 PM, Patrick Lists wrote:

Hi,

Does MeetMe in Asterisk 11.4 set some kind of exit status or a var so I
know for example if a conf ended normally or if someone gave a wrong
conf number or pin?

Thanks,
Patrick



There is no channel variable that provides that level of granularity.
The closest available is the MEETMESECS channel variable, which tells
you how many seconds the participant was in the conference.

You can find a full list on the Asterisk wiki:

https://wiki.asterisk.org/wiki/display/AST/MeetMe+Channel+Variables


Thanks Matt. I'll see if I can use MEETMESECS.

Regards,
Patrick




--
_
-- 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] Confbridge doesn't kick chan_local

[Matthew Jordan]

On 06/03/2013 01:03 PM, Chris Gentle wrote:
> On Mon, Jun 3, 2013 at 11:52 AM, Matthew Jordan  wrote:



>> If both (1) and (2) are successful, than there's some impact that the
>> Ices application is having on the Local channel that is messing up the
>> reference counting inside the ConfBridge. Otherwise, it's an error in
>> ConfBridge.
> 
> So what do you think?  Should I file a bug?
> 

Please do - https://issues.asterisk.org/jira

Please link this conversation on the issue as well, so the bug marshals
can reference it when the issue is triaged.

http://lists.digium.com/pipermail/asterisk-users/2013-June/279231.html

Thanks!

Matt

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

on this server we don't have mysql.socket because he don't have mysql server

we want access to a mysql based on a other server




2013/6/3 Bakko 

>  Hello,
>
> are you sure MySQL socket is in /tmp directory?
>
> dbsock = /tmp/mysql.sock
>
> Regards
>
> El 03/06/2013 12:16, Olivier CALVANO escribió:
>
>   Thanks for your help Ron,
>
> Do you know where is the confirguration ?
>
>  Because i have put into res_config_mysql.conf:
>
> [general]
> dbhost = myhost.mydomain.net
> dbname = MyDB
> dbuser = MyUser
> dbpass = MyPassword
> dbport = 3306
> dbsock = /tmp/mysql.sock
> dbcharset = latin1
> requirements = warn
>
>
>  after in extconfig.conf:
> sipusers => mysql,general,Comptes_SIP
> sippeers => mysql,general,Comptes_SIP
> iaxusers => mysql,general,Comptes_IAX
> iaxpeers => mysql,general,Comptes_IAX
> extensions => mysql,general,Extensions
> meetme => mysql,general,MeetMe
> musiconhold => mysql,general,Musiconhold
> voicemail => mysql,general,VoiceMail
>
>  and in cdr_mysql.conf
>
> [global]
> hostname=myhost.mydomain.net
> dbname=MyDB
> table=Cdr
> password=MyPassword
> user=MyUser
> port=3306
> sock=/tmp/mysql.sock
>
> [aliases]
> start=calldate
> end=callend
> callerid=clid
> src=src
> dst=dst
> dcontext=dcontext
> channel=channel
> dstchannel=dstchannel
> lastapp=lastapp
> lastdata=lastdata
> duration=duration
> billsec=billsec
> disposition=disposition
> amaflags=amaflags
> accountcode=accountcode
> userfield=userfield
> uniqueid=uniqueid
> CodeTier=CodeTier
>
>
>
> you know what file I forgot to configure?
>  Olivier
>
>
>
>
>
>
>
>
>
>
>
>
> 2013/6/3 Ron Wheeler 
>
>>  Fix this.
>>
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database user found, using 'asterisk' as default.
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database password found, using 'asterisk' as default.
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database host found, using localhost via socket.
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database name found, using 'asterisk' as default.
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database port found, using 3306 as default.
>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>> database socket found (and unable to detect a suitable path).
>>
>> Asterisk is telling you that you have not configured ANY database.
>>
>> It is not worrying about what tables are in it because you have not even
>> defined the database itself.
>> There is NO database at all so worrying about versions is not Asterisk's
>> big problem..
>>
>> The rest of the messages after that are a bit screwy because the routines
>> producing the error are not aware that there is no database at all so they
>> just complain about the piece that they know about.
>>
>>
>> Ron
>>
>>
>>
>> On 03/06/2013 12:19 PM, Olivier CALVANO wrote:
>>
>>  No other idea ?
>>
>>
>>
>>
>> 2013/6/3 Olivier CALVANO 
>>
>>>Hi
>>>
>>>  i have installed a new Asterisk server on Fedora. My first server use
>>> Asterisk 1.6.x with a MySQL CDR and
>>> realtime.
>>>
>>>  I have a small problems, when i configure on the new server, the same
>>> information in MySQL, we have a error:
>>>
>>> [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed
>>> to connect database server SSI on myhost.myserver.com (err 2003). Check
>>> debug for more info.
>>> [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
>>> found in database.  This table should exist if you're using realtime.
>>> [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
>>> database SSI on myhost.myserver.com.
>>> [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
>>> database SSI on myhost.myserver.com.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database user found, using 'asterisk' as default.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database password found, using 'asterisk' as default.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database host found, using localhost via socket.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database name found, using 'asterisk' as default.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database port found, using 3306 as default.
>>> [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
>>> database socket found (and unable to detect a suitable path).
>>>
>>>  The exacly same config work on 1.6.x
>>>
>>> and from the new server, the database access is Ok:
>>>
>>> [root@voip-2 log]# !mys
>>> mysql -h myhost.myserver.com -u Asterisk -p SSI
>>> Enter password:
>>> Reading table information for completion of table and column names
>>> You can turn off this feature to get a quicker startup with -A
>>>
>>> Welcome to t

Re: [asterisk-users] DAHDI 2.6 and OPENVOX cards

[Mordechay Kaganer]

B.H.

On Mon, Jun 3, 2013 at 9:15 PM, Emiliano Vazquez
wrote:

> Openvox have anothers modules to compile dahdi.
>
> You need compile with the latest openvox-dahdi [1] or diff this with the
> latest dahdi from digium.
>

Thanks! The patched version worked 100%. Don't ask me why they use Digium's
ids :)


>
>
> Best regards.
>
> [1] 
> http://downloads.openvox.cn/**pub/drivers/dahdi-linux-**complete/
>
>
>
> --
> Emiliano Vazquez | PcCentro Informatica & CCTV
> Office: +54 (11) 4635-3218 y Rotativas
> Movil: 011-15-6253-7165
> Mail: emilianovazq...@gmail.com
> Web: http://www.pccentro.com.ar
>
>
>
> --
> __**__**_
> -- 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
>



-- 
משיח NOW!
Moshiach is coming very soon, prepare yourself!
יחי אדוננו מורינו ורבינו מלך המשיח לעולם ועד!
--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Asghar Mohammad]

asterisk trying connect to mysql via socket remove that line from config
files.
1 check if port 3306 is open in iptables on both servers.
2 check permissions on db for user Asterisk.


On Mon, Jun 3, 2013 at 9:18 PM, Olivier CALVANO  wrote:

> on this server we don't have mysql.socket because he don't have mysql
> server
>
> we want access to a mysql based on a other server
>
>
>
>
> 2013/6/3 Bakko 
>
>>  Hello,
>>
>> are you sure MySQL socket is in /tmp directory?
>>
>> dbsock = /tmp/mysql.sock
>>
>> Regards
>>
>> El 03/06/2013 12:16, Olivier CALVANO escribió:
>>
>>   Thanks for your help Ron,
>>
>> Do you know where is the confirguration ?
>>
>>  Because i have put into res_config_mysql.conf:
>>
>> [general]
>> dbhost = myhost.mydomain.net
>> dbname = MyDB
>> dbuser = MyUser
>> dbpass = MyPassword
>> dbport = 3306
>> dbsock = /tmp/mysql.sock
>> dbcharset = latin1
>> requirements = warn
>>
>>
>>  after in extconfig.conf:
>> sipusers => mysql,general,Comptes_SIP
>> sippeers => mysql,general,Comptes_SIP
>> iaxusers => mysql,general,Comptes_IAX
>> iaxpeers => mysql,general,Comptes_IAX
>> extensions => mysql,general,Extensions
>> meetme => mysql,general,MeetMe
>> musiconhold => mysql,general,Musiconhold
>> voicemail => mysql,general,VoiceMail
>>
>>  and in cdr_mysql.conf
>>
>> [global]
>> hostname=myhost.mydomain.net
>> dbname=MyDB
>> table=Cdr
>> password=MyPassword
>> user=MyUser
>> port=3306
>> sock=/tmp/mysql.sock
>>
>> [aliases]
>> start=calldate
>> end=callend
>> callerid=clid
>> src=src
>> dst=dst
>> dcontext=dcontext
>> channel=channel
>> dstchannel=dstchannel
>> lastapp=lastapp
>> lastdata=lastdata
>> duration=duration
>> billsec=billsec
>> disposition=disposition
>> amaflags=amaflags
>> accountcode=accountcode
>> userfield=userfield
>> uniqueid=uniqueid
>> CodeTier=CodeTier
>>
>>
>>
>> you know what file I forgot to configure?
>>  Olivier
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> 2013/6/3 Ron Wheeler 
>>
>>>  Fix this.
>>>
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database user found, using 'asterisk' as default.
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database password found, using 'asterisk' as default.
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database host found, using localhost via socket.
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database name found, using 'asterisk' as default.
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database port found, using 3306 as default.
>>> [Jun  3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
>>> database socket found (and unable to detect a suitable path).
>>>
>>> Asterisk is telling you that you have not configured ANY database.
>>>
>>> It is not worrying about what tables are in it because you have not even
>>> defined the database itself.
>>> There is NO database at all so worrying about versions is not Asterisk's
>>> big problem..
>>>
>>> The rest of the messages after that are a bit screwy because the
>>> routines producing the error are not aware that there is no database at all
>>> so they just complain about the piece that they know about.
>>>
>>>
>>> Ron
>>>
>>>
>>>
>>> On 03/06/2013 12:19 PM, Olivier CALVANO wrote:
>>>
>>>  No other idea ?
>>>
>>>
>>>
>>>
>>> 2013/6/3 Olivier CALVANO 
>>>
Hi

  i have installed a new Asterisk server on Fedora. My first server use
 Asterisk 1.6.x with a MySQL CDR and
 realtime.

  I have a small problems, when i configure on the new server, the same
 information in MySQL, we have a error:

 [Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime:
 Failed to connect database server SSI on myhost.myserver.com (err
 2003). Check debug for more info.
 [Jun  3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not
 found in database.  This table should exist if you're using realtime.
 [Jun  3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
 database SSI on myhost.myserver.com.
 [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
 database SSI on myhost.myserver.com.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database user found, using 'asterisk' as default.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database password found, using 'asterisk' as default.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database host found, using localhost via socket.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database name found, using 'asterisk' as default.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database port found, using 3306 as default.
 [Jun  3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
 database socket fo

Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x

[Ron Wheeler]

Do you have this problem in your conf file?

http://forums.digium.com/viewtopic.php?p=63736

"The parser won't accept an ; (semicolon) for remarks! So he found at 
the first the old remarks and tried to access my database with the false 
data."





Ron

On 03/06/2013 3:18 PM, Olivier CALVANO wrote:
on this server we don't have mysql.socket because he don't have mysql 
server


we want access to a mysql based on a other server




2013/6/3 Bakko mailto:asannu...@gmail.com>>

Hello,

are you sure MySQL socket is in /tmp directory?

dbsock = /tmp/mysql.sock

Regards

El 03/06/2013 12:16, Olivier CALVANO escribió:

Thanks for your help Ron,

Do you know where is the confirguration ?

Because i have put into res_config_mysql.conf:

[general]
dbhost = myhost.mydomain.net 
dbname = MyDB
dbuser = MyUser
dbpass = MyPassword
dbport = 3306
dbsock = /tmp/mysql.sock
dbcharset = latin1
requirements = warn



--
Ron Wheeler
President
Artifact Software Inc
email:rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

--
_
-- 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 T.38 Pass-Through doesn't work

[Andrey Polovov]

On 06/03/2013 05:03 PM, Larry Moore wrote:
Have you checked the installed version of firmware against the latest 
available from Cisco?
Oh! I didn't guess to check. The firmware was not fresh, but upgrading 
doesn't help.
Looking at your SIP information when your ITSP initiated a T.38 
session it did not indicate a maxmimum bitrate, it would appear your 
spa112 attempted to negotiate a connection at 2400bps.

Whether there is a way to force my provider to indicate maximum bitrate?
Do you have a sip debug session when you sent a fax from your Asterisk 
box to the PSTN, it would be interesting to see if it sends it as a 
t.38 or reverts to G711 audio.
I have collect a set of debugs (with fresh SPA112 firmware) and actual 
config files:


== spa112 — cmd ReceiveFax
https://gist.github.com/anonymous/5701032

== cmd SendFax — PSTN
https://gist.github.com/anonymous/5701150

== spa112 — PSTN
https://gist.github.com/anonymous/5701207

== sip.conf
https://gist.github.com/anonymous/5701231

== udptl.conf
https://gist.github.com/anonymous/5701247

--
_
-- 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] RHEL6 packages - SRTP support? [patch]

[Daniel Pocock]

On 03/06/13 19:18, Jason Parker wrote:
> 
> 
> On 06/03/2013 12:03 PM, Daniel Pocock wrote:
>> I tried building manually from the source RPM
>>
>> Before running rpmbuild, I installed libsrtp-devel and I notice that
>> res_srtp.so is generated during the build
>>
>> However, the rpmbuild fails for other reasons (see the other email I
>> sent to the list about mISDNutils-devel and other spec file errors)
>>
>> Can you confirm the exact procedure you recommend for rpmbuild on a
>> CentOS6 system
> rpmbuild --rebuild --without tds --without misdn somepackage.src.rpm
> 

Now trying it on a fresh VM (CentOS 6 + EPEL6, freshly built)

I have these errors during installation of build dependencies:


  Installing : kmod-dahdi-linux-fwload-vpmadt032-2.6.2-1_centos6.2.6.32
  20/73
WARNING:
/lib/modules/2.6.32-358.6.2.el6.x86_64/weak-updates/dahdi-linux-fwload-vpmadt032/dahdi_vpmadt032_loader.ko
needs unknown symbol vpmadtreg_unregister
WARNING:
/lib/modules/2.6.32-358.6.2.el6.x86_64/weak-updates/dahdi-linux-fwload-vpmadt032/dahdi_vpmadt032_loader.ko
needs unknown symbol vpmadtreg_register
WARNING:
/lib/modules/2.6.32-358.el6.x86_64/weak-updates/dahdi-linux-fwload-vpmadt032/dahdi_vpmadt032_loader.ko
needs unknown symbol vpmadtreg_unregister
WARNING:
/lib/modules/2.6.32-358.el6.x86_64/weak-updates/dahdi-linux-fwload-vpmadt032/dahdi_vpmadt032_loader.ko
needs unknown symbol vpmadtreg_register



and then rpmbuild fails with:

checking for gcc... no
checking for cc... no
configure: error: in `/root/rpmbuild/BUILD/asterisk-11.4.0':
configure: error: no acceptable C compiler found in $PATH
See `config.log' for more details
error: Bad exit status from /var/tmp/rpm-tmp.isB97h (%build)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.isB97h (%build)



so I think to be added to the build dependencies in the spec file.


Then there is a more cryptic failure:

checking how to run the C++ preprocessor... /lib/cpp
configure: error: in `/root/rpmbuild/BUILD/asterisk-11.4.0':
configure: error: C++ preprocessor "/lib/cpp" fails sanity check
See `config.log' for more details
error: Bad exit status from /var/tmp/rpm-tmp.q7wr5n (%build)



config.log reveals that g++ is missing.  The build dependency is gcc-c++
-  I install that and it fails due to missing make

Later, there is another failure due to missing subversion.

Altogether, these are the missing lines for the spec file:

BuildRequires: gcc
BuildRequires: gcc-c++
BuildRequires: make
BuildRequires: subversion


although I would recommend not having a build dependency on SVN or
network access, some people like to build on secured machines without
network access.


Eventually, I end up with the same failure I had before:


RPM build errors:
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/cdr_adaptive_odbc.so
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/cdr_odbc.so
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/cel_odbc.so
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/func_odbc.so
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/res_config_odbc.so
File not found:
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64/usr/lib64/asterisk/modules/res_odbc.so



Now I've tried:


rpmbuild --rebuild \
--without tds \
--without misdn \
--without odbc \
asterisk-11.4.0-1_centos6.src.rpm

and on the rebuild, I get

gzip: ./usr/share/man/man8/autosupport.8 already exists; do you wish to
overwrite (y or n)?
gzip: ./usr/share/man/man8/astgenkey.8 already exists; do you wish to
overwrite (y or n)?

which suggests that `make clean' didn't really clean up after the last
attempt

Finally, I get:

Checking for unpackaged file(s): /usr/lib/rpm/check-files
/root/rpmbuild/BUILDROOT/asterisk-11.4.0-1_centos6.x86_64
error: Installed (but unpackaged) file(s) found:
   /usr/lib64/asterisk/modules/func_speex.so
   /usr/lib64/asterisk/modules/res_srtp.so


RPM build errors:
Installed (but unpackaged) file(s) found:
   /usr/lib64/asterisk/modules/func_speex.so
   /usr/lib64/asterisk/modules/res_srtp.so


so I added those two items to the spec file and finally I have a build.

I attach a diff for fixing the spec file, it fixes all these issues
except the `make clean'

Regards,

Daniel

--- SPECS/asterisk.spec.orig	2013-06-03 22:52:12.302227936 +0200
+++ SPECS/asterisk.spec	2013-06-03 23:02:33.899224528 +0200
@@ -70,6 +70,10 @@
 Requires: %{name}-doc = %{actversion}
 Requires: %{name}-voicemail = %{actversion}-%{release}
 Requires: asterisk-sounds-core-en-gsm
+BuildRequires: gcc
+BuildRequires: gcc-c++
+BuildRequires: make
+BuildRequires: subversion
 BuildRequires: sqlite-devel
 BuildRequires: ncurses-devel
 BuildRequires: libxml2-devel
@@ -616,7 +620,7 @@
 
 make %{makeflags} 2> err
 

Re: [asterisk-users] Fiber or regular DSL Supported Gateways/PRI

[Nick Khamis]

Anyone?

--
_
-- 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 11 + repro WebRTC tested

[Daniel Pocock]

I've just done a test with a WebRTC client connecting to the repro proxy
with the SIP messages relayed over TCP to Asterisk

Asterisk successfully answers the call using SAVPF, SRTP and ICE.

The client is greeted by the demo

This was tested in the Asterisk 11 environment described in my earlier
email about SRTP build issues on the asterisk-users list.

This is quite useful because it proves that Asterisk doesn't have to be
exposed as the HTTP WebSocket server: all the WebSocket handshake and
message parsing is done by the proxy.

Specific versions tested:
- Asterisk 11.4 built from SRPM on CentOS 6 + EPEL6
- repro 1.9.0~alpha0 package from Debian experimental
- JsSIP `tryit' client
- Google Chrome

Just some more notes about problems encountered with the Asterisk SRPM:
it doesn't seem to know anything about /usr/share/asterisk/sounds - even
though I install both the gsm and ulaw sounds RPMs, it always gives
errors such as
file.c:701 ast_openstream_full: File demo-congrats does not exist in any
format

I manually edited extensions.conf to include the full absolute paths and
then it works, e.g:

BackGround(/usr/share/asterisk/sounds/demo-congrats)


--
_
-- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

oh ron thanks for your help :

We have deleted all commented line, only put the configuration and now
that's work !




2013/6/3 Ron Wheeler 

>  Do you have this problem in your conf file?
>
> http://forums.digium.com/viewtopic.php?p=63736
>
> "The parser won't accept an ; (semicolon) for remarks! So he found at the
> first the old remarks and tried to access my database with the false data."
>
>
>
>
> Ron
>
>
> On 03/06/2013 3:18 PM, Olivier CALVANO wrote:
>
>  on this server we don't have mysql.socket because he don't have mysql
> server
>
>  we want access to a mysql based on a other server
>
>
>
>
>  2013/6/3 Bakko 
>
>>  Hello,
>>
>> are you sure MySQL socket is in /tmp directory?
>>
>> dbsock = /tmp/mysql.sock
>>
>> Regards
>>
>> El 03/06/2013 12:16, Olivier CALVANO escribió:
>>
>>   Thanks for your help Ron,
>>
>> Do you know where is the confirguration ?
>>
>>  Because i have put into res_config_mysql.conf:
>>
>> [general]
>> dbhost = myhost.mydomain.net
>> dbname = MyDB
>> dbuser = MyUser
>> dbpass = MyPassword
>> dbport = 3306
>> dbsock = /tmp/mysql.sock
>> dbcharset = latin1
>> requirements = warn
>>
>>
> --
> Ron Wheeler
> President
> Artifact Software Inc
> email: rwhee...@artifact-software.com
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>
> --
> _
> -- 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] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

grrr no in asterisk -d i have no error, but when i start normaly asterisk i
have :

[Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to
connect database server xxx on xxx.xxx.net (err 2003). Check debug for more
info.
[Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to
connect database server xxx on xxx.xxx.net (err 2003). Check debug for more
info.


what is the command in asterisk for i see the SQL query ?




2013/6/4 Olivier CALVANO 

> oh ron thanks for your help :
>
> We have deleted all commented line, only put the configuration and now
> that's work !
>
>
>
>
> 2013/6/3 Ron Wheeler 
>
>>  Do you have this problem in your conf file?
>>
>> http://forums.digium.com/viewtopic.php?p=63736
>>
>> "The parser won't accept an ; (semicolon) for remarks! So he found at
>> the first the old remarks and tried to access my database with the false
>> data."
>>
>>
>>
>>
>> Ron
>>
>>
>> On 03/06/2013 3:18 PM, Olivier CALVANO wrote:
>>
>>  on this server we don't have mysql.socket because he don't have mysql
>> server
>>
>>  we want access to a mysql based on a other server
>>
>>
>>
>>
>>  2013/6/3 Bakko 
>>
>>>  Hello,
>>>
>>> are you sure MySQL socket is in /tmp directory?
>>>
>>> dbsock = /tmp/mysql.sock
>>>
>>> Regards
>>>
>>> El 03/06/2013 12:16, Olivier CALVANO escribió:
>>>
>>>   Thanks for your help Ron,
>>>
>>> Do you know where is the confirguration ?
>>>
>>>  Because i have put into res_config_mysql.conf:
>>>
>>> [general]
>>> dbhost = myhost.mydomain.net
>>> dbname = MyDB
>>> dbuser = MyUser
>>> dbpass = MyPassword
>>> dbport = 3306
>>> dbsock = /tmp/mysql.sock
>>> dbcharset = latin1
>>> requirements = warn
>>>
>>>
>> --
>> Ron Wheeler
>> President
>> Artifact Software Inc
>> email: rwhee...@artifact-software.com
>> skype: ronaldmwheeler
>> phone: 866-970-2435, ext 102
>>
>>
>> --
>> _
>> -- 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] Difference MySQL between 1.6.x and 11.4.x

[Ron Wheeler]

Well, at least you are making progress.
What is the error in the debug log?

Ron


On 03/06/2013 8:03 PM, Olivier CALVANO wrote:
grrr no in asterisk -d i have no error, but when i start normaly 
asterisk i have :


[Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: 
Failed to connect database server xxx on xxx.xxx.net 
 (err 2003). Check debug for more info.
[Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: 
Failed to connect database server xxx on xxx.xxx.net 
 (err 2003). Check debug for more info.



what is the command in asterisk for i see the SQL query ?




2013/6/4 Olivier CALVANO >


oh ron thanks for your help :

We have deleted all commented line, only put the configuration and
now that's work !




2013/6/3 Ron Wheeler mailto:rwhee...@artifact-software.com>>

Do you have this problem in your conf file?

http://forums.digium.com/viewtopic.php?p=63736

"The parser won't accept an ; (semicolon) for remarks! So he
found at the first the old remarks and tried to access my
database with the false data."




Ron


On 03/06/2013 3:18 PM, Olivier CALVANO wrote:

on this server we don't have mysql.socket because he don't
have mysql server

we want access to a mysql based on a other server




2013/6/3 Bakko mailto:asannu...@gmail.com>>

Hello,

are you sure MySQL socket is in /tmp directory?

dbsock = /tmp/mysql.sock

Regards

El 03/06/2013 12:16, Olivier CALVANO escribió:

Thanks for your help Ron,

Do you know where is the confirguration ?

Because i have put into res_config_mysql.conf:

[general]
dbhost = myhost.mydomain.net 
dbname = MyDB
dbuser = MyUser
dbpass = MyPassword
dbport = 3306
dbsock = /tmp/mysql.sock
dbcharset = latin1
requirements = warn



-- 
Ron Wheeler

President
Artifact Software Inc
email:rwhee...@artifact-software.com  

skype: ronaldmwheeler
phone:866-970-2435, ext 102  


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






--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

--
_
-- 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] Minimum requirement for Asterisk IVR

[luke devon]

Hi Justin , 

Thank you so much for the help . I will start to do relevant configuration.

Regards
Luke.



 From: Justin Killen 
To: luke devon ; Asterisk Users Mailing List - 
Non-Commercial Discussion  
Sent: Tuesday, 4 June 2013, 0:06
Subject: RE: [asterisk-users] Minimum requirement for Asterisk IVR
 


 
1)  I’m sure it’s
possible, it’s just a matter of talking to the mobile network in question
and finding out what kind of options they have available.
 
2/3) Once asterisk gets the call, it can
redirect it to just about any endpoint you’d like it to.  For more
information on asterisk’s IVR capabilities, I suggest starting here: 
http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/asterisk-IVR.html
 
What modules you’ll need will vary
depending on how asterisk is connected to the PTSN and to the external IVR
application.
 
‘Do we need to install complete
Asterisk’?  I guess this depends on your definition of ‘complete’.
 My advice to you as a start/test would be to install asterisk and all the
sample configurations and then start playing around with connections.
 
-Justin 


 
From:asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of luke devon
Sent: Saturday, June 01, 2013 7:59
AM
To: Astericks
Subject: [asterisk-users] Minimum
requirement for Asterisk IVR
 
Hi 
 
1. When a mobile
user dial an IVR short code , mobile network able to divert that call to
Asterisk platform. 
 
2. There would
be web servers which are holds Voice XML .
 
3. Asterisk
would be able to redirect the mobile request to certain Voice XML server
accordingly.
 
Just for like
this setup , how do we install asterisk with minimum of asterisk modules ?
 
Do we need to
install complete Asterisk just for the IVR functionality ?
 
Thanks in
advance
Luke--
_
-- 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] G.729 codec in pass-thru mode

[Kamlesh Kumar]

Matthew,
 
SIP.conf
[100]
username=100
secret=password
type=friend
host=dynamic
nat=yes
canreinvite=no
insecure=port
disallow=all
allow=ulaw
allow=alaw
allow=g729
context=asterisk
qualify=no
 
dialplan
[asterisk]
exten => _X.,1,AGI(call.php)
exten => h,1,AGI(hangup.php)
 
SIP Trace:
201.xxx.xxx.xxx = SIP Softphone which originates the call
xxx.xxx.xxx.xxx = Asterisk server
yyy.yyy.yyy.yyy = ITSP
 
<--- SIP read from UDP:201.xxx.xxx.xxx:5060 --->
INVITE sip:12127773...@xxx.xxx.xxx.xxx SIP/2.0
To: 
From: 100;tag=7c0c4b22
Via: SIP/2.0/UDP 
201.xxx.xxx.xxx:5060;branch=z9hG4bK-d87543-181300058-1--d87543-;rport
Call-ID: 6601fe453f41d566
CSeq: 1 INVITE
Contact: 
Max-Forwards: 70
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, 
INFO
Content-Type: application/sdp
User-Agent: eyeBeam release 3007n stamp 17816
Content-Length: 228
 v=0
o=- 7847157 7847631 IN IP4 201.xxx.xxx.xxx
s=eyeBeam
c=IN IP4 201.xxx.xxx.xxx
t=0 0
m=audio 8614 RTP/AVP 0 101
a=alt:1 1 : 05A48429 007F 201.xxx.xxx.xxx 8614
a=fmtp:101 0-15
a=rtpmap:101 telephone-event/8000
a=sendrecv
<->
[Jun  3 13:11:27] --- (12 headers 10 lines) ---
[Jun  3 13:11:27]   == Using SIP RTP CoS mark 5
[Jun  3 13:11:27] Sending to 201.xxx.xxx.xxx : 5060 (no NAT)
[Jun  3 13:11:27] Using INVITE request as basis request - 6601fe453f41d566
[Jun  3 13:11:27] Found peer '100' for '100' from 201.xxx.xxx.xxx:5060
[Jun  3 13:11:27] 
<--- Reliably Transmitting (NAT) to 201.xxx.xxx.xxx:5060 --->
SIP/2.0 401 Unauthorized
Via: SIP/2.0/UDP 
201.xxx.xxx.xxx:5060;branch=z9hG4bK-d87543-181300058-1--d87543-;received=201.xxx.xxx.xxx;rport=5060
From: 100;tag=7c0c4b22
To: ;tag=as1999a2fb
Call-ID: 6601fe453f41d566
CSeq: 1 INVITE
Server: PBX
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO
Supported: replaces, timer
WWW-Authenticate: Digest algorithm=MD5, realm="asterisk", nonce="0c9deee3"
Content-Length: 0
 <>
[Jun  3 13:11:27] Scheduling destruction of SIP dialog '6601fe453f41d566' in 
32000 ms (Method: INVITE)
[Jun  3 13:11:27] 
<--- SIP read from UDP:201.xxx.xxx.xxx:5060 --->
INVITE sip:12127773...@xxx.xxx.xxx.xxx SIP/2.0
To: 
From: 100;tag=7c0c4b22
Via: SIP/2.0/UDP 
201.xxx.xxx.xxx:5060;branch=z9hG4bK-d87543-254704504-1--d87543-;rport
Call-ID: 6601fe453f41d566
CSeq: 2 INVITE
Contact: 
Max-Forwards: 70
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, 
INFO
Content-Type: application/sdp
User-Agent: eyeBeam release 3007n stamp 17816
Authorization: Digest 
username="100",realm="asterisk",nonce="0c9deee3",uri="sip:12127773...@xxx.xxx.xxx.xxx",response="e84d9090cfc8e60f94768583218ae0ad",algorithm=MD5
Content-Length: 228
v=0
o=- 7847157 7847631 IN IP4 201.xxx.xxx.xxx
s=eyeBeam
c=IN IP4 201.xxx.xxx.xxx
t=0 0
m=audio 8614 RTP/AVP 0 101
a=alt:1 1 : 05A48429 007F 201.xxx.xxx.xxx 8614
a=fmtp:101 0-15
a=rtpmap:101 telephone-event/8000
a=sendrecv
<->
 [Jun  3 13:11:27] --- (13 headers 10 lines) ---
 [Jun  3 13:11:27] Sending to 201.xxx.xxx.xxx : 5060 (NAT)
 [Jun  3 13:11:27] Using INVITE request as basis request - 6601fe453f41d566
 [Jun  3 13:11:27] Found peer '100' for '100' from 201.xxx.xxx.xxx:5060
 [Jun  3 13:11:27] Found RTP audio format 0
 [Jun  3 13:11:27] Found RTP audio format 101
 [Jun  3 13:11:27] Found audio description format telephone-event for ID 101
 [Jun  3 13:11:27] Capabilities: us - 0x10c (ulaw|alaw|g729), peer - audio=0x4 
(ulaw)/video=0x0 (nothing)/text=0x0 (nothing), combined - 0x4 (ulaw)
 [Jun  3 13:11:27] Non-codec capabilities (dtmf): us - 0x1 (telephone-event), 
peer - 0x1 (telephone-event), combined - 0x1 (telephone-event)
 [Jun  3 13:11:27] Peer audio RTP is at port 201.xxx.xxx.xxx:8614
 [Jun  3 13:11:27] Looking for 12127773456 in asterisk (domain xxx.xxx.xxx.xxx)
 [Jun  3 13:11:27] list_route: hop: 
[Jun  3 13:11:27] 
<--- Transmitting (NAT) to 201.xxx.xxx.xxx:5060 --->
SIP/2.0 100 Trying
Via: SIP/2.0/UDP 
201.xxx.xxx.xxx:5060;branch=z9hG4bK-d87543-254704504-1--d87543-;received=201.xxx.xxx.xxx;rport=5060
From: 100;tag=7c0c4b22
To: 
Call-ID: 6601fe453f41d566
CSeq: 2 INVITE
Server: PBX
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO
Supported: replaces, timer
Contact: 
Content-Length: 0
<>
[Jun  3 13:11:27] -- Executing [12127773456@asterisk:1] 
AGI("SIP/100-34d8", "call.php") in new stack
[Jun  3 13:11:27] -- Launched AGI Script /var/lib/asterisk/agi-bin/call.php
[Jun  3 13:11:28] -- AGI Script Executing Application: (Dial) Options: 
(SIP/yyy.yyy.yyy.yyy/12127773456)
[Jun  3 13:11:28]   == Using SIP RTP CoS mark 5
[Jun  3 13:11:28] Audio is at xxx.xxx.xxx.xxx port 56248
[Jun  3 13:11:28] Adding codec 0x4 (ulaw) to SDP
[Jun  3 13:11:28] Adding non-codec 0x1 (telephone-event) to SDP
[Jun  3 13:11:28] Reliably Transmitting (NAT) to yyy.yyy.yyy.yyy:5060:
INVITE sip:12127773...@yyy.yyy.yyy.yyy SIP/2.0
Via: SIP/2.0/UDP xxx.xxx.xxx.xxx:5060;branch=z9hG4bK15380659;rport
Max-Forwards: 70
From: "100" ;tag=as6

Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x

[Olivier CALVANO]

What is the best commande for put the debug ? because with core set debug,
i don't have a return.


voip-2*CLI> realtime mysql status
Vop configured for m...@myhost.mydomain.net, port 3306 with username
Asterisk.
[Jun  4 06:48:25] ERROR[27879]: res_config_mysql.c:1577 mysql_reconnect:
MySQL RealTime: Failed to connect database server Vop on
vop.phibee-telecom.net (err 2003). Check debug for more info.

He read correctly the config because it's the good DB, Server and username


in /var/log/asterisk/message i have:

[Jun  4 06:46:21] Asterisk 11.4.0 built by mockbuild @
buildvm-12.phx2.fedoraproject.org on a x86_64 running Linux on 2013-05-20
15:47:05 UTC
[Jun  4 06:46:21] NOTICE[27825] loader.c: 1 modules will be loaded.
[Jun  4 06:46:21] NOTICE[27825] config.c: Registered Config Engine mysql
[Jun  4 06:46:21] NOTICE[27825] cdr.c: CDR simple logging enabled.
[Jun  4 06:46:21] NOTICE[27825] loader.c: 192 modules will be loaded.
[Jun  4 06:46:21] NOTICE[27825] res_smdi.c: No SMDI interfaces are
available to listen on, not starting SMDI listener.
[Jun  4 06:46:21] WARNING[27825] res_musiconhold.c: No music on hold
classes configured, disabling music on hold.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net(err 2003). Check
debug for more info.
[Jun  4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_IAX not
found in database.  This table should exist if you're using realtime.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net(err 2003). Check
debug for more info.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net(err 2003). Check
debug for more info.
[Jun  4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_SIP not
found in database.  This table should exist if you're using realtime.
[Jun  4 06:46:21] NOTICE[27825] confbridge/conf_config_parser.c: Adding
default_user profile to app_confbridge
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: Starting AEL load process.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: parsed config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: checked config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: compiled
config file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: merged config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: verified
config file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:22] ERROR[27825] cdr_mysql.c: Failed to connect to mysql
database MyDB on MyHost.MyDomain.net .
[Jun  4 06:47:51] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net(err 2003). Check
debug for more info.
[Jun  4 06:48:25] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net(err 2003). Check
debug for more info.

Asterisk have the good information, but i don't understand why he can't
connect to the DB, if i use:
mysql -h MyHost.MyDomain.net  -u Aserisk -p
MyDB
i have a full access to my MySQL server.

may be missing in a Fedora package ?


2013/6/4 Ron Wheeler 

>  Well, at least you are making progress.
> What is the error in the debug log?
>
> Ron
>
>
>
> On 03/06/2013 8:03 PM, Olivier CALVANO wrote:
>
>  grrr no in asterisk -d i have no error, but when i start normaly
> asterisk i have :
>
> [Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server xxx on xxx.xxx.net (err 2003). Check debug for
> more info.
> [Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server xxx on xxx.xxx.net (err 2003). Check debug for
> more info.
>
>
>  what is the command in asterisk for i see the SQL query ?
>
>
>
>
> 2013/6/4 Olivier CALVANO 
>
>>  oh ron thanks for your help :
>>
>>  We have deleted all commented line, only put the configuration and now
>> that's work !
>>
>>
>>
>>
>>  2013/6/3 Ron Wheeler 
>>
>>>   Do you have this problem in your conf file?
>>>
>>> http://forums.digium.com/viewtopic.php?p=63736
>>>
>>> "The parser won't accept an ; (semicolon) for remarks! So he found at
>>> the first the old remarks and tried to access my database with the false
>>> data."
>>>
>>>
>>>
>>>
>>> Ron
>>>
>>>
>>> On 03/06/2013 3:18 PM, Olivier CALVANO wrote:
>>>
>>>  on this server we don't have mysql.socket because he don't have mysql
>>> server
>>>
>>>  we want access to a mysql based on a other server
>>>
>>>
>>>
>>>
>>>  20