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.
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:
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. An it seems the PostgreSQL
support is included in the package as if you execute
ldd $(which sqlbox) the libpq.so.5 is displayed:
debian:/etc/kannel# ldd $(which sqlbox)
linux-gate.so.1 => (0xb787d000)
libpq.so.5 => /usr/lib/libpq.so.5 (0xb7852000)
libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb784e000)
libpam.so.0 => /lib/libpam.so.0 (0xb7841000)
librt.so.1 => /lib/i686/cmov/librt.so.1 (0xb7838000)
libresolv.so.2 => /lib/i686/cmov/libresolv.so.2 (0xb7824000)
libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb780d000)
libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb77e7000)
libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb77cd000)
libxml2.so.2 => /usr/lib/libxml2.so.2 (0xb76a3000)
libpcreposix.so.3 => /usr/lib/libpcreposix.so.3 (0xb76a1000)
libpcre.so.3 => /lib/libpcre.so.3 (0xb766c000)
libmysqlclient_r.so.16 => /usr/lib/libmysqlclient_r.so.16 (0xb746e000)
libsqlite.so.0 => /usr/lib/libsqlite.so.0 (0xb7414000)
libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb738a000)
libcrypto.so.0.9.8 => /usr/lib/i686/cmov/libcrypto.so.0.9.8 (0xb7232000)
libssl.so.0.9.8 => /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb71e8000)
libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb70a1000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0xb6fef000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0xb6feb000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0xb6fbc000)
libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb6f8a000)
libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0xb6f47000)
/lib/ld-linux.so.2 (0xb787e000)
libz.so.1 => /usr/lib/libz.so.1 (0xb6f33000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0xb6f0f000)
libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0xb6f08000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0xb6f05000)
liblber-2.4.so.2 => /usr/lib/liblber-2.4.so.2 (0xb6ef8000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb6ee1000)
libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0xb6e48000)
libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0xb6e38000)
libgcrypt.so.11 => /usr/lib/libgcrypt.so.11 (0xb6dc4000)
libgpg-error.so.0 => /usr/lib/libgpg-error.so.0 (0xb6dc0000)
>
> Please note that severity is tied globally to the *package*, not to *your*
> usage of the package.
IMHO this package is unusable if you're not using MySQL.
BR
--
Arnau
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
