Connect to public hosted Ubuntu server MySQL Docker Image from local MySQL Workbench

Hi folks,

Today I am going to explain the procedure to test the public cloud hosted MySQL docker in Ubuntu Server to your local MySQL WorkBench.

We configured a Ubuntu Server on public cloud and installed docker.
Ping the public IP address to make sure, it is reachable to your pc/laptop.

Configure System

Install MySQL Docker Image

# docker pull mysql/mysql-server:latest

Check the images

#docker images

You should be able to view the downloaded mysql server image

Start the MySQL Server

# docker run --name=mysql1 -p 33061:3306 -d mysql/mysql-server
-d : Run in daemon mode
-p host_port:container_port
--name: container name

The mapped public ubuntu server port is 33061, which is mapped to the mysql server port 3306.

Check the containers

# docker ps

You should be able to view your mysql docker containers with container id and ports information

Get the MySQL root user password

MySQL generates a one-time password for docker container and writes to the log.

• To view the log, execute the following command

# docker logs mysql1

• To get the generate one-time password, filter the log with keyworkd "GENERATED"

# docker logs mysql1 2>&1 | grep GENERATED

• You should be able to get the line like below

GENERATED ROOT PASSWORD: Axegh3kAJyDLaRuBemecis&EShOs

• Copy the one-time password. In the next step, we will use this to login.

Reset MySQL root user password

• Connect to MySQL server

# docker exec -it mysql1 -uroot -p

• Paste the generated root password
• Change the password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpwd';
mysql> FLUSH PRIVILEGES;

• Though you have the root user credentials, you won't be able to connect.

Root cause: root user belongs to localhost, not for the public host usage
Solution: create another user with all privileges

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'youpwd';
mysql> GRANT ALL PRIVILEGES on *.* TO USER 'username'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

• Exit the mysql

mysql> exit;

• Restart the docker

# docker restart mysql1

Connect from MySQL Workbench

1. Open MySQL Workbench
2. Click on add new connection icon
3. Enter the "Connection name"
4. Enter host name "public IP address" or "URL"
5. Enter username as "dev" (Above created user)
6. Click on Password "Store in vault" button and enter the "dev" user password
7. Click on "Test Connection" button
8. You should be able to view the "Successfully made the SQL Connection" pop-up

Hope this tutorial helps you to get connected with your public hosted mysql docker instance to your local mysql workbench.

Please send your feedback and comments to psrdotcom@gmail.com

ADFS (Active Directory Federation Services) not starting after reboot

Hi all,

I have stuck with one of the problem where ADFS was not starting after rebooting the PC.

Solution from different sources worked for me

Try your luck.

ADFS not starting issue solution

1. Start "Microsoft Key Distribution Service"
2. Start "Windows Internal Database"
3. Start "Active Directory Federation Services"

Please send your feedback to psrdotcom@gmail.com

Docker postgres db to local volume/drive for persistent storage permanently

Hi all,

Today, I would be explaining the way to maintain the DB with data persistent when connecting to docker.

System Status

Postgresql DB container is in Docker
Windows 10 PC
Linux containers

Issue

Whenever I restart docker/PC the database wiped off due to container is stopped.

Solution

Create a docker volume

Syntax: docker volume create <>
Example: docker volume create pgdata

Start the container with volume option

Syntax: docker run --rm --name <> -e POSTGRES_PASSWORD=<> -d -p 5432:5432 -v <>:/var/lib/postgresql/data <>
Example: docker run --rm --name pgcontainer -e POSTGRES_PASSWORD=MyPassword -d -p 5432:5432 -v pgdata:/var/lib/postgresql/data postgres

Now, you can run all your database commands

Upon restart also, your data should be safe.

Thanks for reading the blog post.

Please send your feedback and comments to psrdotcom@gmail.com

Android and Java latest integration changes for AVDManager and SDKManager non-working issues

Hi all,

If you haven't used your Android skills in recent times with latest Java then, you might come across a situation where the SDK Manager and AVD Manager are not working.

Issue

SDK Manager and AVD Manager are not working.

Environment

Java 9 with Android SDK 23

Note

Though, I am able to perform development using Android Studio but when it come to update the SDK build tools and others, I was not able to update with SDK Manager.

Solution

1. Now, Android SDK Manager have moved to sdk/tools/bin with filename sdkmanager.bat
2. Edit the sdkmanager.bat file with any text editor
3. Go to "@rem Execute sdkmanager" command
4. Update the command with options: -XX:+IgnoreUnrecognizedVMOptions --add-modules java.se.ee 
5. It should look like below after you add the arguments
• @rem Execute sdkmanager
  "%JAVA_EXE%" %DEFAULT_JVM_OPTS% -XX:+IgnoreUnrecognizedVMOptions --add-modules java.se.ee %JAVA_OPTS% %SDKMANAGER_OPTS%  -classpath "%CLASSPATH%" com.android.sdklib.tool.sdkmanager.SdkManagerCli %CMD_LINE_ARGS%
6. If you run android-sdk/tools/bin/sdkmanager.bat, it should be able to run

Note

There is nothing like platform-tools folder now in Android SDK.

So, make sure that you have specified ANDROID_HOME/SDK in your environment variables with your system/pc Android SDK folder

In PATH environment variable, you can specify %ANDROID_HOME%/tools/bin

Thanks for reading my blog. Feel free to post your comments below. Contact me on psrdotcom@gmail.com

Tomcat issue "windows could not start apache tomcat on local computer" after java update issue with resolution

Hi friends,

Today I have faced an issue with Tomcat service starting. I would like to share with you the resolution as well. Please find the details below.

Root cause

Updated java version

Resolution

• Navigate to you apache installed folder
• Go bin folder
• Double click on "Tomcat(X)w.exe" where X the version of tomcat.
• In my case it is "Tomcat8w.exe" because the version is 8
• 
• Select "Use Default". So that, it uses the JAVA_HOME version by default.
• Click on OK
• Start the Tomcat service and enjoy deploying

Please send your comments and feedback to psrdotcom@gmail.com

Windows 7 Unable to drag and drop with mouse issue resolution

Hi friends,

Today, when I was working suddenly I felt like my mouse is not performing drag and drop.

I found a simple solution

1. Press and hold any file in file explorer with your primary (left mouse) button
2. Click "Esc" (Escape) key on your keyboard
3. You should be able to perform drag and drop of files now

Please send your feedback and comments to psrdotcom@gmail.com

Text Formatting in *NIX to run Script files of Different Platforms

Hello all,

While writing shell scripting in Ubuntu, Windows and deploying it in *NIX based machine, we found some issue. That the file running perfectly on the Ubuntu (Linux), Windows machine. The same script was displaying errors like

'\r': command not found

^M: command not found

There was a formatting issue. You need to run the following command to resolve it.

DOS2UNIX

Installation:
sudo apt-get install tofrodos

Syntax: 
dos2unix filename

Example:
dos2unix script1.sh

To know more about this you can go through References.

References:
http://linuxcommand.org/man_pages/dos2unix1.html
http://www.thefreecountry.com/tofrodos/

If you have any further queries, please add your comments. You can also mail to psrdotcom@gmail.com