friend invite

gistfile1.txt

Referer: https://friend.hios.fi:6502/webclient/app.html?app=FriendChat&data=%7B%22type%22%3A%22live-invite%22%2C%22data%22%3A%7B%22type%22%3A%22live%22%2C%22token%22%3A%22pub-0412adc1-daa3-43e9-aa95-46cf9327fe76%22%2C%22host%22%3A%22friend.hios.fi%3A27970%22%2C%22roomId%
22%3A%22room-66fe5696-db77-4e19-a132-9ca590adb83c%22%2C%22vers%22%3A2%7D%7D&theme=borderless
Accept-Encoding: gzip, deflate, br
Accept-Language: en-GB,en;q=0.8,en-US;q=0.6,de;q=0.4
Cookie: deviceId=touch_other_Generic_9e53b81282996fd939bdb55f46cb51a2


 (network/http.c:1086) 140012785506048 NO MORE DATA
 140012785506048: [ProtocolHttp] Request parsed without errors
 (network/protocol_http.c:377) 140012785506048 [ProtocolHttp] Want to parse path: /webclient/locale/en.locale (27)
  (./system/log/user_logger_manager.h:68) 140012785506048 SESSION (nil)
 140012785506048: [ProtocolHttp] read static file /webclient/locale/en.locale size 27
140012785506048: [ProtocolHttp] Read single file, first from cache resources//webclient/locale/en.locale
140012785506048: [ProtocolHttp] File will be reloaded
140012785506048: [ProtocolHttp] Return file content
140012785506048: [ProtocolHttp] File returned to caller
140012785506048: [ProtocolHttp] File delivered
 (network/socket.c:2455) 140012785506048 [SocketClose] before lock
  (network/socket.c:2458) 140012785506048 [SocketClose] locked
  (network/socket.c:2461) 140012785506048 [SocketClose] ssl
  (network/socket.c:2485) 140012785506048 Ret 0
  (network/socket.c:2546) 140012785506048 [SocketClose] before ssl clear
  (network/socket.c:2550) 140012785506048 [SocketClose] ssl released
  (network/socket.c:2563) 140012785506048 shutdown socket
  (network/socket.c:2568) 140012785506048 [SocketClose] before unlock
  (network/socket.c:2570) 140012785506048 [SocketClose] mutex unlocked
 140012751943424: [ProtocolHttp] Request parsed without errors
 (network/protocol_http.c:377) 140012751943424 [ProtocolHttp] Want to parse path: /system.library/login (21)
  (network/protocol_http.c:478) 140012751943424 [ProtocolHttp] -----------------------------------------------------Calling SYSBASE via HTTP login
 140012751943424: --------------------------------------------------------------------------------
 Webreq func: login
 ---------------------------------------------------------------------------------
 (./system/log/user_logger_manager.h:68) 140012751943424 SESSION (nil)
  (system/systembase_web.c:779) 140012751943424 Found logged user under address uanem apiuser pass HASHED9259a5c60b165e76feeef3fdcf695bba59afeec6f6b7e4fc56e4bf73c4eceb17 deviceid loving-crotch-grabbing-espen
  (system/systembase_web.c:878) 140012751943424 Authenticate dstusrsess == NULL is user sentinel 0
  (fcdb.c:315) 140012751943424 [FCDB] Authenticate START (apiuser)
  (system/systembase.c:1910) 140012751943424 [LibraryMYSQLGet] We found mysql library on slot 17.
  (system/user/user_manager.c:1199) 140012751943424 [UMGetLoginPossibilityLastLogins] username apiuser
  (mysqllibrary.c:1057) 140012751943424 [MYSQLLibrary] SELECT QUERY SELECT `LoginTime`,`Failed` FROM `FUserLogin` WHERE `Login`='apiuser' AND (`LoginTime` > 1505803845 AND `LoginTime` <= 1505807445) ORDER BY `LoginTime` DESC
  (system/systembase.c:1983) 140012751943424 [SystemBase] MYSQL slot 17 was closed properly.
  (fcdb.c:334) 140012751943424 [FCDB] Authentication, access: 1, time difference between last login attempt and now 230
  (fcdb.c:359) 140012751943424 [FCDB] Usersession not provided, will be taken from DB
  (system/systembase.c:1910) 140012751943424 [LibraryMYSQLGet] We found mysql library on slot 18.
  (mysqllibrary.c:82) 140012751943424 [MYSQLLibrary] Load
  (mysqllibrary.c:145) 140012751943424 [MYSQLLibrary] SQL SELECT QUERY 'SELECT `ID`,`Name`,`Password`,`Fullname`,`Email`,`SessionID`,`LoggedTime`,`CreatedTime`,`LoginTime`,`MaxStoredBytes`,`MaxReadedBytes` FROM FUser WHERE  Name = 'apiuser'
  (mysqllibrary.c:319) 140012751943424 [MYSQLLibrary] Load END
  (system/systembase.c:1983) 140012751943424 [SystemBase] MYSQL slot 18 was closed properly.
  (system/user/user_manager.c:547) 140012751943424 [UMUserGetByNameDB] END
  (fcdb.c:372) 140012751943424 [FCDB] User not found, generate random loop, seconds: 11
  (system/systembase.c:1910) 140012751943424 [LibraryMYSQLGet] We found mysql library on slot 19.
  (system/systembase.c:1910) 140012751943424 [LibraryMYSQLGet] We found mysql library on slot 20.
  (system/user/user_manager.c:911) 140012751943424 [UMGetUserByNameDB] start
  (mysqllibrary.c:82) 140012751943424 [MYSQLLibrary] Load
  (mysqllibrary.c:145) 140012751943424 [MYSQLLibrary] SQL SELECT QUERY 'SELECT `ID`,`Name`,`Password`,`Fullname`,`Email`,`SessionID`,`LoggedTime`,`CreatedTime`,`LoginTime`,`MaxStoredBytes`,`MaxReadedBytes` FROM FUser WHERE  `Name` = 'apiuser'
  (mysqllibrary.c:319) 140012751943424 [MYSQLLibrary] Load END
  (system/systembase.c:1977) 140012751943424 [SystemBase] Mysql slot 19 is still in use
  (system/systembase.c:1983) 140012751943424 [SystemBase] MYSQL slot 20 was closed properly.
  (system/user/user_manager.c:936) 140012751943424 [UMGetUserByNameDB] end
  (system/user/user_manager.c:1152) 140012751943424 [UMStoreLoginAttempt] start
  (mysqllibrary.c:599) 140012751943424 [MYSQLLibrary] Save
  (mysqllibrary.c:864) 140012751943424 [MYSQLLibrary] New entry created in DB, ID: 109
  (system/systembase.c:1983) 140012751943424 [SystemBase] MYSQL slot 19 was closed properly.
  (system/systembase_web.c:908) 140012751943424 [SysWebRequest] Failed to login user and authenticate.
  (system/systembase_web.c:1067) 140012751943424 [ERROR] User not found by user.library
  (system/systembase_web.c:1689) 140012751943424 Response pointer 0x7f5680000f20
  (network/socket.c:2455) 140012751943424 [SocketClose] before lock
  (network/socket.c:2458) 140012751943424 [SocketClose] locked

Hi, this is a bug on our end. The "apiuser" is missing. You can create it using the "Users" app. Just call it apiuser with apipass as password and set the type to "API user". We will fix our core DB script to set this up on install.

You can also fix this in the DB:

INSERT INTO FUserGroup (UserID,Name,Type) VALUES (0,'API','Level');

INSERT INTO FUser ( Name, Password, FullName, Email, SessionID, LoggedTime, CreatedTime, Image, LoginTime, MaxStoredBytes, MaxReadedBytes) VALUES
('apiuser', '{S6}3a294fec6996cdea157ed88839469eb29c597494d1132ea154528c131263c6f0', 'API', NULL, '', 0, 0, '', 0, 0, 0);

INSERT INTO FUserToGroup (UserID,UserGroupID) VALUES (( SELECT ID FROM FUser WHERE Name = 'apiuser'), (SELECT ID FROM FUserGroup WHERE Name = 'API' AND Type = 'Level'));

We will add this patch to our init sql's.