Re: [dl-ticket-service] Database problem

2017-10-11 Thread Yuri D'Elia
On Wed, Oct 11 2017, Blair Alper wrote:
> I installed dl. When I got to creating a user, I get the message
> "cannot initialize database." I also get the same message when
> attempting to access the web interface. The database file exists and
> the permissions appear correct.

So you did initialize the DB using sqlite3 -init ... and then used
useradmin.php to create an initial user?

> /var/spool/dl
> drwxr-xr-x 2 www-data www-data 4096 Oct 10 21:06 data
> -rw-rw 1 www-data www-data 17408 Oct 11 07:09 data.sdb

Check that /var/spool/dl itself is owned by www-data.
sqlite needs to be able to create lockfiles in it.

> user and password to NULL in confwrap.php. Is there a missing step in
> the instructions about creating a database user?

The main steps are:

- create directories
- initialize the empty database (sqlite3 -init ...)
- create first user (using useradmin.php)




[dl-ticket-service] Database problem

2017-10-11 Thread Blair Alper
I installed dl.  When I got to creating a user, I get the message 
"cannot initialize database."  I also get the same message when 
attempting to access the web interface.  The database file exists and 
the permissions appear correct.


/var/spool/dl
drwxr-xr-x 2 www-data www-data  4096 Oct 10 21:06 data
-rw-rw 1 www-data www-data 17408 Oct 11 07:09 data.sdb

I tried setting the $dbUser and $dbPassword variables.  I also tried 
leaving the three variables commented out.  I see that this sets the 
user and password to NULL in confwrap.php.  Is there a missing step in 
the instructions about creating a database user?