https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6416
Tomás Cohen Arazi <tomasco...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomasco...@gmail.com --- Comment #7 from Tomás Cohen Arazi <tomasco...@gmail.com> --- (In reply to rainer.stowasser from comment #6) > It seems to have something to do with the restore script > > MariaDB [information_schema]> select * from USER_PRIVILEGES; > > 'koha_bibzamg'@'localhost' | def | USAGE | NO > > 'koha_zabibli'@'%' | def | USAGE | NO > > the user bibzamg was created with koha-create > the user koha_zabibli'@'%'with koha-restore (In reply to Simon Story from comment #2) > The '%' wildcard seems to match when mysql is checking the host the > connection is being made, not when matching users to delete. > > I see in koha-create that 'koha_demo'@'localhost' shouldn't have been > created. Since the code is: > CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd' > > Perhaps Magnus you are mistaken as to the course of events? This is current code (20.05's): mysql_hostname="localhost" # Set up MySQL database for this instance. if [ "$op" = create ] then if [ ! -e /etc/mysql/debian.cnf ]; then MYSQL_OPTIONS="-u root" echo "WARNING: The koha-common.cnf file is a dead soft link!" else MYSQL_OPTIONS="--defaults-extra-file=/etc/mysql/koha-common.cnf" fi mysql $MYSQL_OPTIONS <<eof CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; FLUSH PRIVILEGES; eof -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/