XFallSeane Posted March 15, 2021 Share Posted March 15, 2021 54 minutes ago, jcsnider said: Note.. if running on Windows and you use the *:5400 endpoint you probably have to run the server as Admin for it to work. Â Â Yes big note for this notice ! Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 22 hours ago, XFallSeane said:   Hi In cms db, you need enter the ip in default_value and value. Plain password needed. In your server you can give api access for specific user account (cmd in API DOC) We recommend this configuration in api.config.json :  { "RouteAuthorization": {}, "Hosts": [ "http://localhost:5400", "*:5400" ], "Cors": [], "DataProtectionKey": "yourkey", "Enabled": true, "DebugMode": false, "SeedMode": false, "RefreshTokenLifetime": 30, "ThrottlePolicy": { "IpThrottling": false, "IpWhitelist": [], "IpRules": {}, "ClientThrottling": false, "ClientWhitelist": [], "ClientRules": { "test": { "PerSecond": 50, "PerMinute": 50, "PerHour": 0, "PerDay": 0, "PerWeek": 0 } }, "EndpointThrottling": false, "EndpointWhitelist": [], "EndpointRules": { "/api/oauth/token": { "PerSecond": 1, "PerMinute": 5, "PerHour": 0, "PerDay": 0, "PerWeek": 0 } }, "StackBlockedRequests": false, "Rates": { "Second": 1, "Minute": 60 } }, "FallbackClientKey": "test", "RequestLogLevel": 128 }  I work on a total rework for Intersect CMS with several optimization and bug correction. Two official game work with my version of Intersect CMS. I publish soon a post for Rework Intersect CMS.  The user have api roles full access made via cmd accordingly to api docs. Is this cms database settings correct then? Or do you have an example?     Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 4 minutes ago, Worldofjimmy said:  The user have api roles full access made via cmd accordingly to api docs. Is this cms database settings correct then? Or do you have an example?     For this version is correct If the cms not work check in your playerdata.db with SqlLite Browser if the account has all  after api: true is true in the power Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 4 minutes ago, XFallSeane said: For this version is correct If the cms not work check in your playerdata.db with SqlLite Browser if the account has all  after api: true is true in the power  This is in SqlLite Browser for this user. I have also opened all incoming traffic for this port 5400-5403 in IIS in Windows 10 and I run the server as admin.  Not sure where I can debug as it works fine via Postman...  Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 8 minutes ago, Worldofjimmy said:  This is in SqlLite Browser for this user. I have also opened all incoming traffic for this port 5400-5403 in IIS in Windows 10 and I run the server as admin.  Not sure where I can debug as it works fine via Postman...   The cms not work ? Your password is plain in web database ? Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 1 minute ago, XFallSeane said:  The cms not work ? Your password is plain in web database ?  Exactly, does not work. If the password was "Password" then yes, the password is in plain text in web database... Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 2 minutes ago, Worldofjimmy said:  Exactly, does not work. If the password was "Password" then yes, the password is in plain text in web database... If u want my rework version is available here :https://github.com/Thomasfds/intersect-cms Installation process in french is here :https://github.com/Thomasfds/intersect-cms/wiki/Installation-(FR) Worldofjimmy 1 Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 3 minutes ago, XFallSeane said: If u want my rework version is available here :https://github.com/Thomasfds/intersect-cms Installation process in french is here :https://github.com/Thomasfds/intersect-cms/wiki/Installation-(FR)  I'll try your reworked version, use google translate for the installation guide and update you on this :-) Thanks for sharing!  Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 Just now, Worldofjimmy said:  I'll try your reworked version, use google translate for the installation guide and update you on this :-) Thanks for sharing!  No problem  ! Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 54 minutes ago, XFallSeane said: No problem  !  Now I receive this error when I try to Login, is there any logs that I can check somewhere? Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 12 minutes ago, Worldofjimmy said:  Now I receive this error when I try to Login, is there any logs that I can check somewhere? Hm, Can you go to the App / Controller / UserController file on line 162 and remove the // from the code? If no code at this line add this die(var_dump($register)); and retry logging in and screen the page Before in your database web, in cms_setting api_token is # or a token as save ? default_value and value do you have  been modified to text instead of varchar? Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 3 minutes ago, XFallSeane said: Hm, Can you go to the App / Controller / UserController file on line 162 and remove the // from the code? If no code at this line add this die(var_dump($register)); and retry logging in and screen the page  I guess CMS cannot connect to my IP via the port. Not sure why since Postman requests works fine. Maybe the game server needs to be located on an VPS instead of my mini homelab?  I got this message: Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 3 minutes ago, Worldofjimmy said:  I guess CMS cannot connect to my IP via the port. Not sure why since Postman requests works fine. Maybe the game server needs to be located on an VPS instead of my mini homelab?  I got this message: Nice, in db modify in table cms_setting => setting => api_server => http://yourip:yourport and that works  api_server : http://votreip:votreport => step 7 of installation Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 1 hour ago, XFallSeane said: Nice, in db modify in table cms_setting => setting => api_server => http://yourip:yourport and that works  api_server : http://votreip:votreport => step 7 of installation  I did that but it does not work. I setup a new host via Intersect hosting and tried to connect to API there but same problem. I this correct for your version of cms? Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 17 minutes ago, Worldofjimmy said:  I did that but it does not work. I setup a new host via Intersect hosting and tried to connect to API there but same problem. I this correct for your version of cms?  For me yes everything is correct you have same message? Failed to connect yourip....?  IIf you have the same message it's because it's from the server of the shot and not from the cms Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 6 minutes ago, XFallSeane said:  For me yes everything is correct you have same message? Failed to connect yourip....?  Yes same message:   Seems to work to via Postman but not via Intersect CMS   Here is Intersect Server running via Intersect hosting Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 11 minutes ago, Worldofjimmy said:  Yes same message:   Seems to work to via Postman but not via Intersect CMS   Here is Intersect Server running via Intersect hosting   Do you have a token look at Postman? It's weird it should work if you have to replace all the files of the cms with mine Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 2 minutes ago, XFallSeane said:   Do you have a token look at Postman? It's weird it should work if you have to replace all the files of the cms with mine  Yes I receive a token when I tried via Postman. I made a clean setup with your version. Can it be something with the php code?  Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 1 minute ago, Worldofjimmy said:  Yes I receive a token when I tried via Postman. I made a clean setup with your version. Can it be something with the php code?   3 games turns with my version without problem it's weird 🤔 as if it was impossible to join the api in public Not sure it's from the source code of the cms Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 1 minute ago, XFallSeane said:  3 games turns with my version without problem it's weird 🤔 as if it was impossible to join the api in public Is your games public? or locally? Link to comment Share on other sites More sharing options...
XFallSeane Posted March 16, 2021 Share Posted March 16, 2021 Just now, Worldofjimmy said: Is your games public? or locally?  Public Games, do you can share in private preferences.php file ? Link to comment Share on other sites More sharing options...
Worldofjimmy Posted March 16, 2021 Share Posted March 16, 2021 3 minutes ago, XFallSeane said:  Public Games, do you can share in private preferences.php file ? Private message sent :-) Link to comment Share on other sites More sharing options...
jcsnider Posted March 16, 2021 Share Posted March 16, 2021 As an aside.. if you are using my hosting service you can use SSL through a reverse proxy by using https://eu0.hosting.freemmorpgmaker.com/XXXX/api/oauth/token XFallSeane 1 Link to comment Share on other sites More sharing options...
Nimbus Posted April 21, 2021 Share Posted April 21, 2021 I am getting the following error when trying to access the url after setup: Fatal error: Uncaught PDOException: Could not connect to database (BSC). in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php:440 Stack trace: #0 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(161): RedBeanPHP\Driver\RPDO->connect() #1 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(464): RedBeanPHP\Driver\RPDO->runQuery('SELECT * FROM c...', Array) #2 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Adapter\DBAdapter.php(118): RedBeanPHP\Driver\RPDO->GetAll('SELECT * FROM c...', Array) #3 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(158): RedBeanPHP\Adapter\DBAdapter->get('SELECT * FROM c...', Array) #4 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(1226): RedBeanPHP\Facade::query('get', 'SELECT * FROM c...', Array) #5 C:\xampp\htdocs\BSC-CMS\public\index.php(63): RedBeanPHP\Facade::getAll('SELECT * FROM c...') #6 {main} thrown in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php on line 440 Any help would be greatly appreciated! Link to comment Share on other sites More sharing options...
XFallSeane Posted April 21, 2021 Share Posted April 21, 2021 5 minutes ago, Nimbus said: I am getting the following error when trying to access the url after setup: Fatal error: Uncaught PDOException: Could not connect to database (BSC). in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php:440 Stack trace: #0 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(161): RedBeanPHP\Driver\RPDO->connect() #1 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(464): RedBeanPHP\Driver\RPDO->runQuery('SELECT * FROM c...', Array) #2 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Adapter\DBAdapter.php(118): RedBeanPHP\Driver\RPDO->GetAll('SELECT * FROM c...', Array) #3 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(158): RedBeanPHP\Adapter\DBAdapter->get('SELECT * FROM c...', Array) #4 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(1226): RedBeanPHP\Facade::query('get', 'SELECT * FROM c...', Array) #5 C:\xampp\htdocs\BSC-CMS\public\index.php(63): RedBeanPHP\Facade::getAll('SELECT * FROM c...') #6 {main} thrown in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php on line 440 Any help would be greatly appreciated! Â Hi, Did you correctly fill in the information in application / App / preferences.php? 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