no lost MO sms so far, i work in both ways, according the service description
have to say web servers have their limitations, especially in case when the db connection drops and suddenly kannel starts to flood the web server with its endless retries ... when the web server reaches the connection limit, you can imagine its getting even worse my usual setup is a sqlbox with db pool of PostgreSQL started with option for 2000 concurrent connections, which is far beyond the usual smpp concurrent peak load .. :) but, its a box i use for live TV voting shows with HUGE MO peaks ... these days i use the postgresql just to write xml files , there is a kernel inotify feature to watch the xml repository for a file creation on file creation i just process the xml data in parallel so i keep the postgresql only for th usual sqlbox activity, and the processing of the MO data is damn fast .. anyway, my advice: use the technology familiar with. -----Original Message----- From: [email protected] [EMAIL PROTECTED] Sent: 14 Май 2008 г. To: seik Subject:Using sqlbox, can I disable sms-service? > Hi, > So you have an external daemon which check the send_sms table? How fast > is it compares to HTTP? Apache has ModPerl which double the speed I > guess. In 1 million MO do you experience MO lost? TIA > Regards, > Willy > On Wed, 2008-05-14 at 10:57 +0300, seikath wrote: >> well , >> >> 1. i have here rules on insert dealing with the immediate replay, creating >> xml or for implementing the MT billing >> its not possible for mysql >> >> 2. you have external daemon processing the MO according certain rules as >> shortcodes and regexp ... >> which is universal for any db >> >> 3. you may patch the sqlbox for your particular needs .. >> >> these approaches are for HIGH MO traffic ... in case you have like 100 - 500 >> K daily, >> the apache will handle without any issues for sure. >> >> >> -----Original Message----- >> From: [email protected] [EMAIL PROTECTED] >> Sent: 14 Май 2008 г. >> To: seikath >> Subject:Using sqlbox, can I disable sms-service? >> >> > Hi, >> > Just want to know. If we don't have post-url/get-url. Then how we parse >> > the MO? Is it faster to check it directly to MySQL or just send it to an >> > URL? Currently I combine the method. All MO are parsed via *-url. And >> > the result stored to the MySQl and let the SQLBox pick it. Any other >> > idea? What about the membox which is currently developed by Alejandro.G? >> >> > Regards, >> >> >> > Willy >> > On Tue, 2008-05-13 at 19:25 +0300, seik wrote: >> >> exactly >> >> >> >> >> >> -----Original Message----- >> >> From: [email protected] [EMAIL PROTECTED] >> >> Sent: 13 ??? 2008 ?. >> >> To: seik >> >> Subject:Using sqlbox, can I disable sms-service? >> >> >> >> > Hi Seik, >> >> >> >> > If I set the default one like this, I don't need the other service you >> >> > suggested, right? I think setting a default >> >> > service with an empty text would be sufficient. I didn't know about the >> >> > omit empty = true setting, I guess that should do the trick right? >> >> >> >> > So now I have this: >> >> >> >> > # Default sms service. >> >> > group = sms-service >> >> > keyword = plaseireallydonotwatntheapachetohandlethisMTmessageTrankYou >> >> > # get-url = http:// >> >> > text = "" >> >> > omit-empty = true >> >> > catch-all = true >> >> > max-messages = 0 >> >> >> >> > That should work, right? >> >> >> >> > Thanks for your help! I really appreciate it. >> >> >> >> > Kind regards, >> >> > Roland. >> >> >> >> > seik wrote: >> >> > some additional info: >> >> >> >> > and set the default one with empty response text, and set omit empty = >> >> > true .. >> >> >> >> > i believe you got the idea >> >> >> >> > -----Original Message----- >> >> > From: [email protected] [EMAIL PROTECTED] >> >> > Sent: 13 ??? 2008 ?. >> >> > To: seik >> >> > Subject:Using sqlbox, can I disable sms-service? >> >> >> >> > >> >> > Nobody with any ideas? >> >> > >> >> >> >> > >> >> > Rolandow wrote: >> >> > >> >> >> >> > >> >> > Hi Guys, >> >> > >> >> >> >> > >> >> > I am using kannel with the sqlbox, and I am directly processing my >> >> > messages from the mysql database. So I thought I'd >> >> > leave the default sms-service with an empty get-url. Unfortunately this >> >> > gives me an error: >> >> > >> >> >> >> > >> >> > 2008-05-09 10:12:50 [21023] [1] INFO: Starting to service <Yesenia> >> >> > from <4671020481> to <10551> >> >> > 2008-05-09 10:12:50 [21023] [6] ERROR: URL <> doesn't start with >> >> > `http://' nor `https://' >> >> > 2008-05-09 10:12:50 [21023] [6] ERROR: Couldn't send request to <> >> >> > 2008-05-09 10:12:50 [21023] [2] INFO: No reply sent, denied. >> >> > >> >> >> >> > >> >> > So my question is: how can I make the sms-service a "dummy" service, >> >> > which does nothing, and does not take any >> >> > resources. I could of course to a http://localhost or something, but I >> >> > think this is a waste. >> >> > >> >> >> >> > >> >> > I tried just leaving out the sms-service at all, but this gives me an >> >> > error too. >> >> > >> >> >> >> > >> >> > Any suggestions? >> >> > >> >> >> >> > >> >> > Kind regards, >> >> > Roland. >> >> > >> >> >> >> >> >> >> >> > >> >> >> >> >> >> >> >> >> >> >>
