Remote Exception when creating users in Expedition

Mark_Mills — Thu, 04 Mar 2021 03:54:36 GMT

I cannot create new users in Expedition v1.1.91.3, and a blank error box stating "Remote Exception" with no other information. I have tried another installation running an older v1.1.90 and it works fine.

When checking the apache error.log file there is the below error and I hope someone can give advice on how to fix this?

[Thu Mar 04 14:42:54.731320 2021] [:error] [pid 340] [client 10.128.22.14:58607] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'api_key' in 'field list' in /var/www/html/libs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77\nStack trace:\n#0 /var/www/html/libs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(77): PDO->prepare('insert into `us...', Array)\n#1 /var/www/html/libs/vendor/illuminate/database/Connection.php(452): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('insert into `us...')\n#2 /var/www/html/libs/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into `us...', Array)\n#3 /var/www/html/libs/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('insert into `us...', Array, Object(Closure))\n#4 /var/www/html/libs/vendor/illuminate/database/Connection.php(459): Illuminate\\Database\\Connection->run('insert into `us...', Array, Object(Closure))\n#5 /var/www/html/libs/vendor/illuminate/database/Connection.php(411): I in /var/www/html/libs/vendor/illuminate/database/Connection.php on line 664, referer:

Re: Remote Exception when creating users in Expedition

dgildelaig — Thu, 04 Mar 2021 14:19:33 GMT

I cannot reproduce this error. Actually, this error seems related to a Device creation, and not a user creation

What kind of user are you creating?

- Local

- LDAP

- Radius

Have you checked if restarting the Expedition instance, the issue persists?

Re: Remote Exception when creating users in Expedition

Mark_Mills — Mon, 08 Mar 2021 23:49:13 GMT

Restarting expedition does not solve the problem, this has been tried before.

I get the error when attempting to create both a local user and a ldap user.

Tailing /var/log/apache2/error.log when attempting to create a user generates the error included above every time for some reason.

topic Re: Remote Exception when creating users in Expedition in Expedition Discussions

Remote Exception when creating users in Expedition

Re: Remote Exception when creating users in Expedition

Re: Remote Exception when creating users in Expedition