Hi,
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?
Definitely, unless you downloaded a postgress specific binary. To confirm
what you have please type:
ldd $(which sqlbox)
you will see that the binary is for mysql, not postgress.
BR,
Nikos
----- Original Message -----
From: "seikath" <seik...@gmail.com>
To: <users@kannel.org>
Sent: Wednesday, July 28, 2010 12:43 PM
Subject: Re: SQLBox problems with postgresql
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
