Server: occ install doesn't create DB

Created on 22 May 2017 · 18Comments · Source: nextcloud/server

Steps to reproduce

Install Nextcloud 12 with .occ and set DB name
Notice that DB is not created
Create a DB manually
Run .ooc install again
Notice that Nextcloud successfully installs

https://github.com/nextcloud/vm/blob/master/nextcloud_install_production.sh#L268 (added the workaround until this is fixed)

Expected behaviour

DB should be created during install.

Actual behaviour

DB is not installed.

Error message in red that admin couldn't connect to DB because it doesn't exists

Server configuration

Operating system:
Ubunt Server 16.04
Web server:
Apache 2.4
Database:
MySQL 5,7
PHP version:
7.0

Ref similar issue from before https://github.com/nextcloud/server/issues/2661

0. Needs triage bug install and update needs info stale

Source

enoch85

Most helpful comment

Why should nextcloud create the database?

It's convenient. Simple as that. :)

For me though, I don't need it anymore since it's been implemented in the VM to create a DB before occ:install is run ever since this issue arise.

I would be OK with closing.

enoch85 on 6 Jul 2019

👍2

All 18 comments

https://github.com/nextcloud/server/issues/5034

enoch85 on 23 May 2017

We had the same situation with NC11 → #2646 which was fixed by this pull request

lightonflux on 23 May 2017

@lightonflux how is it possible that something that was fixed in nc11 is not in the code of nc12? maybe bad merges?

tessus on 24 May 2017

@tessus Was merged properly and the code is still there.

lightonflux on 24 May 2017

@lightonflux Still doesn't work, so the fact that the code is still there doesn't change anything.

enoch85 on 9 Jun 2017

@rullzer Can you please have a look at this?

enoch85 on 21 Jul 2017

I'm surprised that this isn't fixed yet.

enoch85 on 27 Jul 2017

I´m having this problem using the VM downloaded from your web, any fix?

arodriguezf on 1 Sep 2017

@arodriguezf Nextcloud is already installed in the VM, so I don't understand how you can have this issue?

enoch85 on 1 Sep 2017

@MorrisJobke Is this in NC 13 now? Haven't tested as I create a DB per default in the scripts before Nextcloud is installed.

enoch85 on 16 Feb 2018

@MorrisJobke Is this in NC 13 now? Haven't tested as I create a DB per default in the scripts before Nextcloud is installed.

Don't know. Haven't tested again.

MorrisJobke on 16 Feb 2018

Still occuring @enoch85 ?

skjnldsv on 6 Jun 2019

@skjnldsv Have to test it, solved it by creating the DB before so it worked since. But it's a workaround, not a fix to the real issue.

Will let you know.

enoch85 on 6 Jun 2019

This issue has been automatically marked as stale because it has not had recent activity and it seems to be missing some essential informations. It will be closed if no further activity occurs. Thank you for your contributions.

nextcloud-stale[bot] on 6 Jul 2019

Why should nextcloud create the database? Many users are confused because nextcloud creates a database user on setup. I would prefer that nextcloud just uses the provided credentials and print some warning if the db is missing or has the wrong charset. Would like to hear your opinion @enoch85