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.