RE: mysql support for kannel 1.5.0 from DEB packages

It seems to be an sqlbox problem, crashing for some reason or another.

 

From: cgchen [mailto:[email protected]] 
Sent: zaterdag 5 januari 2013 17:50
To: Rene Kluwen; [email protected]
Subject: Re: mysql support for kannel 1.5.0 from DEB packages

 

sorry, I cut that bit out. See blow. This should be straight forward. Along with the settings below, I created a db and granted all privileges to the db user. Am I missing something? or the DEB package simply doesn't support mysql

 

group = mysql-connection
id = mydlr
host = localhost
username = foo
password = bar
database = dlr
max-connections = 1
 
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc

 

  _____  

From: Rene Kluwen <[email protected]>
To: 'cgchen' <[email protected]>; [email protected] 
Sent: Sunday, 6 January 2013 3:40 AM
Subject: RE: mysql support for kannel 1.5.0 from DEB packages

 

In your previous email with your configuration files, there’s a group = dlr-db missing.

Possibly that’s your problem.

 

From: cgchen [mailto:[email protected]] 
Sent: zaterdag 5 januari 2013 17:06
To: Rene Kluwen; [email protected]
Subject: Re: mysql support for kannel 1.5.0 from DEB packages

 

there's nothing in bearerbox.log nor access.log within kannel. smsbox.log is the only one that shows anything. I've tested the mysql credentials so it's not that.

 

 

2013-01-06 02:03:12 [27121] [0] DEBUG: Kannel smsbox version 1.5.0 starting

2013-01-06 02:03:12 [27121] [0] DEBUG:   dumping group (sendsms-user):

2013-01-06 02:03:12 [27121] [0] DEBUG:     <group> = <sendsms-user>

2013-01-06 02:03:12 [27121] [0] DEBUG:     <username> = <?????>

2013-01-06 02:03:12 [27121] [0] DEBUG:     <password> = <?????>

2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 4 (gw/smsbox.c:obey_request_thread)

2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 5 (gw/smsbox.c:url_result_thread)

2013-01-06 02:03:12 [27121] [0] DEBUG: Started thread 6 (gw/smsbox.c:http_queue_thread)

2013-01-06 02:03:12 [27121] [0] DEBUG: Connecting to <127.0.0.1>

2013-01-06 02:03:12 [27121] [0] ERROR: connect to <127.0.0.1> failed

2013-01-06 02:03:12 [27121] [0] ERROR: System error 111: Connection refused

2013-01-06 02:03:12 [27121] [0] ERROR: error connecting to server `127.0.0.1' at port `13001'

2013-01-06 02:03:12 [27121] [0] PANIC: Couldn't connect to the bearerbox.

2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox(gw_panic+0x147) [0x43fd97]

2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox(main+0xcc5) [0x40ff45]

2013-01-06 02:03:12 [27121] [0] PANIC: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f92e6324c8d]

2013-01-06 02:03:12 [27121] [0] PANIC: /usr/sbin/smsbox() [0x40ebf9]

2013-01-06 02:03:24 [27203] [0] INFO: Added logfile `/var/log/kannel/smsbox.log' with level `0'.

2013-01-06 02:03:24 [27203] [0] INFO: Logging accesses to '/var/log/kannel/access.log'.

2013-01-06 02:03:24 [27203] [0] INFO: Started access logfile `/var/log/kannel/access.log'.

2013-01-06 02:03:24 [27203] [0] INFO: HTTP: Opening server at port 13013.

2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller)

2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread)

2013-01-06 02:03:24 [27203] [0] INFO: Set up send sms service at port 13013

2013-01-06 02:03:24 [27203] [0] DEBUG: Started thread 3 (gw/smsbox.c:sendsms_thread)

 

  _____  

From: Rene Kluwen <[email protected]>
To: 'cgchen' <[email protected]>; [email protected] 
Sent: Sunday, 6 January 2013 2:55 AM
Subject: RE: mysql support for kannel 1.5.0 from DEB packages

 

What do your logs have to say about it?

 

From: [email protected] [mailto:[email protected]] On Behalf Of cgchen
Sent: zaterdag 5 januari 2013 16:27
To: [email protected]
Subject: mysql support for kannel 1.5.0 from DEB packages

 

Hi,

 

Can someone please confirm that kannel 1.5.0 from deb package comes with mysql support. The reason I asked is because as soon as I changed dlr-storage to mysql with mysql connection settings from the user guide, I'm not able to start kannel back up

 

Thanks.