Hi Ryan I have recently created the postgres tables by opensips-cli tool. Copy the default.cfg under your home directory. (while I am root) cp /root/src/opensips-cli/etc/default.cfg /root/opensips-cli.cfg
add postgres section in opensips-cli.cfg. The postgres password should be previously set by psql command. My file looks like this [default] log_level: WARNING prompt_name: opensips-cli prompt_intro: Welcome to OpenSIPS Command Line Interface! prompt_emptyline_repeat_cmd: False history_file: ~/.opensips-cli.history history_file_size: 1000 output_type: pretty-print communication_type: fifo fifo_file: /tmp/opensips_fifo # optional DB override instance, invoked using `opensips-cli -i postgres ...` [postgres] database_path: /usr/local/share/opensips/postgres database_url: postgres://opensips:<postgres-password>@<db-ip>:5432 template_url: postgres://postgres:<postgres-password>@<db-ip>:5432 database_name: opensips Then run the following command to create all tables of opensips opensips-cli -f /root/opensips-cli.cfg -i postgres -x database create opensips-cli uses the sql files in /usr/local/share/opensips/postgres path when creating tables. Arda From: Users <[email protected]> On Behalf Of Ryan embgrets Sent: Monday, February 10, 2020 12:22 AM To: [email protected] Subject: [OpenSIPS-Users] Cannot create opensips database for postgresql using opensips-cli Attention: This email was sent from someone outside of Afiniti. Always use caution when opening attachments, clicking links from unknown senders or when receiving unexpected emails. Greetings, I am trying to create opensips database using opensips-cli module but each time it is failing. I am getting below error during the process. (opensips-cli): database create Please provide the URL of the SQL database: postgres://opensips:[email protected]<mailto:opensips%[email protected]> ERROR: cannot connect to DB server: (psycopg2.OperationalError) FATAL: database "opensips" does not exist ! Traceback (most recent call last): File "/usr/lib/python3.5/cmd.py", line 214, in onecmd func = getattr(self, 'do_' + cmd) AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1044, in _do_get return self._pool.get(wait, self._timeout) File "/usr/lib/python3/dist-packages/sqlalchemy/util/queue.py", line 145, in get raise Empty sqlalchemy.util.queue.Empty During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect return fn() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection return _ConnectionFairy._checkout(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 713, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 480, in checkout rec = pool._do_get() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get self._dec_overflow() File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get return self._create_connection() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection return _ConnectionRecord(self) File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 449, in __init__ self.connection = self.__connect() File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 607, in __connect connection = self.__pool._invoke_creator(self) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect return dialect.connect(*cargs, **cparams) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 385, in connect return self.dbapi.connect(*cargs, **cparams) File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 126, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: database "opensips" does not exist Any help here is much appreciated. Ryan.
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
