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 / ext3 defaults 1 1
/dev/infravg/images_lv /images ext3 defaults 1 2
/dev/rootvg/usr_lv /usr ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/rootvg/swap_lv swap swap defaults 0 0
LABEL=/boot /boot ext3 defaults,nodev,nosuid 1 2
/dev/rootvg/home_lv /home ext3 defaults,nodev,nosuid 1 2
/dev/rootvg/opt_lv /opt ext3 defaults,nodev 1 2
/dev/rootvg/var_lv /var ext3 defaults,nodev,noexec 1 2
/dev/rootvg/tmp_lv /tmp ext3 defaults,nodev,nosuid 1 2
/dev/rootvg/system_lv /system ext3 defaults,nodev 1 2
/dev/cdrom /media/cdrom udf,iso9660 noauto,owner,nodev,nosuid,ro 0 0
/dev/fd0 /mnt/floppy auto noauto,owner,nodev,nosuid,ro 0 0
/dev/infravg/mysql_lv /opt/mysql ext3 defaults,nodev 1 2
/dev/infravg/mysql_na_5144_lv /opt/mysql/na/5.1.44 ext3 defaults,nodev 1 2
172.20.20.16:/vol/DCEPP/DBR1 /myqdata nfs nosuid,nodev,vers=3,tcp,bg,hard,nointr,wsize=32768,rsize=32768,rw,nolock,timeo=600 0 0
Use Filers instead of IP
3. Mount the filesystem
mount -a
4. Check all the mounted filesystem
mount
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.
/**
* Transfer file to Linux server
* @return true or false
*/
public static boolean transferFileToLinuxMachine(String filePath){
JSch jsch = new JSch();
Session session = null;
try {
// Put username and ip of the server
session = jsch.getSession("admycsr","10.170.201.11",22);
session.setPassword("csrtdev1");
session.setConfig("StrictHostKeyChecking", "no");
session.connect();
System.out.println("server connected successfully");
ChannelSftp channel = null;
channel = (ChannelSftp)session.openChannel("sftp");
channel.connect();
System.out.println("channel connected successfully");
File localFile = new File("C://Users//hlcz0172//Desktop//Noname2.txt");
//If you want you can change the directory using the following line.
channel.cd("/home/admycsr");
channel.put(new FileInputStream(localFile),localFile.getName());
System.out.println("File trasfered successfully");
channel.disconnect();
session.disconnect();
} catch (JSchException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SftpException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return true;
}