search

OpenSIPS / opensips-cli

OpenSIPS CLI tool - an interactive command line tool that can be used to control and monitor OpenSIPS servers.
GNU General Public License v3.0
85 stars 48 forks source link

'database create' works weirdly with PostgreSQL #25

Closed lu-lu-yu closed 4 years ago

lu-lu-yu commented 5 years ago

hi, when working with postgresql, if there's no database 'opensips', using the URL of the SQL database:'postgres://opensips:opensipsrw@127.0.0.1/opensips' reports "fatal error: database 'opensips' doesn't exist", but if there's a database 'opensips' already created, using the URL of the SQL database:'postgres://opensips:opensipsrw@127.0.0.1/opensips' reports "error: database 'opensips' already exists". Futher more, when there's no database 'opensips', using the URL of the SQL database:'postgres://opensips:opensipsrw@127.0.0.1/postgres' turns out no error, but creates the database named 'opensips' and all related tables are created into database 'postgres'. My environment: CentOS6.7, postgres9.6, opensips3.0-stable.

opensips-cli errors.txt

Turbid commented 4 years ago

I confirm this problem - tables are created in the template1 base.

debian 10.1, postgresql 11, opensip-cli 0.1~20200128~d37af39-1

ryanembregts commented 4 years ago

I am facing the same issue, any update on this?

liviuchircu commented 4 years ago

This is now fixed, closing.