Re: sqlbox with pgsql

Thanks!

In fact, I did update the MySQL config directives but not the Postgres
thingies.
Thanks for pointing this out.

Rene Kluwen
Chimit

> I just realised
> http://www.mail-archive.com/[email protected]/msg03575.html refers
> to the same set of errors as I had struggled with. I saw the post earlier
> but as it was from 2004 I asumed that it would not be relevant anymore.
>
> Could the the changes perhaps be added to CVS ?
>
> What I needed to do in the end was to get sqlbox working on postgre 7 was
> 1) In sqlbox_pgsql.c   changing
>     if (!(pgsql_user = cfg_get(grp, octstr_imm("pgsql- username"))))
>             panic(0, "SQLBOX: PGSQL: directive 'pgsql-username' is not
> specified!");
>     if (!(pgsql_pass = cfg_get(grp, octstr_imm(" pgsql-password"))))
>             panic(0, "SQLBOX: PGSQL: directive ' pgsql-password' is not
> specified!");
> To
>     if (!(pgsql_user = cfg_get(grp, octstr_imm("username"))))
>             panic(0, "SQLBOX: PGSQL: directive 'username' is not
> specified!");
>     if (!(pgsql_pass = cfg_get(grp, octstr_imm("password"))))
>             panic(0, "SQLBOX: PGSQL: directive 'password' is not
> specified!"
>
> 2) I then followed Klaus Darilion instructions
>
>
> 3) I also needed to change the select from
>  sql = octstr_format("SELECT sql_id, momt, sender, receiver, udhdata,
> msgdata, time, smsc_id, service, account, id, sms_type, mclass,
> mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid,
> alt_dcs,
> rpi, charset, boxc_id, binfo FROM %S  LIMIT 1, 0", sqlbox_insert_table);
> TO
>   sql = octstr_format("SELECT sql_id, momt, sender, receiver, udhdata,
> msgdata, time, smsc_id, service, account, id, sms_type, mclass,
> mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid,
> alt_dcs,
> rpi, charset, boxc_id, binfo FROM %S  LIMIT 1 OFFSET 0", sqlbox_i
> nsert_table);
>
>
> My config file is
>
>
> group = core
> admin-port = 15000
> smsbox-port = 15001
> admin-password = bar
> #status-password = foo
> #admin-deny-ip = ""
> #admin-allow-ip = ""
> log-file = "/tmp/bearerbox2.log"
> log-level = 0
> box-deny-ip = "*.*.*.*"
> box-allow-ip = "172.17.2.42"
> #unified-prefix = "+358,00358,0;+,00"
> access-log = "/tmp/access2.log"
> store-file = "/tmp/kannel2.store"
> #ssl-server-cert-file = "cert.pem"
> #ssl-server-key-file = "key.pem"
> #ssl-certkey-file = "mycertandprivkeyfile.pem"
> dlr-storage = pgsql
>
>
> group = pgsql-connection
> id = mydlr
> host = localhost
> username = pgrobler
> password = pgrobler
> database = kannel
> max-connections = 1
>
>
> group = dlr-db
> id = mydlr
> table = dlr
> field-smsc = smsc
> field-timestamp = ts
> field-destination = destination
> field-source = source
> field-service = service
> field-url = url
> field-mask = mask
> field-status = status
> field-boxc-id = boxc
>
>
> group = pgsql-connection
> id = sqlbox_db
> host = localhost
> port = 5432
> username = pgrobler
> password = pgrobler
> database = kannel
> max-connections = 1
>
>
> group = sqlbox
> # id corresponds to id in group = mysql-connection.
> # this is analogous to id in group = dlr-db
> id = sqlbox_db
> smsbox-id = sqlbox2
> bearerbox-host = "127.0.0.1"
> smsbox-port = 15001
> smsbox-port-ssl = false
> sql-log-table = sent_sms
> sql-insert-table = send_sms
> global-sender = 06121
> log-file = "/tmp/sqlbox.log"
> log-level = 0
>