Installing ownCloud 9.0.1
-
@travisdh1 said in Installing ownCloud 9.0.1:
@scottalanmiller said in Installing ownCloud 9.0.1:
@StrongBad said in Installing ownCloud 9.0.1:
@travisdh1 said in Installing ownCloud 9.0.1:
@alex.olynyk It's most likely something wrong in the setup scripts. I don't know if it'll be glaringly obvious as the path error was or not yet.
I don't believe that the scripts are supposed to handle any of that.
That's correct. If you follow my instructions here: http://mangolassi.it/topic/8399/installing-owncloud-9-on-centos-7 it explains that you have to make the database manually and when to do so and when to put in the details.
On mine, my database is external to the ownCloud instance so a big different than doing it locally. Same basics, of course.
It's throwing that error even after creating a new database and user for said database. From some of the errors I've been seeing, it looks like the script may not be reading the variable for the database username correctly.
So I've gotten to the point where you create the admin username/password, set the data folder location, and enter your database information. The database is ready, the user I created for it has full permissions for that database. The error is:
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[42000][1044] Access denied for user 'oc_admin'@'localhost' to database 'owncloud'
Well duh, 'oc_admin' is NOT what is entered in the Database user box.
-
I get something similar
-
@alex.olynyk said in Installing ownCloud 9.0.1:
I get something similar
From your ssh / terminal session, open up mariadb like this:
mysql -u ownclouduser -p
Enter your password when prompted and show us what you get?
This is assuming that your MariaDB and your OwnCloud host are on the same system.
-
-
that seems like something is wrong, definitely works locally
-
@alex.olynyk said in Installing ownCloud 9.0.1:
Curious... So type exit or hit CTRL C to quit...
and then make sure your have the same username & password in the web form.Also, make sure you have on the web form, make sure you are using localhost or 127.0.0.1 for the Server hostname.
-
He is using localhost, that should work.
-
retyped info in web form, same error
even used 127.0.0.1
-
When I created the database and added a new user, I assigned it as 'user'@'%'. I tried it with a different user assigned to localhost only. Same error, but the username in the error message is now 'oc_admin1'@'localhost'. Other things written in php aren't acting odd for me, so not sure what's going on with this yet.
-
I did a fresh install of 9.0.2 today on CentOS 7 and have the same issue.
-
I'm beginning to worry that there isn't a working ownCloud 9.0.x install right now. Stangely, ownCloud has been totally silent here today.
-
@scottalanmiller said in Installing ownCloud 9.0.1:
I'm beginning to worry that there isn't a working ownCloud 9.0.x install right now. Stangely, ownCloud has been totally silent here today.
I'm coming to the same conclusion. I found even more oddness.
Even tho the config.php file says to use sqlite3, mysql is showing something different. Fired up mysql (MariaDB 5.5.47), and I'm looking at this:
MariaDB [(none)]> SELECT User,Host FROM mysql.user;
And really poor security on those oc_admin accounts that got created:
MariaDB [(none)]> SHOW GRANTS FOR oc_admin1;
Finally, list of all the tables in the database:
MariaDB [owncloud]> select table_name from information_schema.tables where table_schema='owncloud';
-
@travisdh1 said in Installing ownCloud 9.0.1:
@scottalanmiller said in Installing ownCloud 9.0.1:
I'm beginning to worry that there isn't a working ownCloud 9.0.x install right now. Stangely, ownCloud has been totally silent here today.
I'm coming to the same conclusion. I found even more oddness.
Even tho the config.php file says to use sqlite3, mysql is showing something different. Fired up mysql (MariaDB 5.5.47), and I'm looking at this:
MariaDB [(none)]> SELECT User,Host FROM mysql.user;
And really poor security on those oc_admin accounts that got created:
MariaDB [(none)]> SHOW GRANTS FOR oc_admin1;
Finally, list of all the tables in the database:
MariaDB [owncloud]> select table_name from information_schema.tables where table_schema='owncloud';
I'd like to know what got created. I have not tested mine upgraded install yet ofr anoything beyond "it's working" status.
