Re: sqlbox installation issue

[Robin C]

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 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 istaled kannel 1.4.3.
> when i try to make sqlbox i am getting the following error.
>
>
>
> sqlbox_mysql.c: In function ‘mysql_fetch_msg’:
> sqlbox_mysql.c:148:21: error: ‘struct sms’ has no member named ‘meta_data’
> msg->sms.meta_data  = octstr_null_create(row[26]);
> ^
> sqlbox_mysql.c: In function ‘mysql_fetch_msg_list’:
> sqlbox_mysql.c:214:25: error: ‘struct sms’ has no member named ‘meta_data’
> msg->sms.meta_data  = octstr_null_create(row[26]);
> ^
> sqlbox_mysql.c: In function ‘mysql_save_msg’:
> sqlbox_mysql.c:268:74: error: ‘struct sms’ has no member named ‘meta_data’
> st_str(msg->sms.boxc_id), st_str(msg->sms.binfo),
> st_str(msg->sms.meta_data), st_num(msg->sms.priority),
> st_str(msg->sms.foreign_id));
>  ^
> sqlbox_mysql.c:254:76: note: in definition of macro ‘st_str’
> #define st_str(x) (stuffer[stuffcount++] =
> get_string_value_or_return_null(x))
>
>  ^
> sqlbox_mysql.c: In function ‘mysql_save_list’:
> sqlbox_mysql.c:299:82: error: ‘struct sms’ has no member named ‘meta_data’
> st_str(msg->sms.boxc_id), st_str(msg->sms.binfo),
> st_str(msg->sms.meta_data), st_num(msg->sms.priority),
> st_str(msg->sms.foreign_id));
>
>^
> sqlbox_mysql.c:254:76: note: in definition of macro ‘st_str’
> #define st_str(x) (stuffer[stuffcount++] =
> get_string_value_or_return_null(x))
>
>
>
> *[image: Afbeelding verwijderd door afzender.]*
>
>
>
>
>
>
>
> Disclaimer:  This message contains confidential information and is
> intended only for the individual named.  If you are not the named addressee
> you should not disseminate, distribute or copy this e-mail.  Please notify
> the sender immediately by e-mail if you have received this e-mail by
> mistake and delete this e-mail from your system.  E-mail transmission
> cannot be guaranteed to be secure or error-free as information could be
> intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
> contain viruses.  The sender therefore does not accept liability for any
> errors or omissions in the contents of this message, which arise as a
> result of e-mail transmission.  If verification is required please request
> a hard-copy version.
>
> *7* Switch off as you go |*q *Recycle always | P Print only if absolutely
> necessary
>


-- 
 *Thanks & Regards,*



  Robin C

 Linux System Administrator

Web : www.refined.co.in

Address : TC 15/1945-3, Kamala Towers, Ganapathy Kovil Road,
Vazhuthacaud, Thiruvananthapuram,
Kerala - 695014






Disclaimer:  This message contains confidential information and is intended
only for the individual named.  If you are not the named addressee you
should not disseminate, distribute or copy this e-mail.  Please notify the
sender immediately by e-mail if you have received this e-mail by mistake
and delete this e-mail from your system.  E-mail transmission cannot be
guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain
viruses.  The sender therefore does not accept liability for any errors or
omissions in the contents of this message, which arise as a result of
e-mail transmission.  If verification is required please request a
hard-copy version.

*7* Switch off as you go |*q *Recycle always | P Print only if absolutely
necessary

Re: Need an Assistance in my Kannel Config

[Davor Spasoski]

Another possibility is that the number base of the msg-id does not match with the SMSC. Do you maybe have connecion to more than one SMSC, either explicitelly or behind the virtual IP of the smsc? Check the manual:






msg-id-type
number
Optional, specifies which number base the SMSC is using for the message ID numbers in the corresponding submit_sm_resp and deliver_sm PDUs. This is required to make delivery reports
 (DLR) work on SMSC that behave differently. The number is a combined set of bit 1 and bit 2 that indicate as follows: bit 1: type for submit_sm_resp, bit 2: type for deliver_sm. If the bit is set then the value
 is in hex otherwise in decimal number base. Which means the following combinations are possible and valid: 0x00 deliver_sm decimal, submit_sm_resp decimal; 0x01 deliver_sm decimal, submit_sm_resp hex;
 0x02 deliver_sm hex, submit_sm_resp decimal; 0x03 deliver_sm hex, submit_sm_resp hex. In accordance to the SMPP v3.4 specs the default will be a C string literal
 if no of the above values is explicitly indicated using the config directive.







On Feb 18, 2020, at 06:13, Robin C  wrote:



Hi,


The same is happening to me also. Sometimes I am not receiving the DLR of delivered messages also. If i sent 1000  messages i might get 900 DLRs. What might be the reason.



On Mon, Feb 17, 2020 at 3:57 PM Tolga Ulas  wrote:


Also check your smpp logs (raise it to debug level in your config) and
check if kannel can successfully create outgoing dlr records and can
match them with incoming dlrs during transactions. If all goes well
you will see no warning or error for all messages

> - Maybe you have messages that are pending and they have different status. - Try with a simple mask (3) and then set a short expiration of the messages that you are going to test. Have one test phones on, one that you will turn on before expiration and a
 third one that you don’t turn-on before the expiration. Record all the dlrs that the SMSC will send and try to figure out the logic. Increase the dlr-mask and check the other scenarios - check with the SMSC operator if they send back an SLR if the message
 is expired or deleted from the SMSC DB for whatever reason. Regards, Davor






-- 


 Thanks
 & Regards,
    















Disclaimer:  This message contains confidential information and is intended only for the individual named.  If you are not the named addressee you should not disseminate, distribute
 or copy this e-mail.  Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.  E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,
 corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.  The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.  If verification is required
 please request a hard-copy version.
7 Switch
 off as you go |q Recycle
 always | P Print
 only if absolutely necessary














Disclaimer: A1 Makedonija DOOEL Skopje
This e-mail (including any attachments) is confidential and may be protected by legal privilege. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and
 delete your copy from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. A1 Makedonija DOOEL Skopje shall not be liable for the improper or incomplete
 transmission of the information contained in this communication nor for any delay in its receipt or damage to your system.
Please, do not print this e-mail unless it is necessary! Think about saving the environment!

Напомена: А1 Македонија ДООЕЛ Скопје
Оваа електронска порака (вклучувајќи ги и прилозите) е доверлива и може да биде заштитена со правни привилегии. Доколку не сте лицето на кое таа му е наменета пораката, не треба да ја копирате, дистрибуирате или да ја откривате нејзината содржина, туку веднаш
 да ја препратите до испраќачот и да ја избришете оригиналната порака и сите нејзини копии од Вашиот компјутерски систем. Секое неовластено користење на оваа порака во целост или делови од истата е строго забрането. Ве молиме да забележите дека електронските
 пораки се подложни на промени. А1 Македонија ДООЕЛ Скопје не презема одговорност за несоодветно или нецелосно пренесување на информациите содржани во оваа комуникација, ниту пак за било какво задоцнување на приемот или оштетувања на вашиот систем.
Ве молиме не ја печатете оваа порака освен ако не е неопходно! Зачувајте ја природата!