Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Ajax communication failed (error 500) only for wizard and cloud #36

Open
bolemo opened this issue Apr 20, 2023 · 3 comments
Open

Ajax communication failed (error 500) only for wizard and cloud #36

bolemo opened this issue Apr 20, 2023 · 3 comments

Comments

@bolemo
Copy link

bolemo commented Apr 20, 2023

Greetings,

As I want to find a solution to monitor a running and working freeradius setup as a small ISP lab point of view, I gave a try to RADIUSdesk.

I installed a fresh copy of RADIUSdesk on an ubuntu 22.04 VM following these instructions: https://www.radiusdesk.com/wiki/getting_started/22_install_ubuntu_nginx#install_radiusdesk

I made a few changes, as I have a nginx reverse proxy for it, and it points to /var/www/radiusdesk/ instead of /var/www/html/, and I made the symlinks to radiusdesk instead of html, and modified the paths properly from the tutorial, and for the cron4 tasks as well.

I did not sync with the running freeradius yet, as I encounter what seems to be a bug.
I can access the pages, PHP is working fine, I can change the settings, admins…
But I encounter an error as soon as I touch the Clouds, either from the wizard or the OTHERS->Clouds tab.

Creating a cloud (there is of course none by default) is giving me an Ajax communication failed on the GUI (Failed to load resource: the server responded with a status of 500 () on https://radiusdesk.mydomain.com/cake4/rd_cake/wizards/new-site-step-one.json or https://radiusdesk.mydomain.com/cake4/rd_cake/clouds/add.json)

The log shows this:

2023-04-17 11:36:13 warning: DebugKit is disabling itself as your host `radiusdesk.mydomain.com` is not in the known safe list of top-level-domains (localhost, invalid, test, example, local). If you would like to force DebugKit on use the `DebugKit.forceEnable` Configure option.
2023-04-17 11:36:13 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field 'description' doesn't have a default value in /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Stack Trace:
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php:39
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Connection.php:360
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Connection.php:363
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Query.php:254
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:2091
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:1984
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:1883
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:1570
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Database/Connection.php:709
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:1571
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/ORM/Table.php:1884
- /var/www/rdcore/cake4/rd_cake/src/Controller/WizardsController.php:765
- /var/www/rdcore/cake4/rd_cake/src/Controller/WizardsController.php:176
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Controller/Controller.php:547
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:139
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php:114
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/BaseApplication.php:320
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:77
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php:162
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php:186
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:77
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:131
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:73
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Runner.php:58
- /var/www/rdcore/cake4/rd_cake/vendor/cakephp/cakephp/src/Http/Server.php:90
- /var/www/rdcore/cake4/rd_cake/webroot/index.php:40
- /var/www/rdcore/cake4/rd_cake/index.php:16

Request URL: /wizards/new-site-step-one.json
Referer URL: https://radiusdesk.mydomain.com/rd/build/production/Rd/
Client IP: xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx
2023-04-19 11:34:52 warning: DebugKit is disabling itself as your host `radiusdesk.mydomain.com` is not in the known safe list of top-level-domains (localhost, invalid, test, example, local). If you would like to force DebugKit on use the `DebugKit.forceEnable` Configure option.

The problem is likely not nginx or php related, as all the rest works well, but anyway, here is my nginx config in /etc/nginx/site-enabled/radiusdesk.mydomain.com:

server {
    listen              80;
    listen              [::]:80;

    server_name         radiusdesk.mydomain.com;

    include             snippets/certbot.conf;

    location / {
	return              301 https://radiusdesk.mydomain.com$request_uri;
    }
}

server {
    listen	443 ssl http2;
    listen	[::]:443 ssl http2;
    server_name	radiusdesk.mydomain.com;

    allow	xxxx:xxxx:xxxx::/48;
    deny	all;

    add_header	Strict-Transport-Security "max-age=31536000; includeSubDomains" always;

    ssl_certificate	/path/to/certs/radiusdesk.mydomain.com/fullchain.pem;
    ssl_certificate_key	/path/to/certs/certs/radiusdesk.mydomain.com/privkey.pem;

    access_log	/var/log/nginx/access_radiusdesk.log;

    proxy_set_header	Host $http_host;
    include	snippets/robots.conf;
    include	snippets/certbot.conf;

    root /var/www/radiusdesk;
    index index.php index.html index.htm;

    # pass PHP scripts to FastCGI server
    #
    location ~ \.php$ {
      include snippets/fastcgi-php.conf;
      #
      #       # With php-fpm (or other unix sockets):
      fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;
      #       # With php-cgi (or other tcp sockets):
      #       fastcgi_pass 127.0.0.1:9000;
    }

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    location ~ /\.ht {
      deny all;
    }

    location /cake4/rd_cake/node-reports/submit_report.json {
      try_files $uri $uri/ /reporting/reporting.php;
    }

    location /cake4/rd_cake {
      rewrite ^/cake4/rd_cake(.+)$ /cake4/rd_cake/webroot$1 break;
      try_files $uri $uri/ /cake4/rd_cake/index.php$is_args$args;
    }

    location ~ ^/cake4/.+\.(jpg|jpeg|gif|png|ico|js|css)$ {
      rewrite ^/cake4/rd_cake/webroot/(.*)$ /cake4/rd_cake/webroot/$1 break;
      rewrite ^/cake4/rd_cake/(.*)$ /cake4/rd_cake/webroot/$1 break;
      access_log off;
      expires max;
      add_header Cache-Control public;
    }

    location / {
      try_files $uri $uri/ =404;
    }
}

Thank you for you assistance :)
@predators46
Copy link

@bolemo

how do you install radiusdesk in ubuntu? did you run composer

@bolemo
Copy link
Author

bolemo commented May 5, 2023

@bolemo

how do you install radiusdesk in ubuntu? did you run composer

No, I did not use Docker at all.

I followed the instructions here: https://www.radiusdesk.com/wiki/getting_started/22_install_ubuntu_nginx
Except nginx and freeradius were already installed.

My goal is strictly monitoring the existing freeradius (used in an ISP logic to authorize customer devices on DHCP from their router's MAC); I don't need the AP / captive portal features…

@darshankowlaser
Copy link

hello did you come right? also getting the same error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@bolemo @predators46 @darshankowlaser