About Features Downloads Getting Started Documentation Events Support GitHub

Love VuFind®? Consider becoming a financial supporter. Your support helps build a better VuFind®!

Site Tools


Warning: This page has not been updated in over over a year and may be outdated or deprecated.
installation:ubuntu

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
installation:ubuntu [2020/03/16 15:25] demiankatzinstallation:ubuntu [2020/05/18 12:27] – [Database Issues] demiankatz
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: 2024/02/12 12:55 by demiankatz