Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
installation:ubuntu [2019/11/06 13:55] – [Version Requirements] demiankatz | installation:ubuntu [2020/01/30 15:55] – [Database Issues] demiankatz |
---|
* **Case 1 - MySQL, Ubuntu 17 or earlier:** If you need to install MySQL, you may be prompted for a root password during installation. For better security, it is a good idea to set this; if you do, be sure you remember it so you can configure VuFind to access the database later. | * **Case 1 - MySQL, Ubuntu 17 or earlier:** If you need to install MySQL, you may be prompted for a root password during installation. For better security, it is a good idea to set this; if you do, be sure you remember it so you can configure VuFind to access the database later. |
* **Case 2 - MySQL, Ubuntu 18+:** If you wish to connect to the root account through the web-based installer in order to set up VuFind's database, you will need to disable the root account's "auth_socket" plugin, which prevents regular logins. You can do this by logging in with "sudo mysql -uroot" and then running <nowiki>"UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES;"</nowiki> Next you should run "sudo /usr/bin/mysql_secure_installation" to set a root password. | * **Case 2 - MySQL, Ubuntu 18+:** If you wish to connect to the root account through the web-based installer in order to set up VuFind's database, you will need to disable the root account's "auth_socket" plugin, which prevents regular logins. You can do this by logging in with "sudo mysql -uroot" and then running <nowiki>"UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES;"</nowiki> Next you should run "sudo /usr/bin/mysql_secure_installation" to set a root password. |
* **Case 3 - 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 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> |
| |
==== ILS-Specific Issues ==== | ==== ILS-Specific Issues ==== |