net2wire

Members
  • Posts

    107
  • Joined

Everything posted by net2wire

  1. I usually like to keep the volume mappings / hosts path as simple and recognizable to me as possible. The Container volume mapping for ownCload is /var/www/owncloud/data , and my Host path is /mnt/user/Data/owncloud-mariaDB. The reason I named it with -mariaDB is that I have two versions, the original owncloud sqlite install (/mnt/user/Data/owncloud). Basically all my Dockers and Phaze plugins are all under /mnt/user/Data/... hope that was helpful.
  2. Okay I get it now. I completely disregarded the GPU process. Makes more sense when you put it that way. LOL, I do have one more noob question tho. Correct me if I'm wrong but don't Intel and AMD cpu's come HD (gpu's) built into the processor, and perhaps use the full capability of those GPU's by coding the image in that way? I think the XEON's and maybe Opteron's don't have that capability but cpus (apu's) like the Intel i5 and i7 and AMD A and FX series do. Possible?
  3. I have a question about the cpu% used by ubuntu rdp that I'm testing. I notice that it's the only process that's consistently above 14% at any given time and it doesn't go below that and at times peaks to 25%. I have 10 plugins and 3 docker apps running all the time and none of them come close the constant 14%+ of this app. I presume this is not normal?
  4. Thanks again to cirkator for suggesting HeidiSQL. Did a fresh install of ownCloud using MariaDB and everything seems to be functioning as well as I expected. Firstly I recommend that MariaDB be installed, then setting Root password using HeidiSQL, then install ownCloud. Before completing ownCloud installation, at the Add Container Gui, click Advanced View and scroll down to the Environment Variables section and notice the Variable Name and Variable Value. This is used to create your SSL Cert. The Variable Value can be changed to anything you need: /C=US/ST=CA/L=City/O=Organization/OU=Organization Unit/CN=yourhome.com to this: /C=US/ST=NY/L=Buffalo/O=Elm DataCenter/OU=TechOps/CN=mycloud.elmdata.com You can of course include a domain or subdomain that you use to point to your home network (via dynamic dns or other means). I'm assuming that MariaDB and ownCloud will be installed with default ports, and your (Volume Mappings) Host path mapped to your desired location. 1. Simply login to MariaDB with HeidiSQL using the unRAID's IP address with root as username with no password. 2. In HeidiSQL click on Tools then choose User Manager. Find Root and change password. 3. While in HeidiSQL might as well create the ownCloud database and ownCloud user: ex: ocowner 3.A. on the left pane right click your mouse, choose Create new -> Database , and name it what you like ex: owncloud and click OK. 3.B. Click on Tools -> User Manager -> Click Add at the upper left corner -> enter User name, then choose From host (its your preference but I suggest your local LAN), enter password twice, 3.C. then at Allow access to: you may Add object (your preference but I would choose your database to start with and select the entire Database ). I did not choose Global privileges as I believe this will be like adding MariaDB root privileges to ownCloud root user, and this is not desired or necessary IMHO. YMMV. 3.D. Click Save. Exit HiediSQL if you wish. 4. Once ownCloud is installed you can open a browser and go to https://yourlocalhost:8000 and enter a new Admin account and Password, and also choose MariaDB database as install. The rest is your preference. 5. I do recommed after logging in and setting up ownCloud admin settings to winSCP to your unRAID server and find the config.php file for ownCloud, example: /mnt/user/appdata/owncloud/config . You will find config.php under the config folder. Double click the config.php file to open it. It will look like the below code, but be aware that the IP address is specific to my unRAID Tower and mycloud.elmdata.com was added as a trusted domain, that obviously also matches the CN of the SSL cert that was set up in the Environment Variables section in the Add Container section for ownCloud . By adding the URL mycloud.elmdata.com to the config.php there will not be an error on the browser when trying to login to the server from the outside world. I access my server using https://mycloud.elmdata.com by itself. My router port forwards port 80 to https://192.168.100.100:8000. All is good. <?php $CONFIG = array ( 'instanceid' => 'och68ppxik6u', 'passwordsalt' => 'zr0VoAt4/JPiv82RlhcSByxg7c2N9O', 'secret' => 'VbYA4LSzIT0.1Vvg6.amPzTZGtv6RZD13QU9zC9FaddmWfncnotmyrealsecret', 'trusted_domains' => array ( 0 => '192.168.100.100', 1 => 'mycloud.elmdata.com', ), 'datadirectory' => '/var/www/owncloud/data', 'overwrite.cli.url' => 'https://192.168.100.100:8000', 'dbtype' => 'mysql', 'version' => '8.0.2.0', 'dbname' => 'owncloud', 'dbhost' => '192.168.100.100', 'dbtableprefix' => 'oc_', 'dbuser' => 'oc_elmerfudd', 'dbpassword' => 'icantwaitforsummerdeargod', 'installed' => true, 'loglevel' => 0, 'mail_smtpmode' => 'smtp', 'mail_from_address' => 'support', 'mail_domain' => 'elmdata.com', 'mail_smtphost' => 'imap.elmdata.com', 'mail_smtpport' => '465', 'mail_smtpauth' => 1, 'mail_smtpauthtype' => 'PLAIN', 'mail_smtpsecure' => 'ssl', 'mail_smtpname' => '[email protected]', 'mail_smtppassword' => 'itstoodamncoldthiswinter', 'forcessl' => true, );
  5. Awesome! Thank you. HeidiSQL works like a charm. Interesting though how I had to add/change the password several times.
  6. I took jonp's advice from a previous post and started to play around with ownCloud for the first time and I must say that it was fairly easy to install this docker. Thanks gfjardim for making this docker available. Generally installing a docker application seems straight forward enough but while reading the previous posts and referring to ownCloud's documentation it seems as though a more robust database server can be used for ownCloud when using it for a large number of accounts and also for real time data syncing. I noticed that thegizzard had some initial issues with MariaDB and getting it to work with ownCloud and even though thegizzard seems to have worked out the issues with MariaDB and ownCloud there is very little documentation provided on how to proceed with the SQLite to MariaDB conversion. I have MariaDB installed but I can't go no further at this point as I have not idea how to access MariaDB config files to change Root password and to create the necessary account info for ownCloud. Even adding phpMyAdmin is a chore with no real guidance on how and where to install it. It would be of great help to others if the instructions on how to roll out MariaDB with ownCloud was posted.