[asterisk-users] Asterisk realtime MySQL clients from same IP problem

[Patrick Maartense]

Not really, I have all these files, I just mentioned the fields that are filled by my queries ( nex time I will post the complete create statements )

But I think (HOPE) I found the problem

I only had SIPPEERS defined in the config
NOT sipusers

Now I have not seen these problems anymore (at least for now)


Tnx anyway..
Reg
PM

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Philipp Kempgen
Sent: Montag, 08. September 2008 17:22
To: Asterisk Users
Subject: Re: [asterisk-users] Asterisk realtime MySQL clients from same IP problem

Patrick Maartense schrieb:
> Off course the columns all are fine ( right case)

Ok.

> There seems to be an irregularity between the sip peers table and the Sip registry.

> But any idea on the backgrounds of this behaviour??

The SQL query tries to update the ipaddr, port and regseconds fields
which your table is lacking. Thus the query fails.

I'm not sure if that's the cause of your problem but there's no
point in spending time on trying to figure out why something
doesn't work if the setup is wrong in the first place.  :-)

   Philipp Kempgen

-- 
http://www.das-asterisk-buch.de  -  http://www.the-asterisk-book.com
Amooma GmbH - Bachstr. 126 - 56566 Neuwied  ->  http://www.amooma.de
Geschäftsführer: Stefan Wintermeyer, Handelsregister: Neuwied B14998
-- 

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2008 - September 22 - 25 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.169 / Virus Database: 270.6.18/1658 - Release Date: 07.09.2008 15:30