-
Many of the modules require access to a database. In some circumstances it may be necessary or desirable to use different usernames/passwords/hosts for the different modules. However, I suspect for many uses, there is no need to do this. So why do we have to specify the URI for each module that requires DB access ?
Why not have an option to specify a default DB URI (which can still be...
2009-07-13 07:49:51 UTC in OpenSIPS/OpenSER-a versatile SIP Server
-
With the latest code from the trunk, if you try and add a user/subscriber to the DB (when using the Postgres backend) you are unable to. You get the message that the entry already exists in aliases. Yet the aliases tables are empty. Reverting back to the 1.5.1 source tarball, and things work fine.
I suspect that the error is in the way the code is handling the return from the count() SQL...
2009-07-09 20:59:36 UTC in OpenSIPS/OpenSER-a versatile SIP Server
-
Works fine in trunk now,
Thanks.
2009-07-09 20:54:52 UTC in OpenSIPS/OpenSER-a versatile SIP Server
-
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 1234@blah 1234
Used database is PostgreSQL
1234 blah
Entry could not be retrieved from...
2009-07-01 20:16:42 UTC in OpenSIPS/OpenSER-a versatile SIP Server
-
The problem with OpenSIPS & Postgres support, is that naming is NOT consistent.
In some places postgres support is referenced by the name "PGSQL" and in others it's by "postgres"
A decision needs to be made as to what postgres is called, and then stick to it !
My hack to change it to pgsql makes it more consistent with the other config parameters. If you wish it to be postgres, then...
2009-06-29 16:22:59 UTC in OpenSIPS/OpenSER-a versatile SIP Server
-
The db_postgres module does not work in it's current incarnation in both trunk & 1.5.1
If you try and use postgres support out of the box, you get the following error:
"ERROR:core:db_check_api: module db_pgsql does not export db_use_table function"
The module is called pg_postgres, but the DB APIs assume pgsql. From my *very* brief look at the code, the core DB API routines assume the...
2009-06-29 16:05:31 UTC in OpenSIPS/OpenSER-a versatile SIP Server
