Bugs item #2815413, was opened at 2009-07-01 23:16
Message generated for change (Comment added) made by iulia_bublea
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2815413&group_id=232389
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
Group: 1.5.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Gordon Ross (gordonross)
Assigned to: Nobody/Anonymous (nobody)
Summary: osipconsole broken for Postgres support
Initial Comment:
osipconsole uses the wrong quote character in it's SQL statements. osipconsole
uses double quotes to enclose parameters. However, Postgres needs string
parameters to be enclosed in single quotes. Double quotes, to postgres,
indicate a colum name.
A simple add subscriber in osipconsole:
OpenSIPS$:add 1...@blah 1234
Used database is PostgreSQL
1234 blah
Entry could not be retrieved from tableERROR: column "1234" does not exist
Query results:
================================================
Retrieving user 1...@blah from dbaliases failedERROR: column "1234" does not
exist
Query results:
================================================
Alias 1...@blah does not exist!
Introducing the new user 1...@blah to subscriber table failedERROR: column
"1234" does not exist
This problem does not exist in opensipctl.That uses single quotes and works
fine with Postgres.
# /usr/local/sbin/opensipsctl add 2...@blah 1234
pgsql_query: /usr/bin/psql -A -q -t -P fieldsep=' ' -h localhost -U
opensips opensips -c 'insert into subscriber (username,
domain,ha1,ha1b,password) values
('2345','blah','6bc52aec50b4af97f338b0d406234afa','5cb004acd453ef4e8548dfb19ab23ae4','1234');'
new user '2...@blah' added
----------------------------------------------------------------------
Comment By: Iulia Bublea (iulia_bublea)
Date: 2009-07-02 13:05
Message:
Hi,
I have fixed this a couple of days ago, when another error was reported.
It has been fixed on 1.5 and also on trunk. Please check if it works for
you now.
Regards,
Iulia
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2815413&group_id=232389
_______________________________________________
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
