| Lines 54-63
          getmysqlhost() {
      
      
        Link Here | 
        
          | 54 | } | 54 | } | 
        
          | 55 |  | 55 |  | 
        
          | 56 | getinstancemysqlpassword() { | 56 | getinstancemysqlpassword() { | 
          
            
              | 57 |     sed -n '/<pass>/s:.*>\(.*\)</pass>.*:\1:p' \ | 57 |     xmlstarlet sel -t -v 'yazgfs/config/pass' "/etc/koha/sites/$1/koha-conf.xml" | 
            
              | 58 |         "/etc/koha/sites/$1/koha-conf.xml" |  |  | 
        
          | 59 | } | 58 | } | 
        
          | 60 |  | 59 |  | 
            
              |  |  | 60 | getinstancemysqluser() { | 
            
              | 61 |     xmlstarlet sel -t -v 'yazgfs/config/user' "/etc/koha/sites/$1/koha-conf.xml" | 
            
              | 62 | } | 
            
              | 63 |  | 
            
              | 64 | getinstancemysqldatabase() { | 
            
              | 65 |     xmlstarlet sel -t -v 'yazgfs/config/database' "/etc/koha/sites/$1/koha-conf.xml" | 
            
              | 66 | } | 
        
          | 61 |  | 67 |  | 
        
          | 62 | # Set defaults and read config file, if it exists. | 68 | # Set defaults and read config file, if it exists. | 
        
          | 63 | DOMAIN="" | 69 | DOMAIN="" | 
  
    | Lines 124-130
          then
      
      
        Link Here | 
        
          | 124 |     koha-create-dirs "$name" | 130 |     koha-create-dirs "$name" | 
        
          | 125 |  | 131 |  | 
        
          | 126 |     # Generate Zebra database password. | 132 |     # Generate Zebra database password. | 
          
            
              | 127 |     zebrapwd="$(pwgen -1)" | 133 |     zebrapwd="$(pwgen -s 12 1)" | 
        
          | 128 |     # Set up MySQL database for this instance. | 134 |     # Set up MySQL database for this instance. | 
        
          | 129 |     if [ "$op" = create ] | 135 |     if [ "$op" = create ] | 
        
          | 130 |     then | 136 |     then | 
  
    | Lines 134-140
          CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd';
      
      
        Link Here | 
        
          | 134 | GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; | 140 | GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; | 
        
          | 135 | FLUSH PRIVILEGES; | 141 | FLUSH PRIVILEGES; | 
        
          | 136 | eof | 142 | eof | 
          
            
              | 137 |     fi | 143 |     fi #` | 
        
          | 138 |  | 144 |  | 
        
          | 139 |     # Generate and install Apache site-available file and log dir. | 145 |     # Generate and install Apache site-available file and log dir. | 
        
          | 140 |     generate_config_file apache-site.conf.in \ | 146 |     generate_config_file apache-site.conf.in \ | 
  
    | Lines 183-188
          fi
      
      
        Link Here | 
        
          | 183 |  | 189 |  | 
        
          | 184 | if [ "$op" = create ] || [ "$op" = populate ] | 190 | if [ "$op" = create ] || [ "$op" = populate ] | 
        
          | 185 | then | 191 | then | 
            
              |  |  | 192 |     # Re-fetch the passwords from the config we've generated, allows it | 
            
              | 193 |     # to be different from what we set, in case the user had to change | 
            
              | 194 |     # something. | 
            
              | 195 |     mysqluser=$(getinstancemysqluser $name) | 
            
              | 196 |     mysqldb=$(getinstancemysqldatabase $name) | 
        
          | 186 |     # Use the default database content if that exists. | 197 |     # Use the default database content if that exists. | 
        
          | 187 |     if [ -e "$DEFAULTSQL" ] | 198 |     if [ -e "$DEFAULTSQL" ] | 
        
          | 188 |     then | 199 |     then | 
  
    | Lines 205-211
          UPDATE borrowers
      
      
        Link Here | 
        
          | 205 | SET password = '$staffdigest'  | 216 | SET password = '$staffdigest'  | 
        
          | 206 | WHERE borrowernumber = 3; | 217 | WHERE borrowernumber = 3; | 
        
          | 207 | eof | 218 | eof | 
          
            
              | 208 |  | 219 |         #` | 
        
          | 209 |         echo "staff user password is '$staffpass' but keep that secret" | 220 |         echo "staff user password is '$staffpass' but keep that secret" | 
        
          | 210 |  | 221 |  | 
        
          | 211 |         # Upgrade the database schema, just in case the dump was from an  | 222 |         # Upgrade the database schema, just in case the dump was from an  | 
            
              | 212 | -  |  |  |