This is because smsbox is not connected to sqlbox. Attach your last config file please.
M On 7/14/06, Fourat Zouari <[EMAIL PROTECTED]> wrote:
ok it's working ! thank you 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 = 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 > >
