wmic for Linux

Compiling WMIC for Linux (Without Installing Samba)

http://semafour.wordpress.com/2010/02/17/compiling-wmic-for-linux-without-installing-samba/

http://www.edcint.co.nz/checkwmiplus/

Tunning remote desktop

I just found a way to set default connection setting for clients...
Using Group Policies Editor, gpedit.msc

\Computer Configuration\Administrative Templates\Windows Components\Terminal Services\Printer Redirection

"Do not allow client printer redirection". Set it to Enable

PD. google "disable remote printers using group policies"

firebird setup of microsip in linux

First, you have to backup youcurrent databases in windows

gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\MyCompany.fdb" "c:\Microsip datos\Respaldos\MyCompany.fbk"
gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\System\Config.fdb" "c:\Microsip datos\Respaldos\Config.fbk"
gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\System\Metadatos.fdb" "c:\Microsip datos\Respaldos\Metadatos.fbk"

The security2.fdb should be copied when firebird is not running, so the firebird service should be stopped before copying from windows, and services must be stopped too before copying into linux.

Then, directories must be created in "data" directory of firebird

mkdir /var/lib/firebird/2.5/data/System
mkdir /var/lib/firebird/2.5/data/Respaldos
mkdir /var/lib/firebird/2.5/data/Exportación

Copy the backups into /tmp and restore them on these directories

/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/MyCompany.fbk /var/lib/firebird/2.5/data/MyCompany.fdb
/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/Config.fbk /var/lib/firebird/2.5/data/System/Config.fdb
/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/Metadatos.fbk /var/lib/firebird/2.5/data/System/Metadatos.fdb

All files should be "firebird" owner

chown -R firebird.firebird /var/lib/firebird/2.5/data/

Microsip config is:

"Conexion", "Abrir conexion"
Servidor: 172.16.1.1
Carpeta de datos: /var/lib/firebird/2.5/data/

To test access with isql, try

/usr/bin/isql-fb
> CONNECT localhost:/var/lib/firebird/2.5/data/MyCompany.fdb
> user 'SYSDBA' password 'xxxx';
> show tables;
> quit;

I read this link to understand how to do it and then write this tutorial.

Backup firebird databases

I'm was looking forward how to backup Firebird used by Microsip

gbak "remote-host:c:\Databases\Mytest.FDB" /dev/stdout -user SYSDBA -pass xxxx | gzip > $path/Mytest-$(date +%Y%m%d%H%M).fbk.gz


# Backup config database

gbak "remote-host:c:\Databases\System\CONFIG.FDB" /dev/stdout -user SYSDBA -pass xxxx | gzip > $path/Config-$(date +%Y%m%d%H%M).fbk.gz


# The only way to access the security database is via the Service Manager. As
# GBAK can also use the Service Manager (Option -se), you can run a backup
# using this option. However, the backup file will also be written to the
# server machine.

gbak -user sysdba -pass xxxx -service dbhost:service_mgr "C:\Archivos de programa\Firebird\Firebird_2_1\security2.fdb" "C:\Archivos de programa\Firebird\Firebird_2_1\security2-$(date +%Y%m%d%H%M).fbk"


openvpn routed

I used to have bridge openvpn server in windows.. cause there was the easy way to configure...
But in linux bridge interfaces are not optimal, its better to use route openvpn..
Configuring the server and clients are found almost everywhere.. and iptables is also needed
A pretty short tutorial is can be found here