So, upgraded to 3.3.0, latest Dashboard etc. Connecting to the OwnCloud setup page is not a problem. The issue comes when i try to go to the next step using MySql.
I have MySql Installed and can successfully login to it’s admin panel.
Here is the message I’m getting no matter what i do. I’m sure it’s something simple that i’m over analyzing.
Error
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[28000] [1045] Access denied for user ‘root’@‘localhost’ (using password: YES)
Assumptions:
OC Username & Password will be created by what is put in. example OCuser/OCpassword when it finally connects and you get the next screen.
Since I am logged in via port 8033 in Mysql as root using the password that DroboApp set for me, the same password and username must be used in the OC configure DB section i.e. root/sql_long_password right?
“Database host” should be “localhost”, “127.0.0.1” or “::1” as all three are listed as users in MySQL with Global permissions = all.
DataFolder Default: “/mnt/DroboFS/Shares/DroboApps/owncloud/app/data” is still there but is not reflected in the error message. Figured we could change that later but this is where all synced files should be stored?
Lastly DB Name “ocdb” was chosen.
Question:
We are obviously missing something. we think the db should be created if successful connection but maybe we need to create the db first? I don’t understand how we can connect to MySQL in browser on port 8033 as this:
Localhost MySQL - Source distribution 5.6.26
Logged in as: root@localhost
Yet when we use “root” and the same password in OC setup page we get the message above.
Sorry for the length, just trying to be complete with all information.
Yes, I believe you have to create the database first (in your case, “ocdb”), then ownCloud will create its own tables in it. That’s what I did and I’ve never seen the message you’re getting.
There is a script to create the database for you, if you know your way around a Linux shell. You can find it under DroboApps/mysql/scripts/mysql_create_db.sh. The script has a help screen, and is pretty self explanatory.
Thanks Harrv, I did that also and still the message. I’m assuming there is not DB Password only the root password is needed as i can’t seem to find a way to assign a pw to the db.
Anyway, Ricardo… I don’t know my way around linux shell but i’ll give it a shot, thanks for the reference.
so one other thing… maybe OC won’t do what we are hoping to accomplish anyway and i’ve never really seen a good example of it other than the web interface. We currently use Transporter on a separate drive to sync via GoodSync to the drobo5n folders that we want to share. This little bit of data that we need access to remotely is duplicated but it’s not a big deal. However, with Transporter, we can access the files directly and use them. For example, I can see Transporter as a drive on the OS (windows and OS X) and things like word documents can be opened and edited then when saved, they are saved back to Transporter first and then godsend recognizes the changes and syncs the changes back to Drobo. The most important part of this is label templates that we use daily across multiple machines as well as config files for the multiple printers. This setup, while a little cumbersome with GoodSync in the middle is working and we are hoping that OC can eliminate that middle step of syncing. by sharing the share or share subfolders directly as mountable drives on our computers. If the file can’t be physically opened without being downloaded maybe we just need to give up on OC lol. Any advise on if the data is accessible as a mounted drive?
Harrv is right. You have to create a new database, and then create a new user account with rights to access that database. It is not that complicated, it is just that it takes a couple of long-ish commands to get it right. This is why I recommended using the script.
Harrv is right, I just used the MyWebSQL to create an OwnCloud DB. Also, I don’t think it’s required, but I created a new user with no global privileges but with full privileges on the OwnCloud DB that I used for OwnCloud setup.
Creating a new user without global privileges is not strictly required, but is highly recommended. Using the root account is a big no-no, since the root password can be changed at any time, which will break OwnCloud.
To summarize: if you want to use OwnCloud with MySQL, please do
Login to MyWebSQL using MySQL’s root account
Create a new database
Create a new account only with permissions to the database created in step 2, chose a strong password
Configure OwnCloud with the new database, restricted account and password.