Topic: [SOLVED] OwnCloud install database issues

[guest22]

Hi,

I'm installing OwnCloud 9.02. Once filled out all credentials in the installation wizard, it returns an error. The log shows the wizard want's to create the database, whilst it already there since I created it manually.

Any idea how to solve this?


TIA

[guest22]

Hmmm, it seems that they have dropped the ability to skip the database creation, and that you _have_ to use the Mysql root credentials initially. Don't know if I like that at all....

Hmmm #2 and a minimum of MySQL 5.5....

Need to change the wiki page then...

[DanB35]

Hmmm #2 and a minimum of MySQL 5.5....

Is this documented somewhere?  Because I'm running owncloud 9.02 with mysql 5.1.73 (the version that ships with SME9), and I'm not having any issues or getting any errors/warnings with it.

Edit:  Sorry, I'm on 9.01--for some reason they take quite a while to get new versions into the updater app.

[guest22]

Hi Dan,

It's documented here https://doc.owncloud.org/server/9.0/admin_manual/installation/system_requirements.html

Can you advise me what procedure you followed to get OwnCloud 9.0.2 running on SME Server 9.1 please?

TIA
guest

[guest22]

It's up and running. It seems that indeed, the default version of SME Server 9.1 is sufficient to run OwnCloud 9.0.2.

What is not documented clearly or even at all is that you need to enable the InnoDB engine before installation...

https://wiki.contribs.org/MySQL#Enable_InnoDB_engine

[DanB35]

Can you advise me what procedure you followed to get OwnCloud 9.0.2 running on SME Server 9.1 please?

I don't recall needing to deviate from the wiki's instructions, but it's been a while since I did the initial install.  I'll try testing the wiki's procedure end-to-end and see what happens.

[mmccarn]

I've installed other webapps where the db user needed to have "grant options".

Modify the owncloud wiki instructions from this:

Code: [Select]

mysql
create database owncloud;
grant all privileges on owncloud.* to username@localhost identified by 'password';
flush privileges;
exit

to this:

Code: [Select]

mysql
create database owncloud;
grant all privileges on owncloud.* to username@localhost identified by 'password' with grant option;
flush privileges;
exit

If that doesn't help, the next thing I'd try would be to add the db info into config.php (there's some code in OC/lib/private/setup/mysql.php that I think changes the behavior if there's a username in config.php):

Code: [Select]

  ...
  'dbtype' => 'mysql',
  'dbname' => 'owncloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'username',
  'dbpassword' => 'put-your-password-here',
  ...


[DanB35]

I've installed other webapps where the db user needed to have "grant options".

There's no reason the grant option should be needed here--that's important only if the new database user needs to be able to add other database users and/or grant access privileges to other users.  There's no reason the owncloud database user should need to do this.

@RequestedDeletion, I can confirm that the wiki's instructions work on a clean SME 9.1 install, with all updates, to install Owncloud 9.02, once you set mysql to use innodb.  That last bit surprises me a bit, as I don't see it documented anywhere either.

[Jean-Philippe Pialasse]

There is currently a switch to use innodb as default with mysql/mariadb newest versions.

It will be enabled by default with sme10 as mariadb will refuse to start otherwise. Maybe the switch will be needed to be done for sme9 too

Thank you for your work on owncloud.

[guest22]

FYI https://nextcloud.com/news/ vs https://owncloud.org/blog/owncloud-statement-concerning-the-formation-of-nextcloud-by-frank-karlitschek/

[DanB35]

FYI https://nextcloud.com/news/ vs https://owncloud.org/blog/owncloud-statement-concerning-the-formation-of-nextcloud-by-frank-karlitschek/

Interesting, and somewhat disappointing, though I guess that's part of the beauty of open source--if a project isn't going in the direction you want, and you have the skill, you can fork it so that it does.  It's interesting to me that nextcloud is spending so much time talking about updates--that's probably the greatest frustration for me (9.0.2 was released about a month ago, and still doesn't appear in the updater app; a manual update requires at least a couple of hours' of downtime).  OTOH, if that's the greatest frustration, that must mean the rest of owncloud is working pretty well.

[guest22]

FYI, NextCloud is out...


https://nextcloud.com/install/

[DanB35]

...and the upgrading steps from the wiki (https://wiki.contribs.org/OwnCloud#Upgrade) work perfectly to migrate from owncloud to nextcloud.