Initial Setup: Uncaught mysqli_sql_exception: Table 'resourcespace_db.plugins' doesn't exist

[Steven Swart]

I'm trying to install ResourceSpace on a digitalocean preconfigured LAMP vm, and I'm able to load the first resourcespage setup page, but hitting the button to finish the setup after entering the database info and table names hangs the browser on a blank resourcespace-headered page.

db name: resourcespace

usernames: resourcespace_rw and resourcespace_r

I get a string of errors like this, all seemingly related to the database:

Also - I had previously attempted to install resourcespace with a database "resourcespace_db" but I deleted the setup/include files thinking the database name was the issue (since all examples online called the db "resourcespace" and my previous errors werer related to looking for folders as if resourcespace was the database name, not resourcespace_db

[Tue Mar 08 20:06:14.829922 2022] [php:error] [pid 31205] [client 66.212.4.74:63006] PHP Fatal error:  Uncaught m
ysqli_sql_exception: Table 'resourcespace_db.plugins' doesn't exist in /var/www/html/resourcespace/include/databa
se_functions.php:482\nStack trace:\n#0 /var/www/html/resourcespace/include/database_functions.php(482): mysqli->p
repare('...')\n#1 /var/www/html/resourcespace/include/database_functions.php(1023): ps_query('...', Array, '...',
 -1, true, 0, true, false)\n#2 /var/www/html/resourcespace/include/db.php(229): ps_value('...', Array, '', '...')
\n#3 /var/www/html/resourcespace/index.php(2): include('...')\n#4 {main}\n  thrown in /var/www/html/resourcespace
/include/database_functions.php on line 482
[Tue Mar 08 20:06:37.285409 2022] [php:error] [pid 31201] [client 66.212.4.74:33908] PHP Fatal error:  Uncaught m
ysqli_sql_exception: Table 'resourcespace_db.plugins' doesn't exist in /var/www/html/resourcespace/include/databa
se_functions.php:482\nStack trace:\n#0 /var/www/html/resourcespace/include/database_functions.php(482): mysqli->p
repare('...')\n#1 /var/www/html/resourcespace/include/database_functions.php(1023): ps_query('...', Array, '...',
 -1, true, 0, true, false)\n#2 /var/www/html/resourcespace/include/db.php(229): ps_value('...', Array, '', '...')
\n#3 /var/www/html/resourcespace/index.php(2): include('...')\n#4 {main}\n  thrown in /var/www/html/resourcespace
/include/database_functions.php on line 482
[Tue Mar 08 20:19:10.359165 2022] [php:error] [pid 32030] [client 66.212.4.74:18001] PHP Fatal error:  Uncaught m
ysqli_sql_exception: Table 'resourcespace_db.plugins' doesn't exist in /var/www/html/resourcespace/include/databa
se_functions.php:482\nStack trace:\n#0 /var/www/html/resourcespace/include/database_functions.php(482): mysqli->p
repare('...')\n#1 /var/www/html/resourcespace/include/database_functions.php(1023): ps_query('...', Array, '...',
 -1, true, 0, true, false)\n#2 /var/www/html/resourcespace/include/db.php(229): ps_value('...', Array, '', '...')
\n#3 /var/www/html/resourcespace/index.php(2): include('...')\n#4 {main}\n  thrown in /var/www/html/resourcespace
/include/database_functions.php on line 482

[reidb...@gmail.com]

You need to manually create the database in mysql/mariadb before running the web setup.

[reidb...@gmail.com]

Have a look here: https://www.resourcespace.com/knowledge-base/systemadmin/config-db

[Steven Swart]

I initially created the database using those commands on that page:

CREATE DATABASE your_db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER 'resourcespace_rw'@'localhost' IDENTIFIED BY 'your_rw_password'; GRANT ALL PRIVILEGES ON your_db_name.* To 'resourcespace_rw'@'localhost';

CREATE USER 'resourcespace_r'@'localhost' IDENTIFIED BY 'your_r_password'; GRANT SELECT ON your_db_name.* To 'resourcespace_r'@'localhost';

But I'm getting weird cycling of attempts to access the database in the mysql log, one letter at a time until it has tried the whole username for login:

2022-03-10T19:57:05.019603Z        11 Connect   re@localhost on  using Socket
2022-03-10T19:57:05.019698Z        11 Connect   Access denied for user 're'@'localhost' (using password: YES)
2022-03-10T19:57:05.071658Z        12 Connect   re@localhost on  using Socket
2022-03-10T19:57:05.071761Z        12 Connect   Access denied for user 're'@'localhost' (using password: YES)
2022-03-10T19:57:05.264867Z        13 Connect   res@localhost on  using Socket
2022-03-10T19:57:05.264933Z        13 Connect   Access denied for user 'res'@'localhost' (using password: YES)
2022-03-10T19:57:05.417584Z        14 Connect   reso@localhost on  using Socket
2022-03-10T19:57:05.417824Z        14 Connect   Access denied for user 'reso'@'localhost' (using password: YES)
2022-03-10T19:57:05.576664Z        15 Connect   resour@localhost on  using Socket
2022-03-10T19:57:05.576734Z        15 Connect   Access denied for user 'resour'@'localhost' (using password: NO)
2022-03-10T19:57:05.613214Z        16 Connect   resour@localhost on  using Socket
2022-03-10T19:57:05.613287Z        16 Connect   Access denied for user 'resour'@'localhost' (using password: NO)
2022-03-10T19:57:05.842957Z        17 Connect   resourc@localhost on  using Socket
2022-03-10T19:57:05.843016Z        17 Connect   Access denied for user 'resourc'@'localhost' (using password: NO)
2022-03-10T19:57:06.048029Z        18 Connect   resource@localhost on  using Socket

... and so on

[Mike Perry]

I presume you can log into the db through a mysql command line -- that it's the RS login that's failing??