https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39591
--- Comment #4 from Katrin Fischer <[email protected]> --- So we have identified 2 separate problems: 1) missing root privileges for creating the db on the remote server 2) missing configuration options for database encryption For 1) I think pre-creating the database on the remote server could be the solution. For 2) I wonder if koha-create really needs database access after that, as all the "content creation" is then left to the web installer. I wonder if something like this would work, inspired by: bug 14533 comment 4 koha-create --request-db instance Modify the generated file: database name: $mysqldb database user: $mysqluser password: $mysqlpwd On the remote database server, create the db using the same credentials: CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; FLUSH PRIVILEGES; Create a passwdfile in the format: instancename:username:passwd:database:dbhost koha-create --populate-db --dbhost host instance koha-create --use-db --passwdfile ./file Adjust koha-conf.xml to use the encrypted database connection. Run web installer. Questions: - In the snippet taken from bug 14533 it uses both --populate-db and --use-db. Both require a file with the db credentials in different formats to be set up. Is this still correct or can it be avoided? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
