Re: Odd DLR msg ID from operator
That is currently my plan. Waiting for a response from them hopefully today. I would be very surprised if it was only me that complained about this. Kyriacos On 21/02/2011 09:10, Nikos Balkanas wrote: I still think that your best bet would be to contact your provider. I have no experience dealing with them, but it seems to me that if he is a big SMPP one, then all of his clients will have the same problem. That means if the ticket is still active, the more reason for him to change. If not, he might know what his other clients have done about it. BR, Nikos - Original Message - From: Alan McNatty a...@catalyst.net.nz To: Kyriacos Sakkas kyria...@netsmart.com.cy Cc: users us...@vm1.kannel.org Sent: Monday, February 21, 2011 1:16 AM Subject: Re: Odd DLR msg ID from operator Hi Kyriacos, Taking this a step further as I was wondering if this was actually possible. Caveat: I'm thinking out loud in pgsql (more user than admin/guru) and not mysql .. An insert/update/delete trigger to strip out the prefix (eg 01//) wouldn't be a problem assuming you could identify the smsc id, etc (so can avoid impacting those that are behaving). The issue as I see is with the select when you finally get your DLR .. If the 04/ was consistent you would just add it as part of the insert trigger which would work fine. But I'm guessing the '04/' is just an example and is varying so you need would need a view (pref materialized) do strip it out so your select matches. But .. you can't insert / update, etc on a view (in postgres .. as far as I know) so as it stands with the existing kannel config I can't see a way of doing this if this is what you are seeing. However, it might be do-able with a combination of views, triggers, schemas (so you can have a table and a view of the same name but in different schema) and/or different read/write user (associated with different schema). But some code change to support schemas / users would be required in kannel. You would need to check out what mysql can do here .. might not be impossible .. for example, from what I can see online (no personal experience) Oracle seems to support an Instead Of trigger so you could use / handle inserts/etc on a view. Maybe someone with a bit more experience with DB wrangling might be able to help you further with mysql. As Alex notes I suspect a simpler solution might be to support a regexp on DLR details in kannel ;) Cheers, Alan On 18/02/11 22:35, Kyriacos Sakkas wrote: So yep if someone things that this can be done with pure MYSQL triggers or something like that, which does not need heavy kannel changes, please let me know. -- Kyriacos Sakkas Development Team Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email: kyria...@netsmart.com.cy http://www.netsmart.com.cy Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender at kyria...@netsmart.com.cy **
Kannel HTTP locking up
Hi I'm having a problem that looks like Kannel's SMS box HTTP listener is locking up. I've been running some load tests on Kannel, sending out 30K messages over a short space of time. I am running Kannel version 1.5.0 under Windows using Cygwin. I have no problem if it is running on my Windows 7 laptop, 32 bit 2.68G RAM, 2.53GHz. However, when it is running on one of our servers it locks up after about 24K messages. The server is Windows Server 2003 R2 Enterprise x64 Edition SP2, 2GHz with 8G RAM. The only difference between the two is the Kannel configuration file which points the log files to different places in the file system. Both instances of Kannel were compiled from the same source code on the target machines using the latest version of Cygwin. The server isn't under a heavy load. It is also running IIS. After Kannel locks up there are no further entries added to its log files and from what I've found the only solution is to stop and restart it. There doesn't appear to be anything additional logged from the server that isn't logged from my laptop. Has anyone else seen anything like this before? Any clues to what may be the cause or possible solutions would be greatly appreciated. I can post logs and config file if needed. Many thanks. -- Richard Crawshaw Software Developer
Re: Kannel HTTP locking up
Am 21.02.2011 13:58, schrieb Richard Crawshaw: Hi I’m having a problem that looks like Kannel’s SMS box HTTP listener is locking up. I’ve been running some load tests on Kannel, sending out 30K messages over a short space of time. I am running Kannel version 1.5.0 under Windows using Cygwin. I have no problem if it is running on my Windows 7 laptop, 32 bit 2.68G RAM, 2.53GHz. However, when it is running on one of our servers it locks up after about 24K messages. The server is Windows Server 2003 R2 Enterprise x64 Edition SP2, 2GHz with 8G RAM. The only difference between the two is the Kannel configuration file which points the log files to different places in the file system. Both instances of Kannel were compiled from the same source code on the target machines using the latest version of Cygwin. The server isn’t under a heavy load. It is also running IIS. After Kannel locks up there are no further entries added to its log files and from what I’ve found the only solution is to stop and restart it. There doesn’t appear to be anything additional logged from the server that isn’t logged from my laptop. Has anyone else seen anything like this before? Any clues to what may be the cause or possible solutions would be greatly appreciated. I can post logs and config file if needed. Cygin's pthreads, which Kannel uses heavily is NOT(!) stable. That's the simple reason. This is BTW also the reason why Cygwin never packaged the mysql server. So, there is NO way to use Kannel on Cygwin for real production use. Stipe -- --- Kölner Landstrasse 419 40589 Düsseldorf, NRW, Germany tolj.org system architecture Kannel Software Foundation (KSF) http://www.tolj.org/ http://www.kannel.org/ mailto:st_{at}_tolj.org mailto:stolj_{at}_kannel.org --- smime.p7s Description: S/MIME Cryptographic Signature
UNSUBSCRIBE
Regards, Srikanth J +1 781 472 9022 (Cell) -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Stipe Tolj Sent: Monday, February 21, 2011 8:47 AM Cc: users@kannel.org Subject: Re: Kannel HTTP locking up Am 21.02.2011 13:58, schrieb Richard Crawshaw: Hi I'm having a problem that looks like Kannel's SMS box HTTP listener is locking up. I've been running some load tests on Kannel, sending out 30K messages over a short space of time. I am running Kannel version 1.5.0 under Windows using Cygwin. I have no problem if it is running on my Windows 7 laptop, 32 bit 2.68G RAM, 2.53GHz. However, when it is running on one of our servers it locks up after about 24K messages. The server is Windows Server 2003 R2 Enterprise x64 Edition SP2, 2GHz with 8G RAM. The only difference between the two is the Kannel configuration file which points the log files to different places in the file system. Both instances of Kannel were compiled from the same source code on the target machines using the latest version of Cygwin. The server isn't under a heavy load. It is also running IIS. After Kannel locks up there are no further entries added to its log files and from what I've found the only solution is to stop and restart it. There doesn't appear to be anything additional logged from the server that isn't logged from my laptop. Has anyone else seen anything like this before? Any clues to what may be the cause or possible solutions would be greatly appreciated. I can post logs and config file if needed. Cygin's pthreads, which Kannel uses heavily is NOT(!) stable. That's the simple reason. This is BTW also the reason why Cygwin never packaged the mysql server. So, there is NO way to use Kannel on Cygwin for real production use. Stipe -- --- Kölner Landstrasse 419 40589 Düsseldorf, NRW, Germany tolj.org system architecture Kannel Software Foundation (KSF) http://www.tolj.org/ http://www.kannel.org/ mailto:st_{at}_tolj.org mailto:stolj_{at}_kannel.org --- SASKEN BUSINESS DISCLAIMER: This message may contain confidential, proprietary or legally privileged information. In case you are not the original intended Recipient of the message, you must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message and you are requested to delete it and inform the sender. Any views expressed in this message are those of the individual sender unless otherwise stated. Nothing contained in this message shall be construed as an offer or acceptance of any offer by Sasken Communication Technologies Limited (Sasken) unless sent with that express intent and with due authority of Sasken. Sasken has taken enough precautions to prevent the spread of viruses. However the company accepts no liability for any damage caused by any virus transmitted by this email. Read Disclaimer at http://www.sasken.com/extras/mail_disclaimer.html