RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server

Hi Bhavika, thanks for the email. I’m including you and your team in this
email thread for reference.

Hello PostgreSQL team,

I’m having difficulties connecting to our postgresql database through SSH
tunneling when using the ODBC driver. I know my database connection
credentials are correct because I’m able to connect to the database in
DBeaver. The Microsoft team suspects an issues with postgresql and
suggested I reach out. I’m ultimately trying to import data into
Microsoft’s Power BI tool but it seems I need to be able to establish a
connection with ODBC first.

Keith

*From:* Bhavika Padidala (MINDTREE LIMITED) [mailto:v-bhpadi(at)microsoft(dot)com]
*Sent:* Friday, January 17, 2020 11:25 AM
*To:* Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com>; Prashanth Reddy
Kalvakuntla (MINDTREE LIMITED) <v-prkalv(at)microsoft(dot)com>
*Cc:* support <support(at)mail(dot)support(dot)microsoft(dot)com>; Vikram Ramagiri
(MINDTREE LIMITED) <v-virama(at)microsoft(dot)com>
*Subject:* RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

Hello Keith,

I hope you are doing good J.

I tried calling you at +16196002517, but had no luck reaching you.

As written in my previous email I just wanted to follow up with you once
again, we discussed your issue with our product team and they confirmed
that the issue is from PostgreSQL side, you need to get connected to ODBC
Driver using SSH from PostgreSQL in order to connect to Power BI and they
suggested you to raise a PostgreSQL ticket. I thought of discussing this
with you over call but unfortunately couldn’t able to reach you.

Let me know your thoughts on this.

Looking forward to hearing back from you.

If you have any questions or concerns, please reply to this email thread.

Best Regards

*Bhavika Padidala*

Engineer - Microsoft Business Intelligence

Time Zone :-Pacific Standard Time

Hours of Operation: Mon - Fri 9 AM – 6 PM

Email: v-bhpadi(at)microsoft(dot)com

[image: cid:image001(dot)png(at)01D59F06(dot)51B5D970]

*If delay in response to your email, kindly notify to the below Operations
Manager’s team for immediate attention.*

MT-BAP-OM-TA(at)microsoft(dot)com

*From:* Ankit Gawde (MINDTREE LIMITED)
*Sent:* Thursday, January 16, 2020 3:50 PM
*To:* Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com>; Bhavika Padidala
(MINDTREE LIMITED) <v-bhpadi(at)microsoft(dot)com>; Prashanth Reddy Kalvakuntla
(MINDTREE LIMITED) <v-prkalv(at)microsoft(dot)com>
*Cc:* support <support(at)mail(dot)support(dot)microsoft(dot)com>
*Subject:* RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

Hello Keith,

Sorry for the delayed response. We were having a discussion with my
Technical Advisor and we were looking in the Desktop logs. As Technical
Advisor suggested, the PostGre SQL should be able to connect to the ODBC
Driver without which the Power BI won’t be able to get the data. They said
to reach out to PostGre SQL Team and explaining the scenario of PostGre SQL
not connecting to ODBC Driver using SSH.

Best Regards

*Ankit Gawde*

Microsoft Business Intelligence

Time Zone:  PST (US & Canada)

Hours: 9 AM – 6 PM

Email : *v-angawd(at)microsoft(dot)com <v-angawd(at)microsoft(dot)com>*

Manager: Rizwan UL Moin Mohammed (v-momoin(at)microsoft(dot)com*)*

*In case of any delay in response to your email or immediate assistance
needed, kindly notify to the Operations Manager’s team for immediate
attention. *MT-BAP-OM-TA(at)microsoft(dot)com

*From:* Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com>
*Sent:* Thursday, January 16, 2020 1:47 PM
*To:* Bhavika Padidala (MINDTREE LIMITED) <v-bhpadi(at)microsoft(dot)com>;
Prashanth Reddy Kalvakuntla (MINDTREE LIMITED) <v-prkalv(at)microsoft(dot)com>;
Ankit Gawde (MINDTREE LIMITED) <v-angawd(at)microsoft(dot)com>
*Cc:* support <support(at)mail(dot)support(dot)microsoft(dot)com>
*Subject:* RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

I’m still unable to generate an ODBC log file with the tracing feature.
Please let me know how to resolve this so I can provide the requested log
files.

Keith

*From:* Keith Yanase [mailto:keith(dot)yanase(at)soterawireless(dot)com]
*Sent:* Thursday, January 16, 2020 11:55 AM
*To:* 'Bhavika Padidala (MINDTREE LIMITED)' <v-bhpadi(at)microsoft(dot)com>;
'Prashanth Reddy Kalvakuntla (MINDTREE LIMITED)' <v-prkalv(at)microsoft(dot)com>;
'Ankit Gawde (MINDTREE LIMITED)' <v-angawd(at)microsoft(dot)com>
*Cc:* 'support' <support(at)mail(dot)support(dot)microsoft(dot)com>
*Subject:* RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

Hi everyone,

I’m having issues locating the SQL32 and SQL64 log files. When I attempted
to recreate the log files I confirmed that they aren’t being generated.

Do you know why that’s happening?

Keith

-----Original Appointment-----
*From:* Bhavika Padidala (MINDTREE LIMITED) [mailto:v-bhpadi(at)microsoft(dot)com
<v-bhpadi(at)microsoft(dot)com>]
*Sent:* Thursday, January 16, 2020 11:00 AM
*To:* Keith Yanase; Prashanth Reddy Kalvakuntla (MINDTREE LIMITED); Ankit
Gawde (MINDTREE LIMITED)
*Cc:* support
*Subject:* [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server
*When:* Thursday, January 16, 2020 11:00 AM-11:30 AM (UTC-08:00) Pacific
Time (US & Canada).
*Where:* Microsoft Teams Meeting

Hello Keith,

I hope you are doing good J.

As per our discussion, I am scheduling a teams meeting tomorrow at 11:00 AM
PST.

Please click on the invite below to join the meeting.

If you have any questions or concerns, please reply to this Email thread.

________________________________________________________________________________

Join Microsoft Teams Meeting
<https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZDBkMzMyNzItM2RkNy00MTQ5LWI0MTEtYWQ1OWIzMGE4ZTA0%40thread.v2/0?context=%7b%22Tid%22%3a%2272f988bf-86f1-41af-91ab-2d7cd011db47%22%2c%22Oid%22%3a%22d44b0b19-dbad-43be-84e0-ebb62bf3b442%22%7d>

+1 323-849-4874 <+1%20323-849-4874,,989264882#> United States, Los
Angeles (Toll)

Conference ID: 989 264 882#

Local numbers
<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdialin.teams.microsoft.com%2F8551f4c1-bea3-441a-8738-69aa517a91c5%3Fid%3D989264882&data=02%7C01%7Cv-bhpadi%40microsoft.com%7C88f001e5eec248e14ea508d79adecf28%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637148154093105356&sdata=q8%2B%2FUICeVaiS%2FBWD5wg87ousvMMnWXwxV6bQ8RcLLSQ%3D&reserved=0>
| Reset PIN
<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmysettings.lync.com%2Fpstnconferencing&data=02%7C01%7Cv-bhpadi%40microsoft.com%7C88f001e5eec248e14ea508d79adecf28%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637148154093105356&sdata=3LkxdK8DHgXfOHN2SfJ6BgR1VBabsrSwnvROCPXxBo0%3D&reserved=0>
| Learn more about Teams <https://aka.ms/JoinTeamsMeeting> | Meeting options
<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fteams.microsoft.com%2FmeetingOptions%2F%3ForganizerId%3Dd44b0b19-dbad-43be-84e0-ebb62bf3b442%26tenantId%3D72f988bf-86f1-41af-91ab-2d7cd011db47%26threadId%3D19_meeting_ZDBkMzMyNzItM2RkNy00MTQ5LWI0MTEtYWQ1OWIzMGE4ZTA0%40thread.v2%26messageId%3D0%26language%3Den-US&data=02%7C01%7Cv-bhpadi%40microsoft.com%7C88f001e5eec248e14ea508d79adecf28%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637148154093115354&sdata=4ga63%2FAG5OXiQfhSJykHWPeaEbug4yRAO7rnKQMEW3w%3D&reserved=0>

________________________________________________________________________________

Best Regards

*Bhavika Padidala*

Engineer - Microsoft Business Intelligence

Time Zone :-Pacific Standard Time

Hours of Operation: Mon - Fri 9 AM – 6 PM

Email: v-bhpadi(at)microsoft(dot)com

[image: cid:image001(dot)png(at)01D59F06(dot)51B5D970]

*If delay in response to your email, kindly notify to the below Operations
Manager’s team for immediate attention.*

MT-BAP-OM-TA(at)microsoft(dot)com

_____________________________________________
*From:* Keith Yanase [mailto:keith(dot)yanase(at)soterawireless(dot)com
<keith(dot)yanase(at)soterawireless(dot)com>]
*Sent:* Wednesday, January 15, 2020 5:10 PM
*To:* Bhavika Padidala (MINDTREE LIMITED) <v-bhpadi(at)microsoft(dot)com>
*Cc:* Vikram Ramagiri (MINDTREE LIMITED) <v-virama(at)microsoft(dot)com>; support <
support(at)mail(dot)support(dot)microsoft(dot)com>
*Subject:* Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

Yeah absolutely. I will wait for your call tomorrow.

Keith

On Wed, Jan 15, 2020 at 4:40 PM Bhavika Padidala (MINDTREE LIMITED) <
v-bhpadi(at)microsoft(dot)com> wrote:

Hi Keith,

Is it ok if I schedule a call tomorrow at 11:00 AM PST?

Looking forward to hearing back from you.

If you have any questions or concerns, please reply to this Email thread.

Best Regards

*Bhavika Padidala*

Engineer - Microsoft Business Intelligence

Time Zone :-Pacific Standard Time

Hours of Operation: Mon - Fri 9 AM – 6 PM

Email: v-bhpadi(at)microsoft(dot)com

[image: cid:image001(dot)png(at)01D59F06(dot)51B5D970]

*If delay in response to your email, kindly notify to the below Operations
Manager’s team for immediate attention.*

MT-BAP-OM-TA(at)microsoft(dot)com

*From:* Keith Yanase [mailto:keith(dot)yanase(at)soterawireless(dot)com]
*Sent:* Wednesday, January 15, 2020 4:33 PM
*To:* Bhavika Padidala (MINDTREE LIMITED) <v-bhpadi(at)microsoft(dot)com>
*Subject:* [EXTERNAL] Re: Case 120011521001709 - Issues connecting to
postgreSQL server

Hi Bhavika and thanks for the quick response. I just left work but I will
be available tomorrow for a screen share session. You can call me at
+16196002517

I will be in the office between 9am to 4pm pacific time tomorrow. If I
don’t pick up please leave a message and I will call you back.

Looking forward to resolving this with you.

Keith

On Wed, Jan 15, 2020 at 4:25 PM Bhavika Padidala (MINDTREE LIMITED) <
v-bhpadi(at)microsoft(dot)com> wrote:

Hello Keith,

Thank you for contacting Microsoft Support.

My name is Bhavika Padidala and I am the Microsoft Support Engineer who
will be working with you on support request 120011521001709. You can reach
me using the contact information in my signature.

I hope you’re doing well J.

I tried calling you at 8584274620, but it is asking me for extension. Could
you please provide me with your extension?

From the description in the support ticket, I see that you are unable to
connect to a PostgreSQL server through OpenSSH..

Could you please let me know your availability for a screen share session
where we can discuss more about the issue and look for an optimal way to
resolve this issue as early as possible.

I’ll be looking forward to your response.

If you have any questions or concerns, please reply to this Email thread.

Best Regards

*Bhavika Padidala*

Engineer - Microsoft Business Intelligence

Time Zone :-Pacific Standard Time

Hours of Operation: Mon - Fri 9 AM – 6 PM

Email: v-bhpadi(at)microsoft(dot)com

[image: cid:image001(dot)png(at)01D59F06(dot)51B5D970]

*If delay in response to your email, kindly notify to the below Operations
Manager’s team for immediate attention.*

MT-BAP-OM-TA(at)microsoft(dot)com