ihave install sdb-0.5.1
./configure --with-postgres
make
make install
i have install libsdb-0.0.1
with makefile
<cut>
SDB_URL = postgres:host=localhost:db=report
<cut>
then
make
make install
then
on smskannel.conf
group = core
<cut>
dlr-storage = sdb
group = sdb-connection
id = mydlr
url = "postgres:host=localhost:db=report"
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-source = source
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc-id
then
i run bearbox
[EMAIL PROTECTED] gw]# ./bearerbox smskannel.conf
2003-12-19 03:12:43 [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0
2003-12-19 03:12:43 [0] INFO: Connecting to sdb resource
<postgres:host=localhost:db=report>.
No driver for postgres:host=localhost:db=report
2003-12-19 03:12:43 [0] PANIC: Could not connect to database
2003-12-19 03:12:43 [0] PANIC: ./bearerbox [0x80aada5]
2003-12-19 03:12:43 [0] PANIC: ./bearerbox [0x80557c5]
2003-12-19 03:12:43 [0] PANIC: ./bearerbox [0x8053c02]
2003-12-19 03:12:43 [0] PANIC: ./bearerbox(vfprintf+0x1384) [0x804bb24]
2003-12-19 03:12:43 [0] PANIC: /lib/tls/libc.so.6(__libc_start_main+0xe4)
[0x42015574]
2003-12-19 03:12:43 [0] PANIC: ./bearerbox(SSL_write+0x41) [0x804adf1]
[EMAIL PROTECTED] gw]#
if in shell
[EMAIL PROTECTED] gw]# sdb_client postgres:host=localhost:db=report
sdb> select * from dlr
0817309405 werwer 3254 76777 23 325345 2 1 3
Return code: 1
sdb>
CREATE TABLE dlr (
smsc varchar(40),
ts varchar(40),
source varchar(40),
destination varchar(40),
service varchar(40),
url varchar(255),
mask int,
status int,
boxc-id int
);
can anyone help me ?
thank's alot
