Hi Alejandro, Then it's a bug in the sqlbox.conf file. I have just uncommented the postgresql section.
On Wed, Jul 28, 2010 at 11:37 AM, Alejandro Guerrieri <alejandro.guerri...@gmail.com> wrote: > The repeated "id = sqlbox-db" line on the connection it's a typo, or is it > actually repeated? If so, remove one and try again... > > On Wed, Jul 28, 2010 at 11:33 AM, Arnau Rebassa > <arnau.mailingli...@gmail.com> wrote: >> >> 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 >> > >
