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
Gordon Ross wrote:
> I've been (trying) to play with OpenSIPS with the Postgres database.
> Unfortunately, I've come to an unhappy conclusion. osipconsole doesn't
> actually work with Postgres. However, opensipctl works fine.
>
> The problem is the use of the double & single quote characters to enclose
> strings in SQL queries. osipconsole uses double quotes: e.g.
>
> SELECT * FROM SUBSCRIBERS WHERE username = "1234";
>
> Whereas opensipctl uses single quotes:
>
> SELECT * FROM SUBSCRIBERS WHERE username = '1234';
>
> For postgres, string values need to be enclosed in single quotes, not double
> quotes. Double quotes indicates a column name.
>
> Look at the simple command below:
>
> 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
>
>
> Doing the same with opensipctl:
>
> vm3:~ # /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
>
>
> I manually changed a couple of SQL queries in osipconsole to prove this
> hypotheses, and with the quote characters changes, osipconsole works fine.
>
> I've logged this as a bug in the tracker (ID 2815413)
>
> GTG
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
