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

[Philipp Kempgen]

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