Last 10 Posts from Tech Monger :///feeds/ 2020-07-02T07:34:44.599587Z Werkzeug Postgres ODBC with Mutual SSL in Informatica 2020-07-02T07:34:44.599587Z 2020-07-01T14:36:42.511620Z Tech Monger <p class="lead">Encryption has become security norm and communicating with databases on insecure network should not be an exception to this norm. In this tutorial we will learn how to connect to postgres database using ODBC connection which is configured to use 2 way SSL connection.</p> SOLVED : Authentication refused: bad ownership or modes for directory 2019-12-06T17:52:58.536626Z 2019-12-06T17:49:47.662642Z Tech Monger <p class="lead"> If you have setup key based authentication between two different servers for SSH or SFTP then you might face issues while initiating SSH connection. Below we will see how to solve these issues by considering different failure vectors. We assume that you have already setup <code>authorized_keys</code> based keyless ssh login. Denodo VDP ODBC Driver Installation for Informatica 2019-08-31T12:01:13.695613Z 2019-08-31T11:14:56.806961Z Tech Monger <p class="lead"> In this article we will learn to install ODBC Driver for Denodo VDP database. We will use installed ODBC driver to establish connectivity between Informatica Powercenter Clients and Denodo Server. You can also use <a href="/72/informatica-postgres-odbc/" title="Posgres ODBC Connection For Informatica">postgres odbc drivers to connect to the regular denodo database</a>. How Password Hashing Works in Ubuntu Linux 2019-07-06T14:12:28.378608Z 2019-07-06T12:42:06.108035Z Tech Monger <p class="lead"> If you ever wondered where and how user passwords are stored in linux file system then this post will answer most of your questions. Below we will discuss password hashing in ubuntu but many other linux distributions follow this pattern. Below read assumes that you have basic familiarity with hash function like md5 or sha-256. Script to Recover Web Application After Crash 2019-06-14T13:54:00.029529Z 2019-06-10T11:20:17.800411Z Tech Monger <p class="lead"> So you have web application running in production but it goes down unexpectedly and you get midnight calls to take up application. In this post we will build simple script that will recover web application after server crash due to over resource utilization. Informatica Postgres Connection Issues and Solution 2019-05-15T18:34:22.403778Z 2019-05-15T18:29:32.982927Z Tech Monger <p class="lead"> If you are trying to connect postgres database from informatica using ODBC entry then you might face issues with odbc connection details. Below we will discuss common pitfalls and fixes. Redis Remote Connection Configuration 2019-03-06T19:09:42.019114Z 2019-03-06T19:09:10.351904Z Tech Monger <p class="lead">If you want to access redis database from remote client or even server then you would need to configure redis to accept remote connection by binding server IP Address.</p> Password Based Authentication for Redis 2019-03-06T19:12:24.760033Z 2019-03-04T18:21:03.662040Z Tech Monger <p class="lead">By default redis server does not require password for connection but it allows configuration to <a href="/71/remote-connection/" title="Redis Remote Connection">accepts remote connections</a> which is potential security risk. If your redis server accept connections from remote client then it is of <em>utmost importance</em> to have password based authentication configured for your redis instance. Below we will check the configuration changes required to set password and secure our redis setup from an unauthorized access. </p> How to use Jinja2 in Python without Flask 2019-01-05T05:50:09.136214Z 2019-01-04T18:43:27.606962Z Tech Monger <p class="lead"> Due to various reasons you might want to render dynamic html content outside of your web application. For example to create the html email body. Also you might want to use jinja2 with web framework which does not have inbuilt support for it. Below we will explain how to use jinja2 as standalone utility in python script with the help of an <a href="#example">example code</a>. Change TOR IP Address with Python using STEM 2018-12-25T17:02:26.558297Z 2018-12-25T14:37:43.102142Z Tech Monger <p> If you are using TOR inside python script then you may find need to renew IP Address. In this tutorial we will change IP address using <code>stem</code> package. We will use TOR controller file <code>torrc</code> to communicate with TOR. Start and Stop Informatica Services From Command Line 2018-12-07T20:58:11.704294Z 2018-12-07T20:52:49.725375Z Tech Monger <p class="lead"> Often as an Informatica Administrator you require to restart <em>specific service</em> in the informatica domain. You can do it from user interface by using an Admin Console; However if you want to write script or you prefer command line over GUI then you can use informatica <a href="/tag/infacmd" title="INFACMD Command Line Tutorials">infacmd<a/> command line tool. Below we will learn how to use infacmd's <code>EnableService</code> and <code>DisableService</code> command to start and stop the services in informatica domain with the help of <a href="#example" title="Infacmd enableservice and disableservice example">Example</a>.