[asterisk-users] Asterisk realtime MySQL clients from same IP problem
Following setup : Users are creeated in the sippers table with following Fields set Name : .unique Host : dynamic Nat : yes Type: friend Callerid: .unique value Context: autocreate Secret : xx 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 '90241001' 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 = '90241001' New one comes online [Sep 8 15:37:44] VERBOSE[3448] logger.c: -- Registered SIP '92543036' 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 = '92543036' WHERE name = '92543036' 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 = '91350001' [Sep 8 15:41:13] DEBUG[3448] db.c: Unable to find key '91350001' in family 'SIP/Registry' [Sep 8 15:41:13] DEBUG[3448] db.c: Unable to find key '91350001' in family 'SIP/Registry' [Sep 8 15:41:14] VERBOSE[3448] logger.c: -- Registered SIP '91350001' 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 = '91350001' WHERE name = '91350001' 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 91350001, digest has 92543036 [Sep 8 15:43:35] NOTICE[3448] chan_sip.c: Failed to authenticate user 92543036 sip:[EMAIL PROTECTED];tag=z9hG4bK63215952 Anyone has an idea what to do here ? ___ -- 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
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 : .unique Host : dynamic Nat : yes Type: friend Callerid: .unique value Context: autocreate Secret : xx 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 = '92543036' WHERE name = '92543036' 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
Re: [asterisk-users] Asterisk realtime MySQL clients from same IP problem
On Mon, Sep 08, 2008 at 04:28:52PM +0200, Philipp Kempgen wrote: Apart from that I'd appreciate if you could get a better email client which does not insert so many useless blank lines. :-) SCNR. Likely, for you, like me, it's not that his email client is indersting blank lines... it's that whatever you're using to render his HTML email into text is doing it -- for me, it's lynx under Mutt. He probably just needs to find the send HTML email knob and turn it off. *Break* it off, by preference, but what can you do. Cheers, -- jra -- Jay R. Ashworth Baylink [EMAIL PROTECTED] Designer The Things I Think RFC 2100 Ashworth Associates http://baylink.pitas.com '87 e24 St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274 Those who cast the vote decide nothing. Those who count the vote decide everything. -- (Josef Stalin) ___ -- 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
Re: [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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 : .unique Host : dynamic Nat : yes Type: friend Callerid: .unique value Context: autocreate Secret : xx 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 = '92543036' WHERE name = '92543036' 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 ___ -- 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
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
Re: [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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 ___ -- 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