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

[Patrick Maartense]

Off course the columns all are fine ( right case) ( to much german language makes one write words with uppercase almost every word :(

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

For the Client. Well you know, one that has the installed base, also set the standards. (try converting CRLF to CR only on yours :) )

But any idea on the backgrounds of this behaviour??




-----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 16:29
To: Asterisk Users
Subject: Re: [asterisk-users] Asterisk realtime MySQL clients from same IP problem

Patrick Maartense schrieb:

> Users are creeated in the sippers table with following Fields set
> 
> Name : xxxxxxxx .unique 
> 
> Host : dynamic
> 
> Nat : yes
> 
> Type: friend
> 
> Callerid: xxxxxxxx .unique value
> 
> Context: autocreate
> 
> Secret : xxxxxx
> 
> Disallow: all
> 
> Allow : all
> 
> Username : unique : same as Name

Use lowercase column names.

> [Sep  8 15:37:44] DEBUG[3448] res_config_mysql.c: MySQL RealTime: Update
> SQL: UPDATE sippeers SET ipaddr = '127.0.0.1', port = '5102', regseconds
> = '1220884664', username = '925430000036' WHERE name = '925430000036'

> Anyone has an idea what to do here ?

Where are the columns in following: ipaddr, port, regseconds?

Apart from that I'd appreciate if you could get a better email
client which does not insert so many useless blank lines. :-) SCNR.


   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