Hi,
I am setting up a kannel box with
SMS Gateway cvs-20090525
SQLBox version 0.7.2
Postgres 8.3.7-1PGDG.rhel5
RHEL 5.3 kernel 2.6.18-128.el5
Everything has been compiled and installed successfully.
I can start bearerbox without problem. It is when I start sqlbox that it
complains with
<screen>
[r...@vaskannel kannel]# sqlbox -v 0 kannel_sqlbox.conf
2009-06-18 10:50:52 [11071] [0] INFO: Debug_lvl = 0, log_file = <none>,
log_lvl = 0
2009-06-18 10:50:52 [11071] [0] DEBUG: Kannel sqlbox version
`cvs-20090525'.
Build `May 29 2009 11:11:51', compiler `4.1.2 20080704 (Red Hat
4.1.2-44)'.
System Linux, release 2.6.18-128.el5, version #1 SMP Wed Dec 17 11:42:39
EST 2008, machine i686.
Hostname vaskannel, IP 127.0.0.1.
Libxml version 2.6.26.
Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008.
Using native malloc.
2009-06-18 10:50:52 [11071] [0] INFO: Starting to log to file
/tmp/kannel/sqlbox.log level 0
2009-06-18 10:50:52 [11071] [0] INFO: Added logfile
`/tmp/kannel/sqlbox.log' with level `0'.
2009-06-18 10:50:52 [11071] [0] ERROR: PGSQL: connection to database
'kannel' failed!
2009-06-18 10:50:52 [11071] [0] PANIC: PGSQL: could not connect to
server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 36?
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox(gw_panic+0xc2) [0x806e722]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox [0x80623e1]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox(dbpool_increase+0xa7)
[0x8061887]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox(dbpool_create+0x7f)
[0x8061d0f]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox(sqlbox_init_pgsql+0x2fb)
[0x805123b]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox(main+0x3b1) [0x804ff31]
2009-06-18 10:50:52 [11071] [0] PANIC:
/lib/libc.so.6(__libc_start_main+0xdc) [0x125e8c]
2009-06-18 10:50:52 [11071] [0] PANIC: sqlbox [0x804fa21]
</screen>
Of course, postgresql is running and listening and accepting connection
on default port 5432!
I cannot see where does sqlbox pick up the port 36 it tries to connect
to!
I looked in all the kannel and postgresql configuration files without
seeing where I can modify or change something.
Below are the bearerbox and sqlbox configuration files used.
Any help will be appreciated.
Regards,
Tshimanga Minkoka.
<kannel_bearerbox.conf>
# CORE
group = core
admin-port = 13010
admin-password = foo
status-password = bar
#admin-deny-ip = ""
admin-allow-ip = "*.*.*.*"
log-file = "/tmp/kannel/01_core_log_file.log"
log-level = 0
access-log = "/tmp/kannel/01_core_access_log.log"
#http-proxy-host = "127.0.0.1"
#http-proxy-port = 8080
#http-proxy-exceptions = "127.0.0.1"
#http-proxy-username = "user"
#http-proxy-password = "password"
#ssl-certkey-file = "mycertandprivkeyfile.pem"
# Smsbox related
smsbox-port = 13011
#box-deny-ip = "*.*.*.*"
box-allow-ip = "*.*.*.*"
#unified-prefix = "00358,0"
#white-list = "http://127.0.0.1/white-list.txt";
#black-list = "http://127.0.0.1/black-list.txt";
#store-file = "/var/log/kannel/01_core_store_file.log"
#store-dump-freq = 10
# Wapbox related
#wapbox-port = 13012
#udp-deny-ip = "*.*.*.*"
#udp-allow-ip = "127.0.0.1"
#wdp-interface-name = "*"
# SMSC CONNECTIONS - GLOBAL FIELDS
#group = smsc
#smsc =
#smsc-id = 01_ID
#denied-smsc-id = "X;Y"
#allowed-smsc-id = "Z"
#preferred-smsc-id = "W"
#allowed-prefix = "040;050"
#denied-prefix = "060;070"
#alt-charset =
# SMSC SMPP
group = smsc
smsc = smpp
smsc-id = 01_smpp_csmsc01_vastest
host = 1.2.3.4
port = 6200
receive-port = 6200
smsc-username = foo
smsc-password = bar
system-type = ST
#address-range =
interface-version = "33"
my-number = 1234
#source-addr-ton =
#source-addr-npi =
#source-addr-autodetect = true
#dest-addr-ton =
#dest-addr-ton =
#bind-addr-npi =
#bind-addr-npi =
#msg-id-type =
log-file = "/tmp/kannel/smpp_log_file.log"
log-level = 0
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
#smsbox-id = smsbox
#bearerbox-port = smsbox-port found in core group
sendsms-port = 13013
#sendsms-chars = "0123456789 +-"
#global-sender = +243815160684
#global-sender = 1234
#log-file = "/tmp/kannel/smsbox_log_file.log"
#log-level = 0
#access-log = "/tmp/kannel/smsbox_access_log.log"
#white-list =
#black-list =
#reply-couldnotfetch =
#reply-couldnotrepresent =
#reply-requestfailed =
#reply-emptymessage =
</kannel_bearerbox.conf>
<kannel_sqlbox.conf>
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13011
smsbox-port = 13012
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/tmp/kannel/sqlbox.log"
log-level = 0
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
# Example POSTGRESQL Connection
group = pgsql-connection
id = sqlbox-db
username = postgres
password = foobar
database = kannel
host = localhost
</kannel_sqlbox.conf>
