Patrick Maartense
2008-Sep-08 13:51 UTC
[asterisk-users] Asterisk realtime MySQL clients from same IP problem
Following setup : 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 Now as soon as one is registered AND active a Client coming from the same Ipadress can not register anymore The log is like this: Sep 8 15:33:41] VERBOSE[3448] logger.c: -- Registered SIP '902410000001' at 127.0.0.1 port 5100 expires 3600 [Sep 8 15:33:41] DEBUG[3399] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM sippeers WHERE name = '902410000001' New one comes online [Sep 8 15:37:44] VERBOSE[3448] logger.c: -- Registered SIP '925430000036' at 127.0.0.1 port 5102 expires 3600 [Sep 8 15:37:44] DEBUG[3448] res_config_mysql.c: MySQL RealTime: Everything is fine. [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' Now call start to same extension as Nr I is calling Third one comes [Sep 8 15:41:13] DEBUG[3448] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM sippeers WHERE name = '913500000001' [Sep 8 15:41:13] DEBUG[3448] db.c: Unable to find key '913500000001' in family 'SIP/Registry' [Sep 8 15:41:13] DEBUG[3448] db.c: Unable to find key '913500000001' in family 'SIP/Registry' [Sep 8 15:41:14] VERBOSE[3448] logger.c: -- Registered SIP '913500000001' at 127.0.0.1 port 5103 expires 3600 [Sep 8 15:41:14] DEBUG[3448] res_config_mysql.c: MySQL RealTime: Everything is fine. [Sep 8 15:41:14] DEBUG[3448] res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sippeers SET ipaddr = '127.0.0.1', port = '5103', regseconds = '1220884874', username = '913500000001' WHERE name = '913500000001' NOW it starts. One channel hangs up. Then tries to get back Sep 8 15:43:35] WARNING[3448] chan_sip.c: username mismatch, have <913500000001>, digest has <925430000036> [Sep 8 15:43:35] NOTICE[3448] chan_sip.c: Failed to authenticate user "925430000036" <sip:925430000036 at talkserver>;tag=z9hG4bK63215952 Anyone has an idea what to do here ? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080908/fa7913c9/attachment-0001.htm
Philipp Kempgen
2008-Sep-08 14:28 UTC
[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 NameUse 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 --
Patrick Maartense
2008-Sep-08 14:46 UTC
[asterisk-users] Asterisk realtime MySQL clients from same IP problem
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 NameUse 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
Patrick Maartense
2008-Sep-08 20:37 UTC
[asterisk-users] Asterisk realtime MySQL clients from same IP problem
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