/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

mysqladmin_shell.sh Shell based Addon

Discussion in 'Add Ons' started by eva2000, Jun 23, 2014.

Tags:
Previous Thread Next Thread
Loading...
Page 6 of 6
  1. Aug 2, 2023 #101
    Jon Snow

    Jon Snow Active Member

    727
    150
    43
    Jun 30, 2017
    Ratings:
    +215
    Local Time:
    11:28 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    Is there a way to test it?

    I tried it the other day and when entering it into src/config.php, it said error making a connection (I've updated the password multiple times with this and in the config file). I had to make a new database user to get it to connect.
     
  2. Aug 2, 2023 #102
    eva2000

    eva2000 Administrator Staff Member

    50,869
    11,786
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,239
    Local Time:
    1:28 PM
    Nginx 1.25.x
    MariaDB 10.x
    The existing MySQL username would have to already have had permissions for accessing the Xenforo database name. Changing the MySQL username's password for a MySQL user that doesn't have permissions to access Xenforo database name, won't make that user work with Xenforo database name.

    What version of MariaDB MySQL are you using? 10.3 or 10.4+
     
  3. Aug 2, 2023 #103
    Jon Snow

    Jon Snow Active Member

    727
    150
    43
    Jun 30, 2017
    Ratings:
    +215
    Local Time:
    11:28 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    10.1.48

    The database, database user and password were made through the script. But I used the script again later to change the password of the database user. I then updated the new password in src/config.php but it wouldn't work.

    I re-created the database & database user, dumped the database, imported it into the new database and got it to work that way. But I couldn't get it to work by simply changing the password.
     
  4. Aug 2, 2023 #104
    eva2000

    eva2000 Administrator Staff Member

    50,869
    11,786
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,239
    Local Time:
    1:28 PM
    Nginx 1.25.x
    MariaDB 10.x
    What version of Xenforo and what version of PHP?

    MariaDB 10.1.48 is very old so could be related. MariaDB 10.1 has been end of life for years now. Probably best to upgrade to 10.3 or 10.4 at least https://community.centminmod.com/threads/mariadb-10-1-upgrades-to-mariadb-10-2-10-3-and-10-4.17793/

    One thing is after you edited src/config.php did you restart PHP-FPM service? Centmin Mod Zend Opcache is configured with opcache.revalidate_freq = 180 seconds, so Zend Opcache PHP cache for performance reasons only checks PHP files for new changes after 180 seconds or if you restart PHP-FPM service to clear the cache. If you edited src/config.php and didn't restart PHP-FPM service within 180 seconds of src/config.php changes and tested Xenforo, it wouldn't have picked up the changes to MySQL user's password unless you waited >180 seconds or restarted PHP-FPM service.

    You can easily confirm if this is the case, by retrying a new password change + PHP-FPM service restart.
     
  5. Aug 2, 2023 #105
    Jon Snow

    Jon Snow Active Member

    727
    150
    43
    Jun 30, 2017
    Ratings:
    +215
    Local Time:
    11:28 PM
    Nginx 1.13.9
    MariaDB 10.1.31
    XF 2.2.13 and PHP 7.4.33.
    I plan to once I get a chance.
    I restarted. I even flushed Redis just in case even tho it's not defined in the src/config.php file.

    This was a test site database user with the issue (the live site with Redis functions fine so it's not XF or PHP related).
     
Previous Thread Next Thread
Loading...
Page 6 of 6

.