Category: sysadmin

Owncloud database migration from SQLite to MySQL – QNAP specific

OwnCloud / sysadminOne Comment

One of new few features on Owncloud 7 is the possibility to migrate databases. On my case, I originally installed Owncloud on SQLite, which is fine for a small number of files and one single user, but when going into the tens of thousands of files and multi user, SQLite is no longer a solution. Then, how do we get out of SQLite without having to start from scratch ? Set up QNAP to locally run Owncloud; Create a new mysql database; Migrate database.

Installing Owncloud 7 on QNAP hardware – upgrade from version 6

OwnCloud / sysadminLeave a comment

Edit: If you’re getting a blank screen after upgrading to ownCloud 7.0.2 or QNAP QTS 4.1, go to this post: View. Little more the 3 months ago I published the guide for Ownclod 6 on QNAP hardware, and Owncloud 7 is upon us. If you wan’t to see how history was made, feel free to have a look at all the previous posts on Owncloud: Installing Owncloud 6 on QNAP hardware – Additional Steps for version 6. For first time install, please make sure you follow the eaccelerator step Installing and using ownCloud on QNAP hardware Owncloud database migration, also on …

Installing Owncloud 6 on QNAP hardware – Additional Steps for version 6

OwnCloud / sysadmin2 Comments

EDIT: Please note since QNAP QTS 4.1.x and ownCloud 7.0.2 the following steps aren’t working anymore. A new post will follow. This post comes as a following to the original Installing and using ownCloud on QNAP hardware post, and serves to users in the process of doing both clean installs and upgrades.  First of all, I need to explain the need for this post: Live was peachy, until someones decided to upgrade ownCloud to version 6.x on any QNAP hardware, both ARM or x86 based. When this upgrade is performed, the user is presented with a white screen, caused by the server …

Activating Apache logs on QNAP hardware (EDIT: fix for QTS 4.1 onwards)

sysadminLeave a comment

This is a quick guide for those needing to debug web apps, such as ownCloud, on QNAP hardware. QNAP systems only come with an Apache error log by default, which only logs apache service errors, not page errors, which make impossible to debug problems on sites. The only way to get more detailed logs is to add a few new config files to Apache, as follows: Login to the QNAP device through SSH Enable .htaccess usage on Apache. To do this you need to create a new Apache configuration file: vi /etc/config/apache/extra/apache-myconfig.conf And add the following commands: CustomLog logs/main_log combined …

When Cisco’s IGMP Snooping stops working for a few seconds

sysadminLeave a comment

Editor’s note: this post related to when traffic is forwarded for a few seconds even if IGMP Snooping is working. Not for instances where you loose all multicast traffic when activating IGMP snooping. For those cases, please remind to activate at least one IGMP querier somewhere on the network, and the corresponding IP address (no IP address, no querier….). Introduction IGMP snooping is a feature derived from the regular IGMP standard since version 1, however it works on a mostly independent manner, as it only works at the local switch level. Multicast traffic, without IGMP snooping enabled, works as a simple …

Semantic MediaWiki By Example – A Datacenter IP Network Manager

Decision Support Systems / SMW / sysadminOne Comment

One of the most common tasks on one datacenter, is the management of the IP Network: assigning IP addresses, creating networks (and subnetworks), creating hosts and setting hostnames. On smaller scale, having a spreadsheet may do the trick, but as datacenters grow (both physical and virtual), both in number as in complexity it quickly underperforms. Even, with all virtualization, this task won’t get any simpler, it will actually get more and mode complicated, because at least, it needs to be performed twice: at the physical hardware level, and at guest level. So, there is the need to create a tool …

Bugzilla access control – Allowing one group to create and access all bugs and another only to access it’s own bugs

sysadminLeave a comment

Now, something completely different: Bugzilla. Bugzilla is one of the most used bug tracking systems worldwide. It’s stable, somewhat customizable, and suits most possible uses, where software development is concerned, and sometimes, also outside the software world. Now, one of the aspects where is falters the most is on user access control. It isn’t because it doesn’t work, but because it is awkward and counter intuitive, until you get used to it… Let’s look at 3 scenarios: All users can create and edit bugs. Please make sure there is at least some kind of access control at network level. To …

LDAP and Apache Basic Auth – how it works and how it doesn’t work

sysadminLeave a comment

Let’s imagine you work on an organization which uses Active Directory (just kidding, is there anyone who doesn’t …?) and on which people are forced to comply with draconian security policies, such as changing you strong password every N days (replace N for any number less than 30… why don’t people understand that it is harder for people to memorize a new strong password, than machines to brake them). Anyways, having a central location for all authentication purposes is, from any point of view, a good idea, even if coming from Microsoft :). If your organization already has in place …

Installing and using ownCloud on QNAP hardware. EDIT1

sysadmin2 Comments

Editor’s note: There is an issue with ownCloud 6 on QNAP. There is a new post with the extra steps here. As of lately, services such as Dropbox and Google Drive, are getting more and more attention, both on the cloud storage front and on file sharing and synchronization. For personal and non critical purposes, those are just fine, specially if you don’t mind the 5GB free capacity. Once you get used to it, either the 5GB storage limit, or the fact that the files are not hosted by a trusted 3rd party, might get on you nerves. On my …

Back to Top