I've tryed to send an MO with smscfake and i got this in bearerbox.log :
--------------------------------------------
2006-07-14 17:37:42 [10645] [6] DEBUG: smsc_fake: new message received
2006-07-14 17:37:42 [10645] [6] WARNING: smsbox_list empty!
2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!
2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!
2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!
2006-07-14 17:37:42 [10645] [4] WARNING: smsbox_list empty!
2006-07-14 17:38:01 [10645] [13] DEBUG: Dumping 1 messages to store
--------------------------------------------
and i got nothing in sent_sms and send_sms tables
On 7/14/06, Humberto Figuera <[EMAIL PROTECTED]> wrote:
Hi Fourat,
please test add the line "port=5432" or "port=the_port_of_postgres" in
the pgsql-connection group.
;p
On 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:
> It's ok, i got the sqlbox working
> But still have one problem :
> I have PGSQL going on the server, created a user owning a database and
> configured my db group to fit that, the db connexion is ok, but sqlbox throw
> an error in sqlbox.log :
> -------------------------------------------------------------------------
> 2006-07-14 16:19:16 [7744] [0] INFO: Added logfile
> `/var/log/smgs/sqlbox.log' with level `0'.
> 2006-07-14 16:19:16 [7744] [0] ERROR: PGSQL: connection to database
> 'smgstest' failed!
> 2006-07-14 16:19:16 [7744] [0] PANIC: PGSQL: could not connect to server:
> Connection refused
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 1735355439?
>
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /usr/local/sbin/sqlbox(gw_panic+0xe1) [0x806c030]
> 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x8060731]
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /usr/local/sbin/sqlbox(dbpool_increase+0xe1) [0x8060cf0]
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /usr/local/sbin/sqlbox(dbpool_create+0x79) [0x8060dba]
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /usr/local/sbin/sqlbox(sqlbox_init_pgsql+0x2f4) [0x80538b5]
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /usr/local/sbin/sqlbox(main+0x379) [0x805087f]
> 2006-07-14 16:19:16 [7744] [0] PANIC:
> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xd2)
> [0xb7b39ea2]
> 2006-07-14 16:19:16 [7744] [0] PANIC: /usr/local/sbin/sqlbox [0x804f911]
> -------------------------------------------------------------------------
>
> Verifying with netstat, postgresql is listening, and i can log into db and
> create any table i want.
> here's my conf :
>
> --SQLBOX----------------------------------------------------------------------
> group = sqlbox
> # id corresponds to id in group = mysql-connection.
> # this is analogous to id in group = dlr-db
> id = dlr-01-db
> # smsbox-id indicates the box where SQL-injected messages appear to be
> coming from
> smsbox-id = smsbox-01
> # bearerbox host to connect to
> bearerbox-host = "127.0.0.1"
> # smsbox port to be listening on
> smsbox-port = 13002
> smsbox-port-ssl = false
> # sql-log-table is the table used to log all sent messages
> sql-log-table = sent_sms
> # sql-insert-table is the table that is monitored for new messages to send
> sql-insert-table = send_sms
> # global sender: If no sender is specified in sql-insert-table then this
> # value is used.
> global-sender = 06121
> log-file = "/var/log/smgs/sqlbox.log"
> log-level = 0
> # ssl-client-certkey-file = ""
> # ssl-server-cert-file = ""
> # ssl-server-key-file = ""
> # ssl-trusted-ca-file = ""
> --SQLBOX----------------------------------------------------------------------
>
> --SMSBOX----------------------------------------------------------------------
> smsbox.conf smsc.conf smsc-fake.conf
> [EMAIL PROTECTED]:/etc/smgs# cat smsbox.conf
> group = smsbox
> bearerbox-host = "localhost"
> log-file = "/var/log/kannel/smsbox.log"
> log-level = 0
> mo-recode = true
> http-request-retry = 10
> http-queue-delay = 60
> smsbox-id = smsbox-01
> sendsms-port = 13002
> bearerbox-is-sqlbox=true
> --SMSBOX----------------------------------------------------------------------
>
> --BEARERBOX----------------------------------------------------------------------
> group = core
> admin-port = 13000
> admin-password = fxxbar
> status-password = sTtx
> admin-deny-ip = "*.*.*.*"
> admin-allow-ip = 127.0.0.1
> box-deny-ip = "*.*.*.*"
> box-allow-ip = 127.0.0.1
> wdp-interface-name = "*"
> log-file = "/var/log/kannel/bearerbox.log"
> log-level = 0
> access-log = "/var/log/kannel/access.log"
> smsbox-port = 13001
> store-file = "/var/log/kannel/store"
> dlr-storage = pgsql
> --BEARERBOX----------------------------------------------------------------------
>
> --SMSC----------------------------------------------------------------------
> group = smsc
> smsc = fake
> smsc-id = SMPP-01-FAKE
> port = 10000
> connect-allow-ip = 127.0.0.1
> --SMSC----------------------------------------------------------------------
>
> --PGSQLCONNEXION----------------------------------------------------------------------
> group = pgsql-connection
> id = dlr-01-db
> host = localhost
> username = test
> password = test
> database = test
> max-connections = 6
> --PGSQLCONNEXION----------------------------------------------------------------------
>
> --DLR-DB----------------------------------------------------------------------
> group = dlr-db
> id = dlr-01-db
> table = dlr
> field-smsc = smsc
> field-timestamp = date
> field-destination = da
> field-source = soa
> field-service = service
> field-url = "">> field-mask = mask
> field-status = status
> field-boxc-id = boxcid
> --DLR-DB----------------------------------------------------------------------
--
Humberto Figuera - Using Linux 2.6.17
Usuario GNU/Linux 369709
Caracas - Venezuela
GPG Key Fingerprint = 5AAC DF0C 00F4 2834 28BA 37AD 3364 01D1 74CA 0603
