DATABASE ERROR 90003 WHEN ADD NEW USERS

Before posting something, READ the changelog, WATCH the videos, howto and provide following:
Your install is: Bare metal, ESXi, what CPU model, RAM, HD, what EVE version you have, output of the uname -a and any other info that might help us faster.

Moderator: mike

Locked
Boss
Posts: 2
Joined: Tue Mar 14, 2023 12:25 pm

DATABASE ERROR 90003 WHEN ADD NEW USERS

Post by Boss » Tue Mar 14, 2023 1:19 pm

OBS: Tested on eve v2.0 and the error dont appear, if someone have the link for older v5 version this would help me
____
Free EVE Community Edition Version 5.0.1-19
Hardware :
EVE-NG Running on-Proxmox v7.3-6
4 x Intel(R) Xeon(R) CPU E3-1220 v3 @ 3.10GHz (1 Socket)
Kernel Version Linux 5.15.85-1-pve #1 SMP PVE 5.15.85-1
32GB RAM 3TB HDD

I have installed this eve yesterday and just tried to add new user, but when i try to add i just can add one user and after this i receive the error database 90003.
https://imgur.com/a/TJJbgnx
1- Reinstall the vm and eve dont worked
2- /opt/unetlab/wrappers/unl_wrapper -a fixpermissions dont worked
3- restore database dont worked
4- log phperror appear this and i have no idea what to do
"[13-Mar-2023 21:07:05 Europe/Rome] Mar 13 21:07:05 ERROR: Database error (90003).
[13-Mar-2023 21:07:05 Europe/Rome] Mar 13 21:07:05 ERROR: Database error (90003).
[13-Mar-2023 21:07:05 Europe/Rome] Mar 13 21:07:05 PDOException: SQLSTATE[HY000] [2002] No such file or directory in /opt/unetlab/html/includes/functions.php:25
Stack trace:
#0 /opt/unetlab/html/includes/functions.php(25): PDO->__construct()
#1 /opt/unetlab/html/api.php(66): checkDatabase()
#2 {main}
[13-Mar-2023 21:07:05 Europe/Rome] Mar 13 21:07:05 PDOException: SQLSTATE[HY000] [2002] No such file or directory in /opt/unetlab/html/includes/functions.php:25
Stack trace:
#0 /opt/unetlab/html/includes/functions.php(25): PDO->__construct()
#1 /opt/unetlab/html/api.php(66): checkDatabase()
#2 {main}
[13-Mar-2023 21:07:05 Europe/Rome] PHP Fatal error: Uncaught Error: Call to a member function prepare() on bool in /opt/unetlab/html/api.php:79
Stack trace:
#0 {main}
thrown in /opt/unetlab/html/api.php on line 79
[13-Mar-2023 21:07:05 Europe/Rome] PHP Fatal error: Uncaught Error: Call to a member function prepare() on bool in /opt/unetlab/html/api.php:79
Stack trace:
#0 {main}
thrown in /opt/unetlab/html/api.php on line 79
[13-Mar-2023 21:07:10 Europe/Rome] Mar 13 21:07:10 ERROR: Database error (90003).
[13-Mar-2023 21:07:10 Europe/Rome] Mar 13 21:07:10 PDOException: SQLSTATE[HY000] [2002] No such file or directory in /opt/unetlab/html/includes/functions.php:25
Stack trace:
#0 /opt/unetlab/html/includes/functions.php(25): PDO->__construct()
#1 /opt/unetlab/html/api.php(66): checkDatabase()
#2 {main}
[13-Mar-2023 21:07:10 Europe/Rome] PHP Fatal error: Uncaught Error: Call to a member function prepare() on bool in /opt/unetlab/html/api.php:79
Stack trace:
#0 {main}
thrown in /opt/unetlab/html/api.php on line 79

"

Uldis (UD)
Posts: 5067
Joined: Wed Mar 15, 2017 4:44 pm
Location: London
Contact:

Re: DATABASE ERROR 90003 WHEN ADD NEW USERS

Post by Uldis (UD) » Wed Mar 15, 2023 8:19 am

In the Community you can add only 2x Admin users

Boss
Posts: 2
Joined: Tue Mar 14, 2023 12:25 pm

Re: DATABASE ERROR 90003 WHEN ADD NEW USERS

Post by Boss » Wed Mar 15, 2023 11:19 am

this on v5? with the v2 i can add more
You know where i can find the older eve releases for download ? did not find on eve site

Uldis (UD)
Posts: 5067
Joined: Wed Mar 15, 2017 4:44 pm
Location: London
Contact:

Re: DATABASE ERROR 90003 WHEN ADD NEW USERS

Post by Uldis (UD) » Wed Mar 15, 2023 5:51 pm

EVE-NG Community is v5.0.1-19, and it has only 2x admin accounts.

old Ubuntu 16 vers 2.x is end of life and support.

EVE 2.0 all versions are deprecated, no download, no support

Locked