mercoledì, maggio 22, 2013

Verificare se un volume è montato MOUNT

Faccio una verifica nel file /proc/mounts se esiste la riga in riferimento al volume desiderato:

#!/bin/sh
if grep -qs '/mnt/miacartella' /proc/mounts; then
echo "il volume è montato!";
else
echo "il volume non è montato!";
fi

Per info, nel file /proc/mounts vengono elencati tutti i mount effettuati sulla macchina

SMBFS mount


Articolo preso da: http://www.linuxnix.com/2009/09/8-ways-to-mount-smbfs-samba-file-system-in-linux.html

How to Mount smbfs (SAMBA file system) permanently in Linux.In this post I am going to give some examples how to do SMB (Server Message Block) mounts.

Type1 : Listing SMB shared folder through command prompt
#smbclient –L ipadd –U username
Here –L will specify listing of SMB share for the server with ipadd

Or
#smbclient //192.168.0.1/share1 –U username

Example :
#smbclient –L 192.168.0.1 –U root

Type2 : Mounting SMB share on local folder by using smbmount command
#smbmount //ipadd/sharename /mountpoint –o username=userid,workgroup=workgroupname

Example :
#smbmount //192.168.0.1/share1 /mnt –o username=steev,workgroup=test

Type3 : Mounting SMB share by using mount command
#mount –t smbfs ipadd:/sharename /mountpoint –o username=userid,workgroup=workgroupname

Or
#mount –t smbfs //ipadd/sharename /mountpoint –o username=userid,workgroup=workgroupname

Example :
#mount –t smbfs 192.168.0.1:/share1 /mnt –o username=surendra,workgroup=test

Type4 : Mounting CIFS (Common Internet File System) is nothing but a advanced SMB file system implementation which support RAP (Remote Access Protocol)
#mount –t cifs ipadd:/sharename /mountpoint –o username=userid,workgroup=workgroupname

Example :
#mount –t cifs 192.168.0.1:/share1 /test –o username=Surendra,workgroup=test

Type5 : All the above commands will ask password to display/mount the share name, however we can specify the password in command itself as below
#mount -t smbfs -o username=userid,workgroup=workgroupname,password=XXXXX //ipadd/sharepoint /mountpoint/

Example :
#mount –t smbfs –o username=Surendra,workgroup=test,password=xylBJRS8 //192.168.0.1/share1 /test

Type6 : Mounting permanently by editing /etc/fstab file, below is the fstab file entry example
#vi /etc/fstab//192.168.0.1/share1 /test smbfs rw,user,username=surendra,password=xylBJRS8 0 0

Save and exit the file and conform that you edited fstab file properly. By below commands
#mount –a

This command should not through any error,
#df –H

This command should n style="font-size: small;"> show mount from 192.168.0.1 server

Type7 : Mounting a share where user belongs to a domain permanently by editing /etc/fstab file
The above command will not work properly for domain users so we have to specify domain as well when specifying username
So now username will be changed to domainusername
#vi /etc/fstab
//192.168.0.1/share1 /mnt smbfs rw,user,username=testsurendra,password=xylBJRS8 0 0

Save the file and exit then execute mount –a and df –H for just conformation if the mount is done successfully.

Type8:As you people know /etc/fstab file is visible to all the users who logged in, so specifying user password in /etc/fstab file is not that much good procedure.. So there is a work around to resolve this issue, just create a credential file in users home directory and point that file in /etc/fstab file entry as mention below.
#cd ~
#echo username=surendra > .smbfile
#echo password=xylBJRS8 >> .smbfile
#chmod 600 .smbfile

Then edit the /etc/fstab file and specify the entries as below
#vi /etc/fstab
//192.168.0.1/share1 /mnt smbfs credentials=/home/myhomedirectoryofuser/. smbfile,rw,user 0 0

Save and exit the file and execute mount –a, df –H to check if you did any mistakes..

mercoledì, maggio 15, 2013

Filesystem NFS

Installazione pacchetto NFS e mount
# apt-get install nfs-common

Supponendo che il server NFS sia "192.168.1.100" e la directory condivisa sia "/home/user"
#mount 192.168.1.100:/home/user /mnt/miadir

Per il mount su fstab:

inserire nel file etc/fstab la riga:
192.168.1.100:/home/user mnt/miadir nfs rsize=8192,wsize=8192,timeo=14,intr

poi, semplicemente:
#mount /mnt/ftp


venerdì, maggio 10, 2013

Linux MDBTOOLS (mdb-export)

Per esportare tabelle create con Access in MySQL

Installare utility mdbtools:
# apt-get install mdbtools

Per esportare le tabelle di Access usare mdb-export con questa sintassi:

Direttamente in mysql
# mdb-export -D '%Y/%m/%d' -I mysql database.mdb table_name | sed -e 's/)$/)\;/' | mysql -u username --password=<pwd> database_name


In un file MySQL
# mdb-export -D '%Y/%m/%d' -I mysql database.mdb table_name | sed -e 's/)$/)\;/' > nomefile.sql

In CSV
# mdb-export database.mdb table_name > export.csv

L'opzione -D serve per la formattazione della data, in questo caso con lo standard "%Y / %m / %d" ossia "ANNO/MESE/GIORNO"

Da notare nelle ultime versioni di mdbtools l'indicazione del tipo di "backend" nell'opzione "-I" che sono: access, sybase, oracle, postgres, mysql

NB
per importare in MySQL da un file con il terminale:
# mysql -u username --password=<pwd> database_name < file.sql

Rsync su FTP con CURLFTPFS

Necessario sia RSYNC che CURLFTPFS

Installazione:
# apt-get install rsync
# apt-get install curlftpfs

Eseguire mount su server linux da ftp:
# curlftp -o allow_other ftp://utente:password@mioserverftp.it /mnt/ftp

Eseguire rsync su cartella remota
# rsync -av --delete /home /mnt/ftp

Per inviare report via mail usare server "mutt" (vedi configurazione MUTT) in questo modo:
# rsync -av --delete /home /mnt/ftp | mutt -s "Report backup rsync" destinatario@mail.com

Per il mounting automatico di curlftpfs editare il file /etc/fstab in questo modo:
curlftpfs#user:password@mioserverftp /mnt/ftp fuse rw,uid=500,user,noauto 0 0

poi direttamente:
# mount /mnt/ftp


Configurare MUTT su linux (debian/ubuntu based)

Necessario: MUTT e SSMTP

# apt-get install mutt ssmtp

Configurazione per GMAIL:

Editare il file "ssmtp.conf" in /etc/ssmtp/ssmtp.conf in questo modo:

Per GMAIL
root=miamail@gmail.com
mailhub=smtp.gmail.com:465
UseTLS=YES
hostname=nomeserver
FromLineOverride=YES

---------------------------------------------------------------------------

Per altro gestore, ad es ARUBA
#root=
mailhub=smtp.aruba.it:25
#rewriteDomain=
#hostname=
UseSTARTTLS=NO
AuthUser=utente
AuthPass=password
FromLineOverride=YES

Creare nella directory utente (in questo caso root /root) il file ".muttrc" ed inserire:

Per GMAIL con IMAP
set imap_user = "vostra_email@gmail.com"
set imap_pass = "vostra_password"
set from = "vostra_email@gmail.com"
set realname = "vostro_nome"
set sendmail = "/usr/sbin/ssmtp -fvostro_nome -au vostra_email@gmail.com -ap vostra_password"
set folder = "imaps://imap.gmail.com:993"
set spoolfile = "+INBOX"
set postponed="+[Gmail]/Drafts"
set header_cache=~/.mutt/cache/headers
set message_cachedir=~/.mutt/cache/bodies
set certificate_file=~/.mutt/certificates
set sort = 'threads'
set sort_aux = 'last-date-received'
set imap_check_subscribed
set move = no

ignore "Authentication-Results:"
ignore "DomainKey-Signature:"
ignore "DKIM-Signature:"
hdr_order Date From To Cc

---------------------------------------------------------

Per altro gestore, ad es ARUBA
# Purge deleted message without confirm.
set delete=yes

# Don't move read message to mbox and don't ask for it!
set move=no

# Set a customized "From: " header.
my_hdr From: Pippo<info@pippo.it>

# Mailbox format should be autodetected.
#set mbox_type=Maildir

# Specifies the default location of local mailboxes.
# Default is "~/Mail".
set folder=~/Maildir

# Append sent messages to "Sent", mbox or Maildir format will
# be autodetected. The "+" sign means relative to the $folder
# directory.
set record=+Sent

# Where to store postponed messages (instead of ~/postpone).
set postponed=+Postponed

# Choose which header to hide/show, and their order.
ignore *
unignore  from: date: subject: to: cc:
hdr_order from: date: subject: to: cc:

# Select the text editor.
set editor="/usr/bin/nano -r 65"

------------------------------------------

Per inviare mail da terminale:
# echo "prova invio mail" | mutt -s "soggetto messaggio" destinatario@mail.com

OpenVPN server - installazione su Windows 10

SERVER