Cloud Vedas

Solved: ERROR: current transaction is aborted - Redshift

Problem:-

[Amazon](500310) Invalid operation: current transaction is aborted, commands ignored until end of transaction block;

Solution:-
If you are getting the above error while you are connected to Redshift, ensure that you have checked the “Autocommit” box below the “Password” box in SQL Workbench/J connection window. (refer image below)

Once you check the “Autocommit” box try connecting to the Redshift cluster again.

Solved: docker - error during connect

sagu@sagu-pc MINGW64 ~$ docker image lserror during connect: Get http://%2F%2F.%2Fpipe%2Fdocker_engine/v1.29/images/json: open //./pipe/docker_engine: The system cannot find the file specified. In the default daemon configuration on Windows, the docker client must be run elevated to connect. This error may also indicate that the docker daemon is not running.sagu@sagu-pc MINGW64 ~

If you are getting above error while running the docker commands in Docker Quickstart Terminal then you can have one of the listed problem.

The docker deamon is not running.
The docker host machine itself is down.
Required configuration file is missing.

First check that the host machine is up and the configuration file is present at its location. Once you are sure both the above things are ok, in that case easiest way to get rid of this issue is to open the Docker Quickstart Terminal by selecting “Run as Administrator” . It will take some time to start but let it complete and you should be back in business soon.

Solved: How to allow remote root login in Solaris

In this post we will show you how you allow root login to a solaris sevrer from a remote machine.

Login to the Solaris Server via console as root user.
Modify the /etc/ssh/sshd_config . Look for the PermitRootLogin entry in the file and change it from no to yes .

PermitRootLogin yes

Finally refresh the ssh service so that it re-read the configuration changes you made to sshd_config. For Solaris 10 you can refresh ssh service using svcadm.
```
 svcadm refresh svc:/network/ssh:default
```

For Solaris 7,8 & 9 you can restart ssh service as below.
```
 /etc/init.d/sshd restart
```

Solved: How to reset root password in Redhat Linux or CentOS

In this post we will discuss how to reset the root password of a Redhat linux server if you forgot it.

Reboot the server
While you are at boot menu press “Up or Down” arrow key to prevent system from booting.
Select the boot device and press “e” to edit it.

Scroll down the program with arrow key, till you see a line starting with “linux16”. That line will have words “rhgb quiet” .(refer Image 1)

Image 1

Now change “rhgb quiet” to init=/bin/bash as in image 2.

Image 2

After making the change press “ctrl x” to boot the system.
Screen will now take you to command prompt without asking for password.

On the command prompt remount root as read-write.

mount -o remount,rw /

Now execute “passwd” command to change the password of root user. (refer image)

Tip:

Pick strong password else it will throw error of bad password and may not change the password.
If you are getting error “passwd command not found” ensure that your machine is booted with the disk and not the ISO. Many people working on VMs make this mistake so you are not alone 🙂

If you are using SElinux you will have to run this extra relabel step before reboot or else you won’t be able to login with the new password.

touch  /.autorelabel

Finally reboot the server

exec /sbin/init

Now you should be able to login with new password.
Hope this post is helpful to you. Do let me know if you have any query.

Solved: How to mount ISO in a linux VM

In this post we will discuss how to mount ISO in Linux VM running inside Virtualbox or VMware.
Virtualbox
You can mount ISO in Linux VM running on Virtualbox by following these steps

Select the running machine window.
Click on Devices > Optical Devices
Choose disk image, browse and select ISO .

Now go to the redhat linux server and execute the mount command

 mount /dev/cdrom /mnt

VMware

If the linux VM is in VMware. You can select the iso image in vmware console similar to what we did for virtual box.
Right click on the machine > “Removable Devices” > “CD/DVD” > Settings. Browse and select the ISO. Check mark on “Connected”.
Finally execute the following command in Linux VM.
```
mount /dev/sr0 /mnt
```
If you do “df -h” new ISO should be mounted and visible to you as /mnt .

Tip: If you are getting error /mnt busy ensure that /mnt is not already mounted. If /mnt is already mounted either unmount /mnt first and try again or create a new directory and mount the ISO on the new directory.