Upload content - Youtube link upload isn't working

[komalm]

Hi @amit-tarento, @keshavprasadms

Hope you are doing well!..

Site Environments Details - SunbirdEd portal of version 4.4.1

Issue - We are unable to upload content like Youtube link upload content isn't working.

API Details -

Request URL: host/action/asset/v3/validate?field=license
Request Method: POST
Status Code: 400 Bad Request

Payload -

{
    "asset": {
        "provider": "youtube",
        "url": "https://www.youtube.com/watch?v=E7LwQgUJnYQ"
    }
}

Response -

{
    "resmsgid": "b0ceb3fe-88b1-443e-b075-d4f261865003",
    "msgid": null,
    "err": "ERR_YOUTUBE_LICENSE_VALIDATION",
    "status": "failed",
    "errmsg": "Please Provide Valid YouTube URL!"
} 

Can you please look into it and let us know the steps to resolve the same.

cc @coolbung, @Renuka-S, @vinod303, @pranavirabatti

[vinukumar-vs]

@komalm Please use the valid youtube URL to create. You have chosen the youtube watch or bowser URL to create. Use the youtube share URL to create the content. Also verify the video license is CC(check this video how to check the license).

@AmiableAnil @vaibhavbhuva Check did we updated our microsite with this information. If so please share the link here.

[pranavirabatti]

@vinukumar-vs thanks for taking your time and replying. Unfortunately, this did not work. Can you please share the documentation/guide where I can read more on this? I did not find anything.

[vinukumar-vs]

Did you try with a valid youtube video which has CC BY license?

The video link which you shared is not having CC BY license.
"url": "https://www.youtube.com/watch?v=E7LwQgUJnYQ"
#16 (comment)

[pranavirabatti]

I had tried this @vinukumar-vs

provider: "youtube"
url: "https://youtu.be/Gjqy1jVGuWc"

[pranavirabatti]

@vinukumar-vs any update on this?

[Jayaprakash8887]

Error is thrown from the service when the license value of the video is blank. License is populated using the video details fetched from Youtube API. Looks like video details could not be fetched from youtube. Pls check the youtube API_KEY configuration ("learning_content_youtube_apikey" & "youtube_api_key" - system variable configuration)

https://github.com/project-sunbird/knowledge-platform/blob/release-4.4.0/platform-modules/url-manager/src/main/java/org/sunbird/url/util/YouTubeUrlUtil.java (line - 90)

[vinukumar-vs]

@pranavirabatti Can you verify the Youtube_API_key is valid & having access to get a youtube video license
https://developers.google.com/youtube/v3/sample_requests

[pranavirabatti]

2022-06-10 13:28:51,446 {"eid":"LOG","ets":1654867731446,"ver":"3.0","mid":"LP.1654867731446.082907c0-d040-4b04-b980-24bcab50d4b3","actor":{"id":"org.sunbird.learning.platform","type":"System"},"context":{"channel":"in.ekstep","pdata":{"id":"dev.dev.portal","pid":"","ver":"1.0"},"env":"content","sid":"DcFFE3VkWvmU1Pn4hMSbBvWrOlu_Qbhl"},"edata":{"level":"INFO","type":"api_access","message":"","params":[{"duration":69},{"protocol":"http"},{"size":5417},{"method":"GET"},{"uip":"10.10.1.239"},{"url":"/channel/v3/read/0130152125009674241"},{"status":200}]},"syncts":1654867731446}
Default License is not available for channel: 0130152125009674241
com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.2.5:9042 (com.datastax.driver.core.exceptions.UnavailableException: Not enough replicas available for query at consistency QUORUM (2 required but only 1 alive)))
	at com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:284)
	at com.datastax.driver.core.RequestHandler.access$1200(RequestHandler.java:62)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.findNextHostAndQuery(RequestHandler.java:376)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.retry(RequestHandler.java:558)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.processRetryDecision(RequestHandler.java:540)
	at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:810)
	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1233)
	at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1151)
	at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:323)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:297)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
	at com.datastax.driver.core.InboundTrafficMeter.channelRead(InboundTrafficMeter.java:38)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1408)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:930)
	at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:796)
	at io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:427)
	at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:328)
	at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:905)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.base/java.lang.Thread.run(Thread.java:834)
Exception occurred - class :com.datastax.driver.core.exceptions.NoHostAvailableException with message :All host(s) tried for query failed (tried: /192.168.2.5:9042 (com.datastax.driver.core.exceptions.UnavailableException: Not enough replicas available for query at consistency QUORUM (2 required but only 1 alive)))
2022-06-10 13:29:38,382 {"eid":"LOG","ets":1654867778382,"ver":"3.0","mid":"LP.1654867778382.e065696a-8f6e-4ed1-880b-3cea92d68bc6","actor":{"id":"org.sunbird.learning.platform","type":"System"},"context":{"channel":"in.ekstep","pdata":{"id":"dev.dev.portal","pid":"","ver":"1.0"},"env":"content","sid":"DcFFE3VkWvmU1Pn4hMSbBvWrOlu_Qbhl"},"edata":{"level":"INFO","type":"api_access","message":"","params":[{"duration":17},{"protocol":"http"},{"size":302},{"method":"POST"},{"uip":"10.10.1.239"},{"url":"/content/v3/create"},{"status":500}]},"syncts":1654867778382}

We have updated the youtube api keys. I'm getting this error now. The channel we are using to create/update has a Default License as well. I know this error is not specific to youtube. Can you shed some light on this matter?

[Jayaprakash8887]

Looks like Cassandra DB connection seems to have the problem. Kindly verify the same.

com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.2.5:9042 (com.datastax.driver.core.exceptions.UnavailableException: Not enough replicas available for query at consistency QUORUM (2 required but only 1 alive)))

[coolbung]

Seem to be same as this issue - https://github.com/project-sunbird/sunbird-community/discussions/596

[pranavirabatti]

@pranavirabatti Can you verify the Youtube_API_key is valid & having access to get a youtube video license https://developers.google.com/youtube/v3/sample_requests

We replaced youtube API keys and it is working now. Thanks @vinukumar-vs @Jayaprakash8887