"internal server error" while trying to create SQLITE DB?

[mathieumd]

Hello,

I'm trying to setup a fresh ASM3 v46, installed from official Debian repo.

After configuring /etc/asm3.conf:

db_type = SQLITE # MYSQL, POSTGRESQL, SQLITE or DB2
db_name = /srv/www/asm3_db/asm3.sqlite

And making sure perms are good (Apache is running as www-data):

stat /srv/www/asm3_db/ |grep Uid
Access: (0755/drwxr-xr-x)  Uid: (   33/www-data)   Gid: (   33/www-data)

The website redirects to /database, but when I click on Create Database button, I only get internal server error, and the log (alghouth debug is enabled) just says:

dbupdate.install_default_data creating default database schema

What did I miss?

[bobintetley]

I can't see anything wrong with what you're doing. What do the Apache error log files say?

[mathieumd]

Traceback (most recent call last):, referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/web062/application.py", line 281, in process, referer: https://asm.example.com/database
    return self.handle(), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/web062/application.py", line 272, in handle, referer: https://asm.example.com/database
    return self._delegate(fn, self.fvars, args), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/web062/application.py", line 518, in _delegate, referer: https://asm.example.com/database
    return handle_class(cls), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/web062/application.py", line 496, in handle_class, referer: https://asm.example.com/database
    return tocall(*args), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/code.py", line 396, in POST, referer: https://asm.example.com/database
    return self.post_all(o), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/code.py", line 526, in post_all, referer: https://asm.example.com/database
    asm3.dbupdate.install(dbo), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbupdate.py", line 2669, in install, referer: https://asm.example.com/database
    install_db_structure(dbo), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbupdate.py", line 2509, in install_db_structure, referer: https://asm.example.com/database
    dbo.execute_dbupdate(s.strip()), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbms/base.py", line 316, in execute_dbupdate, referer: https://asm.example.com/database
    return self.execute(sql, params=params, override_lock=True), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbms/base.py", line 304, in execute, referer: https://asm.example.com/database
    raise err, referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbms/base.py", line 284, in execute, referer: https://asm.example.com/database
    c, s = self.cursor_open(), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbms/base.py", line 148, in cursor_open, referer: https://asm.example.com/database
    c = self.connect(), referer: https://asm.example.com/database
  File "/usr/lib/sheltermanager3/asm3/dbms/sqlite.py", line 18, in connect, referer: https://asm.example.com/database
    return sqlite3.connect(self.database, detect_types=sqlite3.PARSE_DECLTYPES | sqlite3.PARSE_COLNAMES), referer: https://asm.example.com/database
sqlite3.OperationalError: unable to open database file, referer: https://asm.example.com/database
, referer: https://asm.example.com/database

(Real FQDN replaced by asm.example.com)

[mathieumd]

Got it!

I modified my Apache vhost conf (copied from /etc/apache2/sites-available/asm3.conf) by removing the sub-folder /asm3:

+WSGIScriptAlias / /usr/lib/sheltermanager3/code.py/
-WSGIScriptAlias /asm3 /usr/lib/sheltermanager3/code.py/
+Alias /static /usr/lib/sheltermanager3/static
-Alias /asm3/static /usr/lib/sheltermanager3/static

And of course also updated base_url and service_url in /etc/asm3.conf.

Which was why I got this Internal server error. Adding back this /asm3 did allow to create database.

As I dedicated a subdomain to ASM3, I don't need this sub-folder, and URL would be simpler for users without it.

[mathieumd]

But both /srv and /srv/www are world readable and executable (0755).

Coult it be that it cached my first run, where I did not set db_name, and then it got the default asm value?

[bobintetley]

Possibly - if you changed db_name without restarting Apache?

[mathieumd]

That's it, then!
As changing base_url and service_url are taken into account without restarting Apache, I did not though some other options would.

[bobintetley]

The config file is only read once on startup, so any change to it requires a restart to Apache :)

[mathieumd]

Maybe when the DB is not created yet?
Anyway, thank you very much for your help!