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 > >