| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
| installation:ubuntu [2019/09/16 13:10] – demiankatz | installation:ubuntu [2019/11/06 13: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. Instead, you should run "sudo /usr/bin/mysql_secure_installation" to properly set up security. 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 - 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 ==== |
