Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Blog

SQL Server 2000 set Date Time format…

Convertire una stringa (sequenza di caratteri) in un dato di tipo data o timestamp in SQL standard è abbastanza semplice tramite il comando ‘cast‘ . Semplicemente scrivento : cast(‘2010-3-31’ as datetime) oppure cast(‘2010-3-31’ as timestamp) otteniamo la conversione, ma come sempre nel caso delle date non esiste la parola semplice, i formati con cui si…
Leggi tutto

Chroot SFTP users

Obiettivo l’obiettivo è quello di configurare degli utenti che possano accedere in ssh senza uscire dalla loro home. Devono poter pubblicare i loro file, quindi i virtual host punteranno a tali home directory Requisiti ssh >= 4.7 syna@serverweb-prod:/home$ aptitude show openssh-server Pacchetto: openssh-server Stato: installato Installato automaticamente: no Versione: 1:5.1p1-6ubuntu2 Apache 2 con moduserdir root@serverweb-prod:/etc/apache2/mods-enabled#…
Leggi tutto

Small Talk on zkoss.org

One of our article, reviewed and extendend, today appears on the official zk site ! We are very proud to appear on the zk official site, it is also a confirmation of the advanced work we made here.

Embarcadero RAD Studio RoadMap Update

From Embarcadero there is a new roadmap update at http://edn.embarcadero.com/article/39934 that speak about RAD Studio Solution to build native x86 applications. In particular is focused on future of Delphi / C++ Builder on cross platform and Native 64bit. regards ivan

Oracle tip #8 [Enable apex not only for localhost]

After installing Oracle 10g on an Ubuntu 9.04 system, i found that the Apex application was enabled only for the localhost. Some time is necessary open or close the access of apex from remote. To do this is only need to access to your oracle system by a dba user and run this sql command:…
Leggi tutto

Extend swap file on Ubuntu

Sometimes happen that you need to extend the swap space on your system, so it happens to me when i tried to install Oracle10ex on my ubuntu system. So i found the solution on this ubuntu forum : http://ubuntuforums.org/showthread.php?t=89782 To extend the swap file to 1gb : First, create a large empty file: Code:


Leggi tutto