Installing OwnCloud 9 on CentOS 7 with REMI\EPEL, PHP 5.6, Apache 2.4, MariaDB and SSL

Alex Sage

It almost all works. Any suggestions welcome

The SQL isn't working yet.....

scottalanmiller

What database error are you getting?

Alex Sage

@scottalanmiller No errors.

The commands to secure MySQL and create the database with proper permissions don't work right yet. The last 17 lines.

Alex Sage

Do I need to encapsulate the variables in quotes?

scottalanmiller

@aaronstuder said:

Do I need to encapsulate the variables in quotes?

I think that the command needs to be in quotes. I don't script MySQL commands that way often so am not familiar with the syntax. I use SQL inside MySQL regularly, but not this way. But that looks like a case where quotes would be needed.

Alex Sage

I take it back, it seems the securing MySQL part works fine.....

The problem is here:

echo Setting Up MySQL
mysql -u root -p $mysqlroot -e create database $ownclouddb;
mysql -u root -p $mysqlroot -e create user '$ownclouduser'@'localhost' identified by '$ownclouduserpassword';
mysql -u root -p $mysqlroot -e grant all on $ownclouddb.* to '$ownclouduser'@'localhost';
mysql -u root -p $mysqlroot -e flush privileges;

Alex Sage

@scottalanmiller

So you mean:

mysql -u root -p $mysqlroot -e create database $ownclouddb;

Becomes:

mysql -u root -p $mysqlroot -e "create database $ownclouddb;"

?

scottalanmiller

@aaronstuder Correct

dsc81

Hi,
I would like to thank you for your guide. It works great. Can you provide additional information e.g how to upload a big file, or how to upload a lot of file maybe 2000 files, 3000 files at once?
Thanks

scottalanmiller

@dsc81 said:

Hi,
I would like to thank you for your guide. It works great. Can you provide additional information e.g how to upload a big file, or how to upload a lot of file maybe 2000 files, 3000 files at once?
Thanks

What kind of info do you want about that? The sync tool will handle that for you. There isn't any magic answer, a large upload will take quite some time.

dsc81

@scottalanmiller
What I mean is I only can upload one file at a time, I heard that we can setting so we can upload many file at once and also the limit is only 2mb, can we upload file 5GB?

JaredBusch

@dsc81 said:

@scottalanmiller
What I mean is I only can upload one file at a time, I heard that we can setting so we can upload many file at once and also the limit is only 2mb, can we upload file 5GB?

You need to configure your system to fix the PHP issue restricting filesize.

You have multiple options for connectivity. if you are using the web browser, the basic setup is single file uplaods.