SFTP using DSA key without password
sftp -vvv -oCheckHostIP=no -oPasswordAuthentication=no -oIdentityFile=~/.ssh/id_dsa DCE02@transfer-france-ua.itn.ftgroup put “new.sh” “/IN/DCE03Z01”
Category Archives: Linux
Restore Mysql dump.
mysql -u root -pdbaft schema_name < dumpfile For example: mysql -u root -pdbaft dce2 < /backup/dce2_backup_20150814.sql
Create Mysql user with all privileges.
CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; After that Grant privileges: GRANT ALL PRIVILEGES ON *.* TO ‘user’@’localhost’ WITH GRANT OPTION;
Show all the users of mysql
Go to mysql prompt: SELECT User FROM mysql.user; mysql:root:(none)> select user from mysql.user -> ; +———+ | user | +———+ | bigip | | dce | | gwap | | myadmin | | slave | | dce | | root | +———+ 7 rows in set (0.01 sec)
Mount command for Filers
For filers we can check at the following location: /etc/fstab 1. Check the hosts cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 10.99.160.38 DCEPP-DBR-01 10.114.138.51 aptplaton.si.francetelecom.fr 172.20.20.16 FILER 2. Change the Filer in the fstab file /dev/rootvg/root_lv / Continue Reading…
Set permsize in catalina.sh
Java opts is used to increase the memory size in catalina.sh. JAVA_OPTS=”$JAVA_OPTS -Xms256m -Xmx512m -XXermSize=512m -XX:MaxPermSize=512m” vi /home/apache-tomcat-6.0.33/bin/catalina.sh
Transfer file to linux server in java
To transfer the file through SSH protocol we have to download two jar files : jsch-0.1.42.jar, xercesImpl.jar JSch and ChannelSftp classes are used to transfer the file on linux server.