CODEWITHSUNDEEP
owncloud
CHINMAYA DEHURY
CHINMAYA DEHURY

Reputation: 135

Unable to install owncloud

I am trying to install and setup owncloud from the scratch. I followed the steps provided in https://doc.owncloud.org/server/10.0/admin_manual/installation/source_installation.html#prerequisites-label

I have created the mysql user after installing Mariadb-server using following command

sudo apt-get install mariadb-server
sudo mysql --user=root mysql
CREATE USER ADMIN@localhost IDENTIFIED BY 'adminpass';
GRANT ALL PRIVILEGES ON *. * TO ADMIN@localhost WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

I have tried both commandline installation wizard and graphical installation wizard.

Following is the command line install wizard command

sudo -u www-data php /var/www/owncloud/occ maintenance:install --database "mysql" --database-name "funocdb" --database-user "root" --database-pass "mysql"  --admin-user "ADMIN" --admin-pass "adminpass"

But I am getting the following error:

ownCloud is not installed - only a limited number of commands are available

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

Here the screenshot of 'occ' error

occ error

While trying the same with Graphical installation wizard, I got the following error:

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'ADMIN'@'localhost' (using password: YES)

Here the screenshot of GUI error

GUI error

Upvotes: 2

Views: 1730

Answers (2)

Yamu Poudel
Yamu Poudel

Reputation: 1

Please access your database from mysqlworkbench or any mysql client and please go to owncloud database and alter oc_calendarsubscriptions.lastmodified to NN(Not Null)

Upvotes: 0

Alfageme
Alfageme

Reputation: 2145

By reading the comments I think you're mixing up the ownCloud's --admin-user and mySQL's "root" user ("ADMIN") since you mentioned that it works out using mySQL cli. From the command line, try using --database-user "admin" instead (also note that user names in mySQL can be case sensitive depending on your settings).

And from the web UI you can try to append mySQL's port no. (standard is 3306) to the host name, like the notice at the bottom of the screenshot says.

Upvotes: 0

Related Questions