RE: sqlbox

https://sourceforge.net/p/kannelappliance/wiki/Configuration/attachment/sqlbox-userguide.pdf Van: users Namens Arun Verzonden: woensdag 22 april 2020 20:04 Aan: users@kannel.org Onderwerp: sqlbox hello I want to read some documentation or sqlbox I want to store Messages in

Re: sqlbox installation issue

On Monday 24 February 2020 at 06:27:24, Robin C wrote: > I have tried to install 1.4.5 . But it is not working. When I try to > decompress the file it is showing that it is not a tar.gz file. or its not > a zip file. Please tell us: 1. The name of the file you are trying to decompress 2. The

Re: sqlbox installation issue

in C > *Verzonden:* maandag 24 februari 2020 06:27 > *Aan:* Rene Kluwen > *CC:* users > *Onderwerp:* Re: sqlbox installation issue > > > > I have tried to install 1.4.5 . But it is not working. When I try to > decompress the file it is showing that it is not a tar.gz file

RE: sqlbox installation issue

Did you try to unzip with: tar -z -xvf (name-of-file.tar.gz) Otherwise download anew or with svn. == Rene Van: Robin C Verzonden: maandag 24 februari 2020 06:27 Aan: Rene Kluwen CC: users Onderwerp: Re: sqlbox installation issue I have tried to install 1.4.5

Re: sqlbox installation issue

I have tried to install 1.4.5 . But it is not working. When I try to decompress the file it is showing that it is not a tar.gz file. or its not a zip file. On Wed, Feb 19, 2020 at 3:29 PM Rene Kluwen wrote: > I think you will need a newer version of Kannel in order to install that > version of

RE: sqlbox installation issue

I think you will need a newer version of Kannel in order to install that version of sqlbox. == Rene Van: users Namens Robin C Verzonden: woensdag 19 februari 2020 10:03 Aan: users Onderwerp: sqlbox installation issue Hi all, I was tryting to install sqlbox in centos 7 . I have

Re: SQLBox Database structure on Kannel 1.4.5

If you grant SQLbox create privileges , it should create the schema on start up. Regards, On Mon, Jun 3, 2019 at 2:21 AM Web Min wrote: > I'm trying to install the SQLbox since a long time ago, no installation > procedure yet. > > Could you please share your steps for the installation and

Re: SQLBox Database structure on Kannel 1.4.5

I'm trying to install the SQLbox since a long time ago, no installation procedure yet. Could you please share your steps for the installation and will compare the new structure with the old one. Regards On Sat, Jun 1, 2019 at 9:44 PM Loyc Cossou wrote: > Hi Friends, > > It seems like the

Re: sqlbox looking for mssql connection although mysql installed

Congratulations brother! So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Tue, Oct 16, 2018 at 2:17 AM Cedar Jet wrote: > Finally, I got the below result: > > 2018-10-15

Re: sqlbox looking for mssql connection although mysql installed

Finally, I got the below result: 2018-10-15 15:10:49 [25046] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0 2018-10-15 15:10:49 [25046] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2018-10-15 15:10:49 [25046] [0] INFO: MYSQL: Connected to server at

Re: sqlbox looking for mssql connection although mysql installed

Thanks a lot for your replies. I joined the mail lists of kannel after I completed all topics in :) Some of the posts are new for me and some of them are old for me. For this purpose I decided to join and post a fresh thread Regards On Mon, Oct 15, 2018 at 12:46 PM Willy Mularto wrote: >

Re: sqlbox looking for mssql connection although mysql installed

You may check the archives of this mailing list. Thanks. So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Mon, Oct 15, 2018 at 4:20 PM Cedar Jet wrote: > Thanks for the tip!

Re: sqlbox looking for mssql connection although mysql installed

Thanks for the tip! Can you share them? On Mon, Oct 15, 2018 at 12:11 PM Willy Mularto wrote: > BTW there are some threads with Ubuntu installation topic. Thanks. > > > > So Far Express VPN still the fastest > >

Re: sqlbox looking for mssql connection although mysql installed

BTW there are some threads with Ubuntu installation topic. Thanks. So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Mon, Oct 15, 2018 at 3:41 PM Cedar Jet wrote: > heheh I'm

Re: sqlbox looking for mssql connection although mysql installed

heheh I'm following since 3 days :) On Mon, Oct 15, 2018 at 11:33 AM Willy Mularto wrote: > Follow the error message to install required package. Thanks. > > > > So Far Express VPN still the fastest > >

Re: sqlbox looking for mssql connection although mysql installed

Follow the error message to install required package. Thanks. So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Mon, Oct 15, 2018 at 3:31 PM Cedar Jet wrote: > Ok, I will do

Re: sqlbox looking for mssql connection although mysql installed

Ok, I will do that. but how? If via repository it wont compile with mysql and if from the source we have a problem with the compilation and installation on Ubuntu 18.4 LTS Regards On Mon, Oct 15, 2018 at 11:23 AM Willy Mularto wrote: > I prefer you to use source based installation rather than

Re: sqlbox looking for mssql connection although mysql installed

I prefer you to use source based installation rather than distro package. Thanks. So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Mon, Oct 15, 2018 at 11:56 AM Cedar Jet wrote:

Re: sqlbox looking for mssql connection although mysql installed

Look, After investigation, I noticed that the kannel install is working well via source, but the sqlbox was installed via repository kannel-sqlbox, so for this reason I couldn't compile it. I ran apt-get remove kannel-sqlbox I went to kannel source code folder then addons/sqlbox and ran

Re: sqlbox looking for mssql connection although mysql installed

What version do you use? Also how do you initiate the SQLBox? Thanks. So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Mon, Oct 15, 2018 at 10:38 AM Cedar Jet wrote: > I tried

Re: sqlbox looking for mssql connection although mysql installed

I tried what Willy Suggest with the same result. I saw some posts saying that we should compile sqlbox with mysql, for that reason I'm running now on server that containing apache2, phpmyadmin php5.6 and mysql on Ubuntu 16.4 only. I had followed the below link

Re: sqlbox looking for mssql connection although mysql installed

Try to put the database connection before the sqlbox group. Thanks Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet menulis: > Sure, and you can find the configuration below > > group = sqlbox > id = sqlbox-db > smsbox-id = sqlbox > #global-sender = "" > bearerbox-host = localhost >

Re: sqlbox looking for mssql connection although mysql installed

Sure, and you can find the configuration below group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 18001 smsbox-port = 18005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-level = 0 log-file =

Re: sqlbox looking for mssql connection although mysql installed

Sure, and sorry for the late reply you can find the configuration below group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 18001 smsbox-port = 18005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-level

Re: sqlbox looking for mssql connection although mysql installed

Share your SQLBox configuration file. Thanks So Far Express VPN still the fastest https://www.expressrefer.com/refer-friend?referrer_id=15939000_campaign=referrals_medium=copy_link_source=referral_dashboard On Sun, Oct 14, 2018 at 12:35 AM Cedar Jet wrote: > Hello, > > I'm always getting the

Re: sqlbox installation

http://www.akashif.co.uk/kannel/install-kannel-addons-opensmpp-and-sqlbox On Tue, Jan 23, 2018 at 12:36 PM, Robin C wrote: > > Hi users, > > How can I install sqlbox in kannel.? > -- > > > > > > > Disclaimer: This message contains confidential information and is >

RE: sqlbox make error

This is not an error. All is well -Original Message- From: christopher kamutumwa [mailto:chriskamutu...@gmail.com] Sent: Friday, March 25, 2016 4:35 PM To: Беляев Владимир Николаевич Cc: spameden; users Subject: Re: sqlbox make error Now when configuring sqlbox. I get below error

Re: sqlbox make error

sqlbox > ./configure --with-kannel-dir=/home/u3850/gateway-1.5.0 > > -Original Message- > From: users [mailto:users-boun...@kannel.org] On Behalf Of christopher > kamutumwa > Sent: Friday, March 25, 2016 1:48 PM > To: spameden > Cc: users > Subject: Re: sqlbox make e

Re: sqlbox make error

iday, March 25, 2016 1:48 PM > To: spameden > Cc: users > Subject: Re: sqlbox make error > > Hi below is what am getting now. please advise > > > Configuring DB support ... > checking whether to compile with MySQL support... disabled checking whether > to compile with LibS

RE: sqlbox make error

Subject: Re: sqlbox make error Hi below is what am getting now. please advise Configuring DB support ... checking whether to compile with MySQL support... disabled checking whether to compile with LibSDB support... disabled checking whether to compile with SQLite2 support... disabled checking whether

Re: sqlbox make error

Hi below is what am getting now. please advise Configuring DB support ... checking whether to compile with MySQL support... disabled checking whether to compile with LibSDB support... disabled checking whether to compile with SQLite2 support... disabled checking whether to compile with SQLite3

Re: sqlbox make error

2016-03-24 22:52 GMT+03:00 christopher kamutumwa : > hello, > > Ive installed kannel on ubuntu. now i want to install sqlbox i get > below error kindly advise how to resolve this? i aready have mysql on > server; > > sqlbox.c:98:2: error: #error You need support for at

Re: sqlbox for incoming messages?

i'm not sure what the right way is, so others feel free to correct me. I simply deleted everything in kannel directory and all sbin kannel files as well. doing this corrected another problem i had where i could not get kannel to connect to postgresql, only mysql. after delete, ,resvn, reconfig,

Re: sqlbox for incoming messages?

Following up on my own problem...I must have made an error in during compilation, I started over again and my config works. On Tue, Feb 2, 2016 at 1:03 PM, joe schacher wrote: > thanks for the help! > > i must not be understanding because i think i do have it set up that

Re: sqlbox for incoming messages?

thanks for the help! i must not be understanding because i think i do have it set up that way: core smsbox-port is waiting on 13002, sqlbox bbport is 13002 smsbox bbport is 13005, sqlbox smsport is 13005. is that wrong? I've tried switching the ports in sqlbox, commenting out bbport in smsbox

Re: sqlbox for incoming messages?

You need to make following chain via ports connection: BBOX <-> SQLBOX <-> SMSBOX Should make smsbox connect to sqlbox in order to get incoming SMS into sqlbox table. On Mon, Feb 1, 2016 at 8:45 PM, joe schacher wrote: > Ok thank you. Unfortunately, incoming messages

Re: sqlbox for incoming messages?

Ok thank you. Unfortunately, incoming messages are not appearing in sent_sms. Outgoing works well. I can see that messages are being retrieved from sim card memory in bearer_box, but they are not transferred to mysql database. I am also receiving the error sms_list is empty! I tried setting

Re: SQLBOX queued messages question

Hello Everyone I have the answer to the speed issues I have been encountering for the last 2 months. The issue was access speeds on the dlr table which is used as temporary storage. This was corrected by adding an index on the smsc which dramatically increased speeds. Whats good to know for

Re: SQLBOX queued messages question

I suspect the issue I am still experiencing is because of TCP retransmission between Kannel and SMSC. The time out for ack is 210ms on the SMSC we are sending to and the delay can sometimes be as long as 370ms. I have not found a solution, but am exploring further optimisations and avenues.

Re: SQLBOX queued messages question

2016-01-13 15:14 GMT+03:00 Grant Saicom : > Thanks for the advice. > > Which smpp implementation does kannel code ship with from the repo? Just > want to clarify as it sounds it isn’t opensmpp in the answer. > Why do you even ask about opensmppbox? I thought original

Re: SQLBOX queued messages question

opensmppbox is generally not recommended for production, it's very basic and there is no accounting at all, for SMPP-server I'd recommended contacting Stipe Tolk (you can find his e-mail on the lists archive in google), he has commercial solution carrier-grade. about TCP retransmissions you might

Re: SQLBOX queued messages question

Thanks for the advice. Which smpp implementation does kannel code ship with from the repo? Just want to clarify as it sounds it isn’t opensmpp in the answer. With regards to network, all the machines are on the same subnet, including the smsc. We have an instance within our network. On top of

Re: SQLBOX queued messages question

2016-01-13 18:30 GMT+03:00 Grant Saicom : > I might have the wrong end of the stick here, but I was under the > impression that kannel/bearerbox used openSMPP libraries to implement its > smpp functionality. I have done a bit of googling and cannot see anything >

Re: SQLBOX queued messages question

I might have the wrong end of the stick here, but I was under the impression that kannel/bearerbox used openSMPP libraries to implement its smpp functionality. I have done a bit of googling and cannot see anything confirming this. So I guess this is not the case :) With respect to mtr (both

Re: SQLBOX queued messages question

Yes. The only thing that comes to my mind is to use kannel-store = spool and move your spool store to /tmp dir, this way queue will be in multiple files instead of the single file and in RAM, I found this way it's very fast. Let me know if it helps. If you want to preserve queue (in case of

Re: SQLBOX queued messages question

store-type = spool store-location = "/tmp/kannel-spool/" put these 2 lines below group = core in /etc/kannel/kannel.conf do you use for dlr MySQL as well? worth adding index on dlr table as well: KEY `smsc_ts` (`smsc`,`ts`) ALTER table dlr add index `smsc_ts` (`smsc`,`ts`); 2015-12-15

Re: SQLBOX queued messages question

2015-12-09 12:43 GMT+03:00 Grant Saicom : > We process the sent_sms into another table on they fly. Maximum size the > sent_sms table gets is maybe 40k tops but mostly it averages around 10K. We > see this once 1 week maybe. > > I have really made every attempt to remove

Re: SQLBOX queued messages question

We process the sent_sms into another table on they fly. Maximum size the sent_sms table gets is maybe 40k tops but mostly it averages around 10K. We see this once 1 week maybe. I have really made every attempt to remove any bottlenecks in terms unwieldy database sizes to allow kannel to work

Re: SQLBOX queued messages question

Hi I don’t see any real improvement in performance. I am trying some different values. Just an aside: It almost seems to me that the bottleneck is sqlbox’s submission to bearerbox and not the quantity sqlbox pops out of send_sms to hand over. I am going to go over the sqlbox config doc again,

Re: SQLBOX queued messages question

2015-12-08 11:23 GMT+03:00 Grant Vorenberg : > [image: Saicom-now-offers-Cloud-PBX] > > Here is my config: > > group = sqlbox > id = sqlbox-db > smsbox-id = sqlbox > #global-sender = "" > bearerbox-host = localhost >

Re: SQLBOX queued messages question

2015-12-08 12:51 GMT+03:00 Grant Vorenberg : > [image: Saicom-Voice-Services] > > Hi > > We manage how big send_sms gets. The queue builder puts in 500 messages at > a time to a total maximum of 3000 from a larger main

Re: SQLBOX queued messages question

2015-12-07 14:03 GMT+03:00 Grant Vorenberg : > [image: Saicom-now-offers-Cloud-PBX] > > Hi Guys > > I am a new to the list subscription and am looking for a little clarity on > the SQLBOX. > > I have a Debian Wheezy box

Re: SQLBOX time and foreign_id

2015-08-12 8:03 GMT+03:00 Sergey Yudin ser...@centrcombank.com: 2015-08-07 22:42 GMT+03:00 spameden spame...@gmail.com mailto:spame...@gmail.com: 2015-08-07 22:41 GMT+03:00 spameden spame...@gmail.com mailto:spame...@gmail.com: 2015-08-07 21:06 GMT+03:00 Sergey Yudin

Re: SQLBOX time and foreign_id

2015-08-07 22:42 GMT+03:00 spameden spame...@gmail.com mailto:spame...@gmail.com: 2015-08-07 22:41 GMT+03:00 spameden spame...@gmail.com mailto:spame...@gmail.com: 2015-08-07 21:06 GMT+03:00 Sergey Yudin ser...@centrcombank.com mailto:ser...@centrcombank.com:

Re: SQLBOX time and foreign_id

2015-08-07 16:16 GMT+03:00 Sergey Yudin ser...@centrcombank.com: Dear Kannel People I am using Bearer + SQLBOX with Oracle database. SENT_SMS table contains TIME and FOREIGN_ID fields but they are empty for sent messages with Momt='MT'. Why bearer/sqlbox dosent feel it ? foreign_id is the

Re: SQLBOX time and foreign_id

Always copy list, so others would benefit from solution too. 2015-08-07 22:42 GMT+03:00 spameden spame...@gmail.com: 2015-08-07 22:41 GMT+03:00 spameden spame...@gmail.com: 2015-08-07 21:06 GMT+03:00 Sergey Yudin ser...@centrcombank.com: Can you give some tips about using charset

Re: sqlbox send_sms and openSMPP

, a trigger won’t help here… Even if you remove those messages, they will still be forwarded to bearerbox. == Rene *From:* users [mailto:users-boun...@kannel.org] *On Behalf Of *Alvaro Cornejo *Sent:* dinsdag 14 april 2015 23:22 *To:* Ali Kashif *Cc:* users@kannel.org *Subject:* Re

RE: sqlbox send_sms and openSMPP

] On Behalf Of Alvaro Cornejo Sent: dinsdag 14 april 2015 23:22 To: Ali Kashif Cc: users@kannel.org Subject: Re: sqlbox send_sms and openSMPP Hi As far as I know, openSMPP talks directly to bearerbox in bearerbox language. Sqlbox read sms from send_sms table, send them to bearerbox and move sms

Re: sqlbox send_sms and openSMPP

Alvaro -- if you see my above configuration, openSMPP is connecting to sqlbox on 13002 and sqlbox is connecting to kannel on 13001 so it seems like traffic is passing through SQLBox more over i have logs for all sent sms in my sqlbox sent_sms table. so if i agree with you, how messages are

Re: sqlbox send_sms and openSMPP

Hi As far as I know, openSMPP talks directly to bearerbox in bearerbox language. Sqlbox read sms from send_sms table, send them to bearerbox and move sms to sent_sms table. Regards Alvaro

Re: SQLBox UTF-8 Encoding

Hey all, Thanks to RK and Alvaro, this has worked. Thank you very much. I was checking the actual value in db which is utf-8 scrambled, which should be url-decoded. MT On Tue, Oct 28, 2014 at 10:14 PM, MOSES KARIUKI kariuk...@gmail.com wrote: Thanks Alvaro, I will test and revert. Thanks,

Re: SQLBox UTF-8 Encoding

Hi Rajeev, Thanks for your assistance. Much appreciated. This is the scenario. I have Sqlbox connected to Kannel. I am using it to send messages to an external SMSC by inserting messages directly into the send_sms table of SQLBOX, which in-turn send out the messages. It is working OK with

Re: SQLBox UTF-8 Encoding

Hi I guess both tables are on the same database; What is the default charset of your tables? are they the same? Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS)

Re: SQLBox UTF-8 Encoding

Hi. The whole database is UTG-8. UTF-8 is the default charset on both tables. On Oct 28, 2014 4:58 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi I guess both tables are on the same database; What is the default charset of your tables? are they the same? Regards Alvaro

Re: SQLBox UTF-8 Encoding

Hi urlencode(test déjà) = Test+d%C3%A9j%C3%A0 Looks like sqlbox is url-enconding your text somewhere. I suppose you are working everything in UTF-8, so it should be safe if you skip charset info on your insert? i.e. try INSERT INTO send_sms (coding,momt, sender, receiver,dlr_url,msg_text)

Re: SQLBox UTF-8 Encoding

Thanks Alvaro, I will test and revert. Thanks, MT On Tue, Oct 28, 2014 at 8:20 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi urlencode(test déjà) = Test+d%C3%A9j%C3%A0 Looks like sqlbox is url-enconding your text somewhere. I suppose you are working everything in UTF-8, so it

Re: SQLBox UTF-8 Encoding

HI, have you url-enoded the sms text before inserting into sqlbox send_sms table ??? *Rajeev Krishna* Operations Manager Krishnas Software Technologies www.krishnasoft.in mobile :+91 888 5815 888 Sales :+91 888 5813 888 Support :+91 888 5817 888 On Mon, Oct 27, 2014 at 6:35 PM, MOSES

Re: SQLBox UTF-8 Encoding

Hi Rajeev, When I do this : INSERT into tbl_outgoing (msg_text) values ( 'test déjà'); it works fine. but when I do: INSERT INTO send_sms (charset,coding,momt, sender, receiver,dlr_url) VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url') this ,Test+d%C3%A9j%C3%A0, is the value that

Re: SQLBox UTF-8 Encoding

Hi, Please clearly specify the process. I'm Confused at tbl_outgoing send_sms. where how are you inserting sms in to which table. All sms has to be url encoded before inserting into sqlbox send_sms table for unicode sms coding has to be 2. *Rajeev Krishna* Operations Manager Krishnas

Re: SQLBox and Store type

2014-07-08 11:26 GMT+04:00 Antonis Spirou anto...@kapatel.gr: Hi all, a quick question. If i use sqlbox do i have to use kannel's storage facility or one has nothing to do with the other? kannel's storage HAS nothing to do with sqlbox. kannel's storage it's just temporarily to track

Re: SQLBox and Store type

Thanks. Another question. Can DLRs be injected to sqlbox as queries? BR *Antonis Spirou* On 07/08/2014 11:44 AM, spameden wrote: 2014-07-08 11:26 GMT+04:00 Antonis Spirou anto...@kapatel.gr mailto:anto...@kapatel.gr: Hi all, a quick question. If i use sqlbox do i have to

Re: SQLBox and Store type

They're unrelated. Sqlbox uses Kannel's libraries and of course talks to Kannel over the box protocol, but it doesn't use its resources directly. Hope it helps, Alejandro On Tue, Jul 8, 2014 at 3:26 AM, Antonis Spirou anto...@kapatel.gr wrote: Hi all, a quick question. If i use sqlbox do

Re: Sqlbox log not logging information

Can you try logging to /tmp? That would rule out any permissions problems. On Mon, Jun 16, 2014 at 9:31 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Dude Yes, sqlbox shows similar to sqlbox: rt@perusms8:~# lsof |grep box |grep /var/log bearerbox 1383 root 15w REG

Re: Sqlbox log not logging information

Or run without --daemonize, it'll run in foreground and log to STDOUT. On Tue, Jun 17, 2014 at 9:41 AM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Can you try logging to /tmp? That would rule out any permissions problems. On Mon, Jun 16, 2014 at 9:31 PM, Alvaro Cornejo

Re: Sqlbox log not logging information

Hi Dude Yes, sqlbox shows similar to sqlbox: rt@perusms8:~# lsof |grep box |grep /var/log bearerbox 1383 root 15w REG8,1 385623 22937901 /var/log/kannel/bearerbox.log bearerbox 1383 root 16w REG8,110936 22937815

Re: sqlbox and smsbox in parallel

HI Alejandro As per my insert: INSERT INTO send_sms (momt, sender, receiver, udhdata, msgdata,smsc_id, sms_type, coding, compress, validity, dlr_mask, dlr_url,boxc_id ) VALUES ('MT', '991212213', '991212211', NULL, 'sqlbox10:30', 'smsc2email', 2, 2, NULL,

Re: Sqlbox log not logging information

Do you see sqlbox.log in lsof like the other kannel log files? If yes, is the file writable? Also, please show the result of ps aux | grep kannel result.

Re: Sqlbox log not logging information

Don't you need v=1 for logs? I use this: sqlbox -v 1 /etc/sqlbox.conf and then tail -f sqlbox.log On Sat, Jun 14, 2014 at 5:12 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi I still can´t see anything on my sqlbox.log eventhough it is in debug mode ( v=0) I get only the start

Re: sqlbox and smsbox in parallel

Hi Alejandro No, there is nothing on smsbox log Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas

Re: sqlbox and smsbox in parallel

Are you sure registered_delivery is set on the messages going out? smsbox should be receiving the dlr's back, there must be something on bearerbox log and eventually smsbox log, do you have log-level 0 on both? On Sat, Jun 14, 2014 at 9:53 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi

Re: sqlbox: not logging and not calling dlr

Pls add the below in group = smsbox config . bearerbox-port = 13005     On Friday, June 13, 2014 9:58 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi I 'm start using sqlbox and have 2 issues: A) When started with log in debug mode I get: user@peru8:/etc/init.d# tail -f -n 500

Re: sqlbox and smsbox in parallel

Hi Alejandro Is this what you mean? sqlbox --[13001]-- bearerbox --[13001]-- smsbox kannel.conf (to use with bearerbox): group = core smsbox-port = 13001 ... sqlbox.conf: group = sqlbox bearerbox-host = localhost bearerbox-port = 13001 #smsbox-port = 13005 (No smsbox-port since no need to

Re: sqlbox and smsbox in parallel

Yes, both would connect to bearerbox on the same port, but since sqlbox has and smsbox-id it would only receive traffic if you put a specific mo-route to it. Regards, Alejandro On Fri, Jun 13, 2014 at 8:21 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Alejandro Is this what you

Re: sqlbox and smsbox in parallel

Hi Alejandro Thanks for your help. It works as you said; each box is working independently; however sqlbox dlrs are not being called. I've tried by adding sqlbox-id in boxc_id field to match sqlbox-id but nothing. If I leave that field blanc, it gets automatically filed with sqlbox_id (sqlbox).

Re: sqlbox and smsbox in parallel

Is there anything on smsbox log? On Fri, Jun 13, 2014 at 11:54 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Alejandro Thanks for your help. It works as you said; each box is working independently; however sqlbox dlrs are not being called. I've tried by adding sqlbox-id in boxc_id

Re: sqlbox and smsbox in parallel

I mean, the dlr's would be routed to smsbox along with the mo's, and smsbox would be responsible for calling dlr-url as well. On Sat, Jun 14, 2014 at 1:54 AM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Is there anything on smsbox log? On Fri, Jun 13, 2014 at 11:54 PM, Alvaro

Re: sqlbox and smsbox in parallel

Yes, indeed. For mt, both will be able to send. To avoid sqlbox from receiving mo's, assign it an smsbox-id. If you want to route specific traffic to it you can add an smsbox-route, all the other traffic will go to the smsbox without smsbox-id. Check the user guide for more details. -- Alex

Re: SQLBOX ERROR

Hi Try to urlencode the url before inserting ir to send_sms Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú,

Re: SQLBOX ERROR

Hi garbage on url... seems it is not recognizing url charset/encode format. Have you urlencoded it before submitting to sqlbox? what charset do you use when submitting info to sql and what charset is defined on mysql table? Regards Alvaro

RE: sqlbox: save SMS in readable format

Did you try to select UNHEX(msg_data) as unencoded? From: users [mailto:users-boun...@kannel.org] On Behalf Of moz...@gmail.com Sent: donderdag 24 april 2014 19:50 To: users@kannel.org Subject: sqlbox: save SMS in readable format How can we save SMS in readable format in MySQL instead of

Re: sqlbox: save SMS in readable format

2014-04-26 14:26 GMT+04:00 Rene Kluwen rene.klu...@chimit.nl: Did you try to select UNHEX(msg_data) as unencoded? It won't work. msgdata is URLencoded depending on the encoding, basically url_encode feature was implemented to prevent problems with different encodings and escaping characters

RE: sqlbox: save SMS in readable format

From: spameden [mailto:spame...@gmail.com] Sent: Saturday, April 26, 2014 3:30 PM To: Rene Kluwen Cc: Moazzam Ali; users@kannel.org Subject: Re: sqlbox: save SMS in readable format 2014-04-26 14:26 GMT+04:00 Rene Kluwen rene.klu...@chimit.nl: Did you try to select UNHEX

Re: SQLBOX working - LIFO or FIFO

Hi, Many thanks. I tried and tested it. It works fine for small chunks of data (I can see SMS going out of bbox in a sequence they were entered in send_sms table). However, for large amount of data (e.g. I sent a bulk of 20k SMS via SQLBOX), it does not follow the same rule. Is it bearerbox which

Re: SQLBOX working - LIFO or FIFO

For priority I'd suggest adding a column called priority (typically int(3) integer between 0 and 999) and doing ORDER by that column. Do not forget to add an index as well or it might slow things down! 2013/11/12 ha...@aeon.pk ha...@aeon.pk: Hi, Many thanks. I tried and tested it. It works

Re: SQLBOX working - LIFO or FIFO

Actually, if my understanding is correct (i.e. SQLBOX is already doing the right thing by giving messages in FIFO order to bbox, but bbox is shuffling the outgoing messages from within its buffer), then there is no point of adding priority column. What do you say? On Tue, Nov 12, 2013 at 6:28

RE: SQLBOX working - LIFO or FIFO

From: users [mailto:users-boun...@kannel.org] On Behalf Of ha...@aeon.pk Sent: dinsdag 12 november 2013 15:28 To: spameden Cc: kannel users Subject: Re: SQLBOX working - LIFO or FIFO Actually, if my understanding is correct (i.e. SQLBOX is already doing the right thing by giving messages

RE: SQLBOX working - LIFO or FIFO

To: ha...@aeon.pk; 'spameden' Cc: 'kannel users' Subject: RE: SQLBOX working - LIFO or FIFO There's a 'priority' field in the Msg structure. I think it serves for the purpose that you want to. Just it's you cannot set it in the send_sms table. Not sure why, but probably the field was added

Re: SQLBOX working - LIFO or FIFO

*Sent:* dinsdag 12 november 2013 15:35 *To:* ha...@aeon.pk; 'spameden' *Cc:* 'kannel users' *Subject:* RE: SQLBOX working - LIFO or FIFO There’s a ‘priority’ field in the Msg structure. I think it serves for the purpose that you want to. Just it’s you cannot set it in the send_sms table

RE: SQLBOX working - LIFO or FIFO

...@aeon.pk [mailto:ha...@aeon.pk] Sent: dinsdag 12 november 2013 15:51 To: Rene Kluwen Cc: spameden; kannel users Subject: Re: SQLBOX working - LIFO or FIFO This is OK if SMSC does the re-ordering for congestion or some other reasons. But my concern is that messages should at least leave bbox

Re: SQLBOX working - LIFO or FIFO

:* dinsdag 12 november 2013 15:51 *To:* Rene Kluwen *Cc:* spameden; kannel users *Subject:* Re: SQLBOX working - LIFO or FIFO This is OK if SMSC does the re-ordering for congestion or some other reasons. But my concern is that messages should at least leave bbox in the same order by which

  1   2   3   4   5   6   >