[OpenSIPS-Devel] [ opensips-Bugs-2815413 ] osipconsole broken for Postgres support
Bugs item #2815413, was opened at 2009-07-01 23:16
Message generated for change (Settings changed) made by iulia_bublea
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=1086410aid=2815413group_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: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Gordon Ross (gordonross)
Assigned to: Iulia Bublea (iulia_bublea)
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: Gordon Ross (gordonross)
Date: 2009-07-09 23:54
Message:
Works fine in trunk now,
Thanks.
--
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=detailatid=1086410aid=2815413group_id=232389
___
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [ opensips-Bugs-2815413 ] osipconsole broken for Postgres support
Bugs item #2815413, was opened at 2009-07-01 21:16
Message generated for change (Comment added) made by gordonross
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=1086410aid=2815413group_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: Fixed
Priority: 5
Private: No
Submitted By: Gordon Ross (gordonross)
Assigned to: Iulia Bublea (iulia_bublea)
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: Gordon Ross (gordonross)
Date: 2009-07-09 21:54
Message:
Works fine in trunk now,
Thanks.
--
Comment By: Iulia Bublea (iulia_bublea)
Date: 2009-07-02 11: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=detailatid=1086410aid=2815413group_id=232389
___
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [ opensips-Bugs-2815413 ] osipconsole broken for Postgres support
Bugs item #2815413, was opened at 2009-07-01 23:16
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=1086410aid=2815413group_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: Fixed
Priority: 5
Private: No
Submitted By: Gordon Ross (gordonross)
Assigned to: Iulia Bublea (iulia_bublea)
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=detailatid=1086410aid=2815413group_id=232389
___
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [ opensips-Bugs-2815413 ] osipconsole broken for Postgres support
Bugs item #2815413, was opened at 2009-07-01 21:16
Message generated for change (Tracker Item Submitted) made by gordonross
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=1086410aid=2815413group_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
--
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=1086410aid=2815413group_id=232389
___
Devel mailing list
Devel@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
