*New 12.1 series Release:
2020-04-05: XigmaNAS 12.1.0.4.7509 - released

*New 11.3 series Release:
2020-04-05: XigmaNAS 11.3.0.4.7509 - released!


We really need "Your" help on XigmaNAS https://translations.launchpad.net/xigmanas translations. Please help today!

Producing and hosting XigmaNAS costs money. Please consider donating for our project so that we can continue to offer you the best.
We need your support! eg: PAYPAL

How to run OCC command with Nextcloud / XigmaNAS

XigmaNAS Extensions / Add-ons

Moderator: crest

Forum rules
Set-Up GuideFAQsForum Rules
Post Reply
ssorg
Starter
Starter
Posts: 23
Joined: 09 Sep 2015 04:51
Location: Texas
Status: Offline

How to run OCC command with Nextcloud / XigmaNAS

#1

Post by ssorg »

Hello:

I just updated Nextcloud to v. 14.0.0 and I get the following under Security & setup warnings:

Code: Select all

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added 
automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running.
 Once the indexes are added queries to those tables are usually much faster.

    Missing index "share_with_index" in table "oc_share".
    Missing index "parent_index" in table "oc_share".
    Missing index "fs_mtime" in table "oc_filecache".
I've tried unsuccessfully to run the command "occ db:add-missing-indices" using Putty. Can anyone provide a guide on how to run the OCC command with XigmaNAS ?

Thanks in advance.
XigmaNAS 12.1.0.4.7091 embedded / ASUS M5A78L-M/USB3 / AMD FX-4300 / 32GB (4x8GB) Crucial CT2K4G4DFS8213 ECC DDR3 / LSI 9211-8i IT mode / Intel Gigabit CT / Fractal Design Define R5 / ZFS 6x4TB WD RED RaidZ2 / UPS: APC BN700MC Back-UPS / Nextcloud 17.0.5

User avatar
ms49434
Developer
Developer
Posts: 840
Joined: 03 Sep 2015 18:49
Location: Neuenkirchen-Vörden, Germany - GMT+1
Contact:
Status: Online

Re: How to run OCC command with Nextcloud / XigmaNAS

#2

Post by ms49434 »

Did you run the command as the HTTP user?
1) XigmaNAS 12.1.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U3, 22GB out of 32GB ECC RAM, LSI 9300-8i IT mode in passthrough mode. Pool 1: 2x HGST 10TB, mirrored, SLOG: Samsung 850 Pro, L2ARC: Samsung 850 Pro, Pool 2: 1x Samsung 860 EVO 1TB , services: Samba AD, CIFS/SMB, ftp, ctld, rsync, syncthing, zfs snapshots.
2) XigmaNAS 12.1.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U3, 8GB out of 32GB ECC RAM, IBM M1215 crossflashed, IT mode, passthrough mode, 2x HGST 10TB , services: rsync.

ssorg
Starter
Starter
Posts: 23
Joined: 09 Sep 2015 04:51
Location: Texas
Status: Offline

Re: How to run OCC command with Nextcloud / XigmaNAS

#3

Post by ssorg »

OK, I just ran this command and it looks like they were added, and the warning is gone:

Code: Select all

sudo -u www php occ db:add-missing-indices
So the http user is www? Interesting. I'm hoping this success will open the door to other occ commands.
XigmaNAS 12.1.0.4.7091 embedded / ASUS M5A78L-M/USB3 / AMD FX-4300 / 32GB (4x8GB) Crucial CT2K4G4DFS8213 ECC DDR3 / LSI 9211-8i IT mode / Intel Gigabit CT / Fractal Design Define R5 / ZFS 6x4TB WD RED RaidZ2 / UPS: APC BN700MC Back-UPS / Nextcloud 17.0.5

ssorg
Starter
Starter
Posts: 23
Joined: 09 Sep 2015 04:51
Location: Texas
Status: Offline

Re: How to run OCC command with Nextcloud / XigmaNAS

#4

Post by ssorg »

Also, one more issue.... When I ran the occ command there was this warning:

Code: Select all

The current PHP memory limit is below the recommended value of 512MB.
How should I address/fix this?
XigmaNAS 12.1.0.4.7091 embedded / ASUS M5A78L-M/USB3 / AMD FX-4300 / 32GB (4x8GB) Crucial CT2K4G4DFS8213 ECC DDR3 / LSI 9211-8i IT mode / Intel Gigabit CT / Fractal Design Define R5 / ZFS 6x4TB WD RED RaidZ2 / UPS: APC BN700MC Back-UPS / Nextcloud 17.0.5

adamvnz
NewUser
NewUser
Posts: 8
Joined: 12 May 2013 11:39
Location: New Zealand
Status: Offline

Re: How to run OCC command with Nextcloud / XigmaNAS

#5

Post by adamvnz »

ssorg wrote:
19 Sep 2018 14:31
Also, one more issue.... When I ran the occ command there was this warning:

Code: Select all

The current PHP memory limit is below the recommended value of 512MB.
How should I address/fix this?
I am having this issue and wanting to know if you found a fix or the solution
Thanks

ssorg
Starter
Starter
Posts: 23
Joined: 09 Sep 2015 04:51
Location: Texas
Status: Offline

Re: How to run OCC command with Nextcloud / XigmaNAS

#6

Post by ssorg »

I added the following line to the php.ini file and no longer see the warning:

Code: Select all

memory_limit = 512M
XigmaNAS 12.1.0.4.7091 embedded / ASUS M5A78L-M/USB3 / AMD FX-4300 / 32GB (4x8GB) Crucial CT2K4G4DFS8213 ECC DDR3 / LSI 9211-8i IT mode / Intel Gigabit CT / Fractal Design Define R5 / ZFS 6x4TB WD RED RaidZ2 / UPS: APC BN700MC Back-UPS / Nextcloud 17.0.5

Post Reply

Return to “Extensions / Add-ons”