Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
Hi This also happens if you try with sqlite3. I configured it wiht mysql and everything fine. / WITH SQLITE3 **/ / CONF 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/sqlbox.log log-level = 4 group = sqlite3-connection id = sqlbox-db database = /opt/smsbox.db lock-timeout = 5 max-connections = 1 /LOG 2012-11-07 13:40:35 [30413] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2012-11-07 13:40:35 [30413] [0] PANIC: SQLBOX: MySQL: connection settings for id 'sqlbox-db' are not specified! 2012-11-07 13:40:35 [30413] [0] PANIC: sqlbox(gw_panic+0x147) [0x42b437] 2012-11-07 13:40:35 [30413] [0] PANIC: sqlbox(sqlbox_init_mysql+0x110) [0x40d060] 2012-11-07 13:40:35 [30413] [0] PANIC: sqlbox(sqlbox_init_sql+0x9) [0x412149] 2012-11-07 13:40:35 [30413] [0] PANIC: sqlbox(main+0x30f) [0x40ccef] 2012-11-07 13:40:35 [30413] [0] PANIC: /lib/libc.so.6(__libc_start_main +0xfd) [0x7f25af051c8d] 2012-11-07 13:40:35 [30413] [0] PANIC: sqlbox() [0x40bc09] / WITH MYSQL **/ / CONF 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/sqlbox.log log-level = 4 group = mysql-connection id = sqlbox-db host = localhost username = root password = internal database = kannel /LOG 2012-11-07 13:39:33 [29274] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2012-11-07 13:39:33 [29274] [0] INFO: MYSQL: Connected to server at localhost. 2012-11-07 13:39:33 [29274] [0] INFO: MYSQL: server version 5.1.63-0 +squeeze1-log, client version 5.1.63. 2012-11-07 13:39:33 [29274] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2012-11-07 13:39:33 [29274] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 29274. 2012-11-07 13:39:33 [29274] [1] INFO: Connected to bearerbox at localhost port 13001. 2012-11-07 13:39:33 [29274] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2012-11-07 13:39:33 [29274] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 29274 Best regards, António
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
Found the problem. Its in the library that initializes the sql connection. Right now it only allows connection to mysql, since is the first that the program will attempt to connect. The code in sqlbox_sql.c it should have a switch type, so the user can set witch to use. I attach a possible patch that make it possible to select between the different types of db. This patch adds the possibility to put in the configuration for the sqlbox, the option db-storage, witch can be one of the supported DB engines. _ António Silva E-mail:asi...@wirelessmundi.com diff -rNu sqlbox-0.7.2-orig//gw/sqlbox-cfg.def sqlbox-0.7.2/gw/sqlbox-cfg.def --- sqlbox-0.7.2-orig//gw/sqlbox-cfg.def 2008-11-03 20:33:15.0 +0100 +++ sqlbox-0.7.2/gw/sqlbox-cfg.def 2012-11-07 16:06:01.0 +0100 @@ -21,4 +21,5 @@ OCTSTR(ssl-server-cert-file) OCTSTR(ssl-server-key-file) OCTSTR(ssl-trusted-ca-file) +OCTSTR(db_storage) ) diff -rNu sqlbox-0.7.2-orig//gw/sqlbox_sql.c sqlbox-0.7.2/gw/sqlbox_sql.c --- sqlbox-0.7.2-orig//gw/sqlbox_sql.c 2009-05-19 17:08:35.0 +0200 +++ sqlbox-0.7.2/gw/sqlbox_sql.c 2012-11-07 16:10:28.0 +0100 @@ -3,49 +3,74 @@ struct server_type *sqlbox_init_sql(Cfg *cfg) { +CfgGroup *grp; +Octstr *db_storage; +char *type; struct server_type *res = NULL; + +if (!(grp = cfg_get_single_group(cfg, octstr_imm(sqlbox + panic(0, SQLBOX: SQL INIT: group 'sqlbox' is not specified!); + /* fetch database type, default to mysql if not configured */ + if (!(db_storage = cfg_get( grp, octstr_imm(db_storage + db_storage = octstr_create(mysql); + + + if (octstr_compare(db_storage, octstr_imm(mssql)) == 0) { #ifdef HAVE_MSSQL -res = (struct server_type *)sqlbox_init_mssql(cfg); -if (res) { -return res; -} -#endif -#ifdef HAVE_MYSQL -res = (struct server_type *)sqlbox_init_mysql(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_mssql(cfg); + if (res) { + return res; + } #endif + } + else if (octstr_compare(db_storage, octstr_imm(oracle)) == 0) { #ifdef HAVE_ORACLE -res = (struct server_type *)sqlbox_init_oracle(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_oracle(cfg); + if (res) { + return res; + } #endif + } + else if (octstr_compare(db_storage, octstr_imm(pgsql)) == 0) { #ifdef HAVE_PGSQL -res = (struct server_type *)sqlbox_init_pgsql(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_pgsql(cfg); + if (res) { + return res; + } #endif + } + else if (octstr_compare(db_storage, octstr_imm(sdb)) == 0) { #ifdef HAVE_SDB -res = (struct server_type *)sqlbox_init_sdb(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_sdb(cfg); + if (res) { + return res; + } #endif + } + else if (octstr_compare(db_storage, octstr_imm(sqlite)) == 0) { #ifdef HAVE_SQLITE -res = (struct server_type *)sqlbox_init_sqlite(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_sqlite(cfg); + if (res) { + return res; + } #endif + } + else if (octstr_compare(db_storage, octstr_imm(sqlite3)) == 0) { #ifdef HAVE_SQLITE3 -res = (struct server_type *)sqlbox_init_sqlite3(cfg); -if (res) { -return res; -} + res = (struct server_type *)sqlbox_init_sqlite3(cfg); + if (res) { + return res; + } +#endif + } + else { +#ifdef HAVE_MYSQL + res = (struct server_type *)sqlbox_init_mysql(cfg); + if (res) { + return res; + } #endif + } return res; }
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
Package: kannel-sqlbox Version: 0.7.2-3 Severity: important -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages kannel-sqlbox depends on: ii libc6 2.11.2-2 Embedded GNU C Library: Shared lib ii libmysqlclient165.1.48-1 MySQL database client library ii libpam0g1.1.1-3 Pluggable Authentication Modules l ii libpcre38.02-1 Perl 5 Compatible Regular Expressi ii libpq5 8.4.4-2 PostgreSQL C client library ii libsqlite0 2.8.17-6 SQLite shared library ii libsqlite3-03.7.0-1 SQLite 3 shared library ii libssl0.9.8 0.9.8o-1 SSL shared libraries ii libxml2 2.7.7.dfsg-4 GNOME XML library kannel-sqlbox recommends no packages. kannel-sqlbox suggests no packages. -- Configuration Files: /etc/kannel/sqlbox.conf changed: 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 = kannel database = kannel host = localhost -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
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. When relevant, please include logs with debug enabled. Please note that severity is tied globally to the *package*, not to *your* usage of the package. Kind regards, - Jonas -- * Jonas Smedegaard - idealist Internet-arkitekt * Tlf.: +45 40843136 Website: http://dr.jones.dk/ [x] quote me freely [ ] ask before reusing [ ] keep private signature.asc Description: Digital signature
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
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.x, IP . 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 (0xb6dc) 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
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
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. 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.x, IP . 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. Thanks for the detailed report. 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. Regards, - Jonas -- * Jonas Smedegaard - idealist Internet-arkitekt * Tlf.: +45 40843136 Website: http://dr.jones.dk/ [x] quote me freely [ ] ask before reusing [ ] keep private signature.asc Description: Digital signature
Bug#590692: kannel-sqlbox: Despite the sqlbox.conf has been configured to use PostgreSQL, it tries to connecto to MySQL
Hi Jonas, Thanks for the detailed report. 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. I have tried changing my sqlbox.conf settings to: group = sqlbox id = sqlbox-db smsbox-id = pgsqlbox #global-sender = bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13069 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/sqlbox.log log-level = 0 group = pgsql-connection id = psql-db username = kannel password = kannelpwd database = kannel host = localhost =RESULT===: 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 20:08:10 [3044] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0 2010-07-28 20:08:10 [3044] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2010-07-28 20:08:10 [3044] [0] PANIC: SQLBOX: MySQL: connection settings for id 'sqlbox-db' are not specified! 2010-07-28 20:08:10 [3044] [0] PANIC: /usr/sbin/sqlbox(gw_panic+0xaf) [0x807425f] 2010-07-28 20:08:10 [3044] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_mysql+0x133) [0x8052d53] 2010-07-28 20:08:10 [3044] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_sql+0x12) [0x80585a2] 2010-07-28 20:08:10 [3044] [0] PANIC: /usr/sbin/sqlbox(main+0x3ad) [0x805298d] 2010-07-28 20:08:10 [3044] [0] PANIC: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb7059c76] 2010-07-28 20:08:10 [3044] [0] PANIC: /usr/sbin/sqlbox() [0x8051701] 2nd test group = sqlbox id = sqlbox-db smsbox-id = psql-db #global-sender = bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13069 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/sqlbox.log log-level = 0 group = pgsql-connection id = psql-db username = kannel password = kannelpwd database = kannel host = localhost ===RESULT= 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 20:10:43 [3059] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0 2010-07-28 20:10:43 [3059] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2010-07-28 20:10:43 [3059] [0] PANIC: SQLBOX: MySQL: connection settings for id 'sqlbox-db' are not specified! 2010-07-28 20:10:43 [3059] [0] PANIC: /usr/sbin/sqlbox(gw_panic+0xaf) [0x807425f] 2010-07-28 20:10:43 [3059] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_mysql+0x133) [0x8052d53] 2010-07-28 20:10:43 [3059] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_sql+0x12) [0x80585a2] 2010-07-28 20:10:43 [3059] [0] PANIC: /usr/sbin/sqlbox(main+0x3ad) [0x805298d] 2010-07-28 20:10:43 [3059] [0] PANIC: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb6f7dc76] 2010-07-28 20:10:43 [3059] [0] PANIC: /usr/sbin/sqlbox() [0x8051701] 3rd test group = sqlbox id = psql-db smsbox-id = psqlsmsboxid #global-sender = bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13069 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/sqlbox.log log-level = 0 group = pgsql-connection id = psql-db username = kannel password = kannelpwd database = kannel host = localhost ==RESULT== 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 20:14:03 [3070] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0 2010-07-28 20:14:03 [3070] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2010-07-28 20:14:03 [3070] [0] PANIC: SQLBOX: MySQL: connection settings for id 'psql-db' are not specified! 2010-07-28 20:14:03 [3070] [0] PANIC: /usr/sbin/sqlbox(gw_panic+0xaf) [0x807425f] 2010-07-28 20:14:03 [3070] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_mysql+0x133) [0x8052d53] 2010-07-28 20:14:03 [3070] [0] PANIC: /usr/sbin/sqlbox(sqlbox_init_sql+0x12) [0x80585a2] 2010-07-28 20:14:03 [3070] [0] PANIC: /usr/sbin/sqlbox(main+0x3ad) [0x805298d] 2010-07-28 20:14:03 [3070] [0] PANIC: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb708ec76] 2010-07-28 20:14:03 [3070] [0] PANIC: /usr/sbin/sqlbox() [0x8051701] I don't know which any other combination to test. Let me know if you need I do some other test Thanks --