Blog

pfSense Cron Iterface

Sunday 9 June 2019, 12:08


With pfSense there are many “package” tools available that facilitate the configuration and maintenance of the system.

These include “Cron” which allows you to change the configuration of the operating system crontab (BSD) via the web interface.

To install a package, just select from the menu “System / Package Manager / Available Package /” write the desired package in the search field and install it, in this case “cron”.

One of the most common applications to schedule is the periodic reboot of the system.

Once “cron” is installed, if we wanted to reboot the system every night, it would be sufficient to create a new cron job via the “service / cron” menu

Click on “+Add” to configure the job ad ex:

where I reboot the firewall to the office every morning at 05.30.

Creating more complex scripts could also make the reboot conditional, for example we could only execute it if we do not get a reply by pinging google.com.

Firebird Performance Tour 2019 – Prague

Tuesday 4 December 2018, 12:21

Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses.

Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry Yemanov, Dmitry Kuzmenko, Alexey Kovyazin) and have the latest news on the future of this wonderful RDBMS.

 

 

During the conference we talked about:

  • The future of Firebird and the new features that will be introduced in version 4.x
  • How to optimize firebird performance simply at the SQL level by evaluating its impacts on the execution algorithm.
  • Visions on the live-replication system that allows you to create live replicas of your database

Seizing the opportunity we have pututo to visit a really beautiful city (Prague).

mde

dav

dav

 

Firebird 3.0 & Ubuntu Server 18.04

Monday 29 October 2018, 20:13

Primo test di porting database alla versione Firebird 3.0 che è la versione ufficialmente afficancata ai pacchetti di distribuzione standard di Ubuntu nella versione LTS attuale 18.04.

Le differenze tra la versione 3.0 di FB e le precedenti sono moltissime.
Ma i passaggi sono abbastanza semplici per effettuare il porting dalle versioni precedenti alla attuale e consistono in :

1) Preparare il nuovo ambiente FB 3.0 su una macchina nuova
2) Configurare firebird.conf in modo che risponda in rete sul nuovo sistema
2.5) *Abilitare la connessione “legacy” a firebird (quella vecchia senza crittografia) per non dover modificare i programmi già realizzati
3) Effettuare il bk dei DB e trasferirli sul nuovo sistema e Eseguire il restore dei DB con il solito “gbak”
4) veriufica se funziona da remoto Divertiti con FB 3.0

Sorgenti di info importanti per procedere:

io ho usato anche lo ozioni -username e -password esplicitate in chiaro nel comansdo gbak

1) Prepara il nuovo ambiente

https://help.ubuntu.com/community/Firebird3.0

2) Configurare firebird.conf in modo che risponda in rete sul nuovo sistema

https://superuser.com/questions/814879/firebird-cant-connect-to-host

You have to edit file “/etc/firebird/3.0/firebird.conf” and comment the line:

RemoteBindAddress = localhost
Like this

#RemoteBindAddress = localhost

2.5) *Abilitare la connessione “legacy” a firebird (quella vecchia senza crittografia) per non dover modificare i programmi già realizzati

https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-legacyauth.html
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-legacyauth.html

guide varie consultate sullo stesso argomento:

https://ptfrontline.wordpress.com/2016/04/21/steps-to-upgrade-firebird-v2-5-x-to-version-3-0-0-on-windows/

3) Effettuare il bk dei DB e trasferirli sul nuovo sistema e Eseguire il restore dei DB con il solito “gbak”

bk restore dei DB :

https://firebirdsql.org/manual/gbak-recipies.html
https://www.firebirdsql.org/manual/gbak-restore.html

4) veriufica se funziona da remoto Divertiti con FB 3.0

verifica se la porta di FB è presente tra le porte in ascolto del nuovo sistema:

verifica se FB3 sta girando:

prima connessione in locale con “isql-fb”

https://www.firebirdsql.org/pdfmanual/html/isql-commands.html

List of all selected checkboxes into a JSON string

Thursday 11 October 2018, 20:45

Add class to checkbox

Create a function to return a JSON string

Here an example

https://jsfiddle.net/a3owjh85/1/

Syncronize date time with internet service with Ubuntu 18.04

Sunday 30 September 2018, 17:57

Setting date time daemon and timezone of my locale on my ubuntu 18.04 servers:

Install NTP daemon:

Configure your locale time zone by checking the list:

In my case:

Discover what we can do for your business
Our languages