MySQL not storing

2010-05-23 Thread Barry Murphy
Hi, I've setup Kannel to use mysql for storage, see setup below. When I check the status page it shows no errors and that mysql is being used for DLR, select queries seem fine, but when sending a message from smsbox it doesnt appear to add an entry to DLR, see debug info below: CONFIG

Advice on sending other than sendsms

2010-05-23 Thread Barry Murphy
Hi, I'm using Kannel to act as a SMS gateway between my webserver and my upstream SMPP providers. Does Kannel have an option to run as a SMSC or is there an easy way to send messages other than smsbox. I'd prefer not to have my phpcode have to call 1000 http requests to my kannel smsbox to send

Re: Advice on sending other than sendsms

2010-05-23 Thread preeteesh kakkar
Google abt SqlBox On Sun, May 23, 2010 at 12:12 PM, Barry Murphy ba...@unix.co.nz wrote: Hi, I'm using Kannel to act as a SMS gateway between my webserver and my upstream SMPP providers. Does Kannel have an option to run as a SMSC or is there an easy way to send messages other than smsbox.

Re: Advice on sending other than sendsms

2010-05-23 Thread Barry Murphy
Can you explain more, google gives lots of results for Microsoft SQL server, nothing much to do with smpp On Sun, 23 May 2010 12:16:05 +0530, preeteesh kakkar preeteesh.kak...@gmail.com wrote: Google abt SqlBox On Sun, May 23, 2010 at 12:12 PM, Barry Murphy ba...@unix.co.nz wrote: Hi, I'm

sqlbox

2010-05-23 Thread Barry Murphy
Hi, Not sure if this is the right place to post, but hoping it is, if not please reply offlist direct to me. I've just setup SqlBOX and managed to have it connect to a localhost mysql server, however when I configure it to connect to a remote system it isn't working. My Kannel is using the same

Re: sqlbox

2010-05-23 Thread Alejandro Guerrieri
Your connection string must be wrong, or there's some issue preventing the sqlbox process to connect to the remote host. I'd check the firewall rules. Another explanation could be related to selinux if you're running on a RHEL/CentOS box and have it enabled. Anyhow, please post your sqlbox

Re: sqlbox

2010-05-23 Thread Barry Murphy
I'm running debian lenny on both sides, though the side with sqlbox is version 5, so I wonder if it's because of a different type of auth method or something... As I mention if I use CLI it works fine from the SQLBox to the Actual mysql server, but the other way around it doesnt. Kannel: group =

RE: sqlbox

2010-05-23 Thread Cezary Siwek
Hi, You must set the database port if you are connecting to an external database. Otherwise sqlbox always tries to connect using unix socket. BR Cezary -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Barry Murphy Sent: 23 May 2010 12:15

RE: sqlbox

2010-05-23 Thread Barry Murphy
Ok, So I tried adding :3306 to the IP Addres, still same error. I also tried changing the database name on the kannel dlr connection (which is same user/pass/database/host as the sqlbox) and got a database access denied, so I know the kannel one is connecting and doing sql selects just fine. It's

RE: sqlbox

2010-05-23 Thread Cezary Siwek
Try to set mysql port as another config value: port = 3306 -Original Message- From: Barry Murphy [mailto:ba...@unix.co.nz] Sent: 23 May 2010 12:40 To: Cezary Siwek Cc: Alejandro Guerrieri; Users Subject: RE: sqlbox Importance: Low Ok, So I tried adding :3306 to the IP Addres, still

RE: sqlbox

2010-05-23 Thread Barry Murphy
Thanks, that worked!!! Wonder why it wasnt in any other posts I looked at with people having the same issue , ohh well, thanks again :) Next up, any idea why DLR records arent appearing into the database? It's connecting but not inserting. :/ Thanks Barry On Sun, 23 May 2010 12:43:26 +0100,

RE: sqlbox

2010-05-23 Thread Cezary Siwek
I'm sure I have replied on this list to people having exactly the same issue... few times. Re DLRs: Play with the 'msg-id-type' value in your SMPP SMSC section. Cezary -Original Message- From: Barry Murphy [mailto:ba...@unix.co.nz] Sent: 23 May 2010 12:57 To: Cezary Siwek Cc:

Re: MySQL not storing

2010-05-23 Thread Jovan Kostovski
On Sun, May 23, 2010 at 8:33 AM, Barry Murphy ba...@unix.co.nz wrote: Hi, I've setup Kannel to use mysql for storage, see setup below. When I check the status page it shows no errors and that mysql is being used for DLR, select queries seem fine, but when sending a message from smsbox it

Re: MySQL not storing

2010-05-23 Thread Barry Murphy
Here is a complete copy of my kannel.conf, am I missing something? smsc:/etc/kannel# cat kannel.conf group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar dlr-storage = mysql log-file = /tmp/kannel.log log-level = 0 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1;120.1.1.1

Re: MySQL not storing

2010-05-23 Thread Jovan Kostovski
On Sun, May 23, 2010 at 3:13 PM, Barry Murphy ba...@unix.co.nz wrote: Here is a complete copy of my kannel.conf, am I missing something? There is nothing wrong with your config file. What I told you to do is: 1. from the machine where kannel is running try to connect to the database

Re: MySQL not storing

2010-05-23 Thread Jovan Kostovski
On Sun, May 23, 2010 at 3:13 PM, Barry Murphy ba...@unix.co.nz wrote: Here is a complete copy of my kannel.conf, am I missing something? There is nothing wrong with your config file. What I told you to do is: 1. from the machine where kannel is running try to connect to the database # mysql -h

Re: MySQL not storing

2010-05-23 Thread Nikos Balkanas
Hi, Mysql looks fine. Your problem doesn't seem to be that mysql doesn't store, but rather that mysql doesn't match. Please read User's guide why in message-type. If that doesn't solve your problem. please repost, this time including also submit submit_resp PDUs in your logs. BR, Nikos

Re: MySQL not storing

2010-05-23 Thread Nikos Balkanas
Sorry, that should read msg-id-type not message-type. BR, Nikos - Original Message - From: Nikos Balkanas nbalka...@gmail.com To: Barry Murphy ba...@unix.co.nz; users@kannel.org Sent: Sunday, May 23, 2010 9:11 PM Subject: Re: MySQL not storing Hi, Mysql looks fine. Your problem

WAP-Push with Nokia 6210 as SMSC

2010-05-23 Thread Thomas Sieh
Hi @all, I have got a Nokia 6210 as SMSC. When I send a WAP Push message to the PPG I get a unforseeable number of Generic Errors - up to 30 - and then it will send the message successfully. What could be the Problem? I have tryed already to change sleep-times and other modem options without

Re: Regarding OTA Message

2010-05-23 Thread Benaiad
Hi, I wrote a java method for this and I hope it helps: Note: I've tested this on the latest kannel svn and you have to do the same. public String sendOMASettings(String to, String pin) { String result = ; try { StringBuffer buffer = new StringBuffer(); if

Re: WAP-Push with Nokia 6210 as SMSC

2010-05-23 Thread Thomas Sieh
Hi @all again, I found the mistake by myself... keepalive = true is not a valid value. After changing to 5 it works fine. How stupid :) Thanks Thomas On Sun, May 23, 2010 at 08:41:15PM +0200, Thomas Sieh wrote: | Hi @all, | | I have got a Nokia 6210 as SMSC. When I send a WAP Push message to

Messages with php stripslashes

2010-05-23 Thread Barry Murphy
Hi, I'm using sqlbox to insert text messages into kannel from our php website. Previous to using PHP stripslashes, when ever a person had a ' in a word such as it's, it would add a slash like it\'s which is understandable. We've since used php stripslashes('it\'s') which sends it's to sqlbox and

Re: Messages with php stripslashes

2010-05-23 Thread Emmanuel CHANSON
I have posted some weeks ago a similar issue with sqlbox but it is not resolved for the moment, Alejandro to check on his side to reproduce the issue. Check my post in the mailling list archive to see if it the same problem: Object: *Quote and backslash issue* As you when using CGI interface to

Re: MySQL not storing

2010-05-23 Thread Barry Murphy
I have tried setting msg-id-type=0x03 , 0x02 0x01 0x00, none of which place a dlr into mysql table. thanks Barry - Original Message - From: Barry Murphy ba...@unix.co.nz To: Nikos Balkanas nbalka...@gmail.com Sent: Monday, May 24, 2010 12:16 AM Subject: Re: MySQL not storing

Re: MySQL not storing

2010-05-23 Thread Barry Murphy
Ok so I found the problem, I was not adding dlr_mask 31 which I'm now doing and getting results inserted into dlr table and also into sent_sms for sqlbox. Problem is I only seem to get these messages when I restart kannel, then all the delivery reports come through at that point. Also dlr table is

Re: MySQL not storing

2010-05-23 Thread Barry Murphy
Hi, Having messages queuing up in the dlr and never leaving, this is a problem I assume as per below problem Thanks Barry On Mon, 24 May 2010 13:18:03 +1200, Barry Murphy ba...@unix.co.nz wrote: Ok so I found the problem, I was not adding dlr_mask 31 which I'm now doing and getting results

Re: MySQL not storing

2010-05-23 Thread Nikos Balkanas
Hi, Please do not repost the same message more than once without offering anything new. It is consider spam. I can't quite understand what is your problem: Problem is I only seem to get these messages when I restart kannel, then all the delivery reports come through at that point. What