nokernel 0 Posted April 5, 2020 Share Posted April 5, 2020 Hello, Here is yet another fail to login due to `SQLitePCL.pretty.SQLiteException: Constraint: NOT NULL constraint failed: Tokens.DeviceName` I renamed / rebooted my android device, which changed nothing to the error. I also changed the device hostname in dns ( changed nothing ). Help haha This is a fresh install of emby server 4.4.1.0 on windows. I can login from web interface with the same user `myusername`, but I get invalid username or password when I try to login using the android app ( fresh install also ). 2020-04-05 15:20:52.008 Info HttpServer: HTTP POST http://192.168.150.100:8096/emby/Users/authenticatebyname. UserAgent: Mozilla/5.0 (Linux; Android 10; PH-1 Build/QQ1A.200105.032; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/80.0.3987.162 Mobile Safari/537.36 2020-04-05 15:20:52.008 Debug XmlSerializer: Serializing to file C:\Users\dpaquet\AppData\Roaming\Emby-Server\programdata\config\users\1b5e1a8656b942d1ae2e369a0f5d4310\policy.xml 2020-04-05 15:20:52.010 Info UserManager: Authentication request for myusername has succeeded. 2020-04-05 15:20:52.010 Info SessionManager: Creating new access token for user 3 2020-04-05 15:20:52.011 Error HttpServer: Error processing request *** Error Report *** Version: 4.4.1.0 Command line: C:\Users\dpaquet\AppData\Roaming\Emby-Server\system\EmbyServer.dll Operating system: Microsoft Windows NT 6.2.9200.0 64-Bit OS: True 64-Bit Process: True User Interactive: True Runtime: file:///C:/Users/dpaquet/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll System.Environment.Version: 3.1.3 Processor count: 16 Program data path: C:\Users\dpaquet\AppData\Roaming\Emby-Server\programdata Application directory: C:\Users\dpaquet\AppData\Roaming\Emby-Server\system SQLitePCL.pretty.SQLiteException: Constraint: NOT NULL constraint failed: Tokens.DeviceName SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Security.AuthenticationRepository.Create(AuthenticationInfo info) at Emby.Server.Implementations.Session.SessionManager.GetAuthorizationToken(User user, String deviceId, String app, String appVersion, String deviceName) at Emby.Server.Implementations.Session.SessionManager.AuthenticateNewSessionInternal(AuthenticationRequest request, Boolean enforcePassword, CancellationToken cancellationToken) at MediaBrowser.Api.UserService.Post(AuthenticateUserByName request) at Emby.Server.Implementations.Services.ServiceController.GetTaskResult(Task task) at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken) at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken) Source: SQLitePCL.pretty TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32) Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 5, 2020 Share Posted April 5, 2020 Hi there, what version of the android app are you running? 1 Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 5, 2020 Author Share Posted April 5, 2020 Hi there, what version of the android app are you running? wow fast Android app version is 3.1.14 Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 5, 2020 Share Posted April 5, 2020 Would you mind trying this version of the android app: https://www.dropbox.com/s/84i2gaor1w959q2/MediaBrowser.Mobile-google-armeabi-v7a-release.apk?dl=0 And then provide an android app log by following these instructions: https://emby.media/community/index.php?/topic/15638-how-to-report-an-android-problem/ Thanks. 1 Link to comment Share on other sites More sharing options...
freefrank 0 Posted April 6, 2020 Share Posted April 6, 2020 (edited) Hi I came from another post with same problem. Here is my log from android. 9fd003ea-94ce-4cef-932a-75a9e41b0db7.log Edited April 6, 2020 by freefrank Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 6, 2020 Author Share Posted April 6, 2020 Would you mind trying this version of the android app: https://www.dropbox.com/s/84i2gaor1w959q2/MediaBrowser.Mobile-google-armeabi-v7a-release.apk?dl=0 And then provide an android app log by following these instructions: https://emby.media/community/index.php?/topic/15638-how-to-report-an-android-problem/ Thanks. Hey there, here is the app logs when using the version you sent on dropbox. b5ae0c65-b5af-40dd-85c5-b024826ebd86.log Link to comment Share on other sites More sharing options...
Solution Luke 36886 Posted April 7, 2020 Solution Share Posted April 7, 2020 Ok, can you please try this version: https://www.dropbox.com/s/84i2gaor1w959q2/MediaBrowser.Mobile-google-armeabi-v7a-release.apk?dl=0 Thanks. 1 Link to comment Share on other sites More sharing options...
freefrank 0 Posted April 7, 2020 Share Posted April 7, 2020 This version works! Do you still need the log? Thank you! Ok, can you please try this version: https://www.dropbox.com/s/84i2gaor1w959q2/MediaBrowser.Mobile-google-armeabi-v7a-release.apk?dl=0 Thanks. Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 7, 2020 Share Posted April 7, 2020 Nope, all good. Thanks for the feedback. 1 Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 7, 2020 Author Share Posted April 7, 2020 talk about topic hijack @@freefrank.... Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 7, 2020 Share Posted April 7, 2020 talk about topic hijack @@freefrank.... I asked him to come in here because he created another topic describing the exact same thing. It's just easier for us to have one discussion rather than the multiple ones over the same thing. Anyway, can you try the build I've linked to and see if that helps? I'll get it up on the store today. Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 7, 2020 Author Share Posted April 7, 2020 (edited) Ok, can you please try this version: https://www.dropbox.com/s/84i2gaor1w959q2/MediaBrowser.Mobile-google-armeabi-v7a-release.apk?dl=0 Thanks. Same here using that version I can login to emby server. Great! Was the issue related to it not able to get the device hostname? I asked him to come in here because he created another topic describing the exact same thing. It's just easier for us to have one discussion rather than the multiple ones over the same thing. Anyway, can you try the build I've linked to and see if that helps? I'll get it up on the store today. My bad sorry @@freefrank Edited April 7, 2020 by nokernel Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 7, 2020 Share Posted April 7, 2020 It was an issue that was occurring when your custom android device name was composed of all non-latin characters. 1 Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 7, 2020 Author Share Posted April 7, 2020 It was an issue that was occurring when your custom android device name was composed of all non-latin characters. I see, and looks like that changing device name did not help at all with the older version ( for me ). Well thanks again, I guess I will keep an eye on futur release to go back to the google-play verison of the client once it's released. Link to comment Share on other sites More sharing options...
Typey1 0 Posted April 8, 2020 Share Posted April 8, 2020 That link for me, directs me to the media browser, i was hoping for a working version of emby, so what did i miss? Link to comment Share on other sites More sharing options...
nokernel 0 Posted April 8, 2020 Author Share Posted April 8, 2020 That link for me, directs me to the media browser, i was hoping for a working version of emby, so what did i miss? That link is the android app for emby. With a fix for the issue above. Link to comment Share on other sites More sharing options...
Typey1 0 Posted April 8, 2020 Share Posted April 8, 2020 After i uninstalled the current version I'm able to install the revised emby, i think it's fixed the issue accessing from wan, I'll try the lan tomorrow. Great stuff, much appreciated Luke and all! Link to comment Share on other sites More sharing options...
Luke 36886 Posted April 8, 2020 Share Posted April 8, 2020 Thanks for the feedback. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now