Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL

[Jonas Smedegaard]

On Wed, Jul 28, 2010 at 05:57:35PM +0200, Arnau Rebassa wrote:

On Wed, Jul 28, 2010 at 4:02 PM, Jonas Smedegaard <jo...@jones.dk> wrote:

On Wed, Jul 28, 2010 at 03:33:35PM +0200, Arnau wrote:

Severity: important

Please describe - in more words than subject line - what issue you are experiencing, and why you consider it such high severity.

group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13005
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

group = pgsql-connection
id = sqlbox-db
username = kannel
password = kannelpwd
database = kannel
host = localhost


When sqlbox is started the following message appears in the log file

debian:/etc/kannel# sqlbox
2010-07-28 11:25:08 [8521] [0] INFO: Debug_lvl = -1, log_file =
<none>, log_lvl = 0
2010-07-28 11:25:08 [8521] [0] DEBUG: Kannel sqlbox version `1.4.3'.
Build `Mar 19 2010 03:53:52', compiler `4.4.3'.
System Linux, release 2.6.32-5-686, version #1 SMP Sat Jul 24 02:27:10
UTC 2010, machine i686.
Hostname debian.xxxxxxxxx, IP xxxx.
Libxml version 2.7.6.
Using OpenSSL 0.9.8m 25 Feb 2010.
Compiled with MySQL 5.1.45, using MySQL 5.1.48.
Using SQLite 3.6.23.
Using native malloc.

2010-07-28 11:25:08 [8521] [0] INFO: Starting to log to file
/var/log/kannel/kannel-sqlbox.log level 0
2010-07-28 11:25:08 [8521] [0] INFO: Added logfile
`/var/log/kannel/kannel-sqlbox.log' with level `0'.
2010-07-28 11:25:08 [8521] [0] PANIC: SQLBOX: MySQL: connection
settings for id 'sqlbox-db' are not specified!
2010-07-28 11:25:08 [8521] [0] PANIC: sqlbox(gw_panic+0xaf) [0x807425f]
2010-07-28 11:25:08 [8521] [0] PANIC: sqlbox(sqlbox_init_mysql+0x133)
[0x8052d53]
2010-07-28 11:25:08 [8521] [0] PANIC: sqlbox(sqlbox_init_sql+0x12) [0x80585a2]
2010-07-28 11:25:08 [8521] [0] PANIC: sqlbox(main+0x3ad) [0x805298d]
2010-07-28 11:25:08 [8521] [0] PANIC:
/lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb6f23c76]
2010-07-28 11:25:08 [8521] [0] PANIC: sqlbox() [0x8051701]


As you can see it checks for MySQL and doesn't take into account that
MySQL is not configured but PostgreSQL is.

In theory sqlbox supports different DB like MySQL, Oracle, PostgreSQL, ... In the /etc/kannel/sqlbox.conf you configure which DB you want to use. In my case PostgreSQL, to do so, I configured the sqlbox.conf like:

Thanks for the detailed report.






Regards,

 - Jonas

--
 * Jonas Smedegaard - idealist & Internet-arkitekt
 * Tlf.: +45 40843136  Website: http://dr.jones.dk/

 [x] quote me freely  [ ] ask before reusing  [ ] keep private

I suspect possibly it is a simple matter of misconfiguration: You've given both sectins same id, which I suspect causes the second section to be ignored (and perhaps then the internal default SQL type is MySQL?). Try give the sections different IDs and tell us if that changes anything.

signature.asc
Description: Digital signature