<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi Ryan
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I have recently created the postgres tables by opensips-cli tool.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Copy the default.cfg under your home directory. (while I am root)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">cp /root/src/opensips-cli/etc/default.cfg /root/opensips-cli.cfg<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">add postgres section in opensips-cli.cfg.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The postgres password should be previously set by psql command.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">My file looks like this<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">[default]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">log_level: WARNING<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">prompt_name: opensips-cli<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">prompt_intro: Welcome to OpenSIPS Command Line Interface!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">prompt_emptyline_repeat_cmd: False<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">history_file: ~/.opensips-cli.history<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">history_file_size: 1000<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">output_type: pretty-print<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">communication_type: fifo<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">fifo_file: /tmp/opensips_fifo<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"># optional DB override instance, invoked using `opensips-cli -i postgres ...`<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">[postgres]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">database_path: /usr/local/share/opensips/postgres<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">database_url: postgres://opensips:<postgres-password>@<db-ip>:5432<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">template_url: postgres://postgres:<postgres-password>@<db-ip>:5432<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">database_name: opensips<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then run the following command to create all tables of opensips
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">opensips-cli -f /root/opensips-cli.cfg -i postgres -x database create<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">opensips-cli uses the sql files in /usr/local/share/opensips/postgres path when creating tables.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Arda<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Users <users-bounces@lists.opensips.org>
<b>On Behalf Of </b>Ryan embgrets<br>
<b>Sent:</b> Monday, February 10, 2020 12:22 AM<br>
<b>To:</b> users@lists.opensips.org<br>
<b>Subject:</b> [OpenSIPS-Users] Cannot create opensips database for postgresql using opensips-cli<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="margin:0in;margin-bottom:.0001pt"><em><b><span style="color:blue">Attention:</span></b><span style="color:blue"> 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.</span></em><o:p></o:p></p>
<p style="margin:0in;margin-bottom:.0001pt"> <o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Greetings, <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I am trying to create opensips database using opensips-cli module but each time it is failing. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I am getting below error during the process. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">(opensips-cli): database create<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Please provide the URL of the SQL database: postgres://<a href="mailto:opensips%3Aopensipsrw@127.0.0.1">opensips:opensipsrw@127.0.0.1</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR: cannot connect to DB server: (psycopg2.OperationalError) FATAL: database "opensips" does not exist<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Traceback (most recent call last):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> func = getattr(self, 'do_' + cmd)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">During handling of the above exception, another exception occurred:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Traceback (most recent call last):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1044, in _do_get<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return self._pool.get(wait, self._timeout)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/util/queue.py", line 145, in get<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> raise Empty<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">sqlalchemy.util.queue.Empty<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">During handling of the above exception, another exception occurred:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Traceback (most recent call last):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return fn()<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return _ConnectionFairy._checkout(self)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 713, in _checkout<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> fairy = _ConnectionRecord.checkout(pool)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 480, in checkout<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> rec = pool._do_get()<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> self._dec_overflow()<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> compat.reraise(exc_type, exc_value, exc_tb)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> raise value<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return self._create_connection()<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return _ConnectionRecord(self)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 449, in __init__<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> self.connection = self.__connect()<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 607, in __connect<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> connection = self.__pool._invoke_creator(self)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return dialect.connect(*cargs, **cparams)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 385, in connect<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> return self.dbapi.connect(*cargs, **cparams)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 126, in connect<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> conn = _connect(dsn, connection_factory=connection_factory, **kwasync)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">psycopg2.OperationalError: FATAL: database "opensips" does not exist<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Any help here is much appreciated. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Ryan. <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>