Owncloud 8 and MySQL: alternative approach

Hi!

I have successful installed owncloud 8, as explained in this thread. However I cant upload files bigger than 2M (yes 2 megabytes). And it gives me the following error: "The uploaded file exceeds the upload_max_filesize directive in php.ini: 10G"

Any suggestions?

Thanks

Yes it was... I forgot it.... Thanks!

I had a problem with my SSL certificate (HSTS) and have found out that it has been fixed within a new Owncloud 8 version.
I installed it and it's working great
Under Data Performance Info there is a message that Ownlcoud is using a SQlite database.
Is this a problem,or is it easy to install the normal MySQL or MariaDB?

The Owncloud version within the plugin looks outdated version 6
Isn't it vulnerable for hacks?
What i see the only disadvantage with this install is that the users aren't synct.
But now you get all of the updates from Owncloud.

Thanks for the alternative approach

I have installed it with setup-owncloud.php but forgot to enable mysql.
After a message i enabled it.

Tried to delete Owncloud and the database to begin over again but made the fault by deleting the sql database directory.
That wasn't the best way because i needed to delete and reinstall all the databases.
But now i was able to make a new database.

Only i have a problem with setting a MySQL root password.
I have changed it within the MySQL app i pressed save and then apply.
But it doesn't change
After a while i just tried to install Owncloud with no password but hope i can change it for security reasons

I can now login to MyWebSQL and see that there are 7 users and a change password tap.
Can i just change all the users to another password or is there another way?

These are the users:
root@localhost
debian-sys-maint@localhost
oc_admin@%
oc_admin@localhost
root@127.0.0.1
root@::1
root@"myservername"

The Data Performance Info was found within the admin screen of OwnCloud
After a reinstall i don't see the message anymore.

Thanks, everything is working great now

I have make a guide for use file2ban with owncloud
[GUIDE] file2ban and owncloud

Hi guys,

I followed this tutorial , and I got stuck during the mySQL password creation.
But I got it fixed.

I'm able to log in owncloud, and create users.

My questions:

1. Do I need to use mysql to create user or anything ?
I'm assuming use OC web-gui for user creation, and external storage mapping...

2. I upload the user_openmediavault plugin into the /var/www/owncloud/apps, but I don't see it in the admin apps console.

3. Why the Nginx's Pool User, and Group aren't saved after I chose www-data for both, and click Save?

4. I'm also getting this error in OC portal:

php does not seem to be setup properly to query system environment 
variables. The test with getenv("PATH") only returns an empty response.


		Please check the installation documentation for php configuration 
notes and the php configuration of your server, especially when using 
php-fpm.	


	No memory cache has been configured. To enhance 
your performance please configure a memcache if available. Further 
information can be found in our documentation.
The "Strict-Transport-Security" HTTP header is not configured to least 
"15768000" seconds. For enhanced security we recommend enabling HSTS as 
described in our security tips.


		Please double check the installation guides ↗, and check for any errors or warnings in the log.

Hi Enra,

Thanks for the response.

Regarding to question 3, I was talking about where you show the screenshot of 'Configure nginx; Add a pool in nginx'.

I select www-data for both group & user, then click save, but when I reopen it, it shows blank.

I'm going to use your screenshot instead b/c I don't have mine at the moment.
I wonder if the pool settings of group/user should be saved after I click save.

Thanks, I'm going to re-install this OC again tonight.

If I install the OC in the root folder of /www/owncloud, put in the dot, would my external url be http://www.mydomain.com/owncloud ?

FYI:
Something is weird going on w/the Nginx plugin.
The user/group selection sometimes display properly and sometimes isn't, regardless whether I using Firefox or Chrome.
However, the settings are saved properly in the /etc/php5/fpm/pool.d/xxxxxxxxxxxxxxxxxxx.conf

I finally got OC installed after 5 attempts, mysQL is a pain in the @ss!
It almost ruin my OMV server.

Anyway, whenever I connect to OC via LAN or WAN, i have to specified the port number for it in order to connect.
Is there a way to connect without put in the port number such as http://www.abc.mydomain.com:8443 ?
Can my OC CN (common name) be http://www.xyz.mydomain.com:8443?

on owncloud 8.1 i have an error on the admin side:

PHP scheint zur Abfrage von Systemumgebungsvariablen nicht richtig eingerichtet zu sein. Der Test mit getenv ("PATH") liefert nur eine leere Antwort zurück. Bitten überprüfe die Installationsdokumentation auf Hinweise zur PHP-Konfiguration sowie die PHP-Konfiguration Deines Servers, insbesondere dann, wenn Du PHP-FPM einsetzt.

sorry, it's in german
everybody have an idea?
Do i need options in my nginx pool or changing my nginx config?

I have the same error as yours.
I think this is the answer:

Zitat

Configuration notes to php-fpm¶System environment variables

When you are using php-fpm, system environment variables like PATH, TMP or others are not automatically populated in the same way as when using php-cli. A PHP call like getenv('PATH'); can therefore return an empty result. So you may need to manually configure environment varibles in the appropropriate php-fpm ini/config file.

Here are some example root paths for these ini/config files:

Ubuntu/MintCentOS/Red Hat/Fedora/etc/php5/fpm//etc/php-fpm.d/In both examples, the ini/config file is called www.conf, and depending on the distro version or customizations you have made, it may be in a subdirectory.

Usually, you will find some or all of the environment variables already in the file, but commented out like this:

;env[HOSTNAME] = $HOSTNAME
;env[PATH] = /usr/local/bin:/usr/bin:/bin
;env[TMP] = /tmp
;env[TMPDIR] = /tmp
;env[TEMP] = /tmp

Uncomment the appropriate existing entries. Then run printenv PATH to confirm your paths, for example:

$ printenv PATH
/home/user/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:
/sbin:/bin:/

If any of your system environment variables are not present in the file then you must add them.

When you are using shared hosting or a control panel to manage your ownCloud VM or server, the configuration files are almost certain to be located somewhere else, for security and flexibility reasons, so check your documentation for the correct locations.

Please keep in mind that it is possible to create different settings for php-cli and php-fpm, and for different domains and Web sites. The best way to check your settings is with phpinfo().

Maximum upload size

If you want to increase the maximum upload size, you will also have to modify your php-fpm configuration and increase the upload_max_filesize and post_max_size values. You will need to restart php5-fpm and your HTTP server in order for these changes to be applied.

Alles anzeigen