When I try to start the sqlbox the process start with this error and do not
terminates
[root@cloned-KannelTest svn]# sqlbox /etc/kannel.conf.sql
2011-03-29 17:18:29 [14082] [0] INFO: Debug_lvl = -1, log_file = <none>,
log_lvl = 0
2011-03-29 17:18:29 [14082] [0] DEBUG: Kannel sqlbox version `svn-r4879'.
Build `Mar 28 2011 15:44:29', compiler `4.1.2 20080704 (Red Hat 4.1.2-48)'.
System Linux, release 2.6.18-028stab070.14, version #1 SMP Thu Nov 18 16:05:10
MSK 2010, machine i686.
Hostname cloned-KannelTest, IP 196.2.194.58.
Libxml version 2.6.26.
Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008.
Compiled with MySQL 5.0.77, using MySQL 5.0.77.
Using native malloc.
2011-03-29 17:18:29 [14082] [0] INFO: Starting to log to file
/var/log/kannel/kannel-sqlbox.log level 0
2011-03-29 17:18:29 [14082] [0] INFO: Added logfile
`/var/log/kannel/kannel-sqlbox.log' with level `0'.
2011-03-29 17:18:29 [14082] [0] INFO: MYSQL: Connected to server at localhost.
2011-03-29 17:18:29 [14082] [0] INFO: MYSQL: server version 5.0.77, client
version 5.0.77.
2011-03-29 17:18:29 [14082] [0] ERROR: Could not create new thread.
2011-03-29 17:18:29 [14082] [0] ERROR: System error 12: Cannot allocate memory
This is the system memory status :
[root@cloned-KannelTest svn]# free -m
total used free shared buffers cached
Mem: 5525 34 5490 0 0 0
-/+ buffers/cache: 34 5490
Swap: 0 0 0
[root@cloned-KannelTest svn]# df -Th
Filesystem Type Size Used Avail Use% Mounted on
/dev/vzfs vzfs 1.0G 650M 375M 64% /
none tmpfs 1.8G 4.0K 1.8G 1% /dev
Have any one any idea that could solve this issue
___________________________________
___ _ _ __ ___ __ _ _ __
/ __)( )( ) ( ) ( ,) ( ) ( \( ) ( )
\__ \ )__( /__\ ) ,\ /__\ ) ( /__\
(___/(_)(_)(_)(_)(___/(_)(_)(_)\_)(_)(_)
Have fun. Don't forget to bookmark this website :)
From: Kurt Quehenberger [mailto:[email protected]]
Sent: Tuesday, March 29, 2011 3:20 PM
To: Ahmed Shabana
Cc: [email protected]; [email protected]
Subject: Re: Kannel access-log / sent SMS insert to MySQL?
You're absolutely right, Ahmed!
There's no information about sqlbox in the kannel userguide.
But I found that there's a documentation included in the source code, or just
try the following link:
http://www.blogalex.com/archives/46
Best regards,
Kurt
Am 2011-03-29 12:47, schrieb Ahmed Shabana:
Can not find any SQLBOX guide at user guide ,
Please could u provide us with any sqlbox guide
___________________________________
___ _ _ __ ___ __ _ _ __
/ __)( )( ) ( ) ( ,) ( ) ( \( ) ( )
\__ \ )__( /__\ ) ,\ /__\ ) ( /__\
(___/(_)(_)(_)(_)(___/(_)(_)(_)\_)(_)(_)
Have fun. Don't forget to bookmark this website :)
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of
[email protected]<mailto:[email protected]>
Sent: Tuesday, March 29, 2011 11:34 AM
To: [email protected]<mailto:[email protected]>
Cc: [email protected]<mailto:[email protected]>
Subject: Re: Kannel access-log / sent SMS insert to MySQL?
Read SQLBOX from userguide.
On Tue, Mar 29, 2011 at 2:06 PM, Kurt Quehenberger
<[email protected]<mailto:[email protected]>> wrote:
Dear all!
Has anybody an advice how to insert *sent* SMS from the KANNEL "bearerbox" into
an MySQL Database?
For a simple test I defined the tag "access-log" in the core group:
group = core
...
access-log = "var/log/kannel/access.log"
The access.log file collects all sent/received SMS and looks like below:
2011-03-29 09:32:44 Log begins
2011-03-29 09:33:39 Receive SMS [SMSC:smsc-x] [SVC:] [ACT:] [BINF:] [FID:]
[from:+43xxx] [to:+43yyy] [flags:-1:0:-1:0:-1] [msg:8:A Incoming] [udh:0:]
2011-03-29 09:33:41 Sent SMS [SMSC:smsc-x] [SVC:^[ ]*(a)[ ]*] [ACT:] [BINF:]
[FID:] [from:+43yyyy] [to:+43xxx] [flags:-1:0:-1:-1:-1] [msg:31:Outgoing]
[udh:0:]
2011-03-29 09:37:27 Log ends
But I need something similar to my received SMS Script:
---
That was an quite easy task, I did it via an cgi Script in the "group =
sms-service":
group = sms-service
keyword = A
get-url =
http://hostname/cgi-bin/smsrxdb.cgi?time=%t&rx_phonenr=%p&tx_phonenr=%P&sendsms_user=%n&text=%a<http://hostname/cgi-bin/smsrxdb.cgi?time=%25t&rx_phonenr=%25p&tx_phonenr=%25P&sendsms_user=%25n&text=%25a>
(=>The script connects to a MySQL Database and inserts all the values into a
"sentsms" table)
---
Thanks very much in advance for your help!!!
Kind regards,
Kurt
