Hi, I tried your configuration and the same error. I guess it's not compiled with the postgresql support. Anybody knows how to enable it?
On Wed, Jul 28, 2010 at 11:43 AM, seikath <seik...@gmail.com> wrote: > r...@bubu:[Wed Jul 28 12:41:59]:[~]$ cat /opt/kannel/etc/sqlbox.conf > group = sqlbox > id = sqlbox-db > smsbox-id = smsbox > #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" > #access-file = "/var/log/kannel/kannel-sqlbox.log" > log-level = 5 > #white-list = "" > #black-list = "" > #white-list-regex = "" > #ssl-client-certkey-file = "" > #ssl-server-cert-file = "" > #ssl-server-key-file = "" > #ssl-trusted-ca-file = "" > > group = pgsql-connection > id = sqlbox-db > host = localhost > port = 5432 > username = seik > password = > database = sms > max-connections = 10 > > > > On 07/28/2010 12:37 PM, Alejandro Guerrieri 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 <mailto: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 >> >> > >
