Well, everything should be on the userguide. (This wasn't the case, though).
I don't know of any other missing parameters (I would have written a patch otherwise ;) ). Regards, AlejandroOn Thu, Jun 18, 2009 at 4:41 PM, Tshimanga Minkoka < [email protected]> wrote: > Hi Alex, > > > > It works with > > port = 5432 > > in the pgsql-connection group. > > > > Is there something else that is interesting and not mentioned in the user > guide? > > > > Tshimanga. > > > > *From:* Alejandro Guerrieri [mailto:[email protected]] > *Sent:* Thursday 18 June 2009 14:10 > *To:* Tshimanga Minkoka > *Cc:* [email protected] > > *Subject:* Re: Trouble to launch sqlbox panic in relation to postgres port > 36 > > > > That error comes in fact from the PGSql layer, being invoked from kannel's > dbpool. > > > > I assume something's wrong with your pgsql configuration(s?) and it's > taking 36 as the default port somehow, though your pgsql engine is obviously > not taking that value to boot. > > > > Try setting "port = 5432" on your pgsql-connection group, it should solve > your problem. > > > > (BTW, I've just noticed this is not documented on the userguide!) > > > > Hope it helps, > > > > Alejandro > > On Thu, Jun 18, 2009 at 12:07 PM, Tshimanga Minkoka < > [email protected]> wrote: > > 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> > > > > >
