About Features Downloads Getting Started Documentation Events Support GitHub

Site Tools


installation:ubuntu

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
installation:ubuntu [2020/03/16 15:25]
demiankatz
installation:ubuntu [2020/05/18 12:27] (current)
demiankatz [Database Issues]
Line 62: Line 62:
   * **Case 3 - MySQL, Ubuntu 19.10+:** Follow the instructions above under "​Ubuntu 18+," but also edit /​etc/​mysql/​mysql.conf.d/​mysqld.cnf,​ add the line "​default_authentication_plugin= mysql_native_password"​ and run "sudo service mysql restart"​ before attempting to set up VuFind. This will ensure that new accounts are created using a PHP-compatible authentication method.   * **Case 3 - MySQL, Ubuntu 19.10+:** Follow the instructions above under "​Ubuntu 18+," but also edit /​etc/​mysql/​mysql.conf.d/​mysqld.cnf,​ add the line "​default_authentication_plugin= mysql_native_password"​ and run "sudo service mysql restart"​ before attempting to set up VuFind. This will ensure that new accounts are created using a PHP-compatible authentication method.
   * **Case 4 - MariaDB:** If you are using a distribution that includes MariaDB instead of MySQL, you will not be prompted to set a root password during installation. Instead, you should run "sudo /​usr/​bin/​mysql_secure_installation"​ to properly set up security. If this command is missing, try installing the mariadb-client and mariadb-server packages with apt-get. If you wish to connect to the root account through the web-based installer in order to set up VuFind'​s database, you may also need to disable the root account'​s "​unix_socket"​ plugin, which prevents regular logins. You can do this by logging in with "sudo mysql -uroot -p" and then running <​nowiki>"​UPDATE mysql.user SET plugin=''​ WHERE User='​root';​ FLUSH PRIVILEGES;"</​nowiki>​   * **Case 4 - MariaDB:** If you are using a distribution that includes MariaDB instead of MySQL, you will not be prompted to set a root password during installation. Instead, you should run "sudo /​usr/​bin/​mysql_secure_installation"​ to properly set up security. If this command is missing, try installing the mariadb-client and mariadb-server packages with apt-get. If you wish to connect to the root account through the web-based installer in order to set up VuFind'​s database, you may also need to disable the root account'​s "​unix_socket"​ plugin, which prevents regular logins. You can do this by logging in with "sudo mysql -uroot -p" and then running <​nowiki>"​UPDATE mysql.user SET plugin=''​ WHERE User='​root';​ FLUSH PRIVILEGES;"</​nowiki>​
 +  * **When all else fails:** If you cannot successfully connect to the database with VuFind'​s installer using the root account, you can still set up the database manually through the command line. When filling out the "Auto Configure"​ database form, omit the "MySQL Root User" and "MySQL Root Password"​ fields at the bottom, and instead of clicking the regular "​Submit"​ form, click the "​Skip"​ button below it. This will show you all of the SQL commands that need to be run to set up VuFind'​s database. Using the MySQL command line client ("​mysql -u root -p"), run the first four (CREATE DATABASE/​CREATE USER/​GRANT/​FLUSH) commands that are displayed. This will set up your new VuFind database. Now, you need to run a "​USE"​ command to select that database (e.g. "USE vufind;"​ if you're using the default database name of "​vufind"​). Finally, copy and paste the remainder of the SQL (consisting of many CREATE TABLE statements). This will populate your new VuFind database. You may also need to edit the [Database] section of config.ini to adjust the database connection string to use the credentials created for your new database.
  
 ==== ILS-Specific Issues ==== ==== ILS-Specific Issues ====
installation/ubuntu.txt · Last modified: 2020/05/18 12:27 by demiankatz