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 -- Arnau -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
