On Wed, Mar 16, 2005 at 03:25:17PM +0800, Ronald Wiplinger wrote:
Mar 16 15:13:45 DEBUG[29502]: Raw Hangup 69.73.19.178:4569, src=14, dst=1259
Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Update SQL: UPDATE
sip_buddies SET name = '621' WHERE allow = 'g729'
Mar 16 15:13:45 DEBUG[29502]: MySQL
Martijn van Oosterhout wrote:
On Wed, Mar 16, 2005 at 03:25:17PM +0800, Ronald Wiplinger wrote:
Mar 16 15:13:45 DEBUG[29502]: Raw Hangup 69.73.19.178:4569, src=14, dst=1259
Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Update SQL: UPDATE
sip_buddies SET name = '621' WHERE allow = 'g729'
Mar 16
Ronald Wiplinger wrote:
vpbx*CLI realtime update sippeers allow g729 name 621
Failed to update. Check the debug log for possible SQL related
That is the wrong format of the command. Notice the incorrect SQL that
was queried? Type realtime update by itself to see an example.
That is a
Martijn van Oosterhout wrote:
On Wed, Mar 16, 2005 at 03:25:17PM +0800, Ronald Wiplinger wrote:
Mar 16 15:13:45 DEBUG[29502]: Raw Hangup 69.73.19.178:4569, src=14,
dst=1259 Mar 16 15:13:45 DEBUG[29502]: MySQL RealTime: Update SQL:
UPDATE sip_buddies SET name = '621' WHERE allow = 'g729'
Mar
Matthew Boehm wrote:
Ronald Wiplinger wrote:
[mysql1]
dsn = astconf
username = root
password = MyPassword
pre-connect = yes
You are not using the ODBC drivers. You can remove that [mysql1] stuff
from your res_mysql.conf
Removed, but still no codecs
br
*CLI Urgent handler
-- SIP Seeding peers from Astdb: '3044' at [EMAIL PROTECTED]:64718 for
120
Urgent handler
-- Registered SIP '3044' at 64.XX.XX.XX port 17524 expires 120
Codecs : 0x10c (ulaw|alaw|g729)
Codec Order : (g729|ulaw|alaw)
Using the following table:
CREATE TABLE
Matthew Boehm wrote:
*CLI Urgent handler
-- SIP Seeding peers from Astdb: '3044' at [EMAIL PROTECTED]:64718 for
120
Urgent handler
-- Registered SIP '3044' at 64.XX.XX.XX port 17524 expires 120
Codecs : 0x10c (ulaw|alaw|g729)
Codec Order : (g729|ulaw|alaw)
Using the following table:
I changed the sequence first disallow and than allow. After
restarting * it is working now!
I am sure I copied the table and did not change it, ... somewhere it
must have the wrong order.
Thanks for your patient with me!
Glad we got it working.
-Matthew
Hi,
On Wed, Mar 16, 2005 at 08:47:49AM -0600, Matthew Boehm wrote:
OK. I've been patient and kind up until now. Here comes the rudeness:
Martijn, shut up! This is now the 3rd time you have stated that Realtime is
not ready for production using baseless acquisations.
I'm terribly sorry, It was
Martijn van Oosterhout wrote:
However, I'm quite sure (and I grepped all my mail just to be sure)
but this is the only time I have ever mentioned realtime in any
email involving this list. Maybe you have me confused with somebody
I might have. I just remember someone else (could have been you
Ronald Wiplinger wrote:
Matthew Boehm wrote:
INSERT INTO sip_buddies VALUES
(1,'621',NULL,NULL,NULL,'\Demo\,621','yes','inhouse',NULL,'rfc2833',NULL
,N
ULL,'dynamic',NULL,NULL,NULL,NULL,'[EMAIL PROTECTED]',NULL,'yes',NULL,NULL,NULL,'1',
''
Is there anything I can do to track down the problem? e.g., is there a
command in *CLI to read the database record? push a record, see the
differences, ...
You can try this:
realtime update sippeers allow g729 name 621
That should be the SQL equivalent to UPDATE TABLE sippeers SET allow =
Matthew Boehm wrote:
Is there anything I can do to track down the problem? e.g., is there a
command in *CLI to read the database record? push a record, see the
differences, ...
You can try this:
realtime update sippeers allow g729 name 621
That should be the SQL equivalent to UPDATE TABLE
INSERT INTO sip_buddies VALUES
(1,'621',NULL,NULL,NULL,'\Demo\,621','yes','inhouse',NULL,'rfc2833',NULL
,N
ULL,'dynamic',NULL,NULL,NULL,NULL,'[EMAIL
PROTECTED]',NULL,'yes',NULL,NULL,NULL,'1',
''
,'999',NULL,NULL,NULL,'Password','friend','621','ulaw;alaw','all',NULL,0,'',
'y
Try using commas
Matthew Boehm wrote:
INSERT INTO sip_buddies VALUES
(1,'621',NULL,NULL,NULL,'\Demo\,621','yes','inhouse',NULL,'rfc2833',NULL
,N
ULL,'dynamic',NULL,NULL,NULL,NULL,'[EMAIL PROTECTED]',NULL,'yes',NULL,NULL,NULL,'1',
''
Matthew Boehm wrote:
You may not have most recent CVS. You should have this in your sip.conf:
You are right, ... but the sip.conf will not be updated anyway, if I do
not want to loose all my settings.
rtcachefriends=yes
; Cache realtime friends by adding them to the internal list
; just like
:42:07 +0800
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] Realtime does not work yet, ...
Matthew Boehm wrote:
You may not have most recent CVS. You should have this in your sip.conf:
You are right
Matthew Boehm wrote:
Are you sure that NAT is set correctly everywhere? I sometimes forget to set
the phone to be NAT aware.
That is weird that 'sip show peers/users' doesn't show the phone both times.
Have you stopped/started asterisk since these changes? Do it again just to
make sure.
The only
-To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Date: Mon, 14 Mar 2005 09:27:52 +0800
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] Realtime does not work yet, ...
Matthew
- Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] Realtime does not work yet, ...
Matthew Boehm wrote:
Are you sure that NAT is set correctly everywhere? I sometimes forget to set
the phone to be NAT aware.
That is weird that 'sip show peers/users' doesn't
Mark Matthew,
I know how frustrating it may be, ...
I can imagine your feelings, ...
HOWEVER, with all respect, it does not help me to fix my problem!
Can we come back to the subject, please?
I apologies for the missing words for me in the Subject!
I tried to follow (and may made some mistakes)
-To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Date: Sat, 12 Mar 2005 07:50:54 +0800
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] Realtime does not work yet, ...
Matthew
sipfriends = mysql,astconf,sip_buddies
Yes. Remove that line. This was done a few weeks ago to better split
peers/users.
sip show users and sip show peers does not show the phone, but
Go into sip.conf and enable the 3 RealTime cacheing variables. This will
make them show up in the
You may not have most recent CVS. You should have this in your sip.conf:
rtcachefriends=yes
; Cache realtime friends by adding them to the internal list
; just like friends added from the config file only on a
; as-needed basis.
rtnoupdate=yes
; do not send the update request over realtime.
I try to get Realtime to work, ... the debug looks like below.
Mar 12 00:56:56 DEBUG[25640]: MySQL RealTime: Retrieve SQL: SELECT *
FROM sip_buddies WHERE name = '621'
Mar 12 00:56:56 DEBUG[25640]: MySQL RealTime: Everything is fine.
Mar 12 00:56:56 DEBUG[25640]: Unable to find key '621' in
Matthew Boehm wrote:
Just because it doesn't work for you doesn't mean it doesn't work for
everyone else.
If I would believe that, I would not bother with it anymore ;-)
1. Do you have a record in your database for user 621?
I put the record into the database and I can see the record with
2. Run the query inside MySQL cli. How many rows where returned? If
none, then its your fault it failed.
How do I do that inside of CLI?
if you don't know what the MySQL CLI is then you need to stop using mysql.
I see that you are running phpmyadmin, did you run the query that debug
spits
Ronald Wiplinger wrote:
I try to get Realtime to work, ... the debug looks like below.
Mar 12 00:56:56 DEBUG[25640]: MySQL RealTime: Retrieve SQL: SELECT *
FROM sip_buddies WHERE name = '621'
Mar 12 00:56:56 DEBUG[25640]: MySQL RealTime: Everything is fine.
Mar 12 00:56:56 DEBUG[25640]: Unable to
On Mar 11, 2005, at 2:38 PM, Cirelle Internet Products wrote:
We bailed on it for now, as it does not appear to be 100%.
Phones would not re-register, calls would fail.(just a lot of
headaches)
I tried out realtime a few weeks ago but stopped using it because it
seg faulted whenever I issued a
It looks as tho the db addon is just that, patches to make it work
instead of rewriting the
thing from scratch with all storage in a database and not in conf
files.
You are wrong here. ARA is not an addon. ARA is core code that 'was'
written from scratch. The res_config_mysql is an addon
Here is a perfect example of a lack of user-developer communication. If
developers don't hear your problems then we can't fix them.
Did you post a bug report? Did you ask for support in -users? IRC? Aparently
not cause your problem could have been fixed.
Seems like a very Microsoft-like
Matthew Boehm wrote:
2. Run the query inside MySQL cli. How many rows where returned? If
none, then its your fault it failed.
How do I do that inside of CLI?
if you don't know what the MySQL CLI is then you need to stop using mysql.
Are you talking about host *CLI or host mysql ?
On Mar 11, 2005, at 4:00 PM, Matthew Boehm wrote:
Here is a perfect example of a lack of user-developer communication.
If
developers don't hear your problems then we can't fix them.
Did you post a bug report? Did you ask for support in -users? IRC?
Aparently
not cause your problem could have
33 matches
Mail list logo