Categories
osTicket

osTicket attachments migration for huge databases

.Recently I had some issues during the migration of files from database to filesystem for an istance of osTicket 1.12.x, but I think it’s related to all range 1.10-1.14.

The istance had more than 60.000 files ( 40GB of data ) pushed as attachments inside the database. And the database was quickly growing by 1GB/week causing problems to the nightly backup procedure on a DB Cloud. Simply, the procedure stopped to work when the database reached 20GB and the provider did not offer any alternative solution. So it was mandatory to proceed with the migration on filesystem to keep it smooth and easy to backup.

Continue reading “osTicket attachments migration for huge databases”

Categories
Qubes

Qubes and PulseAudio bug

After updating dom0 I experienced different malfunctions related to how my HP zBook 14″ works with Qubes. The most annoying were:

  1. no correct functioning of the Fn keys
  2. audio missing at all
  3. shutting down not working
  4. random freezing of qubes-manager and other tools.
Continue reading “Qubes and PulseAudio bug”
Categories
Qubes

Qubes and Windows 7 OEM

It’s almost six months I’ve fallen in love with the wonderful Qubes OS and I’m starting to feel confortable with it, organizing all my project through AppVMs and updating Templates.

Continue reading “Qubes and Windows 7 OEM”
Categories
Node.js

Node.js and NPM on Wheezy

It was a surprise, after some years in Ubuntu ground! Using a Debian stable release could take you in old times when running Linux ment hacking your own system. But it’s still this way, if you use it day-by-day.

With Ubuntu it’s a piece of cake to add Node.js and NPM with apt-get, while Debian Wheezy has no packages.

Continue reading “Node.js and NPM on Wheezy”
Categories
PaaS Python

Plone on OpenShift!

No matter how far it goes… cloud is winning.

Why spending so much time to stress a local o remote machine, when you can have free services on PaaS?

Continue reading “Plone on OpenShift!”
Categories
ubuntu

Quantal & ia32-libs

It seems obvious that a new stable ubuntu distro should work fine with new 64-bit PCs.

Anyway I have lost sometime to fix the correct installation of ia32-libs, a compatibility package that aims to help in amd64/i386 issues on Ubuntu.

Continue reading “Quantal & ia32-libs”
Categories
Django

Install Django in Ubuntu

Just an easy recap to install django in a standard ubuntu environment:

  1. download the latest stable package from official page
  2. extract the package with: tar -xzvf Django-M.m.r.tar.gz [now: M=1, m=4, r=2]
  3. enter the folder with: cd Django-M.m.r
  4. run the command: sudo python setup.py install

At the end of the installation you can test it opening a python console with:

  • import django
  • django.get_version()
Categories
Python

Python DeDRM

I don’t know at the moment if the e-readers’ trend is to grow or to disappear to let smartbooks and tablets take the leadership.

Continue reading “Python DeDRM”
Categories
Plone

How to install Plone on Linux/BSD/Unix

It could seems hard to configure Plone, but it’s just a matter of time.

  1. Continue reading “How to install Plone on Linux/BSD/Unix”
Categories
news

Fresh news

I’d like to spend some time to draw all things I was involved, but it’s time to give my contribution to the open source community for all great products I have worked with in last years.

I’ll write about osTicket, WordPress, OpenERP, Plone, Symfony, Prestashop, Qubes and so on.