[OpenSIPS-Users] I am facing some issue while creating DB through opensips-cli .

[Sasmita Panda]

Hi All ,

I am a first time user of opensips-cli .  this installed successfully . I
have created a config file with all the details like below .

[default]
database_modules: All
[mysql]
database_admin_url: mysql://root:cccl0g1c@localhost/opensips
database_url:  mysql://opensips:opensipsrw@localhost
database_schema_path: ./opt/opensips-3.1/scripts

I am running command
opensips-cli -f /opt/opensips-cli/etc/opensips-cli.cfg -x database create
opensips -d

DEBUG: using config file /opt/opensips-cli/etc/opensips-cli.cfg
DEBUG: Loaded module 'user'
DEBUG: fifo file /tmp/opensips_fifo does not exist!
DEBUG: Skipping module 'mi' - excluded on purpose
DEBUG: Loaded module 'tls'
DEBUG: Loaded module 'database'
DEBUG: Loaded module 'instance'
DEBUG: Loaded module 'trace'
DEBUG: Loaded module 'diagnose'
DEBUG: Loaded module 'trap'
DEBUG: running in non-interactive mode '['database', 'create', 'opensips']'
DEBUG: running command 'create' '['opensips']'
DEBUG: db_name: 'opensips'
Password for admin MySQL user (root):
DEBUG: read password: 'cccl0g1c'
DEBUG: admin DB URL: 'mysql://root:cccl0g1c@localhost'
DEBUG: connecting to mysql://root:cccl0g1c@localhost
DEBUG: check database URL 'mysql://root:cccl0g1c@localhost/opensips'
DEBUG: DB does not exist
DEBUG: Create Database 'opensips' for dialect 'mysql' ...
DEBUG: success
DEBUG: DB URL: 'mysql://opensips:opensipsrw@localhost'
DEBUG: connecting to mysql://opensips:opensipsrw@localhost/opensips
INFO: creating access user for opensips ...
INFO: created user 'opensips'
/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/default.py:552:
Warning: 'SET PASSWORD FOR <user> = PASSWORD('<plaintext_password>')' is
deprecated and will be removed in a future release. Please use SET PASSWORD
FOR <user> = '<plaintext_password>' instead
  cursor.execute(statement, parameters)
INFO: set password 'o********w' for 'opensips' (MariaDB)
INFO: granted access to user 'opensips' on DB 'opensips'
INFO: flushed privileges
DEBUG: connecting to mysql://opensips:opensipsrw@localhost/opensips
DEBUG: check database URL 'mysql://opensips:opensipsrw@localhost/opensips'
DEBUG: DB 'opensips' exists
*ERROR: path '/usr/share/opensips' to OpenSIPS DB scripts does not exist!*

In the config file I have specified the database_schema_path still why its
searching in '/usr/share/opensips' .

What should I do to avoid this error .

*Thanks & Regards*
*Sasmita Panda*
*Senior Network Testing and Software Engineer*
*3CLogic , ph:07827611765*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201120/30da49bf/attachment.html>