Re: PostgresSQL DLR support
Alexander Malysh wrote: > hmm, that was my first attempt to get things right ;) > Oracle's OCI is just complex and I've introduced 'select/update' within > dbpool. IMO, we should abstract more, so that dbpool deal with DBConnection > and DBConnection object should implement 'select/update'. +1 on a full dbpool abstraction layer. There are projects that try to do this. Martin, if you can have a view into those?! Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
Re: Questions
zohar wrote: > > Hi, > I tried getting some answers on the users' list, but nobody answered. I hope > I have better luck here: > 1. Is it possible to limit the listening endpoint in kannel to specific > interfaces, instead of them listening on all IPs? yes, you can define in the conf file to which interface you want to bind. Please see the user's guide for more details. > 2. Is it possible to control the URLs accessible via the WAP Gateway? yes, you can have a mapping that restricts simply those that are not mapped. Which means the WAP GW will allow access to those URLs that are not mapped, and those that are mapped (via asterics) can be mapped to those that are allowed anyway. Another option here is off course IP based FW rules to disallow everything except the hosts/URLs that are about to be allowed. Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
RE: PostgresSQL DLR support
About the psotgres patch: In configure.in linking is done against -llibpg which should be (for me) -lpg. Alexander: I saw your start of select/update abstraction. The one in which select takes a **List parameter. Are we talking about the same thing now? Implementing this won't be too hard and I can take that job upon me, as I am doing sqlbox now as well (mysql, postgres, mssql) which would also benefit from it. But.: How about different SQL syntax of different SQL server implementation? As an example: mysql: select * from table limit 0,1; ms-msql: select top 1 * from table; Also create table and field-types are kind of different. Regards, Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stipe Tolj Sent: dinsdag 3 februari 2004 14:51 Cc: [EMAIL PROTECTED] Subject: Re: PostgresSQL DLR support Alexander Malysh wrote: > hmm, that was my first attempt to get things right ;) > Oracle's OCI is just complex and I've introduced 'select/update' within > dbpool. IMO, we should abstract more, so that dbpool deal with DBConnection > and DBConnection object should implement 'select/update'. +1 on a full dbpool abstraction layer. There are projects that try to do this. Martin, if you can have a view into those?! Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
Re: PostgresSQL DLR support
On Tuesday 03 February 2004 15:32, Rene Kluwen wrote: > About the psotgres patch: > > In configure.in linking is done against -llibpg which should be (for > me) -lpg. FYI: linking is always done with -lpg (w/o lib prefix). > > Alexander: I saw your start of select/update abstraction. The one in which > select takes a **List parameter. Are we talking about the same thing now? yep... but I'm too busy to make further changes. You can look into dbpool_oracle.c as example (it's not a ideal solution but works ;)). Other ideas on how todo it are highly welcome ;) > Implementing this won't be too hard and I can take that job upon me, as I > am doing sqlbox now as well (mysql, postgres, mssql) which would also > benefit from it. > > But.: How about different SQL syntax of different SQL server > implementation? > As an example: mysql: select * from table limit 0,1; ms-msql: select top 1 > * from table; > > Also create table and field-types are kind of different. yes, and it's not easy solvable problem :( We can try todo something I did for libsdb dlr support? > > Regards, > > Rene Kluwen > Chimit > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Stipe Tolj > Sent: dinsdag 3 februari 2004 14:51 > Cc: [EMAIL PROTECTED] > Subject: Re: PostgresSQL DLR support > > Alexander Malysh wrote: > > hmm, that was my first attempt to get things right ;) > > Oracle's OCI is just complex and I've introduced 'select/update' within > > dbpool. IMO, we should abstract more, so that dbpool deal with > > DBConnection > > > and DBConnection object should implement 'select/update'. > > +1 on a full dbpool abstraction layer. There are projects that try to > do this. Martin, if you can have a view into those?! > > Stipe > > mailto:[EMAIL PROTECTED] > --- > Wapme Systems AG > > Münsterstr. 248 > 40470 Düsseldorf, NRW, Germany > > phone: +49.211.74845.0 > fax: +49.211.74845.299 > > mailto:[EMAIL PROTECTED] > http://www.wapme-systems.de/ > --- > > -BEGIN PGP PUBLIC KEY BLOCK- > Version: GnuPG v1.2.2 (Cygwin) > > mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS > OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 > nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT > dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv > bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID > AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl > OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ > K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H > g2HyLAEKQIp30Q== > =aYCI > -END PGP PUBLIC KEY BLOCK- -- Best regards / Mit besten Grüßen aus Düsseldorf Dipl.-Ing. Alexander Malysh ___ Centrium GmbH Vogelsanger Weg 80 40470 Düsseldorf Fon: +49 (0211) 74 84 51 80 Fax: +49 (0211) 277 49 109 email: [EMAIL PROTECTED] web: www.centrium.de msn: [EMAIL PROTECTED] icq: 98063111 ___ Please avoid sending me Word, Excel or PowerPoint attachments. See http://www.fsf.org/philosophy/no-word-attachments.html
[CFP] Kannel WAP 2.0 roadmap IRC meeting
Hi list, as we actually didn't have a meeting last friday. (unfortunatly personally I couldn't make it). We are re-scheduling to this friday: Fri, 6th Feb, 02:30pm (CET) freenode.net IRC #kannel Topics are as mentioned in the subject. Fixing TODOs and roadmapping to WAP 2.0 compliance of Kannel. See you (virtually) friday. Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
RE: Things I learned about MMS clients (so far)
The final mystery is solved. My MMS client works with Vodafone D2 in Germany. It turned out, that the WAP gateway did not know about the binary encoding for "application/vnd.wap.mms-message". I'm now able to send MMS messages with all four German network operators. Thanks to everybody who helped me on and off the list! Kind regards Jörg -Ursprüngliche Nachricht- Von: Jörg Pommnitz Gesendet: Freitag, 30. Januar 2004 17:38 An: Kannel-Devel (E-Mail) Betreff: Things I learned about MMS clients (so far) Some obstacles I overcame and that are not readily obvious from the standards: 1. The Vodafone MMS WAP gateway dislikes fragmented IP packets. They obviously get dropped somewhere. Conclusion: make sure your SAR segment size is smaller then the GPRS SDU size. 1000 Bytes works for me. 2. The E-Plus MMSC is picky. It does not accept anything but application/vnd.wap.multipart.mixed or .related as MMS payload. 3. The E-Plus MMS WAP gateway is very picky. If you send a POST request that exceeds the default 1400 Byte SDU size, it will reject it. You have to announce larger SDUs with the WSP Server-SDU-Size capability field. Hope this helps others. Kind regards Jörg
Re: [PATCH] daemon/parachute & co for all boxes
At 07:21 PM 2004/01/20, Alexander Malysh wrote: as no objections were there, commited to cvs. thanks - works purfectly in my test environment nisan On Thursday 15 January 2004 14:56, Alexander Malysh wrote: > Hi List, > > attached you can find a patch that adds some usefull command line > parameters for all boxes. > 1) -P/--parachute : start watcher father process that catch and restart > crashed child process > 2) -X/--panic-script : execute this script if child process crashed > 3) -u/--user : change process user-id (security) > 4) -p/--pid-file : write PID into the given file > 5) -d/--daemonize : daemonize the process > > Comments and votes please! -- Best regards / Mit besten Grüßen aus Düsseldorf Dipl.-Ing. Alexander Malysh ___ Centrium GmbH Vogelsanger Weg 80 40470 Düsseldorf Fon: +49 (0211) 74 84 51 80 Fax: +49 (0211) 277 49 109 email: [EMAIL PROTECTED] web: www.centrium.de msn: [EMAIL PROTECTED] icq: 98063111 ___ Please avoid sending me Word, Excel or PowerPoint attachments. See http://www.fsf.org/philosophy/no-word-attachments.html
Re: [PATCH-RFC] adding pids to logging
At 01:12 PM 2004/01/28, Stipe Tolj wrote: patch _has_ been commited to cvs. Please update and check. Looks good - works in test environ. Nisan Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
Re: [PATCH] octstr performance
At 06:18 PM 2004/01/20, Stipe Tolj wrote: +1, commited to cvs. excellent - this works like a charm - have linked it into another gwlib app and have similar speed improvements.. ta nisan Stipe mailto:[EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf, NRW, Germany phone: +49.211.74845.0 fax: +49.211.74845.299 mailto:[EMAIL PROTECTED] http://www.wapme-systems.de/ --- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.2.2 (Cygwin) mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H g2HyLAEKQIp30Q== =aYCI -END PGP PUBLIC KEY BLOCK-
RE: PostgresSQL DLR support
I know linking is done w/o lib prefix. But it was an error in the Postgres patch. This was not particularly directed to anybody special except the ones who want to use that patch. About generic SQL support like dbpool_oracle.c: That was exactly what I was talking about. I dont like the select syntax solution like in libsdb dlr support so much. Like for instance some DB's not only use other names to call an animal. But also put those names in different places (compare: 'select ... limit X' with 'select top X '). The adodb style PHP abstraction layer that is really popular has seperate .select and .select_limit methods *shrugs*... A different method for every different kind of statement is also not ideal. But it is better than a different method for every db system. Just my 2 cts. Rene Kluwen Chimit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alexander Malysh Sent: dinsdag 3 februari 2004 15:52 To: Rene Kluwen; Stipe Tolj Cc: [EMAIL PROTECTED] Subject: Re: PostgresSQL DLR support On Tuesday 03 February 2004 15:32, Rene Kluwen wrote: > About the psotgres patch: > > In configure.in linking is done against -llibpg which should be (for > me) -lpg. FYI: linking is always done with -lpg (w/o lib prefix). > > Alexander: I saw your start of select/update abstraction. The one in which > select takes a **List parameter. Are we talking about the same thing now? yep... but I'm too busy to make further changes. You can look into dbpool_oracle.c as example (it's not a ideal solution but works ;)). Other ideas on how todo it are highly welcome ;) > Implementing this won't be too hard and I can take that job upon me, as I > am doing sqlbox now as well (mysql, postgres, mssql) which would also > benefit from it. > > But.: How about different SQL syntax of different SQL server > implementation? > As an example: mysql: select * from table limit 0,1; ms-msql: select top 1 > * from table; > > Also create table and field-types are kind of different. yes, and it's not easy solvable problem :( We can try todo something I did for libsdb dlr support? > > Regards, > > Rene Kluwen > Chimit > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Stipe Tolj > Sent: dinsdag 3 februari 2004 14:51 > Cc: [EMAIL PROTECTED] > Subject: Re: PostgresSQL DLR support > > Alexander Malysh wrote: > > hmm, that was my first attempt to get things right ;) > > Oracle's OCI is just complex and I've introduced 'select/update' within > > dbpool. IMO, we should abstract more, so that dbpool deal with > > DBConnection > > > and DBConnection object should implement 'select/update'. > > +1 on a full dbpool abstraction layer. There are projects that try to > do this. Martin, if you can have a view into those?! > > Stipe > > mailto:[EMAIL PROTECTED] > --- > Wapme Systems AG > > Münsterstr. 248 > 40470 Düsseldorf, NRW, Germany > > phone: +49.211.74845.0 > fax: +49.211.74845.299 > > mailto:[EMAIL PROTECTED] > http://www.wapme-systems.de/ > --- > > -BEGIN PGP PUBLIC KEY BLOCK- > Version: GnuPG v1.2.2 (Cygwin) > > mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS > OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2 > nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT > dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv > bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID > AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl > OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ > K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H > g2HyLAEKQIp30Q== > =aYCI > -END PGP PUBLIC KEY BLOCK- -- Best regards / Mit besten Grüßen aus Düsseldorf Dipl.-Ing. Alexander Malysh ___ Centrium GmbH Vogelsanger Weg 80 40470 Düsseldorf Fon: +49 (0211) 74 84 51 80 Fax: +49 (0211) 277 49 109 email: [EMAIL PROTECTED] web: www.centrium.de msn: [EMAIL PROTECTED] icq: 98063111 ___ Please avoid sending me Word, Excel or PowerPoint attachments. See http://www.fsf.org/philosophy/no-word-attachments.html