2011/3/21 <users-requ...@kannel.org> > Send users mailing list submissions to > users@kannel.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.kannel.org/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > users-requ...@kannel.org > > You can reach the person managing the list at > users-ow...@kannel.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. Re: new to compiling 1.43 version. (Alexander Ulitin) > 2. Re: New to Kannel (Milan P. Stanic) > 3. Re: new to compiling 1.43 version. (Milan P. Stanic) > 4. Re: New to Kannel (Milan P. Stanic) > 5. storing received sms to Database (Harbhag Singh Sohal) > 6. Re: Using SQLBOX - unix timestamp (Willy Mularto) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 22 Mar 2011 02:20:14 +0500 > From: Alexander Ulitin <m...@liworks.ru> > To: Joey L <mjh2...@gmail.com>, users@kannel.org > Subject: Re: new to compiling 1.43 version. > Message-ID: > <aanlktimk+fo+luc2o-_ysmkfk+dgcmqspgk+z-vn5...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > I think, you need to learn how to use and administrate linux. > /somewhere/suitable is your bin path. Print "whereis whereis" in your > console and take "/.../bin" part. Init.d doesn't need to be changed, > but you could write your own, it's not so difficult. > > this is my script, made from old default one, you can take a part of > it if you don't need 2 smsboxes and an sqlbox > > #!/bin/sh > # PROVIDE: kannel_smsbox kannel_wapbox kannel_bearerbox > # REQUIRE: NETWORKING SERVERS > # BEFORE: LOGIN > # KEYWORD: shutdown > > . /etc/rc.subr > > name=kannel > rcvar=`set_rcvar` > command="/usr/local/sbin/run_kannel_box" > extra_commands="reload" > sig_reload=SIGUSR1 > > load_rc_config $name > # Set defaults > kannel_config=${kannel_config:-"/usr/local/etc/kannel.conf"} > kannel1_config=${kannel1_config:-"/usr/local/etc/kannel1.conf"} > kannel2_config=${kannel2_config:-"/usr/local/etc/kannel-sqlbox.conf"} > kannel_user=${kannel_user:-"kannel"} > # Config file is required > if [ ! -r ${kannel_config} ]; then > warn "${kannel_config} is not readable." > case $1 in > force*) : ;; > *) exit 1 ;; > esac > fi > > if test -n ${kannel_enable:-""} && checkyesno kannel_enable; then > kannel_bearerbox_enable=${kannel_bearerbox_enable:-"YES"} > kannel_smsbox_enable=${kannel_smsbox_enable:-"YES"} > kannel_wapbox_enable=${kannel_wapbox_enable:-"NO"} > fi > > # bearerbox > name=kannel_bearerbox > rcvar=`set_rcvar` > pidfile=/var/run/kannel/${name}.pid > # Defaults > kannel_bearerbox_user=${kannel_bearerbox_user:-"${kannel_user}"} > kannel_bearerbox_enable=${kannel_bearerbox_enable:-"NO"} > kannel_bearerbox_config=${kannel_bearerbox_config:-"${kannel_config}"} > kannel_bearerbox_flags=${kannel_bearerbox_flags:-"--pidfile ${pidfile} > --min-delay 1 /usr/local/sbin/bearerbox ${kannel_bearerbox_flags} > ${kannel_bearerbox_config}"} > # > load_rc_config $name > run_rc_command "$1" > # > _rc_restart_done=false > > # smsbox > name=kannel_smsbox > rcvar=`set_rcvar` > pidfile=/var/run/kannel/${name}.pid > # Defaults > kannel_smsbox_user=${kannel_smsbox_user:-"${kannel_user}"} > kannel_smsbox_enable=${kannel_smsbox_enable:-"NO"} > kannel_smsbox_config=${kannel_smsbox_config:-"${kannel_config}"} > kannel_smsbox_flags=${kannel_smsbox_flags:-"--pidfile ${pidfile} > --min-delay 1 /usr/local/sbin/smsbox ${kannel_smsbox_flags} > ${kannel_smsbox_config}"} > # > load_rc_config $name > run_rc_command "$1" > # > _rc_restart_done=false > > # smsbox1 > name=kannel_smsbox1 > rcvar=`set_rcvar` > pidfile=/var/run/kannel/${name}.pid > # Defaults > kannel_smsbox1_user=${kannel_smsbox1_user:-"${kannel_user}"} > kannel_smsbox1_enable=${kannel_smsbox1_enable:-"NO"} > kannel_smsbox1_config=${kannel_smsbox1_config:-"${kannel1_config}"} > kannel_smsbox1_flags=${kannel_smsbox1_flags:-"--pidfile ${pidfile} > --min-delay 1 /usr/local/sbin/smsbox ${kannel_smsbox1_flags} > ${kannel_smsbox1_config}"} > # > load_rc_config $name > run_rc_command "$1" > # > > _rc_restart_done=false > > # smsbox1 > name=kannel_sqlbox > rcvar=`set_rcvar` > pidfile=/var/run/kannel/${name}.pid > # Defaults > kannel_sqlbox_user=${kannel_sqlbox_user:-"${kannel_user}"} > kannel_sqlbox_enable=${kannel_sqlbox_enable:-"NO"} > kannel_sqlbox_config=${kannel_sqlbox_config:-"${kannel2_config}"} > kannel_sqlbox_flags=${kannel_sqlbox_flags:-"--pidfile ${pidfile} > --min-delay 1 /usr/local/sbin/sqlbox ${kannel_sqlbox_flags} > ${kannel_sqlbox_config}"} > # > load_rc_config $name > run_rc_command "$1" > # > > > 2011/3/22 Joey L <mjh2...@gmail.com>: > > I am running Kannel that comes as a debian package. > > I installed and configured it via apt-get . > > I have download the new version 1.43 and have compiled it. > > I would like to remove the old version of the debian package and install > the > > new code - can someone help me ??? > > I know to remove the package, it is dpkg -e kannel. > > I have compiled the new package and i have to run one more command : > > > > make bindir=/somewhere/suitable install > > > > Can anyone tell me what "/somewhere/suitable install" should be ???? > > > > I would also like to know how i can get the init.d script running > properly > > under the new version. > > > > thanks > > > > mjh > > > > > > ------------------------------ > > Message: 2 > Date: Mon, 21 Mar 2011 23:13:23 +0100 > From: "Milan P. Stanic" <m...@arvanta.net> > To: users@kannel.org > Subject: Re: New to Kannel > Message-ID: <20110321221323.ga11...@arvanta.net> > Content-Type: text/plain; charset=us-ascii > > On Mon, 2011-03-21 at 18:48, Nikos Balkanas wrote: > > Go to the site http://www.kannel.org and follow downloading > > instructions. You will need to install package svn. To check you can > > use: > > > > ls $(which svn) > > > > (I am sure there must be a better command to check packages in Debian) > > and to install it: > > > > apt-get svn. > > apt-get install subversion > > or > > aptitude install subversion > > -- > Kind regards, Milan > -------------------------------------------------- > Arvanta, IT Security http://www.arvanta.net > Please do not send me e-mail containing HTML code. > > > > ------------------------------ > > Message: 3 > Date: Mon, 21 Mar 2011 23:18:57 +0100 > From: "Milan P. Stanic" <m...@arvanta.net> > To: users@kannel.org > Subject: Re: new to compiling 1.43 version. > Message-ID: <20110321221857.gb11...@arvanta.net> > Content-Type: text/plain; charset=us-ascii > > On Mon, 2011-03-21 at 17:01, Joey L wrote: > > I am running Kannel that comes as a debian package. > > I installed and configured it via apt-get . > > I have download the new version 1.43 and have compiled it. > > I would like to remove the old version of the debian package and install > the > > new code - can someone help me ??? > > > > I know to remove the package, it is dpkg -e kannel. > > > > I have compiled the new package and i have to run one more command : > > > > make bindir=/somewhere/suitable install > > > > Can anyone tell me what "/somewhere/suitable install" should be ???? > > > > I would also like to know how i can get the init.d script running > > properly under the new version. > > Which Debian release you run? > > I have built Kannel 1.5.0 (not svn) for Debian squeeze (current stable) > and for i386 and amd64 architectures only. If it suits your needs send > me a mail and I will put it somewhere for download. > > -- > Kind regards, Milan > -------------------------------------------------- > Arvanta, IT Security http://www.arvanta.net > Please do not send me e-mail containing HTML code. > > > > ------------------------------ > > Message: 4 > Date: Mon, 21 Mar 2011 23:25:22 +0100 > From: "Milan P. Stanic" <m...@arvanta.net> > To: users@kannel.org > Subject: Re: New to Kannel > Message-ID: <20110321222522.gc11...@arvanta.net> > Content-Type: text/plain; charset=us-ascii > > On Mon, 2011-03-21 at 10:48, Adan Canales wrote: > > I quit on Debian, too dificult, instead on Ubuntu was easy to install. > > Ubuntu is Debian derivative so it is very similar and admin tools are > the same. > > And Debian is stable as a rock. One server with Kannel which I maintain, > right now have uptime of 606 days (should I announce when it comes to > 666 ;-> ), i.e. works 606 days without reboot. > > Here it is: > # uptime > 23:19:55 up 606 days, 15:18, 2 users, load average: 0.00, 0.00, 0.00 >
Oh well, explain to me to get all the tools needed Kannel on Debian and how to configure with MySql and I´ll do it, since I couldn´t make it by myself. Adan > > -- > Kind regards, Milan > -------------------------------------------------- > Arvanta, IT Security http://www.arvanta.net > Please do not send me e-mail containing HTML code. > > > > ------------------------------ > > Message: 5 > Date: Tue, 22 Mar 2011 08:22:15 +0530 > From: Harbhag Singh Sohal <harbhag.so...@gmail.com> > To: users@kannel.org > Subject: storing received sms to Database > Message-ID: > <aanlktikeva4-+7qokzr4h9jo6d6gi5dufjgfk+hom...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > I want to know that how can I store the received SMS to the database. > I guess I am receiving SMS beacause I can see them in the access.log > file. But I want to know if how can I store them into the Database. ? > below are my config files > > #Sample configuration file for Kannel bearerbox on Debian. > # See the documentation for explanations of fields. > # > > # HTTP administration is disabled by default. Make sure you set the > # password if you enable it. > > group = core > admin-port = 13015 > admin-password = hard2guess > #admin-deny-ip = "*.*.*.*" > admin-allow-ip = "127.0.0.1" > dlr-storage = internal > smsbox-port = 13016 > #wdp-interface-name = "*" > log-file = "/var/log/kannel/bearerbox.log" > access-log = "/var/log/kannel/access.log" > #box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1" > log-level = 0 > > #group = wapbox > #bearerbox-host = localhost > #log-file = "/var/log/kannel/wapbox.log" > group = smsc > smsc-id = huawei_e220 > smsc = at > modemtype = huawei > device= /dev/ttyUSB0 > my-number = +91 > connect-allow-ip = 127.0.0.1 > sim-buffering = true > log-level = 0 > > # DLR with MySQL support configuration > group = mysql-connection > id = mydlr > host = localhost > username = > password = > database = a > > group = dlr-db > id = mydlr > table = dlr > field-smsc = smsc > field-timestamp = ts > field-source=source > field-destination = destination > field-service = service > field-url = url > field-mask = mask > field-status = status > field-boxc-id = boxc > > group = modems > id = nokia > name = "Huawei" > detect-string = "huawei" > init-string = "ATZ" > init-string = "AT+CMEE=1" > init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" > init-string = "AT+CNMI=0,1" > message-storage = SM > message-start = 0 > #speed = 460800 > #message-start = 0 > > group = smsbox > smsbox-id = mysmsc > bearerbox-host = 2 > #bearerbox-port = 13018 > sendsms-port = 13018 > global-sender = +91 > access-log = "/var/log/kannel/smsbox-access.log" > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > mo-recode = true > > group = smsbox-route > smsbox-id = mysmsc > > group = sendsms-user > username = > password = hard2guess > concatenation= true > max-messages = 10000 > > group = sms-service > keyword-regex = .* > catch-all = yes > accepted-smsc = huawei_e220 > max-messages = 3 > get-url = "http://localhost/~harbhag/test.php?phone=%p&text=%a"; > > > > group = sqlbox > id = sqlbox-db > smsbox-id = mysmsc > global-sender = "+91" > bearerbox-host = 202 > bearerbox-port = 13016 > smsbox-port = 13017 > smsbox-port-ssl = false > sql-log-table = sent_sms > sql-insert-table = send_sms > log-file = "/var/log/kannel/kannel-sqlbox.log" > log-level = 0 > #ssl-client-certkey-file = "" > #ssl-server-cert-file = "" > #ssl-server-key-file = "" > #ssl-trusted-ca-file = "" > > # Database connection examples. Please uncomment as needed > > # Example MYSQL Connection > group = mysql-connection > id = sqlbox-db > host = localhost > username = > password = > database = > > > > This is what I see when I start bearerbox > > > > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT&F^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- AT&F > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> ATE0^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- ATE0 > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+IFC=2,2^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPIN?^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPIN: READY > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGF=0^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CSMS=?^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CNMI=0,1^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CSMS: (0-1) > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS="SM"^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] INFO: AT2[huawei_e220]: AT SMSC > successfully opened. > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > 0,20,0,20,0,20 > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > > > from bearerbox log, this is what I see when a SMS is received > > > > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",1,20,"SM",1,20,"SM",1,20 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: 1 messages > waiting in memory > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGR=0^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CMGR: 0,,23 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- > 0791194971909979240C9119494661994000001130228060122204D4F29C0E > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: received > message from SMSC: +919417099997 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: Numeric sender > (international) <+91> > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: User data > length read as (4) > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: Udh decoding > done len=4 udhi=0 udhlen=0 udh='' > 2011-03-22 08:07:00 [7225] [6] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGD=0^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:08:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:09:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:09:04 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",1,20,"SM",1,20,"SM",1,20 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: 1 messages > waiting in memory > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGR=0^M > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CMGR: 0,,26 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- > 0791194971909979240C9119494661994000001130228070942207C8703C2D0E8B01 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: received > message from SMSC: +919417099997 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: Numeric sender > (international) <+91> > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: User data > length read as (7) > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: Udh decoding > done len=7 udhi=0 udhlen=0 udh='' > 2011-03-22 08:09:05 [7225] [6] WARNING: smsbox_list empty! > > > Moreover I get this smsbox_list empty warning. > I am using Ubuntu 10.10 64 bit and Kannel version 1.50. > Thanks > -- > Harbhag Singh Sohal > www.harbhag.wordpress.com > > > > ------------------------------ > > Message: 6 > Date: Mon, 21 Mar 2011 17:54:22 +0700 > From: Willy Mularto <sangpr...@gmail.com> > To: ha...@aeon.pk > Cc: kannel users <users@kannel.org> > Subject: Re: Using SQLBOX - unix timestamp > Message-ID: <9f3e3007-f510-4761-9085-c89f5c1db...@gmail.com> > Content-Type: text/plain; charset=us-ascii > > change the type to datetime ;) > > > On Mar 21, 2011, at 5:47 PM, ha...@aeon.pk wrote: > > > Hi, > > > > While using sqlbox, the column 'time' in sent_sms column of kannel > database is having timestamp values in unix time. Is there a parameter in > config by which I could control it to paste values in normal timestamps in > the table? > > > > Thanks, > > H > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > > > ------------------------------ > > _______________________________________________ > users mailing list > users@kannel.org > http://www.kannel.org/mailman/listinfo/users > > > End of users Digest, Vol 55, Issue 58 > ************************************* >
