DLR matches wrong message

2010-06-14 Thread Konstantin Vayner
Hi everyone, I'm using emi/ucp smsc under kannel 1.4.3. Here's smsc group configuration (sensitive information masked): group = smsc smsc = emi smsc-id = ucp_smsc log-file = /var/log/kannel/ucp_smsc.log log-level = 0 host = 1.2.3.4 port = 1234 smsc-username = 678 smsc-password = XYZPWZYX

Re: DLR matches wrong message

2010-06-14 Thread Nikos Balkanas
Hi, This is a well-known limitation of certain non-SMPP SMScs. DLR mechanism is common for all. SMPP SMScs provide unique ID/SMSc in ts, which never faulters. However, some of them do not provide a destination. Sometime ago a patch was submitted to include destination number in dlr

RE: DLR matches wrong message

2010-06-14 Thread Luís Tiago Rico
This is a known problem to Kannel. Kannel, using EMI connection, cannot guarantee DLR matching of messages sent at the same timestamp. Why? Because it does not compare the MSISDN! It only queries DLR ‘database’, with the timestamp (even that is not in milliseconds) and SMSC. I think

Re: [PATCH] RE: Messages with php stripslashes

2010-06-14 Thread Emmanuel CHANSON
Hello Rene, Trying to patch gw/sqlbox.c I got this error, is it an issue? [r...@kannel gw]# patch -p0 sqlbox.c sql-escape.patch patching file sqlbox.c patching file sqlbox.c Hunk #1 FAILED at 82. 1 out of 1 hunk FAILED -- saving rejects to file sqlbox.c.rej patching file sqlbox.c Reversed (or

Re: [PATCH] RE: Messages with php stripslashes

2010-06-14 Thread Tomasz
Hi, Try to use -R option with path or press y when Assume -R? [n] displays. Regards, Tomasz W Twoim liście datowanym 14 czerwca 2010 (11:46:40) można przeczytać: Hello Rene, Trying to patch gw/sqlbox.c I got this error, is it an issue? [r...@kannel gw]# patch -p0 sqlbox.c sql-escape.patch

Re: [PATCH] RE: Messages with php stripslashes

2010-06-14 Thread Emmanuel CHANSON
Using Assume -R equal to yes it seems the patch is not applied (I checked the sqlbox.c file after and no occurence of msg_escaped for instance). Alex where to downloaded the latest version of sqlbox? The one I got was from your website. BTW I try to apply the patch on the original source I have

Re: [PATCH] RE: Messages with php stripslashes

2010-06-14 Thread Emmanuel CHANSON
Ok I have tested with the sqlbox.c file patched as below, then tested using CGI interface and a SMS with a quote and it works ! Quote not escaped any more... Thanks to Rene, Alex, and others ... Regards, Emmanuel 2010/6/14 Emmanuel CHANSON emmanuelchan...@gmail.com I have tried to patch the

SQLbox and MySQL database charset

2010-06-14 Thread Emmanuel CHANSON
Hello, I would like to ask the community which mysql charset/collation to use ? I have created a mysql database for sqlbox by setting the collation to utf8_unicode_ci and the charset to utf8_general_ci but when inserting an entry in the database I got special character like this test: test é

Re: getting MO and MT data into a database

2010-06-14 Thread Scott Geller
Thanks Nikos This makes sense Maybe I'm under false assumptions... What I'm trying to capture is all the data into a database. I need a few fields: phone number, date/time, message content Is there a best pratice approach to getting this into a db? Sounds like dlr has limitations Thanks!

RE: SQLbox and MySQL database charset

2010-06-14 Thread Patrick MEYE
that is script issue,i do same case using php script with function iconv. Hope help you. B.R Date: Mon, 14 Jun 2010 22:39:07 +1100 Subject: SQLbox and MySQL database charset From: emmanuelchan...@gmail.com To: users@kannel.org Hello, I would like to ask the community which mysql

check SIM registration AT+CREG?

2010-06-14 Thread Matteo Sgala
Hi, I'm searching a way to keep monitored the registration SIM into GSM modems. I found the way to send the AT command AT+CREG? at every keepalive...I could monitor the log file and when I see an +CREG: 0,x (where x is 1 or 5) all is fine. If I see other value, i will catch an alert to my

Re: getting MO and MT data into a database

2010-06-14 Thread Iain Dooley
Hi Scott, Maybe I'm under false assumptions... What I'm trying to capture is all the data into a database. I need a few fields: phone number, date/time, message content MT messages are sent by you, using kannel. The solution here is simple: write the details to a database before you send

Re: check SIM registration AT+CREG?

2010-06-14 Thread Alvaro Cornejo
How do you see the response of the +CREG command? Do you manually parse the bb log? Regards |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y

Re: getting MO and MT data into a database

2010-06-14 Thread Scott Geller
Thanks Iain This put me in a different direction - I'll explore this later this week Hopefully I can figure it out from here Nikos - IMHO I see the future as providing sms analytic services (not just messaging functionality) so please let me know how I can help support the building of this