Page 1 of 1

CLOSED: /admin and sqlite3

PostPosted: Fri Aug 07, 2009 8:24 pm
by Steve
What use does the /admin site provide? I've logged in and I cannot determine what use to make of this.

Is /admin the sole user of the db.sqlite3 database? Does this database need to be backed up?

Why doesn't it use the Postgres database like the webadmin and webclient do?

Re: /admin and sqlite3

PostPosted: Mon Aug 10, 2009 10:20 am
by atarkowska
/admin provides the internal admin panel for OMERO.web. Right now you can add/remove OMERO.server hosts in table "Gateway". Then users can connect to them easily (not in the same time). Since 4.1 database will support queue for internal notification system what is available only in OMERO.web.

To keep the above information in sync you need to back up the database file db.sqlite3.

There is no reason why you cannot use another type of database. Django support many databases (more details is available here http://docs.djangoproject.com/en/1.0/in ... base-setup)
If you want to use PostgreSQL just install py-psycopg2 and change the following in settings.py:

Code: Select all
DATABASE_ENGINE = 'postgresql_psycopg2'
DATABASE_NAME = 'new_db_name_or_omero'  # DB name or path to database file if using sqlite3.
DATABASE_USER = 'db_user'
DATABASE_PASSWORD = 'db_password'
DATABASE_HOST = ''
DATABASE_PORT = ''