Hi all, I'm trying to configure sqlbox to run with PostgreSQL. When I try to start sqlbox from the command line, just to test if it creates de DB I get the following error message:
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] my sqlbox.conf is the following: group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" 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 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" # Database connection examples. Please uncomment as needed group = pgsql-connection id = sqlbox-db id = sqlbox-db username = myuser password = mypass database = kannel host = localhost I'm running this sqlbox on a debian unstable and using the kannel and kannel-sqlbox packages from the official repositories. Do I have to recompile sqlbox to include postgresql support? Cheers!! -- Arnau
