RE: audit sent and queued messages to DB
The problem is that I need to audit also success messages, and as I know the dlr stores a message in the DB and then deletes it when it's delivered successfully. Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] -Original Message- From: seik [mailto:[EMAIL PROTECTED] Sent: Friday, November 09, 2007 2:54 PM To: Knaan Ratosh Cc: users@kannel.org Subject: Re: audit sent and queued messages to DB well in case with queued you mean accepted by the SMSC and still not delivered to the recipient, you may just use DLR reporting data inserted into db each SMS should be sent with unique dlr smsid and proper value of the expiration timeout. from here you will deal with the sql queries i belive. -Original Message- From: Knaan Ratosh [EMAIL PROTECTED] Sent: 09 Ноември 2007 г. To: seik Subject:audit sent and queued messages to DB Hi, I need to store in an audit database information regarding messages that were sent successfully, and ones that are queued. I need this because I need to perform some reporting on the results - for example, report that counts the number of queued messages that were sent to a certain user within a range of dates. Does anyone have any idea how to do that? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals computer viruses.
RE: Problem starting kannel with dlr-storage mysql
I don't start the kanne; in a different way when using the dlr-storage=mysql. And when using internal I don't have the problem. So how can it be related to the order in which I start the services? Anyways, when starting only berearbox I get the following exception: [EMAIL PROTECTED] sbin]# ./bearerbox -v 0 /usr/local/kannel/etc/kannel.conf 2007-11-11 09:58:29 [26371] [0] INFO: Debug_lvl = 0, log_file = none, log_lvl = 0 2007-11-11 09:58:29 [26371] [0] PANIC: DLR: storage type 'mySql' is not supported! 2007-11-11 09:58:29 [26371] [0] PANIC: ./bearerbox(gw_panic+0xa3) [0x80dd347] 2007-11-11 09:58:29 [26371] [0] PANIC: ./bearerbox(dlr_init+0x1c0) [0x8083e88] 2007-11-11 09:58:29 [26371] [0] PANIC: ./bearerbox(main+0xec) [0x807a450] 2007-11-11 09:58:29 [26371] [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xe3) [0x30be33] 2007-11-11 09:58:29 [26371] [0] PANIC: ./bearerbox [0x8079ed9] Meaning it says mysql is not supported, and this is after I compiled it with mysql specifically. So what can it be? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED] -Original Message- From: Rodrigo Cremaschi [mailto:[EMAIL PROTECTED] Sent: Friday, November 09, 2007 2:44 PM To: Enver ALTIN Cc: users@kannel.org Subject: Re: Problem starting kannel with dlr-storage mysql Hi Knaan, 2007-11-09 07:21:48 [2652] [0] ERROR: error connecting to server `localhost' at port `13002' 2007-11-09 07:21:48 [2652] [0] PANIC: Couldn't connect to the bearerbox. Be sure that bearerbox is up and running before starting any other box. On Nov 9, 2007 7:30 AM, Enver ALTIN [EMAIL PROTECTED] wrote: On Fri, 2007-11-09 at 10:05 +0200, Knaan Ratosh wrote: I was trying to start the kannel using dlr-storage=mysql, but the it fails. The logs in the wapbox.log say: wapbox.log doesn't help, in order to understand the problem we need the output from bearerbox. -- Enver This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals computer viruses.
audit sent and queued messages to DB
Hi, I need to store in an audit database information regarding messages that were sent successfully, and ones that are queued. I need this because I need to perform some reporting on the results - for example, report that counts the number of queued messages that were sent to a certain user within a range of dates. Does anyone have any idea how to do that? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED]
Problem starting kannel with dlr-storage mysql
Hi, I was trying to start the kannel using dlr-storage=mysql, but the it fails. The logs in the wapbox.log say: 2007-11-09 07:21:48 [2652] [0] INFO: Starting to log to file /usr/local/kannel/log/wapbox.log level -1 2007-11-09 07:21:48 [2652] [0] DEBUG: syslog parameter is none 2007-11-09 07:21:48 [2652] [0] INFO: 2007-11-09 07:21:48 [2652] [0] INFO: Kannel wapbox version 1.4.1 starting up. 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 1 (wap/wsp_session.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 2 (wap/wsp_unit.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 3 (wap/wsp_push_client.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 4 (wap/timers.c:watch_timers) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 5 (wap/wtp_init.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 6 (wap/wtp_resp.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 7 (gw/wap-appl.c:main_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 8 (gw/wap-appl.c:return_replies_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 9 (gw/wap_push_ota.c:main_thread) 2007-11-09 07:21:48 [2652] [0] INFO: HTTP: Opening server at port 8380. 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 10 (gwlib/fdset.c:poller) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 11 (gwlib/http.c:server_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 12 (gw/wap_push_ppg.c:ota_read_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 13 (gw/wap_push_ppg.c:http_read_thread) 2007-11-09 07:21:48 [2652] [0] DEBUG: Started thread 14 (gw/wap_push_ppg.c:pap_request_thread) 2007-11-09 07:21:48 [2652] [0] ERROR: connect failed 2007-11-09 07:21:48 [2652] [0] ERROR: System error 111: Connection refused 2007-11-09 07:21:48 [2652] [0] ERROR: error connecting to server `localhost' at port `13002' 2007-11-09 07:21:48 [2652] [0] PANIC: Couldn't connect to the bearerbox. 2007-11-09 07:21:48 [2652] [0] PANIC: /usr/local/kannel/sbin/wapbox(gw_panic+0xa3) [0x80d26cb] 2007-11-09 07:21:48 [2652] [0] PANIC: /usr/local/kannel/sbin/wapbox(main+0x581) [0x807da71] 2007-11-09 07:21:48 [2652] [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xe3) [0x30be33] 2007-11-09 07:21:48 [2652] [0] PANIC: /usr/local/kannel/sbin/wapbox [0x807c509] When I removed the dlr-storage=mysql and replaced it with inernal storage, everything worked fine. I tried to compile kannel using the following configure and I stil have he same problem: ./configure --with-mysql --with-mysql-dir=/usr/local/mysql --prefix=/usr/local/kannel-complied or ./configure --with-mysql --with-mysql-dir=/usr/local/mysql --prefix=/usr/local/kannel-complied --with-dlr=mysql What should I do in order to make it work? Knaan Ratosh Acting VP RD AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED]
Using Kannel as SMSC
Hi, I want to use Kannel (Kannel2) as an SMSC, receiving UCP requests from another Kannel (Kannel 1). I tried the following configuration, but it doesn't fully work: UCP messages are sent to Kannel 2, but the Kannel 2 doesn't return an aswer. I get these lines in the error log: 2007-05-08 08:46:37 [5654] [5] INFO: Client connected from 10.10.2.31 2007-05-08 08:46:37 [5654] [5] DEBUG: Started thread 86 (gw/bb_boxc.c:function) 2007-05-08 08:46:37 [5654] [86] DEBUG: Thread 86 (gw/bb_boxc.c:function) maps to pid 5654. 2007-05-08 08:46:37 [5654] [86] DEBUG: Started thread 87 (gw/bb_boxc.c:boxc_sender) 2007-05-08 08:46:37 [5654] [87] DEBUG: Thread 87 (gw/bb_boxc.c:boxc_sender) maps to pid 5654. 2007-05-08 08:47:38 [5654] [86] INFO: Connection closed by the box 10.10.2.31 2007-05-08 08:47:38 [5654] [87] DEBUG: send_msg: sending msg to box: 10.10.2.31 2007-05-08 08:47:38 [5654] [87] DEBUG: Thread 87 (gw/bb_boxc.c:boxc_sender) terminates. 2007-05-08 08:47:38 [5654] [86] DEBUG: Thread 86 (gw/bb_boxc.c:function) terminates. What else should I add? Where do I keep the username and password of my Kannel, acting as SMSC? Here is the configuration I use: In kannel 1: I set : group = smsc smsc = emi smsc-id = kannel-int80 host = int-80.axismobile.com port = 13001 smsc-username = tester smsc-password = foobar log-file = /home/mailtrex/kannel/log/kannel-int80.log keepalive = 55 #throughput = 1 # SEND-SMS USERS group = sendsms-user username = tester password = foobar faked-sender = 9080 forced-smsc = kannel-int80 In Kannel2: group = core admin-port = 13000 smsbox-port = 13001 wapbox-port = 13002 admin-password = bar #status-password = foo #admin-deny-ip = #admin-allow-ip = log-file = /usr/local/kannel/log/kannel.log log-level = 0 #box-deny-ip = *.*.*.* box-allow-ip = 10.10.2.31 unified-prefix = 00358,0 dlr-storage = internal group = smsc smsc = emi smsc-id = dev-31 host = 10.10.2.31 port = 13001 smsc-username = tester smsc-password = foobar log-file = /usr/local/kannel/log/dev-31.log keepalive = 55 throughput = 1 # SMSBOX SETUP group = smsbox smsbox-id = dlrbox bearerbox-host = localhost sendsms-port = 13013 global-sender = 13013 #sendsms-chars = 0123456789 +- log-file = /usr/local/kannel/log/smsbox.log log-level = 0 access-log = /usr/local/kannel/log/access.log Knaan Ratosh RD Team leader AxisMobile Ltd. Consumer Mobile Email Tel: Int +972-3-7685529 Mobile: Int +972-54-3138460 [EMAIL PROTECTED]
