Owncloud 8,9,10 – List all Shares and Who Has Access – Save Results to CSV file

nbeam published 3 weeks ago in Linux, MySQL, Owncloud.

1

I haven’t posted in ages due to being generally slammed with work but this little piece I threw together was too good to forget about so I wanted to put it down.

If you work with a larger owncloud deployment and have a lot of users and allow file sharing, you may be curious to occasionally take a look at how many shares there are, who owns them, who they are shared with. This isn’t easy to get from the Web GUI but via the command line and mysql it isn’t bad at all.

So, login to mysql on the command line and then use your owncloud database; ie. (if your db name is “owncloud”)

use owncloud;

Then run the following:

select id, share_with, uid_owner, item_type, file_target from oc_share
INTO OUTFILE '/var/lib/mysql-files/shares.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Exit mysql command line and go to /var/lib/mysql-files and you will find a nicely formatted CSV file with a list of all shares and who they are shared with. The columns from left to right…

ID, Who it is shared with (one line per person/group), the person that owns the share, whether or not it is a file or folder, the name/location of the file/folder that is shared

Cheers…

Exchange Powershell Kung-Fu – Tracking Email and Mailboxes

nbeam published 4 months ago in Exchange, Microsoft, Powershell, Windows Administration. Tags: , , , ,

0

I am going to get right to it today. I really don’t like Microsoft Exchange. I think it is a bloated, convoluted, over-priced product. Welcome to being a Microsoft admin :).

I was recently tasked with doing a bit of investigative work on an Exchange server and determining what all was using the box for mail services. To that end, I needed to answer two questions…

What mailboxes are currently in use?
What is currently using this machine as an SMTP server to send mail out?

Below I am going to provide the powershell commands I had to figure out which helped me answer those questions. (more…)

Ubuntu – Now with LUKS? Easy to Use Full Disk Encryption

nbeam published 5 months ago in Consumer Tech, Disk Administration, Fun, Information Security, Linux, Ubuntu. Tags: , ,

0

I have decided to give Ubuntu 17.04 LTS Desktop a go. On a whim I installed it on a laptop I had lying about (being an IT person they tend to proliferate over a given period of time in my office… older units becoming doorstops, newer units lovely “Jenga” blocks and maybe the occasional Proxmox cluster…) Since this seems to be the final days of Unity (which I actually don’t mind as a Desktop all that much), I figured now was a good time to take another poke at it as a daily personal driver. I was happy to come across an option for full disk encryption during the install process and wanted to pass my few thoughts on it along. (more…)

IP Address Ordering – What order you place your IP Addresses in on a Windows Server NIC Matters

nbeam published 6 months ago in Microsoft, Networking, Server 2008 R2, Server 2012, Server 2012R2, Windows Administration. Tags: ,

0

I will keep this short and sweet. We have servers in our environment that have multiple IP addresses assigned to a single NIC. That’s normally just fine. However on occasion I will have very strange issues occur where essentially all networking appears to be working and yet web browsing won’t work. I can ping my default gateway, ping other systems in the same subnet, telnet out on port 80 and 443, etc, etc. But the network connectivity still behaves oddly. What’s the issue?

It all has to do with networking logic decisions made many years ago (I believe as far back as Windows Server 2000) by someone at Microsoft. (more…)

Ubuntu Boot Partition Fills Up Often Due to Bug – Quick Fix for Hyper-V Hosted Ubuntu Systems

nbeam published 6 months ago in Disk Administration, Hyper-V, Linux, Microsoft, Ubuntu, Virtualization. Tags: , , ,

0

I run Ubuntu 14.04 LTS servers on Hyper-V.

If you do a fairly routine install you will end up with an anemic ~250 MB boot partition. The boot partition (located at /boot) stores your Linux Kernel and everything the system needs to boot. I am sure you could have guessed that.

Next, if you have automatic security update downloading enabled, then your system is downloading new versions of the ubuntu/linux kernel on a regular basis to this partition.

What should happen is that only a few versions of the kernel should be kept on hand and there is supposed to be some kind of job that cleans this up from time to time.

In reality that cleanup function seems to be bugged in Ubuntu 14.04 LTS so the boot partition will hit 100% full frequently and it is a constant game of manually keeping that partition clean… or else! (or else it turns into a real headache when it hits 100% full). (more…)