Install OC 9.1 and connect to an existing db


#1

Please help us by providing the following info. Before posting please also check the pinned "Known issues" threads and make sure that you're running the latest available version for your oC release: https://owncloud.org/changelog/

Steps to reproduce
1. Fresh server build, download owncloud from official source. Unzip and configure web server.
2. Go to OwnCloud installation wizard
3. Enter in existing db name, db admin and db admin password.

Expected behaviour
Tell us what should happen
The new installation connects to the existing database.

Actual behaviour
Installation wizard fails, see logs below.
For the purpose of this SELinux has been disabled but will be enabled for production.
OwnCloud attempts to create oc_root account and fails because it already exists, and it creates another account with oc_root1 oc_root2 etc. See screenshot below:

Server configuration
Operating system: CentOS 7
Web server: Apache
Database: MySQL
PHP version: 5.4.16
ownCloud version (see ownCloud admin page): 9.1.4
Updated from an older ownCloud or fresh install: Fresh Install
Special configuration (external storage, external authentication, reverse proxy, server-side-encryption):
External Storage, external authentication, reverse proxy and server-side encryption.

ownCloud log (data/owncloud.log)

Please paste possible errors in the following code block, see https://central.owncloud.org/t/how-to-find-webserver-or-oc-logfile-enable-php-logfile/808 for more info

{"reqId":"WOTRGhPtOkSI7xOFEDnggQAAAAU","remoteAddr":"10.1.10.xxx","app":"mysql.setup","message":"Database creation failed: An exception occurred while executing 'GRANT ALL PRIVILEGES ON `owncloud` . * TO 'oc_root'':\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'oc_root'@'%' to database 'owncloud'","level":3,"time":"2017-04-05T11:12:26+00:00","method":"POST","url":"\/index.php","user":"--"}

Integrity status for oC9+

Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.
Not setup yet

Seen this post here but it references a postgres db: Post
Also seen the following 'feature' request (although i'm not sure this is a feature request more a bug?). One of the posters mentions that it should work for MySQL databases. Feature Request


Webhost won't let me create a MySQL DB user
#2

I would suggest to keep an eye on that as there is mostly nothing where we users in here can help with.


#3

That feature request is for postgres, i'm on MySQL and the feature request has been inactive since August last year. I'm sure someone on here will have an idea :slight_smile: if not i'll open a new bug.


#4

Yes, please create a new bug. Everything else doesn't make any sense IMHO (there is an issue in the installer, this needs to be fixed in oC and not worked around by some users in here).


#5

To be honest I may continue to ask for a workaround as well as a fix, as I need a second instance of OwnCloud before I push my deployment to production.

Cheers
A


#6

Git Bug opened
(https://github.com/owncloud/core/issues/27743)


#7

Closed as duplicate of https://github.com/owncloud/core/issues/25665, this request is marked as backlog.