• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    snmysqluser mismatch during upgrade from 1.5.7 to 1.5.9

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    4
    215
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • N
      Nono
      last edited by

      I just upgrade a server from Ubuntu 18.04 (with fog 1.5.7) to Ubuntu 22.04 (with fog 1.5.9 dev-branch).

      I used the dev-branch for the php8 compatibility (from this advise here: https://issueantenna.com/repo/fogproject/fogproject/issues/462#comment-IC_kwDOAR8IuM4_9o39 )

      During the installation, it asks to create the mysql root password but it also generated a new snmysqluser|pass like this :

         snmysqluser='fogstorage'
         snmysqlpass='xxxxxxxxxxx'
      

      and this is where things gets weird.

      Before, on 1.5.7 I had :

      snmysqluser='root'
      snmysqlpass=''
      snmysqlhost='localhost'
      

      following the upgrade to 1.5.9 my .fogsettings file has been updated to :

      snmysqluser='fogmaster' # instead of 'fogstorage'
      snmysqlpass='YYYYYYYY' # not the same as the 'xxxx' printed out earlier
      snmysqlhost='localhost'
      

      Now the question is : Should I take the user/pass from the install script, or keep the one that has been added/edited on my fogsetting file ?

      george1421G 1 Reply Last reply Reply Quote 0
      • george1421G
        george1421 Moderator @Nono
        last edited by george1421

        @nono In earlier version of FOG it used the default login for mysql root with no password. This is a security concern, so the developers changed the code to prompt the FOG Installer for a one time use password to set root to. Then the fog installer creates a new user for mysql access that only has access to the fog database. The fog installer doesn’t store the root password once this fog db user is created.

        The fogmaster account is what the FOG UI uses to talk to the database internally. The fogstorage account is used for remote storage nodes to talk to the mysql database externally.

        The .fogsettings file is used when you reinstall/upgrade fog so the fog installer scripts know your server specific settings.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

        N 1 Reply Last reply Reply Quote 2
        • N
          Nono @george1421
          last edited by

          thanks @george1421
          But then, for the next upgrade, shall I keep the .fogsettings like it is ? or use the fogstorage (and replace it on the file) ? 🤔

          george1421G 1 Reply Last reply Reply Quote 0
          • george1421G
            george1421 Moderator @Nono
            last edited by

            @nono The values in fogsettings should remain as the installer created them. As I said the fogstorage account is for external access to the master fog node from storage nodes. That account only has edit rights to the database, it can’t create or delete tables or schemas, that is the function of the fogmaster account. If you change it to fogstorage your next fog upgrade will fail because it doesn’t have the right access level to update tables in the fog database.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

            1 Reply Last reply Reply Quote 0
            • 1 / 1
            • First post
              Last post

            182

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project