Backend Database configuration Ubuntu Server 18.04

When things doesn't work as they should.
Post Reply
najamalvi
Posts: 1
Joined: Tue Mar 12, 2019 7:01 am

Backend Database configuration Ubuntu Server 18.04

Post by najamalvi » Tue Mar 12, 2019 7:17 am

Hi Everyone,

I am new to Mayan. It looks like a great system to fulfill our requirements. I want to use it on Ubuntu Server 18.04.

I followed https://wiki.mayan-edms.com/index.php?t ... untu_18.04 to install the community version on Ubuntu server.
All installation steps went good with not error.

Now when I tried to start the server by executing: mayan-edms.py runserver
I got following error and server failed to run.

/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/apps.py:90: UserWarning: Your database backend is set to use SQLite. SQLite should only be used for development and testing, not for production.
warnings.warn(force_text(MESSAGE_SQLITE_WARNING))

/opt/mayan-edms/local/lib/python2.7/site-packages/mayan/apps/common/apps.py:90: UserWarning: Your database backend is set to use SQLite. SQLite should only be used for development and testing, not for production.


File "/opt/mayan-edms/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 198, in get_new_connection
conn = Database.connect(**conn_params)
django.db.utils.OperationalError: unable to open database file


I already configured the database as explained in the installation guide mentioned above.

My mayan.conf in /etc/supervisor/conf.d/mayan.conf
[supervisord]
environment=
MAYAN_ALLOWED_HOSTS='["*"]', # Allow access to other network hosts other than localhost
MAYAN_CELERY_RESULT_BACKEND="redis://127.0.0.1:6379/0",
MAYAN_BROKER_URL="redis://127.0.0.1:6379/0",
PYTHONPATH=/opt/mayan-edms/lib/python2.7/site-packages:/opt/mayan-edms/data,
MAYAN_MEDIA_ROOT=/opt/mayan-edms/media,
MAYAN_DATABASE_ENGINE=django.db.backends.postgresql,
MAYAN_DATABASE_HOST=127.0.0.1,
MAYAN_DATABASE_NAME=mayan,
MAYAN_DATABASE_PASSWORD=xxxxxxxx,
MAYAN_DATABASE_USER=mayan,
MAYAN_DATABASE_CONN_MAX_AGE=60,
DJANGO_SETTINGS_MODULE=mayan.settings.production

Where I can set the database settings aside from mayan.conf?

Thanks in advance for your help.

Post Reply