Hi David, Have you had a chance to review the files I have uploaded? Thanks.
-Chuan From: Zhao, Chuan <chuan.z...@teradata.com.INVALID> Date: Tuesday, July 23, 2024 at 7:44 PM To: lidav...@apache.org <lidav...@apache.org> Cc: dev@arrow.apache.org <dev@arrow.apache.org> Subject: Re: [EXTERNAL] Re: Question about arrow flight authentication [You don't often get email from chuan.z...@teradata.com.invalid. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] Hi David, Here are the files: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgist.github.com%2Fbigchuan79%2Fa1efa7d981aa74a3d8f61beb2344f91a&data=05%7C02%7CChuan.Zhao%40teradata.com%7C5de5ab145e7e4c04510b08dcab8a87dd%7C9151cbaafc6b4f4889bb8c4a71982138%7C0%7C0%7C638573858689330954%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=BxAySvjApM5UGWO8sxeWpOxU5V1ND9MTe4QsgXx3z10%3D&reserved=0<https://gist.github.com/bigchuan79/a1efa7d981aa74a3d8f61beb2344f91a> Thanks! -Chuan From: David Li <lidav...@apache.org> Date: Tuesday, July 23, 2024 at 6:21 PM To: dev@arrow.apache.org <dev@arrow.apache.org> Subject: [EXTERNAL] Re: Question about arrow flight authentication [You don't often get email from lidav...@apache.org. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] [CAUTION: External Email] Hi Chuan, The attachment didn't make it through - could you post a Gist or something? Thanks, David On Wed, Jul 24, 2024, at 08:06, Zhao, Chuan wrote: > Hi, > > I am from Teradata and I am working on a POC related to Arrow Flight. > Basically, I wanted to send metadata request from the client to Arrow Flight > Server which fetches the result from Teradata Database (for example table > types) and return it to the client. I want to enable username/password > authentication. Please see attached code on server and client side. > > I found an issue when I run the code. Here is the output on server side: > > Flight SQL Server listening at grpc+tls://localhost:3333 > > awaiting termination ... > > Metadata(content-type=application/grpc,user-agent=grpc-java-netty/1.63.0,grpc-accept-encoding=gzip,authorization=Basic > YXJyb3c6Y2VydA==) > > authenticating user 'arrow' using basic authentication > > Metadata(content-type=application/grpc,user-agent=grpc-java-netty/1.63.0,grpc-accept-encoding=gzip) > > inside method getFlightInfoTableTypes!! > > Metadata(content-type=application/grpc,user-agent=grpc-java-netty/1.63.0,grpc-accept-encoding=gzip,authorization=Basic > YXJyb3c6Y2VydA==) > > authenticating user 'arrow' using basic authentication > > Metadata(content-type=application/grpc,user-agent=grpc-java-netty/1.63.0,grpc-accept-encoding=gzip) > > inside method getStreamTableTypes!! > > I printed out incomingHeaders.toString() in authenticate method in my > ArrowFlightAuthValidate.java. You can see before going into > getFlightInfoTableTypes method, it calls authenticate() two times. The first > time comes with authorization info in the header, but not the second time. > Same for after calling getFlightInfoTableTypes. I have used latest version > 17.0.0 for flight-core, arrow-jdbc and flight-sql on server side and latest > flight-sql-jdbc-driver (17.0.0) on client side. > > Any help would be greatly appreciated. Thanks. > > -Chuan >